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