RENAME THE
UNKNOWN FILE IN THE STANDBY DATABASE WHEN YOU PUT THE STANDBY_FILE_MANAGEMENT
IN MANUAL MODE
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/MYDB/archive/10G_MYDB_5490950350_1_257734.arc
MRP0:
Background Media Recovery terminated with error 1274
Sat Sep 25
07:22:47 2010
Errors in file
/oracle/MYDB/home/admin/MYDB/bdump/MYDB_mrp0_24491.trc:
ORA-01274:
cannot add datafile '/oracle/MYDB/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/MYDB/home/admin/MYDB/bdump/MYDB_mrp0_24491.trc:
ORA-01274:
cannot add datafile '/oracle/MYDB/user02.dbf' - file could not be created
Sat Sep 25
07:22:50 2010
MRP0:
Background Media Recovery process shutdown (MYDB)
Cause
:
----File #45
added to control file as 'UNNAMED045' because
select
FNNAM,FNONM from x$kccfn where FNFNO=45;
/oracle/MYDB/home/product/11.2.0/dbs/UNNAMED045
/oracle/MYDB/user02.dbf
Solution
:
SQL> alter
database create datafile '/oracle/MYDB/home/product/11.2.0/dbs/UNNAMED04554' as
'/oracle/MYDB/user02.dbf';
alter
database datafile 45 online;
if you are
going make standby_file_management as
"AUTO" in the init parameter., then Oracle will use the db_file_name_convert
option to put the files in the respective directory in the standby database.
No comments:
Post a Comment