Oracle 归档模式(archivelog)
1、查看归档模式
SYS@orcl> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Current log sequence 3
2、打开归档(需在 mount 状态下修改归档模式)
SYS@orcl> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl> startup mount
ORACLE instance started.
Total System Global Area 771751936 bytes
Fixed Size 8625464 bytes
Variable Size 583008968 bytes
Database Buffers 176160768 bytes
Redo Buffers 3956736 bytes
Database mounted.
SYS@orcl> alter database archivelog;
Database altered.
SYS@orcl> alter database open ;
关闭归档模式则在mount状态下执行 alter database noarchivelog;
命令。
3、设置归档路径
SYS@orcl> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
SYS@orcl> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3
SYS@orcl> show parameter use_db_recovery_file_dest
SYS@orcl> alter system set log_archive_dest_1='location=/u01/archivelog';
System altered.
SYS@orcl> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/u01/archivelog
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
SYS@orcl> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archivelog
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3
4、归档参数
* log_archive_dest_n:归档文件的存放目录。可以是本地目录,网络目录和网络连接存储(NAS)。
* log_archive_dest_state_n:为归档目标值定义两个状态:如果为 enable,则 arch 进程可以将归档日志归档至指定的值;如果为 defer,则 arch 进程不会在相对应的位置存放归档。
* log_archive_format:指定归档日志的命名格式。
* log_archive_max_processes:定义数据库启动 arch 进程的数量。
* log_archive_min_succeed_dest:指定归档最小成功复制的位置个数。
* log_archive_start:默认为 false。Oracle 10g 及其以后版本 arch 进程自动启动,故不在使用。