物理dataguard日志无法应用问题

今天发现自己搭的一个dg环境归档日志无法应用，看报警日志报如下错误：

 

Sat Mar 26 18:39:18 2011

WARNING: File being created with same name as in Primary

Existing file may be overwritten

File #5 added to control file as 'UNNAMED00005'.

Originally created as:

'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T1.DBF'

Recovery was unable to create the file as:

'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T1.DBF'

WARNING: File being created with same name as in Primary

Existing file may be overwritten

File #6 added to control file as 'UNNAMED00006'.

Originally created as:

'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF'

Recovery was unable to create the file as:

'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF'

Errors with log E:/ARCH/TEST1/ARC00089_0740093130_001.ARC

MRP0: Background Media Recovery terminated with error 1274

Sat Mar 26 18:39:20 2011

Errors in file e:/tools/oracle/admin/test1/bdump/test1_mrp0_2132.trc:

ORA-01274: 无法添加数据文件 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF' - 无法创建文件

ORA-01119: 创建数据库文件 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF' 时出错

ORA-27038: 所创建的文件已存在

OSD-04010: 指定了 <create> 选项, 但文件已经存在

ORA-01119: 创建数据库文件 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T1.DBF' 时出错

ORA-27038: 所创建的文件已存在

OSD-04010: 指定了 <create> 选项, 但文件已经存在

 

Some recovered datafiles maybe left media fuzzy

Media recovery may continue but open resetlogs may fail

Sat Mar 26 18:39:22 2011

Errors in file e:/tools/oracle/admin/test1/bdump/test1_mrp0_2132.trc:

ORA-01274: 无法添加数据文件 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF' - 无法创建文件

ORA-01119: 创建数据库文件 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF' 时出错

ORA-27038: 所创建的文件已存在

OSD-04010: 指定了 <create> 选项, 但文件已经存在

ORA-01119: 创建数据库文件 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T1.DBF' 时出错

ORA-27038: 所创建的文件已存在

OSD-04010: 指定了 <create> 选项, 但文件已经存在

后想起前些日子在主库创建过t1和t2这两个数据文件，但没有在备库上先创建，根据alter日志报错进行如下操作：

SQL> alter system set standby_file_management=manual;

System altered.

 

alter database create datafile 5 as 'E:/TOOLS/ORACLE/ORADATA/TEST1/T1.DBF'；

 

alter database create datafile 6 as 'E:/TOOLS/ORACLE/ORADATA/TEST1/T2.DBF'；

 

alter database rename file 'E:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/UNNAMED00005' to 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T1.DBF'；

 

alter database rename file 'E:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/UNNAMED00006' to 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/T2.DBF'

 

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;

 

SQL> recover managed standby database disconnect from session;
Media recovery complete.

 

再次查看归档应用情况正常。