Partitions restore
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- To: ORACLE-L@xxxxxxxxxxxxx
- Date: Thu, 02 Nov 2006 21:11:01 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
