physical standby database archivelog destination
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 1 May 2005 19:25:11 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
