oracle10g_data guard_rman恢復測試出錯_RMAN-06207

wisdomone1發表於2010-02-01
事由如下:
   不記如何把以前作的控制檔案備份(主庫上),手工刪除,導致 利用rman恢復總提示如下錯誤:
-bash-3.1$ rman target sys/system@centos auxiliary sys/system

Recovery Manager: Release 10.2.0.4.0 - Production on Sun Jan 31 02:45:07 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: CENTOS (DBID=3005679176)
connected to auxiliary database: CENTOS (not mounted)

RMAN> run
2> {set until scn 671285;
3> duplicate target database for standby
4> nofilenamecheck
5> dorecover;
6> }

executing command: SET until clause
using target database control file instead of recovery catalog

Starting Duplicate Db at 31-JAN-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=159 devtype=DISK

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

executing command: SET until clause

Starting restore at 31-JAN-10
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 /oracle/rmanbak/CENTOS_standbyctl.bak
ORA-19870: error reading backup piece /oracle/rmanbak/CENTOS_standbyctl.bak
ORA-19505: failed to identify file "/oracle/rmanbak/CENTOS_standbyctl.bak"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup


然後在主庫進入rman操作如下
rman target sys/system@centos
 1,先驗證主庫備份的有效性
     restore database validate;
     restore archivelog all validate;
 2,list backup of database;
    list copy of database;
    list backupset of database;
    ....同理(對於其它備份物件)
    list backup of controlfile;
    list backup of archivelog;
   
    crosscheck backup of controlfile;--這下子就出來好多無效的控制檔案備份

   哈哈,下來你就可以用delete真正把這些東東,從rman的控制檔案中清除,下次rman在恢復就會再用這些資訊了,以免給你添麻煩
    delete noprompt obsolete;


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

相關文章