Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: HIstorical Table Backup

Re: HIstorical Table Backup

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 20 Feb 2001 11:45:02 -0800
Message-ID: <F001.002B8ECA.20010220113111@fatcity.com>

Alex,
If you make some of your tablespaces "read only" then you will be able to back them up to tape one time after you have made them "read only". The system will know that the SCN has not changed and you can restore them any time you need to. You can backup each tablespace any time you want to because the data will not be changing until the next time you alter the tablespace xxx read write. Make sure you "backup controlfile to trace" each time you make a change to the database. ROR mm

>>> Alex.Berindei_at_elsag.it 02/20/01 01:16PM >>>

Hello you all,
I have a large historical database and I partitioned by date range tables. I don't which is a good way to backup old partitions, which I make ReadOnly, in a way to be able to restore the contents from the time I put them in ReadOnly mode.

Since the database will be large (800Gb) I would like not to backup all database all the time, but only the current date partitions (this means also tablespaces, because I want to create every partition in a separate tablespace).

Do you know if this is possible?

Thx, alex.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Berindei Alex
  INET: Alex.Berindei_at_elsag.it 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Tue Feb 20 2001 - 13:45:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US