Re: Total media recovery from hotbackup

In article <7r01cc$jg3$1_at_taliesin.netcom.net.uk>,   "Alex Hudghton" <alex_at_alenda.freeserve.co.uk> wrote:
>
> <marksmith101_at_my-deja.com> wrote in message
> news:7qmre2$6kt$1_at_nnrp1.deja.com...
> > Hello,
> >
> > I am new to Oracle DB admin. I have been trying to recover an
> > Oracle DB from a hotbackup, but the datafile for the system keeps
> > requiring extra recovery. I believe that the SCNs must be out of
sync
> > when the backup is preformed, but I don't know how to check the
SCNs of
> > a datafile. Here is an overview of the backup procedure:
> >
> > hotbackup datafiles (i.e. alter tablespace ...)
> > backup control file
> > force log switch
> > backup archive logs
> >
> > Here is an overview of the recovery procedure:
> >
> > restore data and control files
> > rename redo logs (assuming)
> > recover the DB using control file
> > open DB with resetlogs
> >
> > At this point the datafile associated with the system tablespace
> > complains about an error:
> >
> > ORA-01110: data file 1: '/home/oradataB1/_/system.dbf'
> >
> > Any suggestions?
> >
>
> Check the view V$BACKUP on your new database to ensure that all of the
> tablespaces are out of hot backup mode.
>
> Alex
>
>

Thanks, this was just the information I needed.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 21:51:04 CDT