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!

What is wrong with my database :(

Beauty_and_dBestMay 28 2016 — edited Jun 6 2016

Hi ALL,

11gR2

OL6

I perform a database recovery of our PROD to DR server using RMAN.

I was able to restore and recover database up to the last archive logs.

But still my database won't open

Is there a force open command?

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/home/oraprod/PROD/data/system01.dbf'

Please help...

Kind regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2016

Added on May 28 2016

#performance-availability, #recovery-manager-rman

44 comments

9,341 views