Oracle9i胶片中文版_5_2.管理数据库的归档模式-caith

单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,华为机密，未经许可不得扩散,文档密级：内部公开,配置数据库归档模式,1.0,1,目标,归档模式与非归档模式的不同点,配置数据库到归档模式,自动归档,人工归档,配置多个归档进程,配置多个归档目标,2,Online redo log files,No redo history,LGWR,Redo history,054,053,052,051,052,历史日志,3,Online redo log files,No redo history,053,LGWR,054,053,052,053,054,053,052,052,非归档模式,4,归档模式,053,053,053,051,053,051,051,052,053,Archivedlog files,Online redo log files,LGWR,054,052,054,052,Redo history,5,改变归档模式,SHUTDOWN NORMAL/IMMEDIATE,1,STARTUP MOUNT,ALTER DATABASE ARCHIVELOG,3,ALTER DATABASE OPEN,4,5,2,init.ora,Control,file,Full database backup,6,自动和人工归档,自动归档:,LOG_ARCHIVE_START,=,TRUE,人工归档:,LOG_ARCHIVE_START,=,FALSE,DBA,ARC0,ARC1,053,053,053,053,7,多个,ARC,n,进程,LOG_ARCHIVE_MAX_PROCESSES,最大为10个,可以通过,ALTER SYSTEM,.,改变,8,停止和启动其它归档进程,LOG_ARCHIVE_MAX_PROCESSES=2,Archived redo logs,053,Online redo logs,ARC0,ARC1,ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=3;,ARC2,053,053,9,自动归档,ARC0,051,Archived log files,051,052,Archived,Archived,Current,LOG_ARCHIVE_START=TRUE,LOG_ARCHIVE_MAX_PROCESSES=,n,Online redo logs,051,052,052,053,051,10,ARC0,通过语句自动归档,ALTER SYSTEM ARCHIVE LOG START TO?/,dbs,/arch;,2,051,052,Online redo logs,052,051,1,3,051,052,11,ARC0,停止自动归档,1,2,ALTER SYSTEM ARCHIVE LOG STOP;,LOG_ARCHIVE_START,052,051,051,052,Online redo logs,052,051,init.ora,12,人工归档,1,ALTER SYSTEM ARCHIVE LOG SEQUENCE 052;,2,052,051,052,051,053,Online redo logs,ServerProcess,051,052,13,归档日志存放,使用,LOG_ARCHIVE_DEST_,n,指定,使用,LOG_ARCHIVE_FORMAT,给出格式,14,指定多个归档目标,本地,远程,standby,数据库,log_archive_dest_1=LOCATION=/archive1,log_archive_dest_2=SERVICE=standby_db1,15,LOG_ARCHIVE_DEST_,n,选项,强制和可选,归档失败后重试间隔时间,log_archive_dest_1=LOCATION=/archive MANDATORY REOPEN,log_archive_dest_2=SERVICE=standby_db1MANDATORY REOPEN=600,log_archive_dest_3=LOCATION=/archive2OPTIONAL,16,指定最小的本地归档数量,参数,LOG_ARCHIVE_MIN_SUCCEED_DEST,日志重用条件,强制归档完成,归档成功数大于,LOG_ARCHIVE_MIN_SUCCEED_DEST,参数,LOG_ARCHIVE_MIN_SUCCEED_DEST=2,17,控制归档,通过参数,LOG_ARCHIVE_DEST_STATE_,n,.,实现,LOG_ARCHIVE_DEST_STATE_2=DEFER,LOG_ARCHIVE_DEST_STATE_2=ENABLE,ALTER SYSTEM SET log_archive_dest_state_3=ENABLE,ALTER SYSTEM SET log_archive_dest_state_3=DEFER,18,指定文件名格式,ARC0,LOG_ARCHIVE_DEST_,n,LOG_ARCHIVE_FORMAT,/,ORADATA/archive,/,Archived log file,052,arch%s.arc,052,053,053,Group 1,053,052,053,052,053,053,ARC0,052,Online redo log files,Group 2,19,获取归档日志信息,V$ARCHIVE_DEST,V$ARCHIVED_LOG,V$LOG_HISTORY,动态视图,命令行,ARCHIVE LOG LIST;,V$DATABASE,V$ARCHIVE_PROCESSES,20,总结和练习,配置归档模式,自动归档,人工归档,多个归档进程,多个归档目标,21,