Re: question on 10.2.0.2.0 Data Guard -- transmit redo data
- From: "Alex Fatkulin" <afatkulin@xxxxxxxxx>
- To: gmei@xxxxxxxxxxxxxx
- Date: Sat, 17 Jan 2009 02:43:10 -0500
Guang,
first of all, the protection level is being set by alter database set
stanbdy database to... statement
different combination of log shipping options are necessarily to
support given level of protection
query protection_mode from v$database to find out the current settings
(though noaffirm is supported by maximum protection only)
default is arch, alert log can confirm this (set log_archive_trace to
1 and take a look)
On Fri, Jan 16, 2009 at 2:21 PM, Guang Mei <gmei@xxxxxxxxxxxxxx> wrote:
> I have an oracle 10.2.0.2.0 Data Guard setup now (physical standby) on two
> linux boxes that I use for learning. And I would like to know if the db is
> using "standby redo logs" or "archived logs" to apply the change .
>
> on Primary DB, I have:
>
> SQL> select dest_id,target,log_sequence,AFFIRM,TRANSMIT_MODE from
> V$ARCHIVE_DEST;
>
> DEST_ID TARGET LOG_SEQUENCE AFF TRANSMIT_MOD
> ---------- ------- ------------ --- ------------
> 1 PRIMARY 15 NO SYNCHRONOUS
> 2 STANDBY 0 NO SYNCHRONOUS
> 3 PRIMARY 0 NO SYNCHRONOUS
> 4 PRIMARY 0 NO SYNCHRONOUS
> 5 PRIMARY 0 NO SYNCHRONOUS
> 6 PRIMARY 0 NO SYNCHRONOUS
> 7 PRIMARY 0 NO SYNCHRONOUS
> 8 PRIMARY 0 NO SYNCHRONOUS
> 9 PRIMARY 0 NO SYNCHRONOUS
> 10 PRIMARY 0 NO SYNCHRONOUS
>
> 10 rows selected.
> Also from Primary DB's init.ora:
>
> STANDBY_FILE_MANAGEMENT=auto
> log_archive_dest_2 = 'SERVICE=ES_PROD reopen=60'
> log_archive_dest_state_2 = ENABLE
>
> Based on the above, can I say the setup is "Maximum Performance" mode (I
> think so, because Affirm=No)? And log shipping (from Primary to Standby) is
> "ARCH" (because TRANSMIT_MOD=SYNCHRONOUS) ? I can not find anywhere to tell
> me that if I do not specify say "LGWR ASYNC", what are the default values
> for these in "log_archive_dest_2"? I only specify reopen and tnsnames entry
> here.
>
> Also with these configuration and after I created the same number of
> "standby redo logs" on standby as the primary "online redo logs", and when I
> made some db changes, then alter system switch logfile on primary, I can see
> the archived logs were shipped to the standby, the db changes were also
> there in db (I opened the standby in read-only mode and can see the new
> tables I created on primary). But I am not sure if the changes were applied
> through shipped "archive logs" or through "standby redo logs". Basically I
> want to know if "Redo Archival Process" is LGWR or ARCH?
> Thanks.
>
> Guang Mei
>
>
--
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
