12c adg添加数据文件报错处理ORA-01111

一、描述12c ADGrhel 7.0

二、现象、处理过程1.主库添加数据文件，备库报错。Beginning Standby Crash Recovery.Serial Media Recovery startedManaged Standby Recovery starting Real Time ApplyStandby Crash Recovery aborted due to error 1111.Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldg_ora_2067.trc:ORA-01111: name for data file 7 is unknown - rename to correct fileORA-01110: data file 7: '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'ORA-01157: cannot identify/lock data file 7 - see DBWR trace fileORA-01111: name for data file 7 is unknown - rename to correct fileORA-01110: data file 7: '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'Completed Standby Crash Recovery.Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldg_ora_2067.trc:ORA-10458: standby database requires recoveryORA-01157: cannot identify/lock data file 7 - see DBWR trace fileORA-01111: name for data file 7 is unknown - rename to correct fileORA-01110: data file 7: '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'ORA-10458 signalled during: ALTER DATABASE OPEN READ ONLY /* db agent *//* {0:0:2} */...2.备库查看数据文件SQL> col name for a60SQL> select file#,name from v$datafile order by file#;     FILE# NAME---------- ------------------------------------------------------------         1 +DATADG/ORCLDG/DATAFILE/system.258.954626559         2 +DATADG/ORCLDG/DATAFILE/roidba.387.963323519         3 +DATADG/ORCLDG/DATAFILE/sysaux.259.954626615         4 +DATADG/ORCLDG/DATAFILE/undotbs1.260.954626701         5 +DATADG/ORCLDG/DATAFILE/roidba.388.963323313         6 +DATADG/ORCLDG/DATAFILE/users.261.954626717         7 /u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED000077 rows selected.3.重新创建新的数据文件SQL> alter database create datafile  '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'  as  '+datadg';Database altered.4.备库查看数据文件SQL> select file#,name from v$datafile order by file#;     FILE# NAME---------- ------------------------------------------------------------         1 +DATADG/ORCLDG/DATAFILE/system.258.954626559         2 +DATADG/ORCLDG/DATAFILE/roidba.387.963323519         3 +DATADG/ORCLDG/DATAFILE/sysaux.259.954626615         4 +DATADG/ORCLDG/DATAFILE/undotbs1.260.954626701         5 +DATADG/ORCLDG/DATAFILE/roidba.388.963323313         6 +DATADG/ORCLDG/DATAFILE/users.261.954626717         7 +DATADG/ORCLDG/DATAFILE/roidba.376.9633497297 rows selected.SQL> SQL> ! ls -l /u01/app/oracle/product/12.1.0/dbhome_1/dbs/total 11448-rw-r----- 1 oracle asmadmin     1024 Dec 14 11:22 archlog_1_83_961866198_585bafa7.arc-rw-r----- 1 oracle asmadmin    48640 Dec 14 11:22 archlog_1_84_961866198_585bafa7.arc-rw-rw---- 1 oracle oinstall     1544 Dec 21 21:00 hc_orcldg.dat-rw-r--r-- 1 oracle oinstall     2992 Feb  3  2012 init.ora-rw-r--r-- 1 oracle oinstall       41 Sep 13 22:08 initorcldg.ora-rw-r----- 1 oracle oinstall       24 Sep 13 22:02 lkORCLDG-rw-r----- 1 oracle asmadmin 11649024 Dec 17 11:53 snapcf_orcldg.f-rw-r----- 1 oracle oinstall     3584 Sep 13 22:02 spfileorcldg.ora5.备库查看dg信息SQL> select message from v$dataguard_status;MESSAGE--------------------------------------------------------------------------------WARNING: STANDBY_FILE_MANAGEMENT initialization parameter isARC0: Archival startedARC1: Archival startedARC2: Archival startedARC1: Becoming the 'no FAL' ARCHARC2: Becoming the heartbeat ARCHARC2: Becoming the active heartbeat ARCHARC3: Archival startedManaged Standby Recovery starting Real Time ApplyPrimary database is in MAXIMUM PERFORMANCE modeRFS[1]: Assigned to RFS process (PID:3014)MESSAGE--------------------------------------------------------------------------------RFS[2]: Assigned to RFS process (PID:3008)RFS[3]: Assigned to RFS process (PID:3021)RFS[4]: Assigned to RFS process (PID:3024)ARC1: Beginning to archive thread 1 sequence 261 (8320210-8320689)ARC0: Beginning to archive thread 1 sequence 258 (8194341-8318764)ARC1: Completed archiving thread 1 sequence 261 (0-0)ARC0: Completed archiving thread 1 sequence 258 (0-0)Attempt to start background Managed Standby Recovery processMRP0: Background Managed Standby Recovery process startedManaged Standby Recovery starting Real Time ApplyMRP0: Background Media Recovery terminated with error 1111MESSAGE--------------------------------------------------------------------------------Managed Standby Recovery not using Real Time ApplyMRP0: Background Media Recovery process shutdownAttempt to start background Managed Standby Recovery processMRP0: Background Managed Standby Recovery process startedManaged Standby Recovery starting Real Time ApplyMedia Recovery Log +DATADG/arch/log_1_258_961866198_585bafa7.arcMedia Recovery Log +DATADG/arch/log_1_259_961866198_585bafa7.arcMedia Recovery Log +DATADG/arch/log_1_260_961866198_585bafa7.arcMedia Recovery Log +DATADG/arch/log_1_261_961866198_585bafa7.arcMedia Recovery Waiting for thread 1 sequence 262 (in transit)32 rows selected.6.主库切归档，备库继续查看日志MESSAGE--------------------------------------------------------------------------------WARNING: STANDBY_FILE_MANAGEMENT initialization parameter isARC0: Archival startedARC1: Archival startedARC2: Archival startedARC1: Becoming the 'no FAL' ARCHARC2: Becoming the heartbeat ARCHARC2: Becoming the active heartbeat ARCHARC3: Archival startedManaged Standby Recovery starting Real Time ApplyPrimary database is in MAXIMUM PERFORMANCE modeRFS[1]: Assigned to RFS process (PID:3014)MESSAGE--------------------------------------------------------------------------------RFS[2]: Assigned to RFS process (PID:3008)RFS[3]: Assigned to RFS process (PID:3021)RFS[4]: Assigned to RFS process (PID:3024)ARC1: Beginning to archive thread 1 sequence 261 (8320210-8320689)ARC0: Beginning to archive thread 1 sequence 258 (8194341-8318764)ARC1: Completed archiving thread 1 sequence 261 (0-0)ARC0: Completed archiving thread 1 sequence 258 (0-0)Attempt to start background Managed Standby Recovery processMRP0: Background Managed Standby Recovery process startedManaged Standby Recovery starting Real Time ApplyMRP0: Background Media Recovery terminated with error 1111MESSAGE--------------------------------------------------------------------------------Managed Standby Recovery not using Real Time ApplyMRP0: Background Media Recovery process shutdownAttempt to start background Managed Standby Recovery processMRP0: Background Managed Standby Recovery process startedManaged Standby Recovery starting Real Time ApplyMedia Recovery Log +DATADG/arch/log_1_258_961866198_585bafa7.arcMedia Recovery Log +DATADG/arch/log_1_259_961866198_585bafa7.arcMedia Recovery Log +DATADG/arch/log_1_260_961866198_585bafa7.arcMedia Recovery Log +DATADG/arch/log_1_261_961866198_585bafa7.arcMedia Recovery Waiting for thread 1 sequence 262 (in transit)ARC3: Beginning to archive thread 1 sequence 262 (8320689-8322685)MESSAGE--------------------------------------------------------------------------------ARC3: Completed archiving thread 1 sequence 262 (0-0)Media Recovery Waiting for thread 1 sequence 263 (in transit)35 rows selected.SQL> 

三、小结1.ALTER DATABASE ... CREATE DATAFILE--官方说明Creates a new empty data file in place of an old one--useful to re-create a data file that was lost with no backup.2.StandbyFileManagement 需要参数设置为autoDGMGRL> edit database orcl set property StandbyFileManagement=auto;Property "standbyfilemanagement" updatedDGMGRL> edit database orcldg set property StandbyFileManagement=auto;Property "standbyfilemanagement" updatedDGMGRL>