use rman duplicate create phyical standby database

配置基础环境，操作步骤如下：

A.在主库上操作：

1.安装数据库软件，以及DBCA建库；

2.配置网路环境，包括（监听，TNSNAME，密码文件)；

3.配置相关参数，如下:

DB_UNIQUE_NAME=qjh10gpr
LOG_ARCHIVE_CONFIG='DG_CONFIG=(qjh10gpr,qjh10gdg)'
LOG_ARCHIVE_DEST_1='LOCATION=/opt/u01/oracle/oradata/qjh10gpr/arclog'
LOG_ARCHIVE_DEST_2='SERVICE=qjh10gdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=qjh10gdg'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=2
FAL_SERVER=qjh10gdg
FAL_CLIENT=qjh10gpr
DB_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gdg/','/opt/u01/oracle/oradata/qjh10gpr/'
LOG_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gdg/','/opt/u01/oracle/oradata/qjh10gpr/'
STANDBY_FILE_MANAGEMENT=AUTO

4.在主库上运行备份：rman target /

run {
allocate channel c1 type disk;
allocate channel c2 type disk;
sql 'alter system archive log current';
backup current controlfile for standby;
BACKUP  DATABASE;
sql 'alter system archive log current';
BACKUP ARCHIVELOG ALL DELETE INPUT;
release channel c2;
release channel c1;
}

5.将备份片SCP复制到备库相同目录

（如果是复制到不同目录，需要到RMAN中使用catalog  命令注册备份集,但是需要保证主库和备库都能访问到这个目录，需要配置NFS,一般不推荐）;

 

 

B.在备库上操作：

1.安装数据库软件，不建库；

2.配置网路环境，包括（监听，TNSNAME，密码文件----注意密码要和主库一样）；

3.建立相关目录；

4.配置相关参数，如下:

DB_UNIQUE_NAME=qjh10gdg
LOG_ARCHIVE_CONFIG='DG_CONFIG=(qjh10gdg,qjh10gpr)'
LOG_ARCHIVE_DEST_1='LOCATION=/opt/u01/oracle/oradata/qjh10gdg/arclog'
LOG_ARCHIVE_DEST_2='SERVICE=qjh10gpr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=qjh10gpr'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=DEFER
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=2
FAL_SERVER=qjh10gpr
FAL_CLIENT=qjh10gdg
DB_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gpr/','/opt/u01/oracle/oradata/qjh10gdg/'
LOG_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gpr/','/opt/u01/oracle/oradata/qjh10gdg/'
STANDBY_FILE_MANAGEMENT=AUTO

5.备库启动到nomount;

6.登陆rman:(qjh10gpr 和 qjh10gdg 是在tnsname.ora中配置的连接字符串）

rman target sys/oracle@qjh10gpr  auxiliary  sys/oracle@qjh10gdg

DUPLICATE TARGET DATABASE FOR STANDBY
DORECOVER;

运行完成后，备库处于mount状态，但是不能应用日志

7.在sqlplus 运行：

alter database recover managed standby database disconnect from session;

完成后备库开始应用日志。

 

基础环境搭建的知识参考：http://blog.csdn.net/plwsab6000/article/details/7916361

 

 

 

ps .

rename datafile 和logfile  的其他两种方法：

Naming Standby Database Files with SET NEWNAME
Naming Standby Database Files with CONFIGURE AUXNAME

详细见官方文档。