Oracle 11g Data Guard 增加数据文件报错：ORA-01111、ORA-01110、ORA-01157

╰半夏微凉° 2024-04-17 23:51 7阅读 0赞

Oracle 11g Data Guard 增加数据文件时报错，在主库执行的语句如下：  
  
SQL> alter tablespace TS\_MIS\_DATA add datafile '/oradata1/misdb/TS\_MIS\_DATA\_32.dbf'  SIZE 34351349760   AUTOEXTEND OFF;  
  
SQL> show parameter standby  
  
NAME     TYPE VALUE  
\------------------------------------ ----------- ------------------------------  
standby\_archive\_dest     string ?/dbs/arch  
standby\_file\_management     string AUTO

SQL> show parameter convert  
  
NAME     TYPE VALUE  
\------------------------------------ ----------- ------------------------------  
db\_file\_name\_convert     string misdbdg, misdb  
log\_file\_name\_convert     string /arch/arch1/misdbdg, /arch/arc  
h1/misdb

备库 ALERT 日志中的报错如下：  
  
Tue Feb 09 17:52:30 2016  
Errors in file /u01/app/oracle/diag/rdbms/misdbdg/misdb/trace/misdb\_dbw0\_16033.trc:  
ORA-01186: file 43 failed verification tests  
ORA-01157: cannot identify/lock data file 43 - see DBWR trace file  
**ORA-01111: name for data file 43 is unknown - rename to correct file**  
**ORA-01110: data file 43: '/u01/app/oracle/product/11.2.0/db\_1/dbs/UNNAMED00043'**  
File 43 not verified due to error ORA-01157  
MRP0: Background Media Recovery terminated with error 1111  
Errors in file /u01/app/oracle/diag/rdbms/misdbdg/misdb/trace/misdb\_pr00\_26503.trc:  
ORA-01111: name for data file 43 is unknown - rename to correct file  
ORA-01110: data file 43: '/u01/app/oracle/product/11.2.0/db\_1/dbs/UNNAMED00043'  
ORA-01157: cannot identify/lock data file 43 - see DBWR trace file  
ORA-01111: name for data file 43 is unknown - rename to correct file  
ORA-01110: data file 43: '/u01/app/oracle/product/11.2.0/db\_1/dbs/UNNAMED00043'  
Managed Standby Recovery not using Real Time Apply  
Slave exiting with ORA-1111 exception

检查备库文件系统的权限，发现新挂载的盘没有授权，给指定目录授权  
  
chown -R oracle.dba oradata1  
  
授权后，在备库进行日志应用，但依旧报错  
  
ORA-01111: name for data file 43 is unknown - rename to correct file  
ORA-01110: data file 43: '/u01/app/oracle/product/11.2.0/db\_1/dbs/UNNAMED00043'  
ORA-01157: cannot identify/lock data file 43 - see DBWR trace file  
ORA-01111: name for data file 43 is unknown - rename to correct file  
ORA-01110: data file 43: '/u01/app/oracle/product/11.2.0/db\_1/dbs/UNNAMED00043'  
Managed Standby Recovery not using Real Time Apply  
Slave exiting with ORA-1111 exception  
  
**使用 ALTER DATABASE ** **CREATE** ** ** **DATAFILE 命令将报错的数据文件改为正确的数据文件**  
  
在备库中执行如下命令：  
  
alter database create datafile  '/u01/app/oracle/product/11.2.0/db\_1/dbs/UNNAMED00043'  as  '/oradata1/misdbdg/TS\_MIS\_DATA\_31.dbf';  
  
CREATE DATAFILE 命令的含义是根据控制文件创建一个新的数据文件，来代替原来的数据文件，之后再通过应用日志来对这个数据文件进行介质恢复。  
  
 **--实时日志应用**  
  
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;  
  
错误被修复，ALERT 日志中的内容如下：  
  
Media Recovery Log /arch/arch1/misdbdg/1\_17845\_827421642.dbf  
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION  
Recovery deleting file \#43:'/oradata1/misdbdg/TS\_MIS\_DATA\_31.dbf' from controlfile.  
Recovery created file /oradata1/misdbdg/TS\_MIS\_DATA\_31.dbf  
Successfully added datafile 43 to media recovery

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

转载于:http://blog.itpub.net/26506993/viewspace-1987469/