Re: Recovery Scenario

Actually, my database is fine. It is the backups that are failing. One file is not getting copied over. Hot backup runs at midnight and there is almost no activity in the database at that time.

I just ran a hot backup and it ran in 13 mins (usually 20 min).

Is there a timeout on AIX? I will post another question.

Thanks,

Manjula

On 7/22/05, Eric Valk <listeric1_at_gmail.com> wrote:
> Hello Munjala,
>
> First, some assumptions:
>
> - database crashed resulting in a damaged database (otherwise all you
> need is instance recovery).
>
> - I assume that it is a datafile that is not backed up on the second day.
>
> - I will also assume that the file is lost, if not then recovery is quite easy
> assuming that you have all required archived redo logs (and possibly
> event the redo logs not yet backed up including the current online log).
>
> - I'll also assume that you have a controlfile that records the lost datafile.
>
> Since you now have a database in your backups that is lacking a datafile
> you'll need to create a new empty datafile that will take the place
> of the lost datafile. The ALTER DATABASE command has a "create datafile"
> option specifically for that purpose. Once you accomplish that you can
> (media) recover your database completely.
>
> HtH
>
> Regards
> Eric Valk
>
>
> 2005/7/21, Manjula Krishnan <oradba.la_at_gmail.com>:
> > Say I have the following scenario.
> >
> > Day 1: Hot Backup - all files backup successfully
> > Day 2: Hot Backup - one file does not back up
> > Day 3: Database crashes
> >
> > Using Day 1 backup, can I restore to current time assuming I have all
> > archive logs needed?
> >
> > Thanks,
> >
> > Manjula
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>

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