部署Oracle 11gR2 Data Guard安装记录(1)

相关文章：
        《部署Oracle 11gR2 Data Guard安装记录(2)》 http://space.itpub.net/23135684/viewspace-757999

        以下是部署Oracle 11gR2 Data Guard的安装记录，Oracle Database的软件版本是11.2.0.3。
        使用RMAN DUPLICATE复制standby数据库的最后收到如下告警：

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orcl/redo02.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 4 thread 1: '/u01/app/oracle/oradata/orcl/sredo04.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/orcl/sredo05.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 6 thread 1: '/u01/app/oracle/oradata/orcl/sredo06.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/orcl/sredo07.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

Finished Duplicate Db at 2013-04-07 08:15:33

       该告警的处理参考文章：https://blogs.oracle.com/Database4CN/entry/11g_%E6%96%B0%E7%89%B9%E6%80%A7_active_database_duplication1
       解决方法：
在主备数据库设置LOG_FILE_NAME_CONVERT参数，即使参数的两个值相同也需要设置。例如：
LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'，该参数需要重启实例才能生效，之后清除备用数据库，在主数据库重新执行duplicate操作即可。


        成功duplicate之后，主数据库的日志不能传输到Standby数据库，在主数据库告警日志中显示如下告警信息：

2013-04-07 08:15:32.828000 +08:00

ALTER SYSTEM ARCHIVE LOG

Thread 1 advanced to log sequence 35 (LGWR switch)

  Current log# 2 seq# 35 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log

Archived Log entry 9 added for thread 1 sequence 34 ID 0x4fccf4e3 dest 1:

2013-04-07 08:19:37.932000 +08:00

Thread 1 advanced to log sequence 36 (LGWR switch)

  Current log# 3 seq# 36 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log

Archived Log entry 10 added for thread 1 sequence 35 ID 0x4fccf4e3 dest 1:

2013-04-07 08:19:45.210000 +08:00

Error 12154 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'orcldg1'. Error is 12154.

2013-04-07 08:20:45.222000 +08:00

Error 12154 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'orcldg1'. Error is 12154.

2013-04-07 08:21:31.206000 +08:00

Thread 1 advanced to log sequence 37 (LGWR switch)

  Current log# 1 seq# 37 mem# 0: /u01/app/oracle/oradata/orcl/redo01.log

Archived Log entry 11 added for thread 1 sequence 36 ID 0x4fccf4e3 dest 1:

2013-04-07 08:21:45.232000 +08:00

Error 12154 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'orcldg1'. Error is 12154.

2013-04-07 08:22:45.245000 +08:00

Error 12154 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'orcldg1'. Error is 12154.

        处理办法是，首先在备用数据库去掉备用数据库的静态注册，重新加载监听配置，确保在主数据库通过备用数据库Oracle Net Service配置名称能够正常的以SYS用户连接到备用数据库，之后将主数据库重启即可。

--end--

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

转载于:http://blog.itpub.net/23135684/viewspace-757896/