doubt in database [message #241689] |
Wed, 30 May 2007 07:26 |
bksrisai
Messages: 30 Registered: May 2007 Location: hyderabad
|
Member |
|
|
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 #241729 is a reply to message #241689] |
Wed, 30 May 2007 08:53 |
oigor
Messages: 8 Registered: September 2006 Location: Athens, GREECE
|
Junior Member |
|
|
Hi,
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)
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/toc.htm
Regards,
Igor Obradovic
|
|
|