Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > Oracle > DR     

Adding new datafiles 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 Jun 22 15:34:33 2006
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';



  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

     (Average: 4 / Votes: 1)   Rate this tip:    

Start discussion or add comment to this tip

  Details
Tip reference : #108
views : 443
Added on : 06/22/06
Submited by : h8dk97
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (149)
 
 
<< Previous Next >>
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Databases > Oracle : Kill user session  
  Databases > Oracle : Scripts to backup Oracle database on Windows NT  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | TipLib FAQ
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com