RMAN在线创建DATAGUARD STANDBY

                                             使用RMAN在线创建DATAGUARD STANDBY的意事项

1，对于备库需要使用net service name连接,即使在备库上操作也相同

[oracle@dg2 admin]$ $ORACLE_HOME/bin/rman target auxiliary /

   执行脚本报错

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/28/2013 10:10:21
RMAN-05501: aborting duplication of target database
RMAN-06217: not connected to auxiliary database with a net service name

2, 在备库的机器上执行duplicat的时候，备库的listener必须要静态注册，不能依赖于动态注册
否则连接不上.因为去态注册的时候，instance会处于一个block状态

Service "sys2" has 1 instance(s).
  Instance "sys", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

[oracle@dg2 admin]$ $ORACLE_HOME/bin/rman target auxiliary

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Aug 28 10:15:06 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SYS (DBID=618396651)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

 

3,密码文件需要一致，否则会报错

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 08/28/2013 10:08:25
RMAN-06403: could not obtain a fully authorized session
ORA-24327: need explicit attach before authenticating a user

 

4,在duplicate 中需要指定db_unique_name

RMAN-03002: failure of Duplicate Db command at 08/28/2013 10:00:19
RMAN-05501: aborting duplication of target database
RMAN-05558: Must specify DB_UNIQUE_NAME with FOR STANDBY clause

查看rman的语法在for standby后面没有db_unique_name这个选项.需要手动指定

spfile
parameter_value_convert 'sys1','sys2'
set 'db_unique_name'='sys2'
nofilenamecheck;