Re: Backing up oracle

From: Andy Kniveton <kniveton_at_zeus.swindon.rtsg.mot.com>
Date: 14 Apr 1994 08:21:37 GMT
Message-ID: <2oiueh$g5l_at_zeus.swindon.rtsg.mot.com>

In article <cheNASa00VI681_ExL_at_andrew.cmu.edu>, Christine Hogan <ch3c+_at_andrew.cmu.edu> writes:
>
> Hi
>
> I work in an environment with 18 servers running Oracle
> databeases of varying sizes. They range from a feww hundred meg
> to several gigs. We are not allowed to shut the databases down.
>
> Currently we are putting the databases in backup mode and writing
> the whole thing to tape every night. Then we write the offline
> redo logs to the end of the tape. Backups are starting to take
> too long. We have a six hour window, and some of our backups are hitting
> the limit on that window.
>
> I was wondering what other people are doing with backups.
> Full exports?
> Incremental exports?
> Backing up different pieces each night?
>
> Oh, right now we are using 25 4mm DAT drives to do backups.
> Most machines back themselves up, but a handfull are being done
> across the network. This is also impacting backup time.
>
> We are thinking about installing dedicated backup servers and
> a secondary network to do backups.
>
> Any suggestions would be appreciated.
>
> Chris
>

I run full exports using cron and the following shell script, backup to disk when there is little use ( if any ! ) of the database then backup the 6AM.dmp file to tape later in the day.

I'd be tempted to backup to disk then tape.

00 06 * * * /usr/database/oracle/dbs/arch/6AM.sh >/dev/null 2>&

#! /bin/sh
# 6AM.sh

EXPORT_DATE=`/bin/date +%c`
ORACLE_HOME=/apps/oracle
ORACLE_SID=eng1
ORACLE_TERM=hp

MENU5PATH=/apps/oracle/forms30/admin/resource ORATERMPATH=/apps/oracle/forms30/admin/resource export ORACLE_HOME ORACLE_SID ORACLE_TERM MENU5PATH ORATERMPATH /usr/oracle/bin/exp PARFILE=/usr/database/oracle/dbs/arch/6AM.par /usr/bin/mailx kniveton_at_zeus.swindon.rtsg.mot.com >/dev/null 2>&1 <<mail_end

~c pauli_at_zeus.swindon.rtsg.mot.com
~s Oracle Full Export Log $EXPORT_DATE
~r /usr/database/oracle/dbs/arch/6AM.dmp.log

mail_end

With the par file looking like this :-

SYSTEM/********
BUFFER=4096
FILE=/usr/database/oracle/dbs/arch/6AM.dmp LOG=/usr/database/oracle/dbs/arch/6AM.dmp.log FULL=Y Andy.

-- 
  _ _ /|  	Andy Kniveton,	Tel No	+44 793 545349
  \'o.O'  	Motorola Ltd,	Fax No	+44 793 541228
  =(___)= 	16 Euro Way,	E-mail	kniveton_at_zeus.swindon.rtsg.mot.com
     U    	Blagrove, Swindon,
		England, SN5 8YQ.

"Additional: Our biggest enemy is going space crazy through loneliness. The 
only thing that helps me maintain my slender grip on reality is the friendship
I share with my collection of singing potatoes." Holly Red Dwarf II, Queeg

Received on Thu Apr 14 1994 - 10:21:37 CEST