Skip to Main Content

Oracle Database Discussions

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!

DB open failes with ORA-01142

user636110Dec 3 2012 — edited Dec 3 2012
Hello Everyone

I'm trying to restore one of the hot backup, however DB open fails,I dont have much information abt this backup, this was handed over to me, but feel there should be some way to end this backup and open the database.
Any guidence in this will be much appreciated.
following is my scenario.


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery if it was restored from backup, or END

SQL> select status from v$backup;

STATUS
------------------
ACTIVE
ACTIVE
ACTIVE
ACTIVE
ACTIVE
ACTIVE
ACTIVE

SQL> alter database end backup;
alter database end backup
*
ERROR at line 1:
ORA-01142: cannot end online backup - none of the files are in backup


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2012
Added on Dec 3 2012
16 comments
3,773 views