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: creating standby database

Re: creating standby database

From: Kenneth Berland <ken_at_hero.com>
Date: Wed, 6 Sep 2000 12:49:13 -0700 (PDT)
Message-Id: <10611.116339@fatcity.com>


I have:
log_archive_dest_2 = "service=name_of_other_host REOPEN=30"

in my pfile.

On Wed, 6 Sep 2000, Ashish Shah wrote:

> 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!
> http://mail.yahoo.com/
> --
> Author: Ashish Shah
> INET: ar_shah_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 06 2000 - 14:49:13 CDT

Original text of this message

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