Control File-Urgent

[pando]

well unfortunately I think your databse's gone for good

[rcaballe]

:D
Try a RECOVER DATABASE
and then put CANCEL
Cross your fingers and open it, if you can't, sorry, It's asistolic (dead).
I guess that's why you must put a timeout in log switch.

[cravi]

HI

WHEN I AM USING THE RECOVER DATABASE UNTIL CANCEL THE ERROR MESSAGE IS:

ORA-00283:RECOVERY SESSION CANCELLED DUE TO ERRORS.
ORA-01610:RECOVERY USING THE BACKUP CONTROLFILE OPTION MUST BE DONE.

ANY IDEA TO RESOLVE THIS

THANKS
RAVI

[rcaballe]

SQL> recover database using backup controlfile until cancel;

[pando]

er I didnt know you can use until cancel option in noarchive mode databases :0

[cravi]

Hi

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
specify log:<<ret>=suggested|filename\auto|cancel

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;

Any solution plz.

Thanks for all your help
Ravi

[rcaballe]

Put cancel.
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)

[pando]

well before do anything to this half dead database... back it up

then do the recovery, when it asks you for the log it must be one of online redo logs, you have to guess which you should apply and type manually the file name NOT auto

[cravi]

Hey ramon/pando & All

Please First of all accept my Thanks.

I did it.

I deleted the previous control file which i created now and the i recreated a control file with NORESETLOGS.

SO IT MAKES THE NEW CONTROLFILE CURRENT.

Then i issued alter database open resetlogs.That's it.All done.

Thank you very much
Ravi

[anuragmin]

what are the side effects of Recover until Cancel ??

Thanks
Anurag


[Edited by anuragmin on 03-12-2001 at 06:04 PM]