Re: Problem on backup datafiles in archive mode

The 'state' of the datafiles will change potentially when they are online. Oracle forces itself to ignore the state-changes once the TS is put into HB mode IF it is presented with the copied file later (e.g. in a datafile restore and recovery operation).

Search on :- SCN, block header, datafile header, media recovery for more info.

D.P.

David YEUNG wrote:
>
> James Williams wrote:
> >
> > On Mon, 16 Apr 2001 09:15:53 +0800, David Yeung <dyeung_at_ust.hk> wrote:
> >
> > Your hot backup script should be using cp or the like if UFS or DD if
> > raw.
> >
>
> But I don't have enough disk space to duplicate the datafiles before copying to
> tape, that's why I have to 'tar' the files to tape directly. Any suggestion?
>
> Thanks
>
> david
>
> > >I set up the Oracle (v8.1.7) running on archive mode and alter a tablespace
> > >to begin backup. However, the 'tar' keeps saying that the datafiles in that
> > >tablespace is being updated. Anyone know if I am doing anything incorrectly?
> > >
> > >Thanks
> > >
> > >david
> > >
> > >
> > >Here is the detail steps in I am doing.
> > >--------------------------------------------------------------------------
> > >SQL> alter tablespace data00 begin backup
> > >
> > >Tablespace altered.
> > >
> > >Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > >With the Partitioning option
> > >JServer Release 8.1.7.0.0 - Production
> > >
> > ><Then I start the 'tar' program to copy the datafiles to tape>
> > >./
> > >./data00_00.dbf
> > >/bin/tar: ./data00_00.dbf: file changed as we read it
> > >./data00_01.dbf
> > >/bin/tar: ./data00_01.dbf: file changed as we read it
> > >./data00_02.dbf
> > >/bin/tar: ./data00_02.dbf: file changed as we read it
> > >./data00_03.dbf
> > >/bin/tar: ./data00_03.dbf: file changed as we read it
> > >./data00_04.dbf
> > >/bin/tar: ./data00_04.dbf: file changed as we read it
> > >./data00_05.dbf
> > >/bin/tar: ./data00_05.dbf: file changed as we read it
> > >./data00_06.dbf
> > >/bin/tar: ./data00_06.dbf: file changed as we read it
> > >./data00_07.dbf
> > >/bin/tar: ./data00_07.dbf: file changed as we read it
> > >./data00_08.dbf
> > >/bin/tar: ./data00_08.dbf: file changed as we read it
> > >./data00_09.dbf
> > >/bin/tar: ./data00_09.dbf: file changed as we read it
> > >/bin/tar: Error exit delayed from previous errors
> > >
> > >> sqlplus ...
> > >SQL*Plus: Release 8.1.7.0.0 - Production on Mon Apr 16 01:10:42 2001
> > >
> > >(c) Copyright 2000 Oracle Corporation. All rights reserved.
> > >
> > >Connected.
> > >SQL> alter tablespace data00 end backup
Received on Sat Apr 21 2001 - 21:01:34 CDT