Re: How do you backup a live database?

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