STEPS TO RENAME THE UNKNOW FILE IN THE STANDBY DATABASE

ALERT LOG:-
File #45 added to control file as ‘UNNAMED045’ because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log /oracle/Doyen/archive/10G_Doyen_660003944_1_257734.arc
MRP0: Background Media Recovery terminated with error 1274
Sat Sep 25 07:22:47 2010
Errors in file /oracle/Doyen/home/admin/Doyen/bdump/Doyen_mrp0_24491.trc:
ORA-01274: cannot add datafile ‘/oracle/Doyen/user02.dbf’ – file could not be created
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Sat Sep 25 07:22:50 2010
Errors in file /oracle/Doyen/home/admin/Doyen/bdump/Doyen_mrp0_24491.trc:
ORA-01274: cannot add datafile ‘/oracle/Doyen/user02.dbf’ – file could not be created
Sat Sep 25 07:22:50 2010
MRP0: Background Media Recovery process shutdown (Doyen)

—-File #45 added to control file as ‘UNNAMED045’ because

select FNNAM,FNONM from x$kccfn where FNFNO=45;
/oracle/Doyen/home/product/10.2.0.4/dbs/UNNAMED045
/oracle/Doyen/user02.dbf

alter database create datafile ‘/oracle/Doyen/home/product/10.2.0.4/dbs/UNNAMED04554’ as ‘/oracle/Doyen/user02.dbf’;

alter database datafile 45 online;

if you are going make  standby_file_management as “AUTO in the init parameter. oracle will use the
db_file_name_convert option to put the files in the respective directory in the standby database.

  • October 15, 2017 | 17 views
  • Comments