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
V$ARCHIVED_LOG: Displays archived log information from the control file;
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;
V$LOG_HISTORY: Contains log file information from the control file.
V$ARCHIVE_PROCESSES: Provides information about the state of the various ARCH processes for the instance.
>SELECT * FROM v$archive_processes;