Oracle-L: Re: Backup Options Query

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Mon, 10 Feb 2003 10:34:52 -0800
Message-ID: <F001.00548899.20030210103452@fatcity.com>

Douglas,
After you change the tablespaces to read-only then you can them up at your leasure. Oracle will not change them again until you change them to read-write for what ever reason. Be sure to "backup controlfile to trace" after you change the tablespace to read-only to have an up to date version of the controlfile if you need to recreate the database. Rman is quite easy to use as an automated method of a backup. After a level 0 backup the level 2 will only backup the changed blocks in the database.
Ron

>>> dba_at_persistent-worlds.net 02/10/03 11:18AM >>> 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: Ron Rogers
INET: RROGERS_at_galottery.org

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