Tuesday, May 27, 2008

switching database to archivelog mode


switch the database to archivelog mode.

SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;

switch database to noarchivelog mode.
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;

No comments: