Databases Reference
In-Depth Information
Disabling Archivelog Mode
If you need to disable archiving, connect to your database with a
sys*
privileged user. You can disable archivelog
mode from within SQL*Plus or RMAN. This example shows how to disable archivelog mode from SQL*Plus:
$ sqlplus / as sysdba
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;
How It Works
Your database is required to be in archivelog mode for online backups. RMAN will return an error if you attempt to
take an online backup when your database isn't in archivelog mode.
After you have changed the archivelog mode of your database, you can verify that the mode has been set
properly. To display the status of archiving, you can query V$DATABASE as follows:
SQL> select log_mode from v$database;
Here is some sample output:
LOG_MODE
--------------------
ARCHIVELOG
You can also query the name and destination to show where the archive redo logs are being written via this query:
SELECT
dest_name
,destination
FROM v$archive_dest
WHERE destination is not null;
The SQL*Plus
archive log list
command displays a useful summary of the archiving configuration of
your database:
SQL> archive log list;
As shown in the following output, it includes information such as the archivelog mode, automatic archiving,
archive destination, and log sequence numbers:
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/product/12.1.0.1/db_1/dbs/arch
Oldest online log sequence 20
Next log sequence to archive 21
Current log sequence 21
Archivelog mode is the mechanism that allows you to recover all committed transactions. This mode protects
your database from media failure because your transaction information can be restored and recovered (applied to
