This content has been marked as final. Show 4 replies
You can't recover a database which is in NOARCHIVELOG mode. It can only do instance recovery, which is recovering transactions which were in redo logs when system crashed.
If you do not have a cold backup, then there is not much you can do. If you have export dump then you can import that.
you don't have cold backup and your database noarchivelog i don't think there's any way to restore it.
Have a look at How To Recover NOARCHIVELOG DB Using The Online Redo Log [ID 186137.1].1 person found this helpful
Might help...but then it might not !! If it doesn't then you won't be able to recover your database.
By Online redolog my database is recovered up to available log...
SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
Present ONLINE REDOLOG ERROR LOCATION
SQL>ALTER DATABASE OPEN RESETLOGS;
Edited by: Venkateshj on Apr 20, 2013 12:14 PM
Edited by: Venkateshj on Apr 20, 2013 12:16 PM
Edited by: Venkateshj on Apr 20, 2013 12:23 PM