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;
Pingback: enable archive logs oracle relevance - dataslist