Re: Total media recovery from hotbackup

<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 Received on Mon Sep 06 1999 - 04:26:25 CDT