|
Re: Oracle incremental backup
1999-05-26 20:53:14
We run Oracle under SAP, on NT. We do ONLINE (I believe that's not same as
incremental),
backups, and then backup the archive logs. This allows us to have a bigger
window, as
we don't have to take systems down. We do a full offline bu on week-ends.
I've never
had any problem restoring, and applying the archive logs. We use the
SAP/ADSM interface
called backint.WE also bu to disk then later to tape (then again for the
OFFISTE tape).
At 09:25 AM 5/26/99 -0400, you wrote:
>We are running ADSM 3.1.1.3 on an H50 under AIX 4.3. We backup to a disk
>pool and then migrate the data to tape later. We use an STK9710 library with
>DLT7000 tapes drives. We currently backup 60+ servers and aprox 200GB a
>night. The majority of the data backed up is full backups of Oracle data
>bases. Most of our Oracle data bases are v7.3.X. We also have a couple
>that are V8. We have two servers with large Oracle databases(aprox 200GB
>each- V7.3.5) we want to add to ADSM. When/if that happens under our
>current environment we will no longer meet our backup window. We have been
>discussing doing incremental backups on the Oracle data bases(do a full
>backup on Sunday and then backup the logs during the week). I'd like to
>hear from anyone who has experience(good & bad) doing incremental Oracle
>backups. I'd also be interested in your method of doing them.
>
>Thanks
>
>Doug Strilecky
>BCBSM
>dstrilecky AT bcbsm DOT com
>ph. 313-983-3411
>fax 313-225-6644
>
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
><HTML>
><HEAD>
><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
><META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
><TITLE>Oracle incremental backup</TITLE>
></HEAD>
><BODY>
>
><P><FONT SIZE=2 FACE="Arial">We are running ADSM 3.1.1.3 on an H50 under
AIX 4.3. We backup to a disk pool and then migrate the data to tape
later. We use an STK9710 library with DLT7000 tapes drives. We
currently backup 60+ servers and aprox 200GB a night. The majority of the
data backed up is full backups of Oracle data bases. Most of our
Oracle data bases are v7.3.X. We also have a couple that are
V8. We have two servers with large Oracle databases(aprox 200GB each-
V7.3.5) we want to add to ADSM. When/if that happens under our current
environment we will no longer meet our backup window. We have been
discussing doing incremental backups on the Oracle data bases(do a full
backup on Sunday and then backup the logs during the week). I'd like
to hear from anyone who has experience(good & bad) doing incremental
Oracle backups. I'd also be interested in your method of doing
them.</FONT></P>
>
><P><FONT SIZE=2 FACE="Arial">Thanks</FONT>
></P>
>
><P><FONT SIZE=2 FACE="Arial">Doug Strilecky</FONT>
><BR><FONT SIZE=2 FACE="Arial">BCBSM</FONT>
><BR><FONT SIZE=2 FACE="Arial">dstrilecky AT bcbsm DOT com</FONT>
><BR><FONT SIZE=2 FACE="Arial">ph. 313-983-3411</FONT>
><BR><FONT SIZE=2 FACE="Arial">fax 313-225-6644</FONT>
></P>
><BR>
>
></BODY>
></HTML>
|
|
|
