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
>>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
