recovery scenerio
amer ali
consider this recovery scenerio
Hi,
Dear Gurus.
Oracle :9.2.0
OS: windows XP
I tried to shut down the database.
The database was shutting down cleanly. But at mount state it stopped.
After waiting for an hour I just rebooted the machine.
I checked the status of the database. It was open.
No errors in alert log file.
When i checked the status of the datafile I found
out of 34 datafiles one datafile (file# no 11) status is recover.
Database is in archive log mode. I have RMAN Backup.
I dont have user managed backup.
I made the datafile offline( it was already offline)
at rman prompt.
I tried
1. RMAN>restore datafile 11;
after half an hour It successfully it says
restore successfully.
2.RMAN>recover datafile 11;
It applied around 200 archive log files.
till 1406 successfullly.
At 1407 it throws the error.(i.e the last arch file)
recovery failed.
I tried restore database and recover database(but the same error)
REASON:When I checked the archive log files.
I find that all arch files size 100mb
but the arch file no 1407 file is only 60mb. (i.e at the time which it
was shut down).
I tried many possible reasons.
I am not able to post this question since 2 days we are facing Net problem
And also I m not able to post the RMAN errors.
which I got in office since I at home now.
My Request:
I would like to know the method where I can apply archive log files
and want to avoid the last one 1407 file no.
I tried until scn, until time. but of no use.
same error.
else any other suggestion by experts:
NOTE: Restore is successful. database is upon running. all other
datafiles are healthy.
Also
some syntax sugg
I need to set until sequence 407
but i tried many syntaxes I failed
plz could u write syntax.
Thanking you
sincierly,
mariobc
if the sequence 1407 was creating in the shudown process, maybe one of
the redos have this... and it will be of 100mb...
amer ali
The said problem is solved.
I did restore using time.
Thanking you
regards,