-
well unfortunately I think your databse's gone for good
-
: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.
-
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
ravi
-
SQL> recover database using backup controlfile until cancel;
-
er I didnt know you can use until cancel option in noarchive mode databases :0
-
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
ravi
-
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)
-
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
-
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
ravi
-
what are the side effects of Recover until Cancel ??
Thanks
Anurag
[Edited by anuragmin on 03-12-2001 at 06:04 PM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|