相关文章:
《部署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用户连接到备用数据库,之后将主数据库重启即可。
处理办法是,首先在备用数据库去掉备用数据库的静态注册,重新加载监听配置,确保在主数据库通过备用数据库Oracle Net Service配置名称能够正常的以SYS用户连接到备用数据库,之后将主数据库重启即可。