Re: Problem on backup datafiles in archive mode

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 Wed Apr 18 2001 - 19:50:15 CDT