Re: Problem on backup datafiles in archive mode

From: andrew <andrew_at_info.nl>
Date: Thu, 19 Apr 2001 15:03:47 +0200
Message-ID: <9bmnor$94d$1@porthos.nl.uu.net>

Use RMAN in stead.
Advantages:
- backups are smaller because only blocks that have ever been written to are backupped
- the backupfile produced by RMAN can be sent to disk or to tape Disadvantage:
- RMAN syntax is ..rman syntax :- But you can Enterprise Manager handle the RMAN backups.

See the documentation or metalink.

Regards,
Andre van Winssen

"David YEUNG" <dyeung_at_ust.hk> wrote in message news:3ADE3647.A23038B3_at_ust.hk...
> 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 Thu Apr 19 2001 - 08:03:47 CDT