Horje
convert databse to achieve log mode oracle Code Example
convert databse to achieve log mode oracle
$ export ORACLE_SID=<MYDB>
Source: www.ibm.com
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
Source: www.ibm.com
convert databse to achieve log mode oracle
$ sqlplus /nolog
SQL> connect / as sysdba
Source: www.ibm.com
convert databse to achieve log mode oracle
SQL> Shutdown
SQL> Startup mount
SQL> Alter database archivelog;
SQL> alter database open;
Source: www.ibm.com




Sql

Related
limit and offset in stored procedure mssql Code Example limit and offset in stored procedure mssql Code Example
how to create triggers in sql server Code Example how to create triggers in sql server Code Example
reset postgresql password windows Code Example reset postgresql password windows Code Example
SHOW COLUMNS Statement Code Example SHOW COLUMNS Statement Code Example
default value false mysql Code Example default value false mysql Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
7