Suggested steps got stuck in the middle
wizards bt12, July 10, 2017 - 9:53 am UTC
Hi,
Many thanks for your reply on this. However, as I tried to execute the steps mentioned in
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1817039200346240329 I came across the following error(The DB was mounted but not open):-
SYS@omc> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
However, the issue here is I cannot open the DB, how can I execute the above query successfully.
July 16, 2017 - 7:27 am UTC
Time to speak to Support.
How to re-create a logfile
Abiven, July 17, 2017 - 10:29 am UTC
You seem to lost a logfile...It is a big issue you should first open a case at the oracle support.
If you cannot and don't matter of the recovery (and if you allow to lose data/transaction), and just want open the database as soon as possible.
You can try this:
ALTER DATABASE CLEAR LOGFILE GROUP 3;
If you are in Archive log mode :
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Best regards,
Jean Christophe Abiven.