Re: How do you backup a live database?

This is a cryptographically signed message in MIME format.

--------------msA8A4C978BC8D2032A997FAB1 Content-Type: multipart/mixed; boundary="------------E82997F453F8C63A32744B64"

This is a multi-part message in MIME format.

--------------E82997F453F8C63A32744B64
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Very Correct. In addition, Oracle includes two solutions for backing up live content. 1) The exp utility exports the filesystem to tape "live". Or, for a more robust backup, use Oracle's Enterprise Backup Utility. This app plugs into most major Backup Management products (Legato, Backup-Edge....) Hope this helps!

Jason C Austin wrote:

> Atif Ahmad Khan wrote:
> > I have Oracle Workgroup Server 7.3.2.* running under Solaris X86
> > 2.5.1.
> > I have been given a 32GB DAT drive and asked to come up with a good
> > backup solution. I am not much concerned about the system backups
> > as it doesn't change much every day. However some tables in the
> > database
> > change every minute. Even if I were to export these tables and do
 an
> > incremental backup, I cant possibly keep the backup up to date.
> > There
> > will be records lost if the drive were to crash in the middle.
>
> The Oracle documentation should explain backup and recovery.
> Basically, you put tablespaces backup mode, write them to tape, and
> then switch back to normal mode. When you switch back, all pending
> changing are made. It's commonly called a hot backup.
>
> You also need set the database to archive redo logs, so if you
>
> have to go back to tape, you can bring it back to the minute the
> tablespace was lost. Save the archived logs on a different disk than
> the tablespaces and write them to tape on a regular basis.
> --
> Jason C. Austin
> austin_at_visi.net

--
_____________________________________
Jim Maze        <jmaze_at_ameritech.net>
Systems Administrator - Ameritech.net
OFC:(312)526-8023 Pager:(312)760-4806
http://www.ameritech.net
_____________________________________


--------------E82997F453F8C63A32744B64
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Maze, Jim 
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Maze, Jim 
n:              Maze;Jim 
org:            Ameritech Interactive Media Services
adr:            300 S Riverside Plaza;;Suite 1800 S;Chicago;IL;60606;
email;internet: jmaze_at_ameritech.net
title:          Systems Administrator
tel;work:       312-526-8023
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
end:            vcard


--------------E82997F453F8C63A32744B64--

--------------msA8A4C978BC8D2032A997FAB1
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

<encoded_portion_removed>
C6MI9HLSmHrzzfEoyXu0rFRNs950lF4=
--------------msA8A4C978BC8D2032A997FAB1--