when i am using recover database using backup controlfile until cancel.The error message is:
ora-00279: change 32498 generated at 03/09/01 needed for thread 1
ora-00289: suggestion: d:\orant\rdbms73\%oracle_sid%00599.001
ora-00280: change 32498 for thread 1 is in sequence #599
I TYPED AUTO
ora-00308:cannot open archivedlog 'D:\orant\rdbms73\%oracle_sid%00599.001'
ora-09202:sfisi:error identifying file
osd-04002:unable to open file
0/s-error:<os 2> the system cannot find the file specified;
If you had backed up the online redo logs before the CREATE CONTROLFILE...RESETLOGS, you could apply it like archived redo logs.
So put cancel.
If it says the DB is inconsistent, it doesn't matter as long as you can export the data.
Put cancel and then ALTER DATABASE OPEN RESETLOGS;
Sorry about my english I don't know how to say in the time (ficticious, wishfull time)