Newsletters Archive - 2006

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Archiving to an Archival Standby Database — (26-July-2006)

Introduced in Oracle9i R1, DBAs can now configure a database (for example, a 
primary database) to send its archived redo log files to an Oracle instance at 
a remote location which is only responsible for accepting and storing the 
archived redo log files. This remote location can serve as a repository 
(or backup) of nothing more than archived redo logs.

This remote location is known as an Archival Standby Database and is nothing 
more than an Oracle instance with a controlfile and no physical database 
associated with it. The controlfile can be a standby controlfile of the source 
database or a controlfile of another database.

The following article describes the steps necessary to configure a database to 
archive its redo log files to a remote archival standby database:

http://www.idevelopment.info/data/Oracle/DBA_tips/Data_Guard/DG_7.shtml

----------------------------
Jeffrey M. Hunter
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------