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: Reddy, Gautam <Gautam_Reddy_at_Dell.com>
Date: Thu, 7 Sep 2000 15:20:38 -0500
Message-Id: <10612.116457@fatcity.com>


Got this reply from one of my friend who works at ORACLE Field Support. This is the reason why we are not using this feature.

Sounds like we may want to hold off on using this feature (log_archive_dest_2 = "service=name_of_other_host REOPEN=30" ) based on this.

"Be very careful when using these new Oracle8i features. Actually would recommend NOT using them. This is a very new feature and is not as robust as I would like it. I recommend still manually FTPing the logs to the standby (without using the new Oracle8i feature)

Go to WebIV and do a bug search on "standby ora-00600" you will see a list of 30 significant bugs.

The big ones are ... If the you fill up the secondary sites archive destination it will crash your primary with an ORA-00600 then you must recover up to a point in time just before the ORA-00600 occurred.

Network failures on mandatory (and sometimes optional) archive destinations can also cause the primary to go down.

I see your on NT. The scripts I have to automatically ftp and apply files are written in TCL and Expect (both share ware). If they write exect for NT and you decide to manually ftp and apply the files, let me know and I will e-mail them to you "      

Thx
Gautam  

-----Original Message-----
From: Kenneth Berland [mailto:ken_at_hero.com] Sent: Wednesday, September 06, 2000 3:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: creating standby database

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).
>

-- 
Author: Kenneth Berland
  INET: ken_at_hero.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
Received on Thu Sep 07 2000 - 15:20:38 CDT

Original text of this message

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