RE: Oracle Standby Database Backups.
Arup,Indy, List Some Clarifications please If the Primary Database is in ARCHIVELOG Mode (Physical Standby) archived files there from are being shipped applied to the Standby Database, What is the need to run the Standby Database in ARCHIVELOG Mode? Are you implying 9i Dataguard with a Standby which works on a mechanism Other than Log-shipping? Please give detail Thanks -Original Message- From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Standby Database Backups. 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 archivedlogbackups 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 - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. 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
Re: Oracle Standby Database Backups.
Vivek, The origianl poster inquired on Physical Standby (in 8i and 9i) as opposed to logical standby (only in 9i). In physical standby, you don't have a choice of running the standby in noarchivelog mode. The control file is created from the primary as "standby controlfile" which is then implanted at the standby site. Therefore the LOGMODE is V$DATABASE is always ARCHIVELOG and the CONTROLFILE_TYPE is always "STANDBY". I guess you are confused on the potential issue - when the logmode is archivelog, whether the standby generates archived log files. No, the standby does not generate archived logs since it does not excute transactions; it just applies the logs shipped from the primary. When you activate the standby to make it the primary, however, the archived logs are generated. Hope this clears any confusion. Do let us know if you have more questions on this. Arup Nanda www.proligence.com - Original Message - From: VIVEK_SHARMA To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 05, 2003 3:09 AM Subject: RE: Oracle Standby Database Backups. Arup,Indy, List Some Clarifications please If the Primary Database is in ARCHIVELOG Mode (Physical Standby) archived files there from are being shipped applied to the Standby Database, What is the need to run the Standby Database in ARCHIVELOG Mode? Are you implying 9i Dataguard with a Standby which works on a mechanism Other than Log-shipping? Please give detail Thanks -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:35 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Standby Database Backups. 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 archivedlogbackups 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 - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. 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
RE: Oracle Standby Database Backups.
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-From: Arup Nanda [mailto:]Sent: Wednesday, September 03, 2003 3:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Standby Database Backups. 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 archivedlogbackups 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 - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. 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
RE: Oracle Standby Database Backups.
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).
RE: Oracle Standby Database Backups.
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
Oracle Standby Database Backups.
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
Re: Oracle Standby Database Backups.
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 archivedlogbackups 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 - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. 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
Re: Oracle Standby Database Backups.
Tom As long as your standby database is Physical Standby DB [ Not for Logical Standby Database where you also need to take the standby database backup] If the Database size is very big [ Not even in TB but few hundred GB ], If the Database is 24*7 If the Network connection is good [ We are not using this for some of the Server that are in remote location as Disaster recovery Server and Network connection is not good] It is good idea to perform the Oracle Backup thru RMAN on Standby Database as this way you can avoid any Resource issue on the Primary Database.Arup has already pointed out the detailed benefits. We are using this for lots of big databases. Indy Johal Manager, Database Administration PR Newswire [EMAIL PROTECTED] http://www.prnewswire.com (201) 946-5687 [W] (201) 400-3960 [M] We tell your story to the world. Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/03/03 03:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle Standby Database Backups. 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 - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. 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