Home » RDBMS Server » Server Administration » doubt in database
doubt in database [message #241689] Wed, 30 May 2007 07:26 Go to next message
Messages: 30
Registered: May 2007
Location: hyderabad

What is meant by standby database and what is going internally when we give standby logfile or standby datafile as i am new to oracle please can any one guide me

Thanks in advance
Re: doubt in database [message #241724 is a reply to message #241689] Wed, 30 May 2007 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Re: doubt in database [message #241729 is a reply to message #241689] Wed, 30 May 2007 08:53 Go to previous message
Messages: 8
Registered: September 2006
Location: Athens, GREECE
Junior Member

You should understand Oracle very well if you want to understand features of Oracle Data Guard and stand-by databases.

A standby database is created by restoring a full backup of the primary site and it is left in a constant recovery mode. There are various parameters that should be configured on primary database server and on standby database server, so that the changes (e.g. archived log files) are automatically transferred from the primary site to the standby site, and that the standby site automatically applies all those changes to itself.

There are various configurations and types of stand-by databases, and it's not easy to explain quickly what's that all about.

You must read some theory, try to implement it yourself, and when you have a practical issue you can post the question again. Start with this, for example:

Oracle Data Guard Concepts and Administration, Release 2 (9.2)

Igor Obradovic
Previous Topic: Invalid Row ID
Next Topic: pl/sql package using UTL_FILE
Goto Forum:

Current Time: Sat Oct 22 21:21:36 CDT 2016

Total time taken to generate the page: 0.07658 seconds