| Some clarification on 10g Standby Scenario [message #181259] |
Fri, 07 July 2006 12:29  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
