相關文章：
《部署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--

部署Oracle 11gR2 Data Guard安裝記錄(1)

相關文章