And for what it's worth doing a recovery without further investigation of the problem you are encountering doesn't sound like a good idea at all. Hopefully this isn't a production database...
1 person found this helpful
Recover database using 'until cancel' option and later open it using resetlogs option. Later, take a fresh backup.
Got these errors now..
SQL> alter database recover until cancel;
alter database recover until cancel
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
set until time "to_date('2014-3-12:17:00:00','yyyy-mm-dd:hh24:mi:ss')";
later, run query: alter database open resetlogs;
set time when db was running according to you.
I recovered database by following steps :-
step1: open "dbca" from start menu (simply by typing dbca in search area or in run)
step2: delete databse
step3: create new databse
step4: select general purpose
step5: database name "orcl"
step6: check on "create sample schema"
Thanx to my teacher for the solution and all those who helped
So you dropped the database and created a new one. I wouldn't call that a recovery as if you would have had any important data in your database you would have lost it
Yeah that wasn't a recovery, but for the time being solved my problem