Home » Server Options » Replication » Manual Replication (Oracle 9i 9.2.0.5.)
Manual Replication [message #490696] Wed, 26 January 2011 16:57 Go to next message
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.
Re: Manual Replication [message #490731 is a reply to message #490696] Thu, 27 January 2011 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 67144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the question is?

Regards
Michel
Re: Manual Replication [message #491043 is a reply to message #490731] Fri, 28 January 2011 10:00 Go to previous messageGo to next message
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.
Re: Manual Replication [message #491048 is a reply to message #491043] Fri, 28 January 2011 11:54 Go to previous messageGo to next message
Michel Cadot
Messages: 67144
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Manual Replication [message #491055 is a reply to message #491048] Fri, 28 January 2011 13:06 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67144
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Manual Replication [message #491063 is a reply to message #491057] Fri, 28 January 2011 15:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67144
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Manual Replication [message #491068 is a reply to message #491066] Fri, 28 January 2011 16:07 Go to previous messageGo to next message
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.
Re: Manual Replication [message #491081 is a reply to message #491068] Sat, 29 January 2011 00:46 Go to previous message
Michel Cadot
Messages: 67144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, the video is exactly what you need.

Regards
Michel
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:
  


Current Time: Mon Jun 01 21:00:43 CDT 2020