Home » Server Options » Replication » How to create physical standby database without data guard (Oracle SE 10.2.0.4)
How to create physical standby database without data guard [message #422448] Wed, 16 September 2009 09:32 Go to next message
aashi1
Messages: 10
Registered: March 2007
Location: NEW YORK
Junior Member
Hi All,

I would need to create a physical standby database for DR without using data guard. I like to know in more details like

1. What would be required to switch over to standby database in case of failure of primary database? Is it going to be a manual process each time, or can be automated using scripts?

2. How the archive logs will be applied to standby database in timely manner to sync with primary database?

3. How the Primary database will be synch with Standby database once the issue resolved on primary database.

4. Where do I get a complete script to create physical standby database on Windows platform?

Thank you in advance. Please provide me all the necessarily details.

Ali

Report message to a moderator

Re: How to create physical standby database without data guard [message #422486 is a reply to message #422448] Wed, 16 September 2009 15:14 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
Before posting please read

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to create physical standby database without data guard [message #422487 is a reply to message #422486] Wed, 16 September 2009 15:17 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>1. What would be required to switch over to standby database in case of failure of primary database? Is it going to be a manual process each time, or can be automated using scripts?

>>2. How the archive logs will be applied to standby database in timely manner to sync with primary database?

>>3. How the Primary database will be synch with Standby database once the issue resolved on primary database.

Manual Method.

4. Where do I get a complete script to create physical standby database on Windows platform?

Understand Manual swithover/failover & search here

http://tahiti.oracle.com/

Report message to a moderator

Previous Topic: I need to setup database replication with updatable materialized view
Next Topic: Problem with advance replication from Master to Mv and Mv to Master
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 28 17:23:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.