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