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).
Received on Thu Sep 04 2003 - 10:29:27 CDT
