Jul 29, 2011

Enable Archivelog mode in oracle 11g

By default in Oracle 10g  the database is in noarchivelog mode. To check the present status of archivelog, login as any user with dba privileges and try the below querys

sql> select log_mode from v$database;
or
sql> archive log list

if the database is in noarchivelog mode, then if require you can change to archivelog mode as shown below

sql> shut immediate;
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;

check the status of archivelog again for confirmation.

No comments:

Post a Comment