Re: Hot backups for Oracle 7/Solaris

bmanry_at_ibmgate-aix.us.oracle.com (Bill Manry - Oracle Corp.) wrote:

>Rich Moldovan (richmo_at_azstarnet.com) wrote:
>>I currently have been assigned the task of backing up an recently
>>started Oracle data base. Oracle 7 is running on a Sparc/Solaris
>>platform and the data files reside on an NFS mounted drive. The
>>NFS server is an Auspex file server running SunOS 4.1.3. We already
>>have tape backup facilities on the Auspex. My problem is - since
>>the database is serving a 24hour/7day manufacturing facility, it is
>>impracticle to shut the database down for cold backups. It seems
>>ludicrous to backup a 2 gig data file that is 98% empty at this
>>point. Does anyone have any recomendations for this situation.
 

>Rich,
 

>You don't have to shut down the database to take a backup. Take
>a look at the DBA guide discussion of ALTER TABLESPACE...BEGIN
>BACKUP etc. Your point about backing up a mostly-empty database
>is a good one. The Oracle Enterprise Backup Utility announced
>this week addresses that problem; check with your Oracle rep for
>details.
 

>I don't know anything about Auspex but...are you sure you want
>to run Oracle with an NFS-mounted database?

Bill;

  my thoughts exactly. I always thought the position was 'Hmm... No.' How about Disk mirroring. Break the mirror swap over etc..

>/b
>--
>Bill Manry - Mainframe and Integration Technologies - Oracle Corporation
>Standard disclaimer applies.
Received on Fri Dec 22 1995 - 00:00:00 CET