Tuesday, November 22, 2011

Enabling/Disabling Archivelog mode in Oracle


Enabling Archivelog Mode 

SQL> connect sys/password as sysdba
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;

Disabling Archivelog Mode


SQL> connect sys/password as sysdba
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;

Note  If  flashback database feature is enabled, first disable it before you disable database archiving.

Displaying Archive Information


Two ways can be used to display the mode of database


SQL> select log_mode from v$database;
          LOG_MODE
          --------------------
          ARCHIVELOG


SQL> archive log list;
          Database log mode                    Archive Mode
          Automatic archival                     Enabled
          Archive destination                     /u02/ora_archives/
          Oldest online log sequence         1
          Next log sequence to archive       2
          Current log sequence                  2



Prior to Oracle Database 10g, it was also required to enable automatic archiving that tells Oracle to automatically create an archived redo log file when the online redo log file becomes full. With Oracle Database 10g onward, it is no longer required to do that by setting the archive_log_start parameter. The archive_log_start parameter is deprecated



No comments:

Post a Comment