Archivelog

Check the Database in an Archive Log Mode or Not

>ARCHIVE LOG LIST

Changing the Archiving Mode

>SHUTDOWN IMMEDIATE

>STARTUP MOUNT

>ALTER DATABASE ARCHIVELOG

>ALTER DATABASE OPEN

Automatic and Manual Archiving

>SHOW PARAMETER DB_RECOVERY_FILE_DEST;

Automatic and Manual Archiving

Automatic Archiving:

>ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE=SPFILE;

>STARTUP FORCE;

Manual Archiving:

>ALTER SYSTEM SET LOG_ARCHIVE_START=FALSE SCOPE=SPFILE;

>STARTUP FORCE;

Stop or Start Additional Archive Processes

>ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=4 SCOPE=SPFILE;

>STARTUP FORCE;

Manually Archiving Online Redo Log Files

>ALTER SYSTEM ARCHIVE LOG CURRENT;

Specify Multiple Archive Log Destinations

Use LOG_ARCHIVE_DEST_ n to specify up to ten archival destinations, which can be on a:

Local Disk

Remote Location

> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1="LOCATION=C:\oracle\product\10.2.0\

icelog_dba12\Location_1" SCOPE=SPFILE;

>STARTUP FORCE;

LOG_ARCHIVE_DEST_n Options

> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2="LOCATION=C:\oracle\product\10.2.0\

icelog_dba12\Location_2 MANDATORY REOPEN" SCOPE=SPFILE;

> ALTER SYSTEM SET LOG_ARCHIVE_DEST_3="LOCATION=C:\oracle\product\10.2.0\

icelog_dba12\Location_2 OPTIONAL REOPEN=200" SCOPE=SPFILE;

>STARTUP FORCE;

Default REOPEN is 300 seconds.

Specifying a Minimum Number of Local Destinations

> ALTER SYSTEM SET LOG_ARCHIVE_MIN_SUCCEED_DEST=2 SCOPE=SPFILE;

Controlling Archiving to a Destination

Archiving to a destination can be disabling

>ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;

Archiving to a destination can be enabling

>ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable;

Dynamic Views

  1. V$ARCHIVED_LOG: Displays archived log information from the control file;

  2. V$ARCHIVE_DEST: For the Current instance, describes all archive log destinations, the current value and status

> SELECT destination, binding,status

FROM v$archive_dest;

  1. V$LOG_HISTORY: Contains log file information from the control file.

  2. V$ARCHIVE_PROCESSES: Provides information about the state of the various ARCH processes for the instance.

>SELECT * FROM v$archive_processes;