Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: physical standby database archivelog destination

Re: physical standby database archivelog destination

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Tue, 3 May 2005 23:06:00 -0400
Message-ID: <52a152eb05050320063aebd68e@mail.gmail.com>


I didn't try this in 10g yet, but for 9i you have to set

standby_archive_dest

On the standby set. This is archive log destination 10. Give it a try

On 5/1/05, Sami Seerangan <dba.orcl_at_gmail.com> wrote:
> Hi:

>=20

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

> But the archive log destination for STANDBY database goes to wrong
> place(db_recovery_file_dest) instead of log_archive_dest_1.
>=20
> I want to setup cascade standby database. Is it a bug or I am missing som=
et=3D
> hing?
>=20

> Thanks in advance
> -Sami
>=20

> SQL> archive log list
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination =3D20
> 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>
>=20

> SQL> show parameter instance_name
>=20

> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------=
--=3D
> ----
> instance_name string hbny
> db_recovery_file_dest string =3D20
> Z:\oracle\product\10.1.0\flash_recovery_area =3D2=
0
> _recovery_area
> db_recovery_file_dest_size big integer 2G
> recovery_parallelism integer 0
> log_archive_dest string
> log_archive_dest_1 string =3D20
> LOCATION=3D3DZ:\oracle\product\10.1.0\db_1\database\archive\hbny
> VALID_FOR=3D3D(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=3D3Dhbny
> log_archive_dest_2 string SERVICE=3D3Dhsbc
> VALID_FOR=3D3D(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=3D3Dhsbc
> log_archive_dest_state_1 string enable
> log_archive_dest_state_2 string enable
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Christo Kutrovsky
Database/System Administrator
The Pythian Group

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 03 2005 - 23:10:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US