Isssue:On standby database:
SQL>alter database commit to switchover to primary;
or
SQL>recover standby database
Errors in
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
file /u01/app/oracle/diag/rdbms/np_hmwprd01/HMWPRD01/trace/HMWPRD01_pr00_32286.trc:ORA-01111: name for data file 6 is unknown - rename to correct fileORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01111: name for data file 6 is unknown - rename to correct file
ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'
Slave exiting with ORA-1111 exception
Solution:
1)Check : standby_file_management = manual or AUTO (make it AUTO)
2)select name from v$datafile;
NAME
----------------------------------------------------
+DG_jd_01/jd/datafile/system.259.808327713
+DG_jd_01/jd/datafile/sysaux.258.808327713
+DG_jd_01/jd/datafile/undotbs1.260.808327713
+DG_jd_01/jd/datafile/users.261.808327713
+DG_jd_01/jd/datafile/mwdata.257.808327711/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006
alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'
as '+DG_jd_01/jd/datafile/mwdata.dbf';
Check following parameter to avoid these issue again:
alter system set db_create_file_dest='+DG_jd_01';
alter system set standby_file_management=auto;
Check standby UNIQUE name
SQL>alter database commit to switchover to primary;
or
SQL>recover standby database
Errors in
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
file /u01/app/oracle/diag/rdbms/np_hmwprd01/HMWPRD01/trace/HMWPRD01_pr00_32286.trc:ORA-01111: name for data file 6 is unknown - rename to correct fileORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01111: name for data file 6 is unknown - rename to correct file
ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'
Slave exiting with ORA-1111 exception
Solution:
1)Check : standby_file_management = manual or AUTO (make it AUTO)
2)select name from v$datafile;
NAME
----------------------------------------------------
+DG_jd_01/jd/datafile/system.259.808327713
+DG_jd_01/jd/datafile/sysaux.258.808327713
+DG_jd_01/jd/datafile/undotbs1.260.808327713
+DG_jd_01/jd/datafile/users.261.808327713
+DG_jd_01/jd/datafile/mwdata.257.808327711/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006
alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'
as '+DG_jd_01/jd/datafile/mwdata.dbf';
Check following parameter to avoid these issue again:
alter system set db_create_file_dest='+DG_jd_01';
alter system set standby_file_management=auto;
Check standby UNIQUE name
No comments:
Post a Comment