Link to home
Start Free TrialLog 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
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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"