Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to recover a PDB in noarchivelog mode?

user2834408Dec 15 2014 — edited Dec 15 2014

Hi all,

Urgent! We have a PDB currently in mount stage after restoring and recovering from backup. Whenever I tried to open it or recover data file, I keep getting this error message:

Errors in file C:\ORACLE\diag\rdbms\us022348\us022348\trace\us022348_p000_8788.trc:

ORA-01113: file 9 needs media recovery

ORA-01110: data file 9: 'D:\ORADATA\12C\US022348\0FB7D663771D443E8DE2229B76E0DCA7\DATAFILE\O1_MF_USERS_B2TVTBL1_.DBF'

The CDB and PDB both are in noarchivelog modes.

Which command should I use to bring the database back?

Thanks!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2015

Added on Dec 15 2014

#database-key-features, #multitenant

3 comments

1,435 views