Home » RDBMS Server » Server Administration » database archival policy (solarin 5.10, oracle 10.2.0.3)
database archival policy [message #340190] Mon, 11 August 2008 19:03 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

we have a 7 years old database and size upto 8 TB. due to this size of of the DB we are facing some performance issued for some select operations.

now we had a plan to archive some data (around 3-4 years of data) into another host which will act as reporting database.

my intension is i need to move 4 years of data from PRODUCTION to REPORTING DATABASE out of 7 years database. i did not have any idea to move 4 years of data. can any one tell/suggest me which one is the best way to do it.

please find some more additional details:

my database was started in 2000 july 3rd. up to now i have 8 years of data. i want to move 2000,2001,2002,2003 data from prod to reporting database.

Report message to a moderator

Re: database archival policy [message #340192 is a reply to message #340190] Mon, 11 August 2008 19:46 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


>i want to move 2000,2001,2002,2003 data from prod to reporting database

Do you have a rigorous methodology to identify the data to be archive?

If so, then proceed to do so.
If not, the give up this pipe dream & buy more disks.

Report message to a moderator

Previous Topic: Password File (oracle)
Next Topic: TDE Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 19:30:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.