physical standby database archivelog destination

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 1 May 2005 19:25:11 -0400
Message-ID: <f09dd62805050116257fea6d5a@mail.gmail.com>

Hi:

I did setup physical standby db setup in 10g,Windows platform. Everything works fine.

But the archive log destination for STANDBY database goes to wrong place(db_recovery_file_dest) instead of log_archive_dest_1.

I want to setup cascade standby database. Is it a bug or I am missing somet= hing?

Thanks in advance
-Sami

SQL> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination          =20
Z:\oracle\product\10.1.0\db_1\database\archive\hbny
Oldest online log sequence     65
Next log sequence to archive   0
Current log sequence           70

SQL> SQL> show parameter instance_name

NAME                                 TYPE        VALUE


------------------------------------ ----------- --------------------------=

----

instance_name                        string      hbny
db_recovery_file_dest                string    =20
Z:\oracle\product\10.1.0\flash_recovery_area                         =20
                _recovery_area
db_recovery_file_dest_size           big integer 2G
recovery_parallelism                 integer     0
log_archive_dest                     string
log_archive_dest_1                   string    =20

LOCATION=3DZ:\oracle\product\10.1.0\db_1\database\archive\hbny VALID_FOR=3D(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=3Dhbny

log_archive_dest_2                   string      SERVICE=3Dhsbc
VALID_FOR=3D(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=3Dhsbc
log_archive_dest_state_1             string      enable
log_archive_dest_state_2             string      enable

--

http://www.freelists.org/webpage/oracle-l Received on Sun May 01 2005 - 19:29:31 CDT