Thursday, July 3, 2008

How to switch a database into the archive log mode:

In order to switch a database to archivelog mode we can use the following procedure:

shutdown immediate;
startup mount exclusive
alter database archivelog;
archive log start;
startup force;

And to check what is the the archivelog mode status:

SELECT log_mode FROM gv$database;

No comments: