OraFAQ Forum: Server Administration » Moving data's with out down the application

Home » RDBMS Server » Server Administration » Moving data's with out down the application

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving data's with out down the application [message #164003]

Tue, 21 March 2006 04:21

gjayasekar
Messages: 45
Registered: October 2005

Member

Hi,

We are using oracle 9.2.0 with weblogic application

every month end we are stopping all the weblogic instance and

create a new table as select * from old_table;

then move the old table with old data's to development after

that we are starting all weblogic instance and connect to the

application for this work we are taking down time 2 hrs - in

production environment

please provide a solution to do this without downtime

thanks
jai

Report message to a moderator

Re: Moving data's with out down the application [message #164038 is a reply to message #164003]

Tue, 21 March 2006 07:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I assume it is not just one table you do.
Depending on your need you can just
*use export & import all the tables ( not an ideal solution and is painful if the volume of data is large).
*use RMAN to clone/duplicate (real cool. I have an 60gb database that can be cloned within 30 minutes with POINT IN TIME RESTORE facility)
*use CDC (change data capture. very cool. You will capture only the data that is changed and push that data to your development. Ideal for day-to-day refresh)
*use materialized views.

There might be more customized options and it depends on your need and resources.

Report message to a moderator

Re: Moving data's with out down the application [message #164041 is a reply to message #164038]

Tue, 21 March 2006 07:44

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And please don't post multiple times.

Report message to a moderator

Re: Moving data's with out down the application [message #164782 is a reply to message #164003]

Sun, 26 March 2006 02:20

gjayasekar
Messages: 45
Registered: October 2005

Member

thanks

but every month end we are billing the data's and move the old data's to the development

then we are creating the new table based on old one with same index and all. (because deleting records wont be free the space)

then we are connecting with application
here downtime is 2 hrs
i want to avoid it and automate it without taking down time

and please give me full steps for CDC and Materialized views

thanks
jai

[Updated on: Sun, 26 March 2006 02:22]

Report message to a moderator

Re: Moving data's with out down the application [message #164786 is a reply to message #164782]

Sun, 26 March 2006 04:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>and please give me full steps for CDC and Materialized views
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96520/cdc.htm
CDC is not the one for you. Since you are 'refreshing' only once a month, a simple export/import or CTAS ( create table as select would do).
I don't see why it would take 2 hours to do this would take 2 hours
or a required downtime.

Report message to a moderator

Previous Topic:	How to startup and shutdown the DataBase Manualy
Next Topic:	Access violation at address 606C1514

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:42:20 CDT 2024