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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
