1 rac異地基於歸檔檔案的增量恢復

2 遇到在主庫新增資料檔案後日誌恢復出現路徑問題。

錯誤如下：

creating datafile fno=20 name=+DATA/datafile/undotbs1-1.dbf

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 07/10/2013 16:37:54

ORA-01119: error in creating database file '+DATA/datafile/undotbs1-1.dbf'

ORA-17502: ksfdcre:4 Failed to create file +DATA/datafile/undotbs1-1.dbf

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Manager

控制檔案中已經記錄了檔案的位置和名稱，但是建立檔案失敗。

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/oracle/oracle/oradata/datafile/system.302.767288597

/oracle/oracle/product/10.2.0/db/dbs/UNNAMED00020

重新建立下這個檔案：/oracle/oracle/product/10.2.0/db/dbs/UNNAMED00020

alter database create datafile '/oracle/oracle/product/10.2.0/db/dbs/UNNAMED00020' as '/oradata/datafile/dtafile.dbf ';

然後繼續恢復就可以了。

oracle基於歸檔的增量異地恢復

相關文章