FreeLists / oracle-l / physical standby database archivelog destination

[Sami Seerangan <dba.orcl@xxxxxxxxx>]

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