OraFAQ Forum: General » Status of Standby database

Home » Other » General » Status of Standby database

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

Status of Standby database [message #331762]

Sat, 05 July 2008 05:25

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi experts,

How would you ensure that standby database is running fine and currently synched with primary database??

kindly revert me with the answer.

Report message to a moderator

Re: Status of Standby database [message #331771 is a reply to message #331762]

Sat, 05 July 2008 08:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/

>How would you ensure that standby database is running fine and currently synched with primary database??

One way is by monitoring standby's alert_SID.log file.

Report message to a moderator

Re: Status of Standby database [message #331785 is a reply to message #331762]

Sat, 05 July 2008 09:21

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

Senior Member
Account Moderator

What do you mean "synched"?

Regards
Michel

Report message to a moderator

Re: Status of Standby database [message #331800 is a reply to message #331762]

Sat, 05 July 2008 11:14

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

database synchronization

means syncing primary database with standby database.

Report message to a moderator

Re: Status of Standby database [message #331807 is a reply to message #331800]

Sat, 05 July 2008 11:52

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

Senior Member
Account Moderator

But define synchronization, database synchronization, what is the criteria of synchronization?

Regards
Michel

Report message to a moderator

Re: Status of Standby database [message #331846 is a reply to message #331807]

Sun, 06 July 2008 00:40

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

criteria of synchronization is :

Transfering all the daytoday archivelogs from primary database to standby database for backup.incase if any disaster happens in primary db ,will allow the standby db to work as primary db until primary db recovers.

Report message to a moderator

Re: Status of Standby database [message #331861 is a reply to message #331846]

Sun, 06 July 2008 02:13

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

Senior Member
Account Moderator

The answer in the views related to archived logs and describe in the documentation.

Regards
Michel

Report message to a moderator

Re: Status of Standby database [message #331995 is a reply to message #331762]

Mon, 07 July 2008 03:30

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

kindly send me the answer related document to me.

Report message to a moderator

Re: Status of Standby database [message #332008 is a reply to message #331995]

Mon, 07 July 2008 04:16

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

As usual, you will find this information in the documentation that you have been sent the link to many many times. Use the search facility that the online documentation offers

Report message to a moderator

Previous Topic:	Oracle9i installation
Next Topic:	Datafile size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:28:25 CDT 2024