Oracle DataGuard处理UNNAMED数据文件

alert 日志报错信息：

Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL/trace/
ORCL_pr00_691.trc:
ORA-01111: name for data file 10 is unknown - rename to correct file
ORA-01110: data file 10: ' /u01/app/oracle2/product/11.2.0/dbhome_1/dbs/
UNNAMED00010'
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
复制

出现原因：

未设置standby 文件管理自动模式，或者文件转换
复制

处理：

1）备库检查需要进行恢复的文件和文件号
SQL> SELECT * FROM V$RECOVER_FILE WHERE ERROR LIKE '%MISSING%';
FILE#       ONLINE  ONLINE_ ERROR                   CHANGE# TIME
---------- ------- ------- ----------------- ---------- ----------
10          ONLINE  ONLINE  FILE MISSING                  0

2）在主库找到相应的数据文件
SQL> SELECT FILE#,NAME FROM V$DATAFILE WHERE FILE#=10;
    FILE#      NAME
---------- -----------------------------------------------
   10     /u01/app/oracle2/datafile/ORCL/users03.dbf

3）备库查询相应的数据文件
SQL> SELECT FILE#,NAME FROM V$DATAFILE WHERE FILE#=10;
    FILE#     NAME
---------- -------------------------------------------------------
10 /u01/app/oracle2/product/11.2.0/dbhome_1/dbs/UNNAMED00010

4）设置STANDBY_FILE_MANAGEMENT 为MANUAL:
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL; 
System altered.

5）利用ALTER DATABASE CREATE DATAFILE  创建文件
SQL> ALTER DATABASE CREATE DATAFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00010' AS '/u01/app/oracle/datafile/ORCL/users03.dbf';
Database altered.

如果启用了OMF，就不能这样进行处理
SQL> ALTER DATABASE CREATE DATAFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00010' AS '/u01/app/oracle/datafile/ORCL/users03.dbf';
*
ERROR at line 1:
ORA-01276: Cannot add file/u01/app/oracle2/datafile/ORCL/users03.dbf. File has an Oracle
Managed Files file name.

正确执行语句：
SQL> ALTER DATABASE CREATE DATAFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00010' AS NEW;
Database altered.

6）设置STANDBY_FILE_MANAGEMENT 为AUTO
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=BOTH; 
System altered.

SQL> SHOW PARAMETER STANDBY_FILE_MANAGEMENT

 NAME                                 TYPE        VALUE
----------------------------------- ----------- ------------------
standby_file_management              string      AUTO

7）查看备库进程和alert 日志内容
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

8)查看备库数据文件
SQL> select name ,status from v$datafile;

9)若已暂停日志应用，则进行开启
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect from session;
复制