| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Common Oracle RDBMS Misconceptions - standby db?
I'm not sure, but he was probably referring to resyncing a standby. Some people think that in order to get the standby back up after a crash, they need to start over by copying all of the datafiles. Instead, all you have to do is ftp the archive log files over, recover standby database and apply the logs, and put into managed recovery mode.
Mike
>From: "Koivu, Lisa" <lisa.koivu_at_efairfield.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Common Oracle RDBMS Misconceptions - standby db?
>Date: Tue, 26 Jun 2001 11:12:24 -0800
>
>OK. I admit my knowledge on standby is minimal, having only read up on it,
>fiddled with it and used the idea sparingly for migrations.
>
>However, Jeremiah, I'm very curious. You state that 'Must reinstantiate
>standby after failover by recopying' is a misconception. Yes, like many of
>the things you state below, the documentation does say that - once you open
>a standby db in r/w mode, it is no longer a valid standby after switching
>back to the primary.
>
>Can someone shed some light on why this is not true? It seemed to make
>complete sense to me. I can see how opening a database read only will work
>and not invalidate the standby, but r/w?
>
>Thanks
>Lisa Koivu
>Ft. Lauderdale, FL, USA
>
> > -----Original Message-----
> > From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> > Sent: Tuesday, June 26, 2001 1:57 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Common Oracle RDBMS Misconceptions
> >
> > Jeremiah,
> >
> > Marlene and I did an "exploding the myths" paper very similar to what
>you
> > are doing..
> >
> > "always set pctincrease on your temporary tablespace to 1"
> >
> > and my OOW submission is very very similar to yours. Not quite, but
> > really
> > close.
> >
> > It will be interesting to see if they choose one, both or neither of our
> > papers :)
> >
> > Rachel
> >
> > >From: Jeremiah Wilton <jwilton_at_speakeasy.net>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Re: Common Oracle RDBMS Misconceptions
> > >Date: Tue, 26 Jun 2001 09:05:27 -0800
> > >
> > >All right folks, I'm collecting misconceptions, of the type held by
> > newbies
> > >and
> > >oldtimers alike. My OOW proposal this year is for a presentation and
> > paper
> > >on a
> > >whole laundry list of these things, similar to what I wrote for hot
> > backup.
> > > I
> > >want to share what I have so far and solicit input for your favorites
> > (pet
> > >peeves). I most certainly will credit individuals and this list for
>any
> > >ideas I
> > >glean.
> > >
> > >So far my favorite misconceptions are:
> > >
> > >* Hot backup stops writing to datafiles
> > >* All network communication is done through the listener
> > >* Always 'switch logfile' after (before, inbetween) hot backups
> > >* Media recovery is required if you crash during backup mode
> > >* Cold backup once a week ("just in case," "as a 'baseline'")
> > >* Export is a good way to back up your database
> > >* Shutdown abort is bad, crash recovery time is as long as 'shutdown
> > >immediate'
> > >* Listener.log/alert.log clearing confusion
> > >* ORA-1555 can be solved by setting transaction (use specific rollback
> > seg)
> > >* Big batch jobs should use one big RBS
> > >* ORA-600 means you have corruption / just call support for ORA-600
> > >* Lots of extents are bad
> > >* Databases can't be renamed
> > >* Select count (1) is better than count (*).
> > >* Listeners have to be started before the instance
> > >* NOLOGGING turns off logging for all operations
> > >* Oracle Corp. won't support NFS datafiles
> > >* checkpoint not complete - misguided solutions
> > >* Must reinstantiate standby after failover by recopying
> > >* redolog size change requires outage
> > >
> > >What's *your* pet misconception?
> > >
> > >--
> > >Jeremiah Wilton
> > >http://www.speakeasy.net/~jwilton
> > >
> > >On Tue, 26 Jun 2001, novicedba wrote:
> > >
> > > > I visited Jeremiah Wilton's web page
>http://www.speakeasy.net/~jwilton
> > > > I was shocked to read Hot backup mode explained
> > > > If this is true then I may be a victim of a disease called
> > > > 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim
> > >carrey-MASK style)
> > > > Please help me. If some one has few more articles like this
>enlighten
> > me
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Jeremiah Wilton
> > > INET: jwilton_at_speakeasy.net
> > >
> > >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 FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: mwkillough_at_hotmail.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 Jun 27 2001 - 13:42:05 CDT
 |
 |