archive logs are not getting transferred to standby

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Sat, 7 Feb 2009 00:47:21 +0530
Message-ID: <7877ab4b0902061117o7ce17f7fu5638b5e8bb99e005_at_mail.gmail.com>

Hello All,

Good Afternoon!!
Hope Every one is doing great and preparing for the Weekend!!

I have a issue with the dataguard,

The logs are not gettitng transferred in the Standby database from the primary.

The screen shot of STDBY database is as below.

SQL> show parameter log_archive_dest_1;

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

log_archive_dest_1                   string

LOCATION=D:\oracle\product\10.

2.0\flash_recovery_area\stdby\

                                                 ARCHIVELOG
VALID_FOR=(ALL_LOGF
                                                 ILES,ALL_ROLES)
DB_UNIQUE_NAME
                                                 =STDBY
log_archive_dest_10                  string

SQL> show parameter log_archive_dest_2;

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

log_archive_dest_2                   string      SERVICE=orcl1 LGWR ASYNC

VALID _FOR=(ONLINE_LOGFILES,PRIMARY_

                                                 ROLE) DB_UNIQUE_NAME=orcl1

=============================================================================

how do I solve this problem ? I am using this for the first time. Even after doing the "alter system switch logfile"; I do not see any logs that are transferred to the standby.

How should i solve this problem...

--

Thanks
Nilesh Soni
Oracle DBA--OCA 10g
Oracle is not a magic..it takes years of experiance :-) 9860584034

--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 06 2009 - 13:17:21 CST