creating standby database

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Wed, 6 Sep 2000 08:54:37 -0700 (PDT)
Message-Id: <10611.116305@fatcity.com>

Hi All,

I am trying to create standby database on different hosts.

• The database names are same on both hosts
• listener/tnsnames files are configured and working
• I was able to create standby database but having problem when i try to enable archive_Dest_2 on primary database.

SVRMGR> alter system set
log_archive_dest_2='service=reptest mandatory reopen=60
';
Statement processed.

SVRMGR> alter system set log_archive_dest_2 = enable; ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16024: parameter LOG_ARCHIVE_DEST_2 cannot be parsed

Any ideas??

When i do tnsping reptest on primary i do get Ok.

TIA.

---

Ashish
Toronto, Canada

---

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! Received on Wed Sep 06 2000 - 10:54:37 CDT