Home > Oracle, Weblogic > STANDBY_FILE_MANAGEMENT parameter is not configured Auto

STANDBY_FILE_MANAGEMENT parameter is not configured Auto

If you have not set standby_file_management to Auto on the primary  and you add a datafile to the primary  you will see the following in the alert log of the standby

File #9 added to control file as ‘UNNAMED00009’ because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 1274

This will stop you standby database from being in recovery mode until this is fixed , so if you are using OMF do the following to fix it

alter database create datafile ‘/u01/app/oracloud/product/12.1.0/db_1/dbs/UNNAMED00009’ as new

also change the following parameters using dataguard broker

edit database clouddr set property StandbyFileManagement=AUTO;

edit database cloud set property StandbyFileManagement=AUTO;

then restart the dataguard broker

 

Advertisements
Categories: Oracle, Weblogic
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: