Home » RDBMS Server » Server Administration » doubt in database
doubt in database [message #241689] Wed, 30 May 2007 07:26 Go to next message
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 #241724 is a reply to message #241689] Wed, 30 May 2007 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/print_hit_summary?search_string=standby+database

Regards
Michel
Re: doubt in database [message #241729 is a reply to message #241689] Wed, 30 May 2007 08:53 Go to previous message
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
Previous Topic: Invalid Row ID
Next Topic: pl/sql package using UTL_FILE
Goto Forum:
  


Current Time: Fri Sep 20 01:53:05 CDT 2024