Home » Server Options » Data Guard » Some clarification on 10g Standby Scenario
Some clarification on 10g Standby Scenario [message #181259] Fri, 07 July 2006 12:29 Go to next message
Vamshee
Messages: 32
Registered: February 2005
Member
Hi

I have been working on 8i standby database setups.
Recently , i have been testing a 10g (R2) Dataguard settings between 2 different hosts ( Windows 2003 Servers).

PDB Parameters:
------------------
fal_client=pdb
fal_server=sdb
log_archive_config='DG_CONFIG=(cppsp01, stby)'
log_archive_dest_1='location=E:\app\oraprd\admin\cppsp01\arch VALID_FOR=(ALL_LOGFILES, ALL_ROLES)'
log_archive_dest_2='SERVICE=stby VALID_FOR=(ONLINE_LOGFILEs,PRIMARY_ROLE) DB_UNIQUE_NAME=stby LGWR ASYNC REOPEN=10'


SDB Parameters:
-------------------

fal_client='STBY'
fal_server='CPPSP01'
log_archive_config='DG_CONFIG=(cppsp01, stby)'
log_archive_dest_1='location=E:\app\oraprd\admin\cppsp01\arch VALID_FOR=(ALL_LOGFILES, ALL_ROLES)'
log_archive_dest_2='SERVICE=CPPSP01 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CPPSP01 LGWR ASYNC REOPEN=10'


Now, after the setting up the Standby
when i issued
PDB> alter system switch logfile;


PRIMARY
---------------
SQl>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
540 05-JUL-06 06-JUL-06
541 06-JUL-06 06-JUL-06
541 06-JUL-06 06-JUL-06
542 06-JUL-06 06-JUL-06
542 06-JUL-06 06-JUL-06
543 06-JUL-06 07-JUL-06
543 06-JUL-06 07-JUL-06
544 07-JUL-06 07-JUL-06
544 07-JUL-06 07-JUL-06
545 07-JUL-06 07-JUL-06
545 07-JUL-06 07-JUL-06


STANDBY
-----------------
SQl>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
535 03-JUL-06 04-JUL-06
536 04-JUL-06 04-JUL-06
537 04-JUL-06 06-JUL-06
538 06-JUL-06 05-JUL-06
539 05-JUL-06 05-JUL-06
540 05-JUL-06 06-JUL-06
541 06-JUL-06 07-JUL-06
542 06-JUL-06 06-JUL-06
543 06-JUL-06 06-JUL-06
544 07-JUL-06 07-JUL-06
545 07-JUL-06 07-JUL-06


Which all looks fine.

Now, when i issue a >alter system switch logfile and check the archives on both the hosts..
The STANDBY Database contains an additional archive that Primary doesnt hold.

Example:
After swith logfile,
the Standby contains the sequence # 546
where as PDB has # 545

and another switch logfile...makes
Standby goes to # 547
and PDB goes to # 546.


Is the behavior normal...
Does this mean that it first applies the archives to Standby and after the next switchover places it on the PDB.

I just want to this understand this behavior.
Could you please clarify on this

Please let me know if iam not clear in explaining my situation.


Thanks
Vamshee
Re: Some clarification on 10g Standby Scenario [message #181601 is a reply to message #181259] Mon, 10 July 2006 14:54 Go to previous message
Vamshee
Messages: 32
Registered: February 2005
Member
Hello Gurus,

anyone please take a look at this post and kindly reply me

Thanks
Vamshee
Previous Topic: Data guard using
Next Topic: The primary DB stopped when the standby datbase failed
Goto Forum:
  


Current Time: Fri Mar 29 01:13:15 CDT 2024