Datagurad ORA-01111錯誤解決

在DBRA測試建立資料檔案中遇到問題。

在生產庫建立了一個資料檔案，備庫應用相關日誌時因為許可權問題出錯：

Attempt to start background Managed Standby Recovery process (netdata)
Tue Jun 23 22:20:36 2015
MRP0 started with pid=19, OS id=10735
MRP0: Background Managed Standby Recovery process started (netdata)
 started logmerger process
Tue Jun 23 22:20:41 2015
Managed Standby Recovery starting Real Time Apply
Tue Jun 23 22:20:41 2015
Errors in file /u01/app/oracle/diag/rdbms/snetdata/netdata/trace/netdata_dbw0_9257.trc:
ORA-01186: file 7 failed verification tests
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00007'
File 7 not verified due to error ORA-01157
Errors in file /u01/app/oracle/diag/rdbms/snetdata/netdata/trace/netdata_dbw0_9257.trc:
ORA-01186: file 202 failed verification tests
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '+DATA'
File 202 not verified due to error ORA-01157
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/snetdata/netdata/trace/netdata_pr00_10738.trc:
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00007'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
因為主備路徑不一致
備庫操作：
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;
alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00007' as '/u02/oradata/netdata/netdata01.dbf'

 ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION