Friday, 20 December 2013

Enabling Archive Log Mode

SQL> SELECT LOG_MODE FOR V$DATABASE;

SQL> SHOW PARAMATER LOG_ARCHIVE_START

SQL> SHOW PARAMATER LOG_ARCHIVE_DEST_1

SQL> ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE=SPFILE;

SQL> SHUT IMMEDIATE;

SQL> STARTUP MOUNT

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ALTER DATABASE OPEN;





No comments:

Post a Comment