两台服务器使用相同的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@PRIMARY>alter database force logging ;
alter database force logging
*
ERROR at line 1:
ORA-12920: database is already in force logging mode
复制代码
2、创建standby controlfile
SYS@PRIMARY>alter database create standby controlfile as '/u01/data/primary/primary/standby.ctl';
Database altered.
复制代码
3、登录到主库，可以了解一下数据文件的信息，之后安全关闭数据库，将全部数据文件拷贝到备库的相应目录下,直接复制目录最简单
SYS@PRIMARY>select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/data/primary/system01.dbf
/u01/data/primary/sysaux01.dbf
/u01/data/primary/undotbs01.dbf
/u01/data/primary/users.dbf
SYS@PRIMARY>show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/data/primary/primary/cont
rol01.ctl, /u01/data/primary/p
rimary/control02.ctl
SYS@PRIMARY>select 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.rdo
6 rows selected.
SYS@PRIMARY>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@PRIMARY>quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ cd /u01/data/
[oracle@localhost data]$ scp -r primary/ 172.26.29.4:/u01/data
oracle@172.26.29.4's password:
system01.dbf 100% 172MB 34.4MB/s 00:05
redo01b.rdo 100% 100MB 33.3MB/s 00:03
sysaux01.dbf 100% 100MB 50.0MB/s 00:02
undotbs01.dbf 100% 133MB 44.3MB/s 00:03
.......
[oracle@localhost data]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 21 20:54:47 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SYS@PRIMARY>startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 402655344 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7360512 bytes
Database mounted.
Database opened.
复制代码
4、主库修改初始化参数文件
SYS@PRIMARY>create pfile from spfile;
File created.
SYS@PRIMARY>!
复制代码
在pfile后面追加如下这些参数：
参