DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, December 29, 2016

Renaming UNNAMED datafile(s) to standby database

Renaming UNNAMED datafile(s) to standby database

If parameter STANDBY_FILE_MANAGEMENT is set to MANUAL in Oracle standby database you may get
this error when rolling forward:

Media Recovery Log logfile.arc
File #416 added to control file as 'UNNAMED00416' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log logfile.arc
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Thu Dec 22 15:34:33 2016
Media Recovery failed with error 1274
ORA-283 signalled during: ALTER DATABASE RECOVER automatic standby database ...

What has to be done is as follows.

On standby database:

SQL> select name from v$datafile where name like '%UNNAMED00416%';

NAME
--------------------------------------------------------------------------------
/apps/oracle/product/10.1.0/db_1/dbs/UNNAMED00416


On production database:

SQL> select name from v$datafile where file# = 416;

NAME
--------------------------------------------------------------------------------
path_to_the_actual_file.dbf

And finally on standby database again:

SQL> alter database create datafile '/apps/oracle/product/10.1.0/db_1/dbs/UNNAMED00416' as
'path_to_the_actual_file.dbf';


Done..!!

No comments: