RMAN Duplicate FROM ACTIVE DATABASE 建物理DG還原檔案期間報錯ORA-17629處理

tolywang發表於2014-11-11

ORACLE 11.2.0.2 , AIX 6.1 , DATABASE SIZE = 2T
使用  "duplicate target database for standby from active database" 建立物理standby ,  當複製資料檔案到幾乎快完成的時候,碰到了如下錯誤, 提示在copy 這個檔案 ctxd.743.850458113的時候,連線不到遠端資料庫伺服器,而且提示這個failed job 不會再次run,  系統繼續其他的檔案複製, 直到結束, 如果是一個50T 的資料庫, 複製到 49T ,  出現這種情況會讓人很崩潰, 那麼是否有某個retry option 可以在網路或連線出現問題的時候, 不斷嘗試很多遍,或者實在沒有這些引數,可以有簡單一點的修復方式,而不至於再做一次full duplicate 。查詢了一些資料,實在不能找到這些option ,  提了SR,  Oracle support 提示沒有retry 選項, 提供了修復方法: Manual Completion of a Failed RMAN Duplicate FROM ACTIVE DATABASE (文件 ID 1602916.1) , 這個場景符合其中的phase 2 。 近期找時間再測試一下。

 ..... 
 channel ch5: starting datafile copy
 input datafile file number=00036 name=/data07/crp3data/apps_ts_tools.776.850432873
 output file name=/oracle/oradata/crp3/hwapps_ts_tx_idx.681.850456011 tag=TAG20141107T180212
 channel ch8: datafile copy complete, elapsed time: 00:05:40
 channel ch8: starting datafile copy
 input datafile file number=00030 name=/data03/crp3data/ctxd.743.850458113
 RMAN-03009: failure of backup command on ch8 channel at 11/08/2014 07:29:55
 ORA-17629: Cannot connect to the remote database server
 ORA-17629: Cannot connect to the remote database server
 continuing other job steps, job failed will not be re-run
...
 output file name=/oracle/oradata/crp3/owapub.728.850443675 tag=TAG20141107T180212
 channel ch2: datafile copy complete, elapsed time: 00:04:41
 ....
 released channel: ch13
 ...
 released channel: ch16
 released channel: stby1
... 
 released channel: stby16

 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-03002: failure of Duplicate Db command at 11/08/2014 07:33:07
 RMAN-05501: aborting duplication of target database
 RMAN-03015: error occurred in stored script Memory Script
 RMAN-03009: failure of backup command on ch8 channel at 11/08/2014 07:29:55
 ORA-17629: Cannot connect to the remote database server
 ORA-17629: Cannot connect to the remote database server
 Recovery Manager complete.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-1328759/,如需轉載,請註明出處,否則將追究法律責任。

相關文章