Re: backup strategy

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 11 Sep 2006 16:22:01 GMT
Message-ID: <J5Fs4s.Mv6@igsrsparc2.er.usgs.gov>

mike7411_at_gmail.com wrote:
> Is it a reasonable Oracle backup strategy to just copy the tablespace
> file(s) to a CD every so often?
>
> Thanks.
>

Do you include the SYSTEM tablespace? How do you "copy" the tablespace's datafiles to CD? Will the database be up and running when you do this? If so, how do you guarantee datafile consistency?

Backups are fully documented in the Oracle Backup and Recovery Guide. You can find a copy here:

http://tahiti.oracle.com

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Mon Sep 11 2006 - 11:22:01 CDT