Sunday, February 19, 2017

ORA-01110: data file 111: '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008'

  ISSUE:ORA-01119, ORA-01110, ORA-01111, ORA-01157, ORA-01186
+============================================+
Managed Standby Recovery starting Real Time Apply
ORA-00089: error in creating database file '/ORADATA/TEST/TEST_DATA_FILE_08.dbf'
ORA-17502: ksfdcre:3 Failed to create file /ORADATA/TEST/TEST_DATA_FILE_08.dbf
Sat Feb 18 12:01:46 2017
Errors in file /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_dbw0_66650230.trc:
ORA-01186: file 008 failed verification tests
ORA-01157: cannot identify/lock data file 008 - see DBWR trace file
ORA-00081: name for data file 008 is unknown - rename to correct file
ORA-00080: data file 008: '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008'
File 008 not verified due to error ORA-01157
MRP0: Background Media Recovery terminated with error 0081
Errors in file /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_pr00_46071938.trc:
ORA-00081: name for data file 008 is unknown - rename to correct file
ORA-00080: data file 008: '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008'
ORA-01157: cannot identify/lock data file 008 - see DBWR trace file
ORA-00081: name for data file 008 is unknown - rename to correct file
ORA-00080: data file 008: '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008'
Managed Standby Recovery not using Real Time Apply
Slave exiting with ORA-0081 exception
Errors in file /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_pr00_46071938.trc:
ORA-00081: name for data file 008 is unknown - rename to correct file
ORA-00080: data file 008: '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008'
ORA-01157: cannot identify/lock data file 008 - see DBWR trace file
ORA-00081: name for data file 008 is unknown - rename to correct file
ORA-00080: data file 008: '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008'
Completed: alter database recover managed standby database using current logfile disconnect
Recovery Slave PR00 previously exited with exception 0081

  Solution

+=======+
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> alter system set standby_file_management = 'manual';
SQL>  select file#,name from v$datafile where name like '%UNNAMED%';
SQL> ALTER DATABASE CREATE DATAFILE '/u01/app/oracle/product/11.2.0/db_home1/dbs/UNNAMED00008' as '/ORADATA/TEST/TEST_DATA_FILE_08.dbf';
SQL> alter system set standby_file_management = 'auto'

No comments:

Post a Comment