Monday, March 11, 2013

How To Set Database To Noarchivelog

Login to sqlplus
# sqlplus /nolog
SQL> connect / as sysdba
The db must be mounted EXCLUSIVE and not open for operation
SQL> shutdown immediate;
SQL> startup mount;
Check the log mode of the database
SQL> select log_mode from v$database;
Set it to noarchivelog mode
SQL> alter database noarchivelog;
Set db open for user operation
SQL> alter database open;

No comments: