OraFAQ Forum: Replication » Manual Replication

Home » Server Options » Replication » Manual Replication (Oracle 9i 9.2.0.5.)

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

Manual Replication [message #490696]

Wed, 26 January 2011 16:57

Hutton
Messages: 7
Registered: January 2011
Location: Malay

Junior Member

Hi - thanks for the excellent site.

Our requirements are as follows, please let us know if this is possible and guide us in this -

- We're not looking into solutions such as -
DATA GUARD or STREAMS or MViews or links or Triggers or GoldenGate.
This needs to be manual process.
Version:Oracle 9.2.0.5.

1. ONLINE RMAN backup (+ archive log + control file..) from production DB <PROD>
2. Copy Backup from PROD to new server.
3. Use the backup (from PROD) to create new COPYDB on this new server.

4. And eventually on a regular (daily/hourly) basis use the archive log of PROD to be applied (restored in) against COPYDB.

Cheers.
HS.

Report message to a moderator

Re: Manual Replication [message #490731 is a reply to message #490696]

Thu, 27 January 2011 01:03

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the question is?

Regards
Michel

Report message to a moderator

Re: Manual Replication [message #491043 is a reply to message #490731]

Fri, 28 January 2011 10:00

Hutton
Messages: 7
Registered: January 2011
Location: Malay

Junior Member

Apologies if it was not clear -

what are the steps involved and/or where can I find manuals/documents for the exact steps.

Thanks again.
HS.

Report message to a moderator

Re: Manual Replication [message #491048 is a reply to message #491043]

Fri, 28 January 2011 11:54

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://tahiti.oracle.com
http://otn.oracle.com
Use the search facilities, you asked for many features so they are spread all over the documentation and papers.

Regards
Michel

Report message to a moderator

Re: Manual Replication [message #491055 is a reply to message #491048]

Fri, 28 January 2011 13:06

Hutton
Messages: 7
Registered: January 2011
Location: Malay

Junior Member

tahiti & otn basically covers everything, no?
I was asking for some actual steps.

Anyone?

THX

[Updated on: Fri, 28 January 2011 13:07]

Report message to a moderator

Re: Manual Replication [message #491057 is a reply to message #491055]

Fri, 28 January 2011 13:36

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Documentation also covers the steps but you asked for too many and broad subjects we can give any step.
If you want steps you have to choose either Data Guard, aither Streamns, either mviews either Golden Gate either triggers either... but not all of them which would require a 300 pages book to cover them.

Regards
Michel

Report message to a moderator

Re: Manual Replication [message #491063 is a reply to message #491057]

Fri, 28 January 2011 15:15

Hutton
Messages: 7
Registered: January 2011
Location: Malay

Junior Member

Michel -

My question clearly states the following...
"
We're not looking into solutions such as -
DATA GUARD or STREAMS or MViews or links or Triggers or GoldenGate.

This needs to be manual process.
"

I've actually put our requirements into various steps.
I need some tech experts, like you, to guide us in translating it into oracle based scripts or guide to relavant doc/manuals.
-------------
1.ONLINE RMAN backup (+ archive log + control file..) from production DB <PROD>
2. Copy Backup from PROD to new server.
3. Use the backup (from PROD) to create new COPYDB on this new server.

4. And eventually on a regular (daily/hourly) basis use the archive log of PROD to be applied (restored in) against COPYDB.
-------------
As you can see step 4 will be something to think about. If you have some real answers/solutions please post it.

THX.

[Updated on: Fri, 28 January 2011 15:17]

Report message to a moderator

Re: Manual Replication [message #491066 is a reply to message #491063]

Fri, 28 January 2011 15:42

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And what do you want to replicate? A table? A schema? A whole database?
How much lag time do you accept?
How far is the 2 servers?
Do you have a network between?
How is the network?

I'd go for the good old manual standby database with a cron jobs forwarding the archived logs and applying them on the standby.
See http://www.youtube.com/watch?v=6uekQo_OZ10 for all the steps.

Regards
Michel

Report message to a moderator

Re: Manual Replication [message #491068 is a reply to message #491066]

Fri, 28 January 2011 16:07

Hutton
Messages: 7
Registered: January 2011
Location: Malay

Junior Member

Great - this is exaclty what am looking for (did not view the video yet).

"I'd go for the good old manual standby database with a cron jobs forwarding the archived logs and applying them on the standby"

1.Whole database
2.Lag time does not matter - wholly left on us to decide.
3.Local - intranet.

Will check the video and let you know if that's what am looking for.
Thanks again.

Report message to a moderator

Re: Manual Replication [message #491081 is a reply to message #491068]

Sat, 29 January 2011 00:46

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In this case, the video is exactly what you need.

Regards
Michel

Report message to a moderator

Previous Topic:	Is ODI the right technology for me to use?
Next Topic:	ORA-00001: unique constraint (%s_PK) violated After replication configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:40:36 CST 2025