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

Home -> Community -> Mailing Lists -> Oracle-L -> Partitions restore

Partitions restore

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 02 Nov 2006 21:11:01 +0200
Message-ID: <454A42C5.4020707@inter.net.il>


Oracle 9206 on windows RAC.
We have am imaging system for checks.
Each morning each employee in the bank retrieve the images of the checks, that belong to the account he is responsible for, and decide if to honor them or bounce them. Grey images(each about 30KB) are kept for 90 days and black and white are kept for 1 year. After the first scan the images are not used again, unless there is something to check.
By the nature of the application the users use mostly the last partition.

In a meeting today someone suggest the following:

1) Put each partition (or several partitions) in a separate tablespace.
2) Backup the whole database.
3) In case of needing to restore, you can restore the system tablespace 
and the tablespaces containing the most recent partitions and activate the database.
4) While the users are working you can restore the other tablespace containing the historical images that are not usually used.

This sounds fine but I started to wonder if Oracle will let me work on a table that contain partitions that should be there but does not exist.

--

Adar Yechiel
Rechovot, Israel

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 02 2006 - 13:11:01 CST

Original text of this message

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