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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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"