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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-1328759/