Re: How do you backup a live database?

The new "Oracle 7.3 Backup and Recovery Book" from Oracle Press looks set to be just as thorough and accurate, useable as the previous editions. I love Oracle's habit of chucking the odd copy in with the upgrade to that version, every other shipment or so we get. Generous, eh? I guess we pay them enough support...

In article <ycx3eq91cs7.fsf_at_quake.cs.odu.edu>, Jason C Austin <jason_at_quake.cs.odu.edu> writes
>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
 

-- 
Tom Cooke