Re: Hot backups for Oracle 7/Solaris

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?

/b

--
Bill Manry  -  Mainframe and Integration Technologies  -  Oracle Corporation
Standard disclaimer applies.