Link to home
Create AccountLog in
Avatar of nobleit
nobleit

asked on

recovery


The database is in archivelog mode   and database crashed..corruption is found scattered among the file system neither or my doing or nor of oracle's ..May I know the recovery option available
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Right a3.

Plus, I assume you have your logs and backups stored offline, not affected by the corruption.

It is also critical to find if you have corruption in the current online redo logs, that will dictate whether you can fully recover or not. If the online logs are still good (run dbverify), and you have a good backup, followed by an unbroken chain of archive logs ending with the current live logs, you can fully recover.

You can also do block level recovery of specific areas, to reduce the overall recovery time. Google docs on "oracle block level recovery"