Posts

Showing posts from May, 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;