欢迎来到天天文库
浏览记录
ID:37863053
大小:93.50 KB
页数:17页
时间:2019-06-01
《Oracle11g 搭建单实例DataGuard》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、环境:主备库都为单实例并且数据库SID相同OS:redhat6.5Oracle:11.2.0.4.3主库操作1. 开启归档模式 创建归档目录[root@enn~]#mkdir-p/u01/archivelog[root@enn~]#chown-Roracle:oinstall/u01/archivelog[root@enn~]#chmod777/u01/archivelog数据库到mount状态开启归档模式[root@enn~]#su-oracle[oracle@enn~]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononSunJ
2、ul2023:46:462014Copyright(c)1982,2013,Oracle. Allrightsreserved.Connectedtoanidleinstance.SQL>startupmountORACLEinstancestarted. TotalSystemGlobalArea 835104768bytesFixedSize 2257840bytesVariableSize 541068368bytesDatabaseBuffers 289406976bytesRedoBuffers 2371584bytesDatab
3、asemounted.设置主库归档目录SQL>altersystemsetlog_archive_dest='/u01/archivelog';altersystemsetlog_archive_dest_1='location=/data/oracle/log1/archive_log'; 最后的目录名称需要为archive_log开启归档模式SQL>alterdatabasearchivelog;Databasealtered.查看归档设置SQL>archiveloglist;Databaselogmode ArchiveModeAutomaticarchival
4、 EnabledArchivedestination /u01/archivelogOldestonlinelogsequence 2Nextlogsequencetoarchive 4Currentlogsequence 4 2. 启动force_logging模式 查看是否force_logging模式SQL>selectlog_mode,force_loggingfromv$database;LOG_MODE FOR---------------ARCHIVELOG NO开启force_logging模式SQL>alterdata
5、baseforcelogging;Databasealtered. 3.创建备库日志文件路径 查看数据库的日志组个数与大小,因为我们创建 standby 日志组的个数是原日志组个数+1 再与 thread 的积((2+1)*3),size 不能小于原日志文件的大小。SQL>selectgroup#,thread#,bytes/1024/1024M,STATUSfromv$log; GROUP# THREAD# MSTATUS---------------------------------------------- 1 1 50CURRENT
6、 3 1 50INACTIVE 2 1 50INACTIVE SQL>selectmemberfromv$logfile;MEMBER--------------------------------------------------------------------------------/u01/app/oracle/oradata/ENN/redo03.log/u01/app/oracle/oradata/ENN/redo02.log/u01/app/oracle/oradata/ENN/redo01.log 创建备库日志组路
7、径SQL>alterdatabaseaddstandbylogfilethread1group4('/u01/app/oracle/oradata/ENN/redo04.log')size50M;Databasealtered.SQL>alterdatabaseaddstandbylogfilethread1group5('/u01/app/oracle/oradata/ENN/redo05.log')size50M;D
此文档下载收益归作者所有