Tom.... it's me again...
I have a (I consider) really good document about stand
by databases... (old, maybe, but still applies to 8i
standby databases)...
if you are interested... I can send you a copy... it
focuses about the 'details' with theses databases...
HTH
JL
- "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
wrote:
> Jose,
>
> I've taken nothing into account. I'm still asking
> theoretical questions,
> trying to prepare for a discussion I will be having
> this afternoon.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Thursday, September 04, 2003 11:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Tom....
>
> I was wondering about the last log file on your
> primary database that still hasn't been sent to your
> standby database until a switch log occurs...
> (thinking about sustained mode too)
>
> Have you taken that into account??
>
> JL
>
> --- "Mercadante, Thomas F"
> <NDATFM_at_labor.state.ny.us>
> wrote:
> > Arup,
> >
> > Thanks for the reply. So I am assuming that the
> > Standby database is in
> > archivelog mode?
> > Good idea performing the backup on the standby
> > rather than the Primary. Our
> > Primary is supposed to grow to 3TB, so your idea
> has
> > merit. And our servers
> > will be in two different buildings, so it makes
> > sense. In case of a
> > disaster, we switch to the Standby and recover the
> > Primary when it becomes
> > available again, right?
> >
> > Thanks again.
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> > -----Original Message-----
> > Sent: Wednesday, September 03, 2003 3:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Tom,
> >
> > You should perform backups from the Standby
> > database, regular RMAN backups,
> > no need to shutdown the database. Make sure you
> > backup the archived log
> > files from there too. Contrary to what the docs
> > might _imply_, I use the
> > word "imply" rather than "state", since the docs
> > have been kind of
> > ambiguous, the archivedlog backups from the
> standby
> > are perfectly alright to
> > be used for recoveries..
> >
> > You could use the RMAN backup on the primary, but
> > why? You would rather want
> > to offload the CPU cycles for RMAN to the standby
> > database. In case of a
> > failure in the primary, your first option is to
> get
> > the files from standby
> > and recover them. If standby is down too (as in
> case
> > of a complete
> > disaster), you would reinstate the standby backup
> > files to primary and you
> > will be ok.
> >
> > We are using it to backup out 7 TB OLTP database.
> >
> > HTH.
> >
> > Arup
> >
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L
> > <mailto:ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, September 03, 2003 2:29 PM
> >
> > All,
> >
> >
> > We are in the beginning stages of designing a
> > database with Oracle Standby
> > capability. The initial size of the database will
> > be 600-800 Gig. The
> > proposed database will be run on a IBM P690 with a
> > mirrored fail-over
> > machine. Two separate machines with separate
> disk.
> > We are considering
> > using Oracle Standby to have the database
> available
> > as much as possible.
> >
> > Do I need to perform regular backups of the
> Standby
> > database? Sounds like a
> > silly question, but how do I do this? Using Rman?
>
> > Or do I shut it down and
> > perform a cold backup? I will definitely use Rman
> > on the primary database.
> > Just curious what you all would suggest.
> >
> > Thanks in advance!
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> >
> >
> >
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Jose Luis Delgado
> INET: joseluis_delgado_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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.net
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
INET: joseluis_delgado_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Sep 04 2003 - 11:54:44 CDT
