Today lt’s have a tour towards the steps which we are going to solve the issue regards “Background Media Recovery terminated with ORA-1274 after adding a Datafile

Symptoms in alert.log file:

Trace file:

Cause:

This Error occurs if we add a Datafile OR Tablespace in PRIMARY Database and that could not be translated to the Standby Database due to these Reasons:

Standby_file_management is set to MANUAL Primary & Physical Standby are having different file structures and DB_FILE_NAME_CONVERT is not set according to the Directory Structures in Primary and Standby Insufficient Space or wrong Permissions on the Standby Database to create the Datafile 

Alert Log in Standby Shows MRP is terminated with below error  

Solution:

For version < 12c — In Standby

— In Primary

— In Standby

References: Oracle Doc ID 739618.1

Thank you for your valuable time.
Thought of the day !
“Today is a wonderful day to have a wonderful day!”

Thank you for giving your valuable time to read the above information.

For More Detail , You can join us follow:

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

About The Author

Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.