Re: backup strategy

From: <fitzjarrell_at_cox.net>
Date: 11 Sep 2006 09:18:31 -0700
Message-ID: <1157991511.140193.173040@p79g2000cwp.googlegroups.com>

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.

"Every so often" means what, exactly? And how do you propose to copy these files 'every so often' to some CD somewhere? You cannot simply use cp on a live database file; the resulting copy is worthless.

What is preventing you from using RMAN to make regular, usable backups of your database? Those you could transfer to a CD, if necessary. Otherwise you'll need to place each tablespace into backup mode, then copy the files to a CD (presuming your database is small enough), then take each tablespace out of backup mode and let Oracle play 'catch-up' with the file headers, not to mention the additional redo generated by that scenario.

This sounds like a really bad idea, given the availability, reliability and ease of RMAN.

David Fitzjarrell Received on Mon Sep 11 2006 - 11:18:31 CDT