Search
 
SCRIPT & CODE EXAMPLE
 

SQL

convert databse to achieve log mode oracle

$ export ORACLE_SID=<MYDB>
Comment

convert databse to achieve log mode oracle

$ sqlplus /nolog
SQL> connect / as sysdba
Comment

convert databse to achieve log mode oracle

SQL> Shutdown
SQL> Startup mount
SQL> Alter database archivelog;
SQL> alter database open;
Comment

convert databse to achieve log mode oracle

SQL> archive log list;
Database log mode 						Archive Mode
Automatic archival 					Enabled
Archive destination 					/oradump/<MYDB>
Oldest online log sequence 		7
Next log sequence to archive 	7
Current log sequence 					9
Comment
PREVIOUS NEXT
Code Example
Sql :: postgres another version 
Sql :: SQL IN Operator With Duplicate Values 
Sql :: mysql drop vs delete 
Sql :: Having trouble running COUNT in my INSERT INTO statement 
Sql :: Components/Fields of Internal Table 
Sql :: oracle apex run 404 
Sql :: INSERT INTO RAHULDEV 
Sql :: opensuse start MySQL 
Sql :: oracle archivemode 
Sql :: sql gather statistics to increase performance 
Sql :: heroku postgres permission denied 
Sql :: sql count return 0 if no rows 
Sql :: sql server query field names 
Sql :: sql dcl queries 
Sql :: java hide mysql login credentials 
Sql :: get last 3 years data in mysql 
Sql :: amount to words oracle Function 
Sql :: valadate mysql 
Sql :: sql table intermédiaire 
Sql :: how to check table in postgresql from terminal 
Sql :: mysql phpmyadmin mysqli_construct:: error for mac user 
Sql :: create query in where clasue 
Sql :: SQL AND, OR and NOT Operators 
Sql :: select from diffrent tables 
Sql :: != not working in mysql 
Sql :: SQL CHECK Constraint in Existing Table 
Sql :: use between operator in mysql 
Sql :: c# sql transaction multiple connections 
Sql :: select all fields from table 
Sql :: oracle winter time change 
ADD CONTENT
Topic
Content
Source link
Name
6+8 =