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.
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