Home » Other » General » Status of Standby database
Status of Standby database [message #331762] Sat, 05 July 2008 05:25 Go to next message
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.




Re: Status of Standby database [message #331771 is a reply to message #331762] Sat, 05 July 2008 08:18 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Status of Standby database [message #331785 is a reply to message #331762] Sat, 05 July 2008 09:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean "synched"?

Regards
Michel
Re: Status of Standby database [message #331800 is a reply to message #331762] Sat, 05 July 2008 11:14 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

database synchronization


means syncing primary database with standby database.
Re: Status of Standby database [message #331807 is a reply to message #331800] Sat, 05 July 2008 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But define synchronization, database synchronization, what is the criteria of synchronization?

Regards
Michel
Re: Status of Standby database [message #331846 is a reply to message #331807] Sun, 06 July 2008 00:40 Go to previous messageGo to next message
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.
Re: Status of Standby database [message #331861 is a reply to message #331846] Sun, 06 July 2008 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Status of Standby database [message #331995 is a reply to message #331762] Mon, 07 July 2008 03:30 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

kindly send me the answer related document to me.
Re: Status of Standby database [message #332008 is a reply to message #331995] Mon, 07 July 2008 04:16 Go to previous message
pablolee
Messages: 2834
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
Previous Topic: Oracle9i installation
Next Topic: Datafile size
Goto Forum:
  


Current Time: Sun Dec 04 20:30:01 CST 2016

Total time taken to generate the page: 0.07366 seconds