RE: best way to convert into large VLDB oracle while running oper ationally

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 25 Feb 2004 11:24:04 -0500
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5939@exchsen0a1ma>

Paula,

Probably the easiest thing to do is to continually run Rman Archivelog backups while this process is running to keep the archivelog disk clear. If you are not using Rman, then run your normal archivelog backup job to keep the disk clear.

The second easiest thing to do is to create another database instance in noarchivelog mode and perform all of the data conversion there. But then, you would need to create a "merge" process to bring the data over to your operational database because of the sequence issue you mentioned.

I think I'd work on the first option - if this is a one-time thing, then it is probably the way to go.

Good Luck!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Paula_Stankus_at_doh.state.fl.us
[mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Wednesday, February 25, 2004 11:12 AM To: oracle-l_at_freelists.org
Subject: RE:best way to convert into large VLDB oracle while running operationally

So,

Oracle 9i

-Vendor is converting data. Their conversion process used 2Gb of space in
archivelogs in one hour. Of course we could turn off archiving but then the redo logs get overwritten.

-Business plans on running operationally in the same database.

-I have concerns about recovering if anything goes wrong or running out of
space at a rate of 2GB space in archives/hour.

-3rd party product - not much say in the conversion process itself

-Wish we could run conversion in a separate instance then do some process to
move data after it was converted to the operational database - in batch off-hours - yadayada. What about using a database link so we get the correct sequence numbers - the operational database would be using the sequence - the database link for the conversion database.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Feb 25 2004 - 10:21:01 CST