Re: practice for backup and recovery

Ajeet,

I think that generally most people are doing well to practice just a few recovery scenarios. :-)
If you read various DBA backup and recovery books that discuss how to recover from various situations, you may be able to compile your own list, and perhaps share it with this group for futher feedback. The Oracle Education Backup & Recovery class walked you through a number of common scenarios. Then the last day the teacher would have you prepare a database, ask you to leave the room, then you would return and attempt to diagnose and recover your database. I think the Oracle Masters examination also did something of that sort, if I recall correctly.

Just off the top of my head, some that come to mind are:

• missing data file.
• missing redo log(s)
• missing control file
• missing everything (recover entire database from backup).
• recover database that is in nonarchivelog mode. As Jared says, the permutations are vast.

Dennis Williams

On 6/18/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 6/18/07, Ajeet Ojha <ajeeto_at_gmail.com> wrote:
> >
> > Hi
> > is there any place - where I can get all the posssible recovery
> > scienarios and can practice them in my database.
> > please let me know.
> >
>
> Get out your calculator.
>
> You won't live long enough to try all possible recovery scenarios.
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l