Oracle集群-DG.doc

Oracle 11g Data Guard配置 操作环境说明： 两台服务器使用相同的Redhat 5.5 内核版本为：2.6.18-194.el5 在主库（primary database）中提前安装好了Oracle 11gR2软件，通过DBCA创建了数据库，实例名为PRIMARY 备库（standby database）中只安装了Oracle 11gR2软件，未创建数据库。 本文完整记录基于11g的DG配置 主库配置 1、确认主库开启了archivelog模式，并设置为force logging模式 SYS@PRIMARYalter database force logging ;alter database force logging*ERROR at line 1:ORA-12920: database is already in force logging mode 2、创建standby controlfile SYS@PRIMARYalter database create standby controlfile as /u01/data/primary/primary/standby.ctl;  Database altered. 3、登录到主库，可以了解一下数据文件的信息，之后安全关闭数据库，将全部数据文件拷贝到备库的相应目录下,直接复制目录最简单 SYS@PRIMARYselect name from v$datafile;NAME--------------------------------------------------------------------------------/u01/data/primary/system01.dbf/u01/data/primary/sysaux01.dbf/u01/data/primary/undotbs01.dbf/u01/data/primary/users.dbfSYS@PRIMARYshow parameter control_filesNAME TYPE VALUE------------------------------------ ----------- ------------------------------control_files string /u01/data/primary/primary/cont rol01.ctl, /u01/data/primary/p rimary/control02.ctlSYS@PRIMARYselect group#,member from v$logfile; GROUP# MEMBER---------- ------------------------------ 1 /u01/data/primary/redo01a.rdo 1 /u01/data/primary/redo01b.rdo 2 /u01/data/primary/redo02a.rdo 2 /u01/data/primary/redo02b.rdo 3 /u01/data/primary/redo03a.rdo 3 /u01/data/primary/redo03b.rdo6 rows selected.SYS@PRIMARYshutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SYS@PRIMARYquitDisconnected from Oracle Database 11g Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@localhost ~]$ cd /u01/data/[oracle@localhost data]$ scp -r primary/ :/u01/dataor