OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » DATA GUARD (10g)

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

DATA GUARD [message #487308]

Fri, 24 December 2010 14:11

rajanishvibha
Messages: 1
Registered: December 2010
Location: MUMBAI

Junior Member

hi,

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

Report message to a moderator

Re: DATA GUARD [message #487311 is a reply to message #487308]

Fri, 24 December 2010 14:16

Michel Cadot
Messages: 68501
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

Report message to a moderator

Re: DATA GUARD [message #494498 is a reply to message #487308]

Tue, 15 February 2011 04:27

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..

Report message to a moderator

Re: DATA GUARD [message #494499 is a reply to message #494498]

Tue, 15 February 2011 04:32

Michel Cadot
Messages: 68501
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

Report message to a moderator

Re: DATA GUARD [message #494504 is a reply to message #494499]

Tue, 15 February 2011 05:03

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.

Report message to a moderator

Re: DATA GUARD [message #494506 is a reply to message #494504]

Tue, 15 February 2011 05:43

Michel Cadot
Messages: 68501
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

vijaykumarm
Messages: 3
Registered: February 2011
Location: Bangalore

Junior Member

ok michel thank u..

Regards,
Vijay.

Report message to a moderator

Re: DATA GUARD [message #508577 is a reply to message #494508]

Mon, 23 May 2011 04:42

rk44
Messages: 18
Registered: June 2010

Junior Member

u can configure ,but it will be no use of it..

Report message to a moderator

Re: DATA GUARD [message #508583 is a reply to message #508577]

Mon, 23 May 2011 05:03

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Once again this is wrong.
Why is this of no use?

Regards
Michel

Report message to a moderator

Re: DATA GUARD [message #508625 is a reply to message #508583]

Mon, 23 May 2011 08:49

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

Michel Cadot
Messages: 68501
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

Report message to a moderator