System Datafile corrupted

[abdel]

Hello,

When I started my database this morning I got a message telling that the database should be open in RESETLOGS or in NORESETLOGS.
I opened it in RESETLOGS as configured in my control file. I then got the ORA-01113 and ORA-01110 message, where I discovered that my system datafile was corrupted. I copied it from the backup location, to the original location then I started the DataBase in mount mode and issued the ALTER DATABASE RENAME command, but then It told me that the file does not exist. Not knowing what step to follow next, I ventured issuing the RECOVER DATABASE command,upon which it instructed me to recover using the BACKUP CONTROLFILE option. I did issue that command
specifying the full path of the control file, and I got the ORA-00905 Keyword missing error.
I re-issued the same command, this time without specifying the location where I did back up my control file and I got the following:

SQL> recover database using backup controlfile
ORA-00279: change 1329085 generated at 12/11/2007 07:59:13 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORA92\RDBMS\ARC00012.001
ORA-00280: change 1329085 for thread 1 is in sequence 12
specify log: {=suggested | filename |AUTO | CANCEL}
Now I'm stucked and I do not know how to proceed.

Any tips?

[PAVB]

Question is... Do you have the archived log Oracle is asking for?

[abdel]

I do not have the arc00012.001 it is asking for. The one I have is
arc00010.001.

[PAVB]

try this...
shutdown your database
restore corrupted datafile from last backup
restore archive logs taken since date of corrupted datafile's last backup
startup mount
recover database until cancel
...apply your logs
...at the time you reach the missing log just type CANCEL with one hand while keeping your fingers crossed on the other hand.
alter database open resetlogs;
shutdown database
take a cold backup
startup

[Tuma]

try this...
shutdown your database
restore corrupted datafile from last backup
restore archive logs taken since date of corrupted datafile's last backup
startup mount
recover database until cancel
...apply your logs
...at the time you reach the missing log just type CANCEL with one hand while keeping your fingers crossed on the other hand.
alter database open resetlogs;
shutdown database
take a cold backup
startup

made my day....

[abdel]

try this...

recover database until cancel
...apply your logs
...at the time you reach the missing log just type CANCEL with one hand while keeping your fingers crossed on the other hand.
startup

Thank god I am working on my own otherwise the stress on me would have iced my fingers, PAV
I will try that though, I would like to know only one thing, How do I apply the logs?

Thanks

[davey23uk]

you follow what it says on screen, by giving the name of the logs - try it out

[abdel]

I did that and even simpler... I tried just hitting ENTER and I saw that it was working

[malay_biswal]

To ABDEL,
Then just say a plain thank you.
PAVB saved your ass.

[Bore]

:-) And maybe you should know that you lost some data