使用RMAN的duplicate命令创建Physical Standby Database

1. 确保P运行在Archivelog 模式下

2. 设置P端的初始化参数

DB_NAME= shacol11
DB_UNIQUE_NAME= shacol11
db_recovery_file_dest_size=200g
db_recovery_file_dest='/oracle/flash_recovery_area
CONTROL_FILES='/oracle/oradata/shacol11/control1.ctl', '/oracle/oradata/shacol11/control2.ctl', '/oracle/oradata/shacol11/control3.ctl'
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc ( unmodificable)
LOG_ARCHIVE_MAX_PROCESSES=30

LOG_ARCHIVE_CONFIG='DG_CONFIG=( shacol11, shbcol11)'

LOG_ARCHIVE_DEST_1=
'LOCATION= USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=shacol11 MANDATORY'

LOG_ARCHIVE_DEST_2=
'SERVICE= shbcol11 LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME= shbcol11 optional '
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=defer

FAL_SERVER=shbcol11
FAL_CLIENT=shacol11
STANDBY_FILE_MANAGEMENT=AUTO

DB_FILE_NAME_CONVERT='/oracle/oradata/shacol11','/oracle/oradata/shbcol11'
LOG_FILE_NAME_CONVERT=/oracle/oradata/shacol11','/oracle/oradata/shbcol11'

......

3.设置S端的初始化参数

DB_NAME=shacol11
DB_UNIQUE_NAME=shbcol11
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
CONTROL_FILES='/oracle/oradata/shacol11/control1.ctl', '/oracle/oradata/shacol11/control2.ctl', '/oracle/oradata/shacol11/control3.ctl'
db_recovery_file_dest_size=200g
db_recovery_file_dest='/oracle/flash_recovery_area

LOG_ARCHIVE_FORMAT=log%t_%s_%r.arc
LOG_ARCHIVE_CONFIG='DG_CONFIG=( shacol11, shbcol11)'
log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=shbcol11'
log_archive_dest_2='service=shacol11 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=shacol11 optional '
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE

STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=chicago
FAL_CLIENT=boston

DB_FILE_NAME_CONVERT='/oracle/oradata/shacol11','/oracle/oradata/shbcol11'
LOG_FILE_NAME_CONVERT=/oracle/oradata/shacol11','/oracle/oradata/shbcol11'

4. 在P和S配置tnsnames,保证能够互相访问

5. 在S端配置listener,确保S的SID在监听范围内

6. 在S端创建一个password文件

7. nomount Standby

startup nomount file='/oracle/product/11.1.0/db_1/dbs/initshbcol11.ora';

8. 执行duplicate

$ORACLE_HOME/bin/rman target sys/admin@shacol11 auxiliary sys/admin@shbcol11

duplicate target database for standby from active database nofilenamecheck;

这个命令将拷贝口令文件, 创建并复制standby control file ,然后mount, 接着复制所有的数据文件.

9. 创建standby log

执行duplicate命令时会在alert.log里生成standby log的创建命令,如果没有指定DB_CREATE_FILE_DEST或者db_create_online_log_dest_n,那么需要添加一下路径名.

可选的,在P端也创建standby log,这样有助于平滑切换角色.

10 在S端开始恢复
alter database recover managed standby database using current logfile disconnect from session;

11.测试一下log transport 和apply
alter system set log_archive_dest_state_2=enable SCOPE=BOTH;

select sequence#, first_time, next_time ,applied from v$archived_log order by sequence#;

select * from v$log;

select dest_id,dest_name, status ,type from v$archive_dest_status ;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/100682/viewspace-1023311/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/100682/viewspace-1023311/