ORA-01110

My Database Setup is :

Primary : 2 Node RAC 12.1.0.2 with Multitenant Architecture and ASM file structure

Standby : 2 Node RAC 12.1.0.2 with Multitenant Architecture and ASM file structure

During Data Guard Configuration, the standby file management was kept to manual (by mistake). After that we have created one new tablespace in primary database and which has shutdown the MRP process in Data Guard with below errors in alert log of standby instance.

ORA-01111: name for data file 87 is unknown – rename to correct file

ORA-01110: data file 87: ‘/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00087’

ORA-01157: cannot identify/lock data file 87 – see DBWR trace file

ORA-01111: name for data file 87 is unknown – rename to correct file

ORA-01110: data file 87: ‘/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00087’

MRP0: Background Media Recovery process shutdown (blrdr2)

SQL> show parameter standby

NAME TYPE VALUE
———————————— ———– ——————————
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
http://www.oracle-ckpt.com/unnamed-file-in-standby-after-adding-new-file-to-primary-ora-01111-ora-01110-ora-01157/
http://www.oracle-ckpt.com/unnamed-file-in-standbypdb-after-adding-new-file-to-primarypdb/

https://community.oracle.com/thread/3980984

Advertisements

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