Oracle11g 搭建单实例DataGuard

《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