Home » Server Options » Data Guard » DATA GUARD (10g)
DATA GUARD [message #487308] Fri, 24 December 2010 14:11 Go to next message
rajanishvibha
Messages: 1
Registered: December 2010
Location: MUMBAI
Junior Member
hi,

I can configure data guard on same Unix server (PRIMARY AND STANDBY DATABASE)
Re: DATA GUARD [message #487311 is a reply to message #487308] Fri, 24 December 2010 14:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rajanishvibha wrote on Fri, 24 December 2010 21:11
rajanishvibha wrote on Fri, 24 December 2010 14:11
hi,

I can configure data guard on same Unix server (PRIMARY AND STANDBY DATABASE)



Just follow the documentation:
Data Guard Concepts and Administration

Regards
Michel

Re: DATA GUARD [message #494498 is a reply to message #487308] Tue, 15 February 2011 04:27 Go to previous messageGo to next message
vijaykumarm
Messages: 3
Registered: February 2011
Location: Bangalore
Junior Member
U can but no use!!

If any disaster comes, both your database and standby will crash .. very difficult to recover..
Re: DATA GUARD [message #494499 is a reply to message #494498] Tue, 15 February 2011 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No use? Yes, there are many usages.
* High availability from a drop file
* Recover a block corruption
* Use lag to recover from logical mistake or corruption
...

Regards
Michel
Re: DATA GUARD [message #494504 is a reply to message #494499] Tue, 15 February 2011 05:03 Go to previous messageGo to next message
vijaykumarm
Messages: 3
Registered: February 2011
Location: Bangalore
Junior Member
Thank u, but this can be done when the database is in remote server also. keeping one standby database in remote server is most recommended. we can have standby in the same server if we want to have more then one standby database.
Re: DATA GUARD [message #494506 is a reply to message #494504] Tue, 15 February 2011 05:43 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This depends on your purpose.
You cannot say that 1 standby database on the same server is useless and not recommended, this is wrong.

Regards
Michel

[Edit: missing letter]

[Updated on: Mon, 23 May 2011 05:02]

Report message to a moderator

Re: DATA GUARD [message #494508 is a reply to message #494506] Tue, 15 February 2011 06:04 Go to previous messageGo to next message
vijaykumarm
Messages: 3
Registered: February 2011
Location: Bangalore
Junior Member
ok michel thank u..

Regards,
Vijay.
Re: DATA GUARD [message #508577 is a reply to message #494508] Mon, 23 May 2011 04:42 Go to previous messageGo to next message
rk44
Messages: 18
Registered: June 2010
Junior Member
u can configure ,but it will be no use of it..
Re: DATA GUARD [message #508583 is a reply to message #508577] Mon, 23 May 2011 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again this is wrong.
Why is this of no use?

Regards
Michel
Re: DATA GUARD [message #508625 is a reply to message #508583] Mon, 23 May 2011 08:49 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
This depends on your purpose.

The primary purpose of datagaurd is to provide high availability, data protection, and disaster recovery.

This also applies with standby databases on the same machine.
If a primary database files gets corrupt we can take backup from standby and recover it.
But all these purpose fails if the entire system crashes.

[Updated on: Mon, 23 May 2011 08:49]

Report message to a moderator

Re: DATA GUARD [message #508649 is a reply to message #508625] Mon, 23 May 2011 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The fact that an architecture fails because it is intended to support a specific failure and does not support others does not prove it is useless.
Otherwise you can say that any data guard is useless, RAC is useless, and so on as they do not cover ALL the failures.

A standby database in the same server as the primary one is useful for some things and does not cover other things, this does NOT mean it is useless.
It covers hardware io errors, it covers application errors (if you configure a time lag), it covers some dba or sysadmin errors, and so on.

Regards
Michel

Re: DATA GUARD [message #508677 is a reply to message #508649] Tue, 24 May 2011 00:09 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
My comment was in support of your argument Michel

Re: DATA GUARD [message #508683 is a reply to message #508677] Tue, 24 May 2011 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It could be read in both ways, so I clarified.

Regards
Michel
Re: DATA GUARD [message #509688 is a reply to message #487308] Tue, 31 May 2011 05:11 Go to previous messageGo to next message
kapardi
Messages: 19
Registered: May 2011
Location: Pune
Junior Member

hello


Yes you can implement the datagaurd on same server no issues what MICHEL said is absolutely correct
Re: DATA GUARD [message #509689 is a reply to message #509688] Tue, 31 May 2011 05:12 Go to previous message
kapardi
Messages: 19
Registered: May 2011
Location: Pune
Junior Member

yes Michel I too support you Smile

regards

kapardi
Previous Topic: how to check dataguard synchronization
Next Topic: Data Guard Setup
Goto Forum:
  


Current Time: Sun Aug 09 22:04:27 CDT 2020