Oracle-L: RE: Backup Options Query

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 10 Feb 2003 09:39:07 -0800
Message-ID: <F001.0054878D.20030210093907@fatcity.com>

Ceri

If you can change some of the tablespaces to read-only, you can back them up once, and keep the tape where you can find it if you ever need it. The key is you must back it up AFTER you change it to read-only. This is the simple answer. Basically if you back it up, then change it to read-only, the recovery gets a little more complicated.

What we do on a DW is load it Sunday, then Monday night do a full backup. RMAN can help if you do a one-time level 0 backup, SAVE THE TAPE, then do level 1 backups subsequently. RMAN would only back up changed blocks since the level 0 backup. You can also get more elaborate with multiple levels of backups.

As with any backup scheme, test your recovery.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, February 10, 2003 10:19 AM To: Multiple recipients of list ORACLE-L

Hi all,

I am in the process of setting up an Oracle Database that is currently about 70Gb in size. The data is static except from a weekly load of about 20Mb of data. Each load goes into a new partition held in a separate tablespace. After the load the tablespace is changed to be read-only.

So my question is what backup options do I have. I would prefer not to have to backup the whole 70Gb everytime. Does this rule out hot-backups? Is this something i can do with RMAN?

Any advice or pointers to documentation or good books very welcome.

Thanks

Ceri Townsend
--

Ceri Database Admin mailto:dba_at_persistent-worlds.net ICQ:153010767

"I love deadlines. I like the whooshing sound they make as they fly by." Douglas Adams

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ceri Townsend
INET: dba_at_persistent-worlds.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------