Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: multiple standby databases
You can have up to nine physical standby databases. Please check the
Oracle documentation Oracle Data Guard Concepts and Administration part
3 Creating a Physical Standby Database.
The LOG_ARCHIVE_DEST_STATE_n parameters (where n = 1, 2, 3, ... 10) specify the availability state of the corresponding destination.
The parameter LOG_ARCHIVE_DEST_1 archives redo data generated by the primary database from the local online redo log files to the local archived redo log files.
The rest of parameters LOG_ARCHIVE_DEST_2 are valid only for the primary role. This destination transmits redo data to the remote physical standby destination.
.
Scott Washburn
Oracle Database Administrator
Wolseley North America Division
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
ryan_gaffuri_at_comcast.net
Sent: Wednesday, August 01, 2007 2:01 PM
To: oracle-l_at_freelists.org
Subject: multiple standby databases
Is it possible to have one primary and 3 physical standby databases using dataguard? Everything I see in the docs leads me to believe its one primary and one standby.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 01 2007 - 13:33:58 CDT
![]() |
![]() |