ArchiveLog Mode
SHUTDOWN IMMEDITE; Start Mount; ALTER DATABASE ArchiveLog; ALTER DATABASE OPEN; Archive Log List;
Automatic Archive ALTER System Archive Log Start / Stop; // Start Archive Process ALTER SESTEM SET LOG_ARCHIVE_DEST_1 = "Location = D: / Oracle / ORADATA / TEST / Arch1 / Mandatory"
init.oralog_archive_start = truelog_archive_format = 'arc% s.log'log_archive_dest_1 = "location = d: / oracle / oradata / test / arch1 / mandatory" log_archive_max_processes = 2FORMATS serial number, serial number 0s to make, do not make up 0
Specifying Multiple Archive log destinations1.local disklog_archive_dest_1 = "location = / archive1"
2.Remote Standby DatabaseLog_archive_dest_2 = "Service = StandBy_db1"
Log_archive_dest_n optionsset Archive Location As Mandatory Or OPTIONALDEFINE TIME BEFORE RETRY IN CASE OF FAILES
log_archive_dest_1 = "LOCATION = / archive / MANDATORY REOPEN" must be generated after a good, redologfile in order to be covered log_archive_dest_2 = "SERVICE = standby_db1 MANDATORY REOPEN = 600" specifies the time to try, day value recorded log_archive_dest_3 = "LOCATION = / archive2 After a / Optional "By default, even if the online log file has no successful archive, this can continue to be used by the log file.
At least two successful LOG_ARCHIVE_MIN_SUCCEED_DEST = 2 An online redo log group can be reused only if: Archiving has been done to all mandatory locationsThe number of local locations archived is greater than or equal to the value of theLOG_ARCHIVE_MIN_SUCCEED_DEST parameter
Contents disabled An archival destination can be disabled by usingthe dynamic initialization parameterLOG_ARCHIVE_DEST_STATE_nLOG_ARCHIVE_DEST_STATE_2 = DEFER / ENABLEALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DEFER / ENABLE
