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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
if fully depends on which backup (files) you have.
if you have the last full backup + all the archive logs since, you can restore the full backup, and apply all the archive logs before you open the db back into normal operational mode
that is the best scenario.

otherwise, you will get into quite complex situations, usually with data loss.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day 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"
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.