Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem on backup datafiles in archive mode

Re: Problem on backup datafiles in archive mode

From: James Williams <willjamu_at_mindspring.com>
Date: Mon, 16 Apr 2001 16:08:27 GMT
Message-ID: <3adb18da.60292208@nntp.mindspring.com>

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.

>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 Mon Apr 16 2001 - 11:08:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US