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

重新查看日志
Attempt to start background Managed Standby Recovery process (netdata)
Tue Jun 23 22:26:33 2015
MRP0 started with pid=28, OS id=10853
MRP0: Background Managed Standby Recovery process started (netdata)
 started logmerger process
Tue Jun 23 22:26:38 2015
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 2 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /u02/archive/1_54_882661788.dbf
Media Recovery Log /u02/archive/1_55_882661788.dbf
Media Recovery Log /u02/archive/1_56_882661788.dbf
Media Recovery Log /u02/archive/1_57_882661788.dbf
Media Recovery Waiting for thread 1 sequence 58 (in transit)
已经恢复正常
总结：在做DG的时候一定要注意主备的参数。增加数据文件时一定注意路径！！！

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

转载于:http://blog.itpub.net/24486203/viewspace-1710076/