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: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Fri, 08 Sep 2000 00:46:30 GMT
Message-Id: <10612.116480@fatcity.com>


another reason is that even if loss of the secondary site doesn't crash your primary, once the chain of auto-archiving to the remote site is broken, it does not automatically resume once the network is back up.

More trouble than it's worth in my opinion... I'd rather ftp them manually, then I have more control.

>From: "Reddy, Gautam" <Gautam_Reddy_at_Dell.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: creating standby database
>Date: Thu, 07 Sep 2000 13:25:23 -0800
>
>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-----
>Sent: Wednesday, September 06, 2000 3:55 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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
>also send the HELP command for other information (like subscribing).
>--
>Author: Reddy, Gautam
> INET: Gautam_Reddy_at_Dell.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).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Received on Thu Sep 07 2000 - 19:46:30 CDT

Original text of this message

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