1. Backup and Recovery strategy and DB design
I need some help/ opinions/ suggestions for the following matter:
We are expecting the size of our database to be about 200GB ,
The current design is :
4 tablespace each table space has one datafile
Tablespace no 1:
Cmacdata contains about 160 table
Tablespace no 2:
CmacIndex contains indexes for the 160 table
Size: 2 GB.
Tablespace no 3:
CmacMeter contains 3 Big tables each one is partitioned by month
Tablespace no 4:
CmacMeterIndex contains indexes for the 3 big tables and they are
Is this a good design , considering the database performance and backup
and recovery performance
Isn't better to have as many datafiles as possible specially for the
Isn't better to have for each month( partition ) a separate datafile ?
and if so , how is it going to affect the database performance , backup
and recovery ?
Also for the backup and recovery strategy the plan is:
The database is on archive mode
Every day we will backup the transaction files ( logfiles )
Every week we will back up the whole database ( I don't know how long it
is going to be ) , we can do the backup for tables space no 1 on
Saturday and for table space no 2 on Sunday and so on ..
Now, is this a good plan? If yes or no , why ?
And how about incremental backup ,incremental levels , non-cumulative
One last thing :
Our business requirements says that the data should be available for 7
years , now because I don't want the database and datafiles to explode ,
I think ( I might be wrong ) I need to backup the data for each year and
save them to tapes then remove the data for that year from the database
using delete from table where . , then if the people needed the data I
have to restore it again .
Firstly, I don't know if this logic is good or bad
Secondly. If it is OK , how can I implement it ?
I really appreciate your help,
Thanks in advance
Sent via Deja.com http://www.deja.com/
Before you buy.
2. Oracle 7 used book
3. table design strategy
4. locked oracle.jdbc.driver.OraclePreparedStatement
5. Replication Strategy Question
6. OQY file format
7. More Questions on Encapsulation Strategy...
8. Retrieve records via a SP using ADO
9. MSSQL Backup Strategy Question?
10. Text file import strategy - DTS newbie question
11. Strategy question - DTS, .NET, OLAP and how to build our data warehouse
12. Question: Sybase vs Oracle replication strategy
13. Workday mapping strategy question.