DB open failes with ORA-01142
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