duplicate ora-19505 （controlfile 不可用）

实施DG利用RMAN恢复STANDBY数据库

RMAN> duplicate target database for standby nofilenamecheck dorecover;

Starting Duplicate Db at 28-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK

contents of Memory Script.:
{
   set until scn  485861;
   restore clone standby controlfile;
   sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 28-MAR-12
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/dgdb1_02n70jpe_1_1_20120328
ORA-19870: error reading backup piece /u01/backup/dgdb1_02n70jpe_1_1_20120328
ORA-19505: failed to identify file "/u01/backup/dgdb1_02n70jpe_1_1_20120328"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/28/2012 12:20:16
RMAN-03015: error occurred in stored script. Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

出现了这个错误，很多人说是RMAN主库与备库目录不同导致的，但是我的目录是相同的。最后检查了一下备份的文件，发现了问题。

RMAN> restore controlfile validate;

Starting restore at 28-MAR-12
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/28/2012 12:34:50
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

咱们备份的控制文件，有问题不能恢复了。所以重新换了全库备份脚本。检查了备份文件。都是可用的。然后把standby恢复了。

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

转载于:http://blog.itpub.net/26442936/viewspace-721007/