How to Enable Disable Archivelog Mode in Oracle

How to Enable/Disable Archivelog Mode in Oracle

This article covers below queries:

  • How to enable archivelog mode in Oracle
  • How to Disable archivelog mode in Oracle
  • turn OFF archive log mode
  • turn ON archive log mode

How to Enable Archive Log Mode:

sqlplus / as sysdba

SQL> archive log list

Database log mode             Archive Mode
Automatic archival              Enabled
Archive destination              USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence    19
Next log sequence to archive  20
Current log sequence 20

here you’ll see Automatic archival-Enabled,That means Archive is ON or ENABLE.

Execute below commands from SQLPLUS:
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database NOARCHIVELOG;
SQL> shutdown immediate
SQL> startup;
SQL> exit;

How to Disable Archive Log Mode:

sqlplus / as sysdba

SQL> archive log list

Database log mode               NO Archive Mode
Automatic archival                 Disabled
Archive destination                USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence        19
Next log sequence to archive     20
Current log sequence 20

here you’ll see Automatic archival-Disabled,That menas Archive is Off or disable.

Execute below commands from SQLPLUS:
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database ARCHIVELOG;
SQL> shutdown immediate
SQL> startup;
SQL> exit;

Leave a Reply

Your email address will not be published. Required fields are marked *