oracle10g_data guard_rman恢復測試出錯_RMAN-06207
事由如下:
不記如何把以前作的控制檔案備份(主庫上),手工刪除,導致 利用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;
不記如何把以前作的控制檔案備份(主庫上),手工刪除,導致 利用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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLSERVER恢復測試SQLServer
- Oracle恢復測試Oracle
- rman 恢復機制與恢復測試
- Oracle RMAN恢復測試Oracle
- 控制檔案恢復測試
- mysql備份恢復測試MySql
- 【管理篇備份恢復】rman恢復測試(二) 控制檔案恢復(三)
- 【管理篇備份恢復】rman恢復測試(二) 控制檔案恢復(二)
- 【管理篇備份恢復】rman恢復測試(二) 控制檔案恢復(一)
- PDM測試資料庫恢復資料庫
- rman備份恢復-rman恢復資料檔案測試
- rman恢復控制檔案測試--log
- DB2備份恢復測試DB2
- oracle備份與恢復測試(五)Oracle
- 【Mysql】xtrabackup 備份和恢復測試MySql
- RMAN備份恢復測試指令碼指令碼
- 【MYSQL備庫恢復速度測試 半同步速度測試】MySql
- Oracle常規恢復的實驗測試Oracle
- 使用RMAN實現災難恢復測試
- abmr:塊恢復特性測試自己主動
- mysql備份和恢復測試(一)--xtrabackupMySql
- oracle誤drop/update資料恢復測試Oracle資料恢復
- 測試恢復5==使用2進位制形式檔案恢復控制檔案
- 【PG備份恢復】pg_dump命令測試
- Oracle DG從庫 Rman備份恢復測試Oracle
- 生產系統恢復到異機測試
- 定時做資料庫恢復測試sqlserver資料庫SQLServer
- 【管理篇備份恢復】rman恢復測試(一) 表空間資料檔案
- 測試恢復3==當資料庫處於開啟狀態時的恢復資料庫
- oracle刪除使用者後的恢復測試Oracle
- mysql效能測試庫的一次CRASH恢復MySql
- dbms_backup_restore恢復測試!nocatalog,丟失controlfile的恢復辦法!REST
- 請教,執行測試JdonRails出錯AI
- Oracle資料恢復顧問(DRA)使用測試 (之二)Oracle資料恢復
- Oracle資料恢復顧問(DRA)使用測試 (之一)Oracle資料恢復
- 阿里雲 Mysql RDS 在 私有環境的恢復測試。阿里MySql
- Nginx 下SSL證書安裝/配置/測試/備份/恢復Nginx
- 11G RAC 異機恢復至單例項測試單例