RE: creating standby database

Post those scripts! Also: How long does Oracle keep rows in v$archived_log?

On Thu, 7 Sep 2000, Reddy, Gautam wrote:

> 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
Received on Thu Sep 07 2000 - 16:24:01 CDT