Archive Log

Activate Archive Log

• Validate Database mode

SELECT LOG_MODE FROM SYS.V$DATABASE;

• Get Archive information

archive log list;
show parameter recovery_file_dest

• Change Archive file destination

alter system set log_archive_dest_1='Location=C:\oracle\E1Local\RDBMS\log';

• Limit the number of archiver running at the same time

alter system set log_archive_max_processes=2;

• Activate Archive log

SHUTDOWN
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;

Reference File

• V$DATABASE : select log_mode from v$database;
• V$ARCHIVED_LOG
• V$ARCHIVE_DEST : select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;
• V$ARCHIVE_PROCESSES
• V$BACKUP_REDOLOG
• V$LOG
• V$LOG_HISTORY