Re: standby database configuration in 9iR2 SE ?
JP, Juan, and Prem, Prem is correct. Standby is certainly a feature of SE, just not the "managed recovery" and "SQL*Net log shipping" parts, which only come with EE. Essentially, Standby Database features in SE is just like Standby Database features from 7.3 through 8.0. I have some shell scripts for log shipping and log apply (executed via "cron") that I wrote for SE on Sun Solaris some years ago. Attachments to this list get stripped off, so email me offline if you'd like 'em. No warranty, no guarantees -- just a starting point... Hope this helps... -Tim on 12/16/03 1:04 AM, Prem Khanna J at [EMAIL PROTECTED] wrote: > No Juan . SE also has the feature but "Managed Recovery" > is not possible as in EE . > > A metalink doc says : > > Basic Standby Database is a feature of SE . > that is it Allows the DBA to manually clone a database, > and to copy and to apply log files to the standby > > > anyway i'm looking for "manual recovery" which is possible in SE. > > Regards, > Jp. > >>> -Original Message- >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >>> >>> Standby is only for Enterprise Ed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: standby database configuration in 9iR2 SE ?
The docs on data guard also include the steps required for manual recovery - as a sort of afterthought admittedly but they are there. If I remember I'll dig up my docs from work on this - I keep meaning to write something on this exact subject. Drawbacks include the fact that you have to keep track of log gaps manually. Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Prem Khanna J > Sent: 16 December 2003 08:04 > To: Multiple recipients of list ORACLE-L > Subject: RE: standby database configuration in 9iR2 SE ? > > > No Juan . SE also has the feature but "Managed Recovery" > is not possible as in EE . > > A metalink doc says : > > Basic Standby Database is a feature of SE . > that is it Allows the DBA to manually clone a database, > and to copy and to apply log files to the standby > > > anyway i'm looking for "manual recovery" which is possible in SE. > > Regards, > Jp. > > >>-Original Message- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >> > >>Standby is only for Enterprise Ed. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > 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: Niall Litchfield 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: standby database configuration in 9iR2 SE ?
No Juan . SE also has the feature but "Managed Recovery" is not possible as in EE . A metalink doc says : Basic Standby Database is a feature of SE . that is it Allows the DBA to manually clone a database, and to copy and to apply log files to the standby anyway i'm looking for "manual recovery" which is possible in SE. Regards, Jp. >>-Original Message- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >> >>Standby is only for Enterprise Ed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: standby database configuration in 9iR2 SE ?
Standby is only for Enterprise Ed. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Prem Khanna J Enviado el: martes, 16 de diciembre de 2003 8:24 Para: Multiple recipients of list ORACLE-L Asunto: standby database configuration in 9iR2 SE ? List, Can someone give me a doc/URL for the steps invloved in standby database configuration ( manual recovery mode ) on 9iR2 SE ? I do have a doc for standby database configuration ( managed recovery mode ) for 8i EE . except automatic log transfer which is not a feature of SE , will the steps involved be quite different or almost the same ? Your suggestions please . Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Juan Miranda 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).
standby database configuration in 9iR2 SE ?
List, Can someone give me a doc/URL for the steps invloved in standby database configuration ( manual recovery mode ) on 9iR2 SE ? I do have a doc for standby database configuration ( managed recovery mode ) for 8i EE . except automatic log transfer which is not a feature of SE , will the steps involved be quite different or almost the same ? Your suggestions please . Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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.
Its possible 'cause we are two different OS and DB versions. Would it be possible if we upgrade source database from 816 to 8174 and then use Standby database. -Original Message- Sent: Thursday, September 25, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Avnish: That is not possible in 8.1.7. You need to be atleast 9.2 to do that. --- [EMAIL PROTECTED] wrote: > We are planning to migrate one 600GB OPS (2 nodes) database from AIX > 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use > Oracle standby database of two different versions of OS and database. > = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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.
Avnish: That is not possible in 8.1.7. You need to be atleast 9.2 to do that. --- [EMAIL PROTECTED] wrote: > We are planning to migrate one 600GB OPS (2 nodes) database from AIX > 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use > Oracle standby database of two different versions of OS and database. > = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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).
Oracle Standby database.
We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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.
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 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
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 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
Re: rename data file on standby database
Many thanks Louis for your input, Have nice day, Kader --- Jose Luis Delgado <[EMAIL PROTECTED]> wrote: > Hi Kader... > > you do not need to do the same on the standby > database... > > That logical changes are reflected automatically... > The only thing is that your physical datafile remain > as initially, but your controlfile has the changes. > > Was I clear? > > note that the only changes that you need to do at > your > standby database is when you add > tablespaces/datafiles > to your primary database, then you need to add them > to > your standby database. > > HTH > JL > > > --- Kader Ben <[EMAIL PROTECTED]> wrote: > > Hi Listers, > > > > I have standby database working fine (until now!). > I > > have renamed one datafile on the primary database > > and > > I'm wondering if I have to do the same thing on > the > > standby database to reflect the structure change. > > I have renamed the file yesterday and the standby > > database stil recovering incoming archives without > > any > > error but the data file renamed on the primary > > database is on the its original location on the > > standby database. > > > > Many thanks for your help, > > > > Kader > > > > > > > > __ > > 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: Kader Ben > > 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). __ 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: Kader Ben 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 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).
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 >
Re: rename data file on standby database
Hi Kader... you do not need to do the same on the standby database... That logical changes are reflected automatically... The only thing is that your physical datafile remain as initially, but your controlfile has the changes. Was I clear? note that the only changes that you need to do at your standby database is when you add tablespaces/datafiles to your primary database, then you need to add them to your standby database. HTH JL --- Kader Ben <[EMAIL PROTECTED]> wrote: > Hi Listers, > > I have standby database working fine (until now!). I > have renamed one datafile on the primary database > and > I'm wondering if I have to do the same thing on the > standby database to reflect the structure change. > I have renamed the file yesterday and the standby > database stil recovering incoming archives without > any > error but the data file renamed on the primary > database is on the its original location on the > standby database. > > Many thanks for your help, > > Kader > > > > __ > 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: Kader Ben > 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).
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.
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 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
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
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
rename data file on standby database
Hi Listers, I have standby database working fine (until now!). I have renamed one datafile on the primary database and I'm wondering if I have to do the same thing on the standby database to reflect the structure change. I have renamed the file yesterday and the standby database stil recovering incoming archives without any error but the data file renamed on the primary database is on the its original location on the standby database. Many thanks for your help, Kader __ 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: Kader Ben 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).
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
Standby database & ORA-16016
ORA-16016 archived log for thread string sequence# string unavailable Hello All I have a standby database oracle 8.1.7.4 on win2k running in "managed recovery mode". NET8 have been transferring logs untill somehow the primary or standby server must have rebooted and I have now have sequence gaps. This doc seems to be everything you ever wanted to know about standby databses http://www.cs.rose-hulman.edu/docs/oracle-817/server.817/a76995/standbyc .htm#29765 But does not seem to address my problem. I would think... The primary database, would be sure to send *any* logs it has not sent. How can I be sure the primary sends all logs? Ive performed a log switch and the missing logs do not get sent. Does anyone have any suggestions to correct this? I would be very thankful. have a good weekend all! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: Standby database & ORA-16016
Hi! I think archive log gap management is a new feature in 9i Data Guard. Check 9i's docs. You might have to build custom scripts for gap management in 8i. Also, I recommend you to use documentation from authentic location, http://tahiti.oracle.com Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 10:59 PM > ORA-16016 archived log for thread string sequence# string unavailable > > Hello All > > I have a standby database oracle 8.1.7.4 on win2k running in "managed > recovery mode". NET8 have been transferring logs untill somehow the > primary or standby server must have rebooted and I have now have > sequence gaps. > > This doc seems to be everything you ever wanted to know about standby > databses > http://www.cs.rose-hulman.edu/docs/oracle-817/server.817/a76995/standbyc > .htm#29765 > > But does not seem to address my problem. > > I would think... The primary database, would be sure to send *any* logs > it has not sent. How can I be sure the primary sends all logs? > > Ive performed a log switch and the missing logs do not get sent. > > Does anyone have any suggestions to correct this? I would be very > thankful. > > have a good weekend all! > > bob > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bob Metelsky > 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: Tanel Poder 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: Purging Managed Standby Database Archive Logs
Title: RE: Purging Managed Standby Database Archive Logs
For pre 9i release2 there is following Note on
metalink
Doc
ID:
Note:190311.1
Subject:
** How to delete an Operating System file from
PL/SQL
This uses a java stored procedure
HTH
Shaleen
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 12:38
AM
Subject: Re: Purging Managed Standby
Database Archive Logs
Hello Steve
If you are on 9.2 you can use utl_file.fremove
directly from the sql.
Yechiel AdarMehish
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list
ORACLE-L
Sent: Thursday, December 12, 2002
9:48 PM
Subject: RE: Purging Managed Standby
Database Archive Logs
Hi John,
Keeping things simple sometimes complicates things when
they go haywire. I thought about the simple shotgun approach but wanted
something a little more robust and I didn't want to risk deleting an
archive log that hadn't been applied and then having to go through the
hassle of finding in on tape. (We use RMAN on production server and
"archivelog all delete input" every night.) A lot of logs could be zapped
if the standby got hosed just before a 3-4 day weekend. I want to avoid
having to rebuild the standby but I don't want to keep multiple days worth
of logs around either. I just want to remove the logs that are no longer
needed and the archive info is in the data dictionary views so why not use
it?
Well after waiting on the list a while nobody did my job
for me so I got busy and rolled my own... :-) --
#!/usr/bin/ksh # File:
sb_log_maint.sh ... Steve Orr, 12/12/2002 #
Purpose: Purge standby database archive logs which have been
applied. ORAUBIN="/u01/app/oracle/bin"
SEQ_FILE="$ORAUBIN/last_purged_seqno.txt"
LAST_PURGED_SEQ=`cat ${SEQ_FILE}`
getAppliedLogs() {
sqlplus -s "/ as sysdba" @$ORAUBIN/login.sql
< set feed off pages 0 echo off wra
off select sequence#, trim(name) from
v\$archived_log where sequence# >
$LAST_PURGED_SEQ and archived='YES'
order by sequence# ; exit
EOSQL }
getAppliedLogs | while read SEQNO FNAME do echo "Removing file
$FNAME" echo $SEQNO >
$SEQ_FILE if [ -f $FNAME ];
then rm
$FNAME fi done --
...it seems to work and I wasn't in a PERLescent
mood.
Steve Orr Bozeman, Montana
-Original Message- From:
John Carlson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: Purging Managed Standby Database Archive Logs
Keep it simple. If you are on unix put this in your
crontab.
30 * * * * find /archive/oradata/YOURSID -type f
-name "1_*.arc" -mtime +0 -exec rm -f {} \;
This will run every hour on the half hour and purge
everything over 24 hours old.
Modify as you like. (-mtime +1 gives you 48
hours) Yes, I know this could delete files
that haven't been applied but I figure if your standby is 24 hours behind, it will need to be re-established
anyway.
HTH, John
>>> [EMAIL PROTECTED] 12/12/02 08:04AM
>>> Any one have a ready-made routine to
purge the unneeded archives which have
been automagically applied to a managed standby
database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of
the archive logs (v$archived_log.name) where sequence# > [the max number you
purged the last time];
2. Cycle through the above list and remove the
files;
3. Record the max(sequence#) from v$log_history for the
next purge.
Any other ideas/suggestions?
AtDhVaAnNkCsE!!! Steve Orr
Standing by in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Author: John Carlson INET: [EMAIL PROTECTED]
Re: Purging Managed Standby Database Archive Logs
Title: RE: Purging Managed Standby Database Archive Logs
Hello Steve
If you are on 9.2 you can use utl_file.fremove directly
from the sql.
Yechiel AdarMehish
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 9:48
PM
Subject: RE: Purging Managed Standby
Database Archive Logs
Hi John,
Keeping things simple sometimes complicates things when they
go haywire. I thought about the simple shotgun approach but wanted something a
little more robust and I didn't want to risk deleting an archive log that
hadn't been applied and then having to go through the hassle of finding in on
tape. (We use RMAN on production server and "archivelog all delete input"
every night.) A lot of logs could be zapped if the standby got hosed just
before a 3-4 day weekend. I want to avoid having to rebuild the standby but I
don't want to keep multiple days worth of logs around either. I just want to
remove the logs that are no longer needed and the archive info is in the data
dictionary views so why not use it?
Well after waiting on the list a while nobody did my job for
me so I got busy and rolled my own... :-) --
#!/usr/bin/ksh # File:
sb_log_maint.sh ... Steve Orr, 12/12/2002 # Purpose:
Purge standby database archive logs which have been applied. ORAUBIN="/u01/app/oracle/bin" SEQ_FILE="$ORAUBIN/last_purged_seqno.txt" LAST_PURGED_SEQ=`cat ${SEQ_FILE}`
getAppliedLogs() { sqlplus -s "/ as sysdba" @$ORAUBIN/login.sql <
set feed off pages 0 echo off wra off select sequence#, trim(name) from v\$archived_log where sequence# > $LAST_PURGED_SEQ and
archived='YES' order by sequence# ; exit EOSQL }
getAppliedLogs | while read SEQNO FNAME do echo "Removing file
$FNAME" echo $SEQNO > $SEQ_FILE
if [ -f $FNAME ]; then rm $FNAME fi done --
...it seems to work and I wasn't in a PERLescent mood.
Steve Orr Bozeman, Montana
-Original Message- From: John
Carlson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: Purging Managed Standby Database Archive Logs
Keep it simple. If you are on unix put this in your
crontab.
30 * * * * find /archive/oradata/YOURSID -type f -name
"1_*.arc" -mtime +0 -exec rm -f {} \;
This will run every hour on the half hour and purge everything
over 24 hours old.
Modify as you like. (-mtime +1 gives you 48 hours)
Yes, I know this could delete files that haven't been
applied but I figure if your standby is 24 hours
behind, it will need to be re-established anyway.
HTH, John
>>> [EMAIL PROTECTED] 12/12/02 08:04AM
>>> Any one have a ready-made routine to
purge the unneeded archives which have
been automagically applied to a managed standby
database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of the
archive logs (v$archived_log.name) where sequence# > [the max number you purged
the last time];
2. Cycle through the above list and remove the files;
3. Record the max(sequence#) from v$log_history for the next
purge.
Any other ideas/suggestions?
AtDhVaAnNkCsE!!! Steve Orr
Standing by in Bozeman, Montana --
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- Author: John Carlson
INET: [EMAIL PROTECTED]
RE: Purging Managed Standby Database Archive Logs
Title: RE: Purging Managed Standby Database Archive Logs
Hi John,
Keeping things simple sometimes complicates things when they go haywire. I thought about the simple shotgun approach but wanted something a little more robust and I didn't want to risk deleting an archive log that hadn't been applied and then having to go through the hassle of finding in on tape. (We use RMAN on production server and "archivelog all delete input" every night.) A lot of logs could be zapped if the standby got hosed just before a 3-4 day weekend. I want to avoid having to rebuild the standby but I don't want to keep multiple days worth of logs around either. I just want to remove the logs that are no longer needed and the archive info is in the data dictionary views so why not use it?
Well after waiting on the list a while nobody did my job for me so I got busy and rolled my own... :-)
--
#!/usr/bin/ksh
# File: sb_log_maint.sh ... Steve Orr, 12/12/2002
# Purpose: Purge standby database archive logs which have been applied.
ORAUBIN="/u01/app/oracle/bin"
SEQ_FILE="$ORAUBIN/last_purged_seqno.txt"
LAST_PURGED_SEQ=`cat ${SEQ_FILE}`
getAppliedLogs()
{
sqlplus -s "/ as sysdba" @$ORAUBIN/login.sql <
set feed off pages 0 echo off wra off
select sequence#, trim(name) from v\$archived_log
where sequence# > $LAST_PURGED_SEQ
and archived='YES'
order by sequence# ;
exit
EOSQL
}
getAppliedLogs | while read SEQNO FNAME
do
echo "Removing file $FNAME"
echo $SEQNO > $SEQ_FILE
if [ -f $FNAME ]; then
rm $FNAME
fi
done
--
...it seems to work and I wasn't in a PERLescent mood.
Steve Orr
Bozeman, Montana
-Original Message-
From: John Carlson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Purging Managed Standby Database Archive Logs
Keep it simple. If you are on unix put this in your crontab.
30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc"
-mtime +0 -exec rm -f {} \;
This will run every hour on the half hour and purge everything over 24
hours old.
Modify as you like. (-mtime +1 gives you 48 hours) Yes, I know this
could delete files that haven't been applied but I figure if your
standby is 24 hours behind, it will need to be re-established anyway.
HTH,
John
>>> [EMAIL PROTECTED] 12/12/02 08:04AM >>>
Any one have a ready-made routine to purge the unneeded archives which
have
been automagically applied to a managed standby database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of the archive
logs
(v$archived_log.name) where sequence# > [the max number you purged the
last
time];
2. Cycle through the above list and remove the files;
3. Record the max(sequence#) from v$log_history for the next purge.
Any other ideas/suggestions?
AtDhVaAnNkCsE!!!
Steve Orr
Standing by in Bozeman, Montana
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Carlson
INET: [EMAIL PROTECTED]
Re: Purging Managed Standby Database Archive Logs
Steve,
It's pretty simple. No need to record anything - see the Order By
Descending in the SQL below.
Here are a batch file and a SQL script I used on an 8.1.7 Standby DB under
Win2k. It ran reliably for months as a Scheduled Task once every hour and
got rid of all applied logs, assuming that there would never be any more
than 400 archived redo logs sent over from the main DB in a single hour.
You could easily change it to shell scripts under UNIX, as well as the
formatting of your archived redo log names.
Delete_Applied_Archived_Redo_Logs_main.bat
---
Set ORACLE_SID=MySID
SQLPlus internal @C:
\Oracle\Admin\MySID\Delete_Applied_Archived_Redo_Logs_sub.sql
C:\Oracle\Admin\MySID\Delete_Applied_Archived_Redo_Logs_Delete.bat
---
Delete_Applied_Archived_Redo_Logs_sub.sql
---
Set FeedBack Off
Set LineSize 200
Set PageSize 0
Set TrimSpool On
Spool C:\Oracle\Admin\MySID\Delete_Applied_Archived_Redo_Logs_delete.bat
Select 'Del U:\Oracle\OraData\MySID\Archive\ARC' || Trim(v.Seq) || '.LOG'
>From (
Select To_Char(Sequence#,'0') Seq
From v$Log_History
Order By Sequence# Desc
) v
Where RowNum < 401
;
Spool Off
Exit
---
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]
"Orr, Steve"
<[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L
m><[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Purging Managed Standby
Database Archive Logs
12/12/2002 10:04
AM
Please respond to
ORACLE-L
Any one have a ready-made routine to purge the unneeded archives which have
been automagically applied to a managed standby database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of the archive logs
(v$archived_log.name) where sequence# > [the max number you purged the last
time];
2. Cycle through the above list and remove the files;
3. Record the max(sequence#) from v$log_history for the next purge.
Any other ideas/suggestions?
AtDhVaAnNkCsE!!!
Steve Orr
Standing by in Bozeman, Montana
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: Purging Managed Standby Database Archive Logs
Keep it simple. If you are on unix put this in your crontab.
30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc"
-mtime +0 -exec rm -f {} \;
This will run every hour on the half hour and purge everything over 24
hours old.
Modify as you like. (-mtime +1 gives you 48 hours) Yes, I know this
could delete files that haven't been applied but I figure if your
standby is 24 hours behind, it will need to be re-established anyway.
HTH,
John
>>> [EMAIL PROTECTED] 12/12/02 08:04AM >>>
Any one have a ready-made routine to purge the unneeded archives which
have
been automagically applied to a managed standby database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of the archive
logs
(v$archived_log.name) where sequence# > [the max number you purged the
last
time];
2. Cycle through the above list and remove the files;
3. Record the max(sequence#) from v$log_history for the next purge.
Any other ideas/suggestions?
AtDhVaAnNkCsE!!!
Steve Orr
Standing by in Bozeman, Montana
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Carlson
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).
Purging Managed Standby Database Archive Logs
Title: Purging Managed Standby Database Archive Logs Any one have a ready-made routine to purge the unneeded archives which have been automagically applied to a managed standby database? I figure it needs to: 1. Query v$archived_log and v$log_history to get a list of the archive logs (v$archived_log.name) where sequence# > [the max number you purged the last time]; 2. Cycle through the above list and remove the files; 3. Record the max(sequence#) from v$log_history for the next purge. Any other ideas/suggestions? AtDhVaAnNkCsE!!! Steve Orr Standing by in Bozeman, Montana
Re: Implementing Continuous Managed Recovery on a Standby Database
upgrade to 9... SQL> recover ... disconnect hth connor --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Problem: How to keep a standby database in > continuous managed recovery > without having to maintain an open terminal session. > (Version 8.1.7.2) > > When you execute the following... > ------ > > SQL> RECOVER MANAGED STANDBY DATABASE; > -- > > ...SQL*Plus does not return a prompt and the > database is in continuous > recovery BUT... as soon as you exit the session, > recovery discontiues and > the logs are nolonger automagically applied. "No > problem," I said, "I'll > just wrap it in a shell script and launch it in the > background." Doesn't > work and it appears SQL*Plus is a misbehaving > process. (Linux) > > So then I tried nohup: > -- > > $ nohup sqlplus "/ as sysdba" @managed_recov.sql & > [1] 23412 > $ nohup: appending output to 'nohup.out' > [1]+ Exit 127 nohup sqlplus "/ as sysdba" > @managed_recov.sql > -- > > The managed_recov.sql script contains this one line: > > RECOVER MANAGED STANDBY DATABASE; > This works but it does not persist as a background > process- it terminates > when I hit enter or leave the terminal session. I > think it terminates > because SQL*Plus is misbehaving. What do you think? > > So with a little help from a *nix geek I did this... > -- > > sqlplus "/ as sysdba" @managed_recov.sql &>standby.log & > -- > > ...presto chango, it works- standard I/O is OK and > running in the > background. The standby DB is in continuous recovery > and I can shutdown my > PC and go home and managed recovery just keeps on > running. Cool. > > Is there a better way to do this? I submitted a TAR > but OWS hasn't been any > help. Doesn't it seem lame that Oracle gives the > "RECOVER MANAGED STANDBY > DATABASE" command but is unable to provide a means > to implement it without > requiring the terminal session to remain open? > > > Whining in Bozeman, Montana > Steve Orr > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Orr, Steve > 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). > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Implementing Continuous Managed Recovery on a Standby Database
I just started the databases up in the background. Patrol keeps track of the databases but we have never had a problem doing this. Had to write a custom dbstart script though. Works fine but is unsupported by Oracle. --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Problem: How to keep a standby database in > continuous managed recovery > without having to maintain an open terminal session. > (Version 8.1.7.2) > > When you execute the following... > ------ > > SQL> RECOVER MANAGED STANDBY DATABASE; > -- > > ...SQL*Plus does not return a prompt and the > database is in continuous > recovery BUT... as soon as you exit the session, > recovery discontiues and > the logs are nolonger automagically applied. "No > problem," I said, "I'll > just wrap it in a shell script and launch it in the > background." Doesn't > work and it appears SQL*Plus is a misbehaving > process. (Linux) > > So then I tried nohup: > -- > > $ nohup sqlplus "/ as sysdba" @managed_recov.sql & > [1] 23412 > $ nohup: appending output to 'nohup.out' > [1]+ Exit 127 nohup sqlplus "/ as sysdba" > @managed_recov.sql > -- > > The managed_recov.sql script contains this one line: > > RECOVER MANAGED STANDBY DATABASE; > This works but it does not persist as a background > process- it terminates > when I hit enter or leave the terminal session. I > think it terminates > because SQL*Plus is misbehaving. What do you think? > > So with a little help from a *nix geek I did this... > -- > > sqlplus "/ as sysdba" @managed_recov.sql &>standby.log & > -- > > ...presto chango, it works- standard I/O is OK and > running in the > background. The standby DB is in continuous recovery > and I can shutdown my > PC and go home and managed recovery just keeps on > running. Cool. > > Is there a better way to do this? I submitted a TAR > but OWS hasn't been any > help. Doesn't it seem lame that Oracle gives the > "RECOVER MANAGED STANDBY > DATABASE" command but is unable to provide a means > to implement it without > requiring the terminal session to remain open? > > > Whining in Bozeman, Montana > Steve Orr > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Orr, Steve > 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). > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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: Implementing Continuous Managed Recovery on a Standby Database
On Friday 06 December 2002 18:29, Orr, Steve wrote: [...] > So then I tried nohup: > -- > $ nohup sqlplus "/ as sysdba" @managed_recov.sql & > [1] 23412 > $ nohup: appending output to 'nohup.out' > [1]+ Exit 127 nohup sqlplus "/ as sysdba" @managed_recov.sql > -- [...] > > So with a little help from a *nix geek I did this... > -- > sqlplus "/ as sysdba" @managed_recov.sql standby.log & > -- [...] > Is there a better way to do this? I submitted a TAR but OWS hasn't been any > help. Doesn't it seem lame that Oracle gives the "RECOVER MANAGED STANDBY > DATABASE" command but is unable to provide a means to implement it without > requiring the terminal session to remain open? > Hi, try it wiht screen, a nice tool, that gives you something like another terminal. An example: $screen sqlplus "/ as sysdba" $sql>RECOVER MANAGED STANDBY DATABASE; So, now you say CTRL-a and CTRL-d and you are back in your first session. now you can work on without any worry. If you want to come back, you say: $screen -r as the same user, you start the screen. Thats it. Hope it helps by Joerg > > Whining in Bozeman, Montana > Steve Orr -- - Software Engineering Vattmannstraße 7, 33100 Paderborn Phone: (+49) 52 51 / 30 1 6333 Fax: (+49) 52 51 / 30 16 399 eMail: [EMAIL PROTECTED] http://www.unitrade.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joerg Jost 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: Implementing Continuous Managed Recovery on a Standby Database
Quit whining =8-) The behaviour is the same for any process that inherits it's stdin/stdout and stderr from the parent. Once the parent (your shell) goes away, the file handles are closed and the child has nothing to talk to. You only half-solved the problem with the nohup. You did the right thing by redirecting stdoutstdin was already pointing to the script file. I would go one more paranoid step further and redirect stderr too. Jeff Herrick On Fri, 6 Dec 2002, Orr, Steve wrote: > Problem: How to keep a standby database in continuous managed recovery > without having to maintain an open terminal session. (Version 8.1.7.2) > > When you execute the following... > -- > SQL> RECOVER MANAGED STANDBY DATABASE; > -- > ...SQL*Plus does not return a prompt and the database is in continuous > recovery BUT... as soon as you exit the session, recovery discontiues and > the logs are nolonger automagically applied. "No problem," I said, "I'll > just wrap it in a shell script and launch it in the background." Doesn't > work and it appears SQL*Plus is a misbehaving process. (Linux) > > So then I tried nohup: > -- > $ nohup sqlplus "/ as sysdba" @managed_recov.sql & > [1] 23412 > $ nohup: appending output to 'nohup.out' > [1]+ Exit 127 nohup sqlplus "/ as sysdba" @managed_recov.sql > ------ > The managed_recov.sql script contains this one line: > RECOVER MANAGED STANDBY DATABASE; > This works but it does not persist as a background process- it terminates > when I hit enter or leave the terminal session. I think it terminates > because SQL*Plus is misbehaving. What do you think? > > So with a little help from a *nix geek I did this... > -- > sqlplus "/ as sysdba" @managed_recov.sql standby.log & > -- > ...presto chango, it works- standard I/O is OK and running in the > background. The standby DB is in continuous recovery and I can shutdown my > PC and go home and managed recovery just keeps on running. Cool. > > Is there a better way to do this? I submitted a TAR but OWS hasn't been any > help. Doesn't it seem lame that Oracle gives the "RECOVER MANAGED STANDBY > DATABASE" command but is unable to provide a means to implement it without > requiring the terminal session to remain open? > > > Whining in Bozeman, Montana > Steve Orr > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Orr, Steve > 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.com -- Author: Jeff Herrick 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).
Implementing Continuous Managed Recovery on a Standby Database
Problem: How to keep a standby database in continuous managed recovery without having to maintain an open terminal session. (Version 8.1.7.2) When you execute the following... -- SQL> RECOVER MANAGED STANDBY DATABASE; -- ...SQL*Plus does not return a prompt and the database is in continuous recovery BUT... as soon as you exit the session, recovery discontiues and the logs are nolonger automagically applied. "No problem," I said, "I'll just wrap it in a shell script and launch it in the background." Doesn't work and it appears SQL*Plus is a misbehaving process. (Linux) So then I tried nohup: -- $ nohup sqlplus "/ as sysdba" @managed_recov.sql & [1] 23412 $ nohup: appending output to 'nohup.out' [1]+ Exit 127 nohup sqlplus "/ as sysdba" @managed_recov.sql -- The managed_recov.sql script contains this one line: RECOVER MANAGED STANDBY DATABASE; This works but it does not persist as a background process- it terminates when I hit enter or leave the terminal session. I think it terminates because SQL*Plus is misbehaving. What do you think? So with a little help from a *nix geek I did this... -- sqlplus "/ as sysdba" @managed_recov.sql standby.log & -- ...presto chango, it works- standard I/O is OK and running in the background. The standby DB is in continuous recovery and I can shutdown my PC and go home and managed recovery just keeps on running. Cool. Is there a better way to do this? I submitted a TAR but OWS hasn't been any help. Doesn't it seem lame that Oracle gives the "RECOVER MANAGED STANDBY DATABASE" command but is unable to provide a means to implement it without requiring the terminal session to remain open? Whining in Bozeman, Montana Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: standby database question.
That would be the manual mode. "Recover standby database". With 8i, and the
multiple archive destinations, you have the sustained recovery mode.
"Recover managed standby database". A sustained recovery mode will lock
your telnet window, and will be dedicated to doing just the recovery. But
then, one can always create a shell script, and run it in the background
with nohup, assuming you are on Unix.
The latest issue of Ora Magazine has a good write up on standby database in
9i, and the FAL (Is that the name?) process.
Raj
The oramag also mentiones Carl Dudley to be the DBA of the year, and also
features x$ Gopal.
Rachel
Carmichael To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: standby database question.
Sent by:
root@fatcity.
com
October 23,
2002 12:49 PM
Please
respond to
ORACLE-L
Windows?
I used to do this with a 7.3.4 instance on Unix, I had a shell script
that would run every x minutes, and would first check to see it if was
already running. If not, it would do the recover automatic. It would
"fail" when it ran out of archived logs to apply, but the cron would
restart it and check for more.
Worked pretty well..
Rachel
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> I'm back on 8i for a different client who wants to implement standby
> database.
>
> other than the whole possibility of losing data during a failover,
> i've
> not been able to find anything about doing managed recovery with out
> having a dedicated session to put the database in managed recovery
> mode.
>
> SQL> recover managed standby database;
>
>
> this does not fork into the background but is a foreground process,
> that
> ties that window up as it receives and applies logs, that is correct
> right?
>
> Its not until 9i where we get the luxury of managed recovery being a
> background proces, right?
>
> thanks, joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> 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!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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
Re: standby database question.
On Wed, Oct 23, 2002 at 08:49:49AM -0800, Tim Gorman wrote: > Correct. > > ...though you can achieve the same thing in 8i by running the SQL*Plus or > SvrMgr process in a "backgrounded" script. Stopping the backgrounded script > is easy using the RECOVER CANCEL command from any other session... I accomplish this with the gnu screen command. It is a pretty nice addon that lets you detach/reattach/multiplex tty sessions. I use this alot for long running commands and what to go home and check on them later. http://www.gnu.org/software/screen/screen.html > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, October 23, 2002 10:14 AM > > > > I'm back on 8i for a different client who wants to implement standby > > database. > > > > other than the whole possibility of losing data during a failover, i've > > not been able to find anything about doing managed recovery with out > > having a dedicated session to put the database in managed recovery mode. > > > > SQL> recover managed standby database; > > > > > > this does not fork into the background but is a foreground process, that > > ties that window up as it receives and applies logs, that is correct > > right? > > > > Its not until 9i where we get the luxury of managed recovery being a > > background proces, right? > > > > thanks, joe > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Joe Testa > > 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.com > -- > Author: Tim Gorman > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: standby database question.
nope its unix(solaris flavor). thanks for the idea, thats probably what I'll do versus trying to setup data guard on the nodes. joe Rachel Carmichael wrote: Windows? I used to do this with a 7.3.4 instance on Unix, I had a shell script that would run every x minutes, and would first check to see it if was already running. If not, it would do the recover automatic. It would "fail" when it ran out of archived logs to apply, but the cron would restart it and check for more. Worked pretty well.. Rachel --- Joe Testa <[EMAIL PROTECTED]> wrote: I'm back on 8i for a different client who wants to implement standby database. other than the whole possibility of losing data during a failover, i've not been able to find anything about doing managed recovery with out having a dedicated session to put the database in managed recovery mode. SQL> recover managed standby database; this does not fork into the background but is a foreground process, that ties that window up as it receives and applies logs, that is correct right? Its not until 9i where we get the luxury of managed recovery being a background proces, right? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: standby database question.
Windows? I used to do this with a 7.3.4 instance on Unix, I had a shell script that would run every x minutes, and would first check to see it if was already running. If not, it would do the recover automatic. It would "fail" when it ran out of archived logs to apply, but the cron would restart it and check for more. Worked pretty well.. Rachel --- Joe Testa <[EMAIL PROTECTED]> wrote: > I'm back on 8i for a different client who wants to implement standby > database. > > other than the whole possibility of losing data during a failover, > i've > not been able to find anything about doing managed recovery with out > having a dedicated session to put the database in managed recovery > mode. > > SQL> recover managed standby database; > > > this does not fork into the background but is a foreground process, > that > ties that window up as it receives and applies logs, that is correct > right? > > Its not until 9i where we get the luxury of managed recovery being a > background proces, right? > > thanks, joe > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > 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!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: standby database question.
Correct. ...though you can achieve the same thing in 8i by running the SQL*Plus or SvrMgr process in a "backgrounded" script. Stopping the backgrounded script is easy using the RECOVER CANCEL command from any other session... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 10:14 AM > I'm back on 8i for a different client who wants to implement standby > database. > > other than the whole possibility of losing data during a failover, i've > not been able to find anything about doing managed recovery with out > having a dedicated session to put the database in managed recovery mode. > > SQL> recover managed standby database; > > > this does not fork into the background but is a foreground process, that > ties that window up as it receives and applies logs, that is correct > right? > > Its not until 9i where we get the luxury of managed recovery being a > background proces, right? > > thanks, joe > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > 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.com -- Author: Tim Gorman 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).
standby database question.
I'm back on 8i for a different client who wants to implement standby database. other than the whole possibility of losing data during a failover, i've not been able to find anything about doing managed recovery with out having a dedicated session to put the database in managed recovery mode. SQL> recover managed standby database; this does not fork into the background but is a foreground process, that ties that window up as it receives and applies logs, that is correct right? Its not until 9i where we get the luxury of managed recovery being a background proces, right? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
9i QUESTIONS: STANDBY DATABASE IMPLEMENTATION
I HAVE read the Data Guard Concepts and Administration manual (repeatedly)and will re-read it several more times. Questions: 1. Any other publications, articles, white papers to follow up on? 2. Has anybody implemented this (9.2 on AIX with IBM Shark storage) and with what level of succes/failure/gotchas. The config that is planned is to put the standby database on a separate AIX platform attached to another Shark storage unit. 3. If there is a canned, step-by-step proc anywhere, would anybody be kind enough to post the same. I vaguely recall this topic from previous posts, but as per usual can't remember much (in fact remember zero is a lot closer - just another senior moment I guess). TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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: Advantage of Standby Database in 9i vs 8i
not quite. only if you are using logical standby, which applies sql statements to the standby database instead of physical standby which applies archived redo logs There is an entire manual dedicated to standby database (now called Data Guard) in the 9i doc set online. There is, as was pointed out elsewhere this morning, a section in each manual that talks of the differences between 8i and 9i versions. It's fascinating reading and I'd recommend doing just that. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Vivek - In 8i the standby database must either be in standby mode > (applying > log files) or open for read-only querying. In 9i it can do both > simultaneously. I haven't use all the correct terms here, but maybe > it will > irritate someone into providing a more complete response. > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > -Original Message- > Sent: Wednesday, September 11, 2002 11:14 AM > To: Multiple recipients of list ORACLE-L > > > > What is the Advantage of Standby Database in 9i vs 8i ? > > Thanks > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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). __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Advantage of Standby Database in 9i vs 8i
Vivek - In 8i the standby database must either be in standby mode (applying log files) or open for read-only querying. In 9i it can do both simultaneously. I haven't use all the correct terms here, but maybe it will irritate someone into providing a more complete response. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Wednesday, September 11, 2002 11:14 AM To: Multiple recipients of list ORACLE-L What is the Advantage of Standby Database in 9i vs 8i ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Advantage of Standby Database in 9i vs 8i
What is the Advantage of Standby Database in 9i vs 8i ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Solution to Microsoft Transaction Server/Standby database problem
Some of you may recall a question I posted on a problem with MTS connection pooling. MTS continued to try to connect to our old IP address after switching between production and standby. This happened even though we switched the IP address the DNS Name was pointing to. Well, we finally managed to replicate the problem in our test environment through using a loadrunner script so it is a load related issue. Even better, using a TAF entry in the tnsnames.ora resolves most of the problem, although it takes several (i.e., app. 2-3) minutes for the switchover to take effect for all connections. Still not certain what's happening in that time period, but it works! If we ever manage to figure out why the problem is happening I'll post again, but wanted to post this now in case anyone else has similar issues. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Microsoft Transaction Server & Standby database problem
Sorry, I've never used MS-MTS... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 3:48 PM > Thanks, > > We tried this syntax in our test environment and it worked very well but of > course had no way of knowing if it solved our problem since that didn't show > up in the test environment even in normal circumstances. > Have you actually had experience using this when Microsoft Transaction > Server wasn't switching the way it should and this resolved the issue? > > Thanks! > Jay > > -Original Message- > Sent: Friday, May 17, 2002 8:43 PM > To: Multiple recipients of list ORACLE-L > > > prod = (description= > (address_list= > (failover=ON) > (load_balance=OFF) > (address=...) <= points to primary db > (address=...) <= points to standby db > ) > (connect_data=(service_name=prod) > ) > ) > > The "ADDRESS_LIST=" stuff has worked since the 7.2 time-frame, though I > think the "FAILOVER=" and "LOAD_BALANCE=" syntax was added with 8.0; it was > just for failover functionality originally. Of course, the "SERVICE_NAME=" > stuff didn't happen until Oracle8i; before that it was "SID=" only... > > The key to the FAILOVER=ON functionality working correctly is the death of > the SQL*Net listener at the specified port, not the death of the database. > Make sure that when the database dies, the SQL*Net listener dies too. > Create a "sniper" process that monitors the database instance and > automatically stops the listener if necessary. Or, calls the UNIX "halt" > command... :-) Whatever works... > > Otherwise, if the database instance is dead but the SQL*Net listener is > still running, then this TNS syntax will timeout waiting for a connection > rather than just failing over to the next "ADDRESS=" entry... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, May 17, 2002 10:33 AM > > > > When we switch between production and standby databases our procedure is > to > > change the DNS Name to point to the new ip address. > > This works perfectly for all our old Powerbuilder client/server apps. > > > > However, our connections that go through Microsoft Transaction Server as a > > middle tier apparently continue to try and connect to the old database > until > > all the services are recycled or the NT boxes are rebooted. This > > unfortunately adds about a half hour to our downtime as well as requiring > > several more people to be present when we're doing the switch. > > > > Microsoft and Oracle are unanimous in saying it's the other one's fault. > > Our developers say there's no way of monitoring what's going on in MTS. > > > > To make matters more difficult we've been unable to replicate the problem > in > > our test environment. We have someone developing a loadrunner script now > in > > the hopes that a much higher load will cause the problem to show up. > There > > are several things (such as TAF) that we'd like to test to see if it helps > > but we can't do that until we can replicate the problem. > > > > So has anyone else seen this behaviour or (even better!) have a proven > > solution for it? > > > > Thanks, > > Jay Miller > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Miller, Jay > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > 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.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California
RE: Microsoft Transaction Server & Standby database problem
Thanks, We tried this syntax in our test environment and it worked very well but of course had no way of knowing if it solved our problem since that didn't show up in the test environment even in normal circumstances. Have you actually had experience using this when Microsoft Transaction Server wasn't switching the way it should and this resolved the issue? Thanks! Jay -Original Message- Sent: Friday, May 17, 2002 8:43 PM To: Multiple recipients of list ORACLE-L prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) <= points to primary db (address=...) <= points to standby db ) (connect_data=(service_name=prod) ) ) The "ADDRESS_LIST=" stuff has worked since the 7.2 time-frame, though I think the "FAILOVER=" and "LOAD_BALANCE=" syntax was added with 8.0; it was just for failover functionality originally. Of course, the "SERVICE_NAME=" stuff didn't happen until Oracle8i; before that it was "SID=" only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a "sniper" process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX "halt" command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next "ADDRESS=" entry... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 10:33 AM > When we switch between production and standby databases our procedure is to > change the DNS Name to point to the new ip address. > This works perfectly for all our old Powerbuilder client/server apps. > > However, our connections that go through Microsoft Transaction Server as a > middle tier apparently continue to try and connect to the old database until > all the services are recycled or the NT boxes are rebooted. This > unfortunately adds about a half hour to our downtime as well as requiring > several more people to be present when we're doing the switch. > > Microsoft and Oracle are unanimous in saying it's the other one's fault. > Our developers say there's no way of monitoring what's going on in MTS. > > To make matters more difficult we've been unable to replicate the problem in > our test environment. We have someone developing a loadrunner script now in > the hopes that a much higher load will cause the problem to show up. There > are several things (such as TAF) that we'd like to test to see if it helps > but we can't do that until we can replicate the problem. > > So has anyone else seen this behaviour or (even better!) have a proven > solution for it? > > Thanks, > Jay Miller > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re: Microsoft Transaction Server & Standby database problem
prod = (description= (address_list= (failover=ON) (load_balance=OFF) (address=...) <= points to primary db (address=...) <= points to standby db ) (connect_data=(service_name=prod) ) ) The "ADDRESS_LIST=" stuff has worked since the 7.2 time-frame, though I think the "FAILOVER=" and "LOAD_BALANCE=" syntax was added with 8.0; it was just for failover functionality originally. Of course, the "SERVICE_NAME=" stuff didn't happen until Oracle8i; before that it was "SID=" only... The key to the FAILOVER=ON functionality working correctly is the death of the SQL*Net listener at the specified port, not the death of the database. Make sure that when the database dies, the SQL*Net listener dies too. Create a "sniper" process that monitors the database instance and automatically stops the listener if necessary. Or, calls the UNIX "halt" command... :-) Whatever works... Otherwise, if the database instance is dead but the SQL*Net listener is still running, then this TNS syntax will timeout waiting for a connection rather than just failing over to the next "ADDRESS=" entry... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 10:33 AM > When we switch between production and standby databases our procedure is to > change the DNS Name to point to the new ip address. > This works perfectly for all our old Powerbuilder client/server apps. > > However, our connections that go through Microsoft Transaction Server as a > middle tier apparently continue to try and connect to the old database until > all the services are recycled or the NT boxes are rebooted. This > unfortunately adds about a half hour to our downtime as well as requiring > several more people to be present when we're doing the switch. > > Microsoft and Oracle are unanimous in saying it's the other one's fault. > Our developers say there's no way of monitoring what's going on in MTS. > > To make matters more difficult we've been unable to replicate the problem in > our test environment. We have someone developing a loadrunner script now in > the hopes that a much higher load will cause the problem to show up. There > are several things (such as TAF) that we'd like to test to see if it helps > but we can't do that until we can replicate the problem. > > So has anyone else seen this behaviour or (even better!) have a proven > solution for it? > > Thanks, > Jay Miller > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Microsoft Transaction Server & Standby database problem
When we switch between production and standby databases our procedure is to change the DNS Name to point to the new ip address. This works perfectly for all our old Powerbuilder client/server apps. However, our connections that go through Microsoft Transaction Server as a middle tier apparently continue to try and connect to the old database until all the services are recycled or the NT boxes are rebooted. This unfortunately adds about a half hour to our downtime as well as requiring several more people to be present when we're doing the switch. Microsoft and Oracle are unanimous in saying it's the other one's fault. Our developers say there's no way of monitoring what's going on in MTS. To make matters more difficult we've been unable to replicate the problem in our test environment. We have someone developing a loadrunner script now in the hopes that a much higher load will cause the problem to show up. There are several things (such as TAF) that we'd like to test to see if it helps but we can't do that until we can replicate the problem. So has anyone else seen this behaviour or (even better!) have a proven solution for it? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Quick one about Standby database
You can try. I use the XP as the primary and Win2000 as the standy database machine. It works fine. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Pablo - Usually you create the standby database by > copying all the data > files from the production system. Then it is an > identical system, so you can > apply the archive logs from production. With > different systems, you couldn't > copy the data files. I'm not even sure you could > move the archive logs over > and use them. I think you are blocked on this idea > unless someone that has > actually done this can explain how they accomplished > it. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, April 29, 2002 3:36 PM > To: Multiple recipients of list ORACLE-L > > > I've read that Oracle does not advise (or may be > support) to have a standby database on a plataform > different to the original one. > > I have a database on Solaris and I'd like to create > a > standby for this db over HP. > > Can that be done? I KNOW IT'S NOT SUPPORTED. > All I want to know is if anyone has tested it. > > > TIA > > > > ___ > Do You Yahoo!? > Yahoo! Messenger > Comunicación instantánea gratis con tu gente. > http://messenger.yahoo.es > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Pablo=20ksksksk?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Quick one about Standby database
Pablo - Usually you create the standby database by copying all the data files from the production system. Then it is an identical system, so you can apply the archive logs from production. With different systems, you couldn't copy the data files. I'm not even sure you could move the archive logs over and use them. I think you are blocked on this idea unless someone that has actually done this can explain how they accomplished it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 3:36 PM To: Multiple recipients of list ORACLE-L I've read that Oracle does not advise (or may be support) to have a standby database on a plataform different to the original one. I have a database on Solaris and I'd like to create a standby for this db over HP. Can that be done? I KNOW IT'S NOT SUPPORTED. All I want to know is if anyone has tested it. TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Quick one about Standby database
I've read that Oracle does not advise (or may be support) to have a standby database on a plataform different to the original one. I have a database on Solaris and I'd like to create a standby for this db over HP. Can that be done? I KNOW IT'S NOT SUPPORTED. All I want to know is if anyone has tested it. TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby Database-No space on Disk
If you are using a tempfile for tempoary tablespace on the primary, then you don't need this at all on the standby (whilst its recovering) hth connor --- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > > Hello All > Oracle 8.1.7, WINNT4. > On our standby Database box, we have run out of > space on the partition which > was holding the Temporary tablespace. Now the > problem is that when ever I > try to start the recovery, it gives the message that > there is no space on > the disk. > How would I add another datafile to the temporary > tablespace? Database is a > standby databse with the controlfile for the standby > database. Is there a > simple way to add a datafile to the tablespaces on a > standby database. Or > should I shutdown the database, move the datafile to > another partition, > repartition this old-temporary partition by adding > more space to it. And > then copy that temporary-datafile back to this old > partition and startup the > database for the Standby mode. > > Would appreciate any prompt suggestions. > Regards, > > Hussain Ahmed Qadri > Database Administrator > Shaukat Khanum Memorial Cancer Hospital & Research > Centre > [EMAIL PROTECTED] > www.shaukatkhanum.org.pk > > > = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Standby Database-No space on Disk
Title: Standby Database-No space on Disk Hello All Oracle 8.1.7, WINNT4. On our standby Database box, we have run out of space on the partition which was holding the Temporary tablespace. Now the problem is that when ever I try to start the recovery, it gives the message that there is no space on the disk. How would I add another datafile to the temporary tablespace? Database is a standby databse with the controlfile for the standby database. Is there a simple way to add a datafile to the tablespaces on a standby database. Or should I shutdown the database, move the datafile to another partition, repartition this old-temporary partition by adding more space to it. And then copy that temporary-datafile back to this old partition and startup the database for the Standby mode. Would appreciate any prompt suggestions. Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
Re: STANDBY DATABASE QUESTION?
thank you all... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 6:18 PM I will be in training the week of April 22nd to April 25th. I will respond to your e-mail when I return on April 26th. Don >>> ORACLE-L 04/19/02 09:48 >>> 1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: > > > Dear Gurus , > > I want to ask something .. > > I want to apply a standby server ,What I wonder is , if I set it up > automatic , is the archive log files automatically copied to standby > server , or do I move it manually . ??? > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so > big ? I know that it is because of SWAP . But I am sure that there must > not be swap since I have 8 GB ram and only 40 users use database for now. . > > . > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > > > The degree of normality in a database > is inversely proportional to that of its DBA. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Donald Bricker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: STANDBY DATABASE QUESTION?
I will be in training the week of April 22nd to April 25th. I will respond to your e-mail when I return on April 26th. Don >>> ORACLE-L 04/19/02 09:48 >>> 1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: > > > Dear Gurus , > > I want to ask something .. > > I want to apply a standby server ,What I wonder is , if I set it up > automatic , is the archive log files automatically copied to standby > server , or do I move it manually . ??? > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so > big ? I know that it is because of SWAP . But I am sure that there must > not be swap since I have 8 GB ram and only 40 users use database for now. . > > . > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > > > The degree of normality in a database > is inversely proportional to that of its DBA. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Donald Bricker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: STANDBY DATABASE QUESTION?
Arslan, not exactly managed mode applies the logs, you need to setup the primary init.ora to have the shipped from primary site to standby site. joe Arslan Bahar wrote: > yes , if you put in "maneged mode" , archived logs are copied and > applıed to standby site from master site. > > - Original Message - > > *From:* Bunyamin K. Karadeniz <mailto:[EMAIL PROTECTED]> > > *To:* Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > > *Sent:* Friday, April 19, 2002 12:03 PM > > *Subject:* STANDBY DATABASE QUESTION? > > > > > Dear Gurus , > > I want to ask something .. > > I want to apply a standby server ,What I wonder is , if I set it up > automatic , is the archive log files automatically copied to standby > server , or do I move it manually . ??? > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it > so big ? I know that it is because of SWAP . But I am sure that > there must not be swap since I have 8 GB ram and only 40 users use > database for now. . > > . > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > > > The degree of normality in a database > is inversely proportional to that of its DBA. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: STANDBY DATABASE QUESTION?
Vikas, you need to read the docs also, you can have the logs automatically shipped and applied to the standby database, it all depends on how you set it up. the docs are a wonderful thing. joe Vikas Khanna wrote: > > Original Message- > *From:* Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] > *Sent:* Friday, April 19, 2002 2:33 PM > *To:* Multiple recipients of list ORACLE-L > *Subject:* STANDBY DATABASE QUESTION? > > > > Dear Gurus , > > I want to ask something .. > > I want to apply a standby server ,What I wonder is , if I set it up > automatic , is the archive log files automatically copied to standby > server , or do I move it manually . ??? > [Vikas Khanna] You have do transfer them manually to the standy by > server. OR you can write automated scripts to do the job for you. > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it > so big ? I know that it is because of SWAP . But I am sure that > there must not be swap since I have 8 GB ram and only 40 users use > database for now. . > [Vikas Khanna] Its the max limit for the size of the file which > this OS support. Even if you might have 8 GB RAM what depends is > your SGA Size. > > . > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > > > The degree of normality in a database > is inversely proportional to that of its DBA. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: STANDBY DATABASE QUESTION?
1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: > > > Dear Gurus , > > I want to ask something .. > > I want to apply a standby server ,What I wonder is , if I set it up > automatic , is the archive log files automatically copied to standby > server , or do I move it manually . ??? > > > > And my second question is on my Win2000 Adv. Server C:\ drive , > PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so > big ? I know that it is because of SWAP . But I am sure that there must > not be swap since I have 8 GB ram and only 40 users use database for now. . > > . > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > > > The degree of normality in a database > is inversely proportional to that of its DBA. > -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: STANDBY DATABASE QUESTION?
>From 8.1, the primary node can automatically transfer the logs to the standby node. hth connor --- Vikas Khanna <[EMAIL PROTECTED]> wrote: > Original Message- > Sent: Friday, April 19, 2002 2:33 PM > To: Multiple recipients of list ORACLE-L > > > > Dear Gurus , > I want to ask something .. > I want to apply a standby server ,What I wonder is > , if I set it up > automatic , is the archive log files automatically > copied to standby server > , or do I move it manually . ??? > [Vikas Khanna] You have do transfer them manually to > the standy by server. > OR you can write automated scripts to do the job for > you. > > And my second question is on my Win2000 Adv. Server > C:\ drive , PAGEFILE.SYS > file is nearly 2 GB , AND does not increase , Why is > it so big ? I know that > it is because of SWAP . But I am sure that there > must not be swap since I > have 8 GB ram and only 40 users use database for > now. . > [Vikas Khanna] Its the max limit for the size of > the file which this OS > support. Even if you might have 8 GB RAM what > depends is your SGA Size. > . > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > The degree of normality in a database > is inversely proportional to that of its DBA. > > > = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: STANDBY DATABASE QUESTION?
Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ???[Vikas Khanna] You have do transfer them manually to the standy by server. OR you can write automated scripts to do the job for you. And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . [Vikas Khanna] Its the max limit for the size of the file which this OS support. Even if you might have 8 GB RAM what depends is your SGA Size. . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: STANDBY DATABASE QUESTION?
yes , if you put in "maneged mode" , archived logs are copied and applýed to standby site from master site. - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 12:03 PM Subject: STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
STANDBY DATABASE QUESTION?
Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
RE: standby database problem ???
I got this error when I first set up my standby database. If you generate a log switch, and then recover again you will not see the problem. If I recall correctly, the issue arises when the redo log that was active when you created your standby control file has not been archived. If you issue a log switch the log will be archived, and your standby database will recover without errors. Steve McClure -Original Message- Sent: Tuesday, April 09, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORA_9I\ORADATA\SB1\DATAFILE\SYSTEM01.DBF' ORA-16016: archived log for thread 1 sequence# 7 unavailable I backed up the primary database when the archive was not on. I shutdown the db using shutdown immediate, and made a complete, cold back, I changed the primary database to archive log right after backup. Why the backup is not sufficient? Must the db in archivelog mode before making a backup? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ADD datafile to standby database
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbym.htm#27175 Brian P. MacLean Oracle DBA, OCP8i Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: ADD datafile to standby database om 04/10/02 01:33 PM Please respond to ORACLE-L Hi all, I am somewhat new to standby databases and I need to add a datafile. What exactly do I need to do or point me to some sources that clearly explains this. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
ADD datafile to standby database
Hi all, I am somewhat new to standby databases and I need to add a datafile. What exactly do I need to do or point me to some sources that clearly explains this. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: standby database problem ???
Janet, I have found that on NT a shutdown immediate can still lead to recovery being required when the database is started back up. That is, maybe you didn't really have a consistent cold backup of your primary. I have instead opted for a shutdown immediate, startup, shutdown normal sequence to ensure the database is consistent. Have a look at the alert log of your primary and see if when you started it back up after the "cold" backup it contained a line like "alter database open Beginning crash recovery of 1 threads" That is, did a crash recovery follow the database being opened. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 10 April 2002 12:58 Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORA_9I\ORADATA\SB1\DATAFILE\SYSTEM01.DBF' ORA-16016: archived log for thread 1 sequence# 7 unavailable I backed up the primary database when the archive was not on. I shutdown the db using shutdown immediate, and made a complete, cold back, I changed the primary database to archive log right after backup. Why the backup is not sufficient? Must the db in archivelog mode before making a backup? Thank you! Janet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
standby database problem ???
Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORA_9I\ORADATA\SB1\DATAFILE\SYSTEM01.DBF' ORA-16016: archived log for thread 1 sequence# 7 unavailable I backed up the primary database when the archive was not on. I shutdown the db using shutdown immediate, and made a complete, cold back, I changed the primary database to archive log right after backup. Why the backup is not sufficient? Must the db in archivelog mode before making a backup? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: License standby database?
Title: RE: RE: License standby database? That's what I was told 2 years ago. But as we have seen, Oracle has an 'evolving' licensing standard. Or was that 'revolving'? Jon -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: License standby database? That's new policy. Last time I talked to Oracle about it (a while ago, I admit) it was "if you aren't using it and the server is not accessible, then you don't need a license" --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > Not sure this is correct Rachel. I sat in a conference call today > with some > folks and an Oracle rep and it was stated that any type of HA > software being > used would require additional licenses for the all possible servers > in the > failover cluster. So even if Oracle is not running on server B until > A > fails I would need a license for B. Of course the whole reason for > the call > was to discuss Oracles "evolving" licensing model. Can anyone else > confirm > or deny? > > - Ethan > > -Original Message- > Sent: Tuesday, April 02, 2002 12:38 PM > To: Multiple recipients of list ORACLE-L > > > yep... but it's because the database is being used, even if you don't > use it for read-only the fact that the executables are running > and > the database is mounted is why you need the license. > > Now, if you have a copy of all the files, and the executables on > another machine, but DON'T run anything, THEN you don't need another > license > > > --- [EMAIL PROTECTED] wrote: > > Jon, > > > > Wrong. You must license the second server identically to the > > original. The > > reason is that a standby database can be used as a read only copy > of > > the > > original. > > > > Dick Goulet > > > > Reply Separator > > Author: Jon Baker <[EMAIL PROTECTED]> > > Date: 4/2/2002 8:03 AM > > > > I believe as long as it is only stand-by, no additional licensing > > required. > > Only one system is "functional" at a time. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > > 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! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: RE: License standby database?
We just ran the licensing gauntlett with Oracle ourselves. Our sales rep made it quite clear that if we installed the binaries we had to license it. This in response to my manager trying all concievable options to avoid licensing our standby database. I am not sure the standby has to be licensed exactly the same as the production DB, but it is no longer free. My thought is that Oracle tried for a few years to compete price wise with MS, and probably feel that decision has cost them more money than it earned them. So they are making up for lost time, and charging like they have the best product on the market. From one extreme to another. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: License standby database?
Yep, HA means High Avalability, but usually used from a server's perspective, more than just Oracle. The issue here is Oracle licensing, standy=2 databases running (aka Oracle HA), hence additional oracle licenses. Server HA (HP MC Serviceguard, IBM HACMP, SunCluster, etc.)=1 database running shared between 2 servers with common storage but Oracle active on 1, hence no additional oracle license. Gene >>> [EMAIL PROTECTED] 04/03/02 11:38AM >>> Gene, HA means High Avalability. >>HA is a DB Server waiting to become the prod DB via >> shared storage, Not really. You can implement HA by any means as long as you ensure you have "High Availability". IMHO standby is also something that is waiting to be activated and "to become prod server". Actually standby is normally a better HA because shared disks would not protect you from disks "going south". The point under discussion here, since you have missed it, is whether standby could be considered oracle "running" on standby host. ORACLE reps went on record saying that you con not since the oracle "running" on other server is in managed recovery mode. HTH Cheers, RS --- Gene Sais <[EMAIL PROTECTED]> wrote: > HA is different from Standby. Standby is an Oracle > DB in recovery, i.e. Oracle running on 2 servers. > HA is a DB Server waiting to become the prod DB via > shared storage, i.e. Oracle running on 1 server. > > >>> [EMAIL PROTECTED] 04/03/02 09:28AM >>> > Yea...I vaguely remember something like that being > said to our company back in 2000. I spoke to couple > of > Oracle Reps and they said as long as you are using > the > DB for HA environment you don't need to license it > separately. I don't know whats going on now. > > Cheers, > RS > --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > > Not sure this is correct Rachel. I sat in a > > conference call today with some > > folks and an Oracle rep and it was stated that any > > type of HA software being > > used would require additional licenses for the all > > possible servers in the > > failover cluster. So even if Oracle is not > running > > on server B until A > > fails I would need a license for B. Of course the > > whole reason for the call > > was to discuss Oracles "evolving" licensing model. > > > Can anyone else confirm > > or deny? > > > > - Ethan > > > > -Original Message- > > Sent: Tuesday, April 02, 2002 12:38 PM > > To: Multiple recipients of list ORACLE-L > > > > > > yep... but it's because the database is being > used, > > even if you don't > > use it for read-only the fact that the > > executables are running and > > the database is mounted is why you need the > license. > > > > Now, if you have a copy of all the files, and the > > executables on > > another machine, but DON'T run anything, THEN you > > don't need another > > license > > > > > > --- [EMAIL PROTECTED] wrote: > > > Jon, > > > > > > Wrong. You must license the second server > > identically to the > > > original. The > > > reason is that a standby database can be used as > a > > read only copy of > > > the > > > original. > > > > > > Dick Goulet > > > > > > Reply > > Separator > > > Author: Jon Baker <[EMAIL PROTECTED]> > > > Date: 4/2/2002 8:03 AM > > > > > > I believe as long as it is only stand-by, no > > additional licensing > > > required. > > > Only one system is "functional" at a time. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Post, Ethan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > 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: RE: License standby database?
Gene, HA means High Avalability. >>HA is a DB Server waiting to become the prod DB via >> shared storage, Not really. You can implement HA by any means as long as you ensure you have "High Availability". IMHO standby is also something that is waiting to be activated and "to become prod server". Actually standby is normally a better HA because shared disks would not protect you from disks "going south". The point under discussion here, since you have missed it, is whether standby could be considered oracle "running" on standby host. ORACLE reps went on record saying that you con not since the oracle "running" on other server is in managed recovery mode. HTH Cheers, RS --- Gene Sais <[EMAIL PROTECTED]> wrote: > HA is different from Standby. Standby is an Oracle > DB in recovery, i.e. Oracle running on 2 servers. > HA is a DB Server waiting to become the prod DB via > shared storage, i.e. Oracle running on 1 server. > > >>> [EMAIL PROTECTED] 04/03/02 09:28AM >>> > Yea...I vaguely remember something like that being > said to our company back in 2000. I spoke to couple > of > Oracle Reps and they said as long as you are using > the > DB for HA environment you don't need to license it > separately. I don't know whats going on now. > > Cheers, > RS > --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > > Not sure this is correct Rachel. I sat in a > > conference call today with some > > folks and an Oracle rep and it was stated that any > > type of HA software being > > used would require additional licenses for the all > > possible servers in the > > failover cluster. So even if Oracle is not > running > > on server B until A > > fails I would need a license for B. Of course the > > whole reason for the call > > was to discuss Oracles "evolving" licensing model. > > > Can anyone else confirm > > or deny? > > > > - Ethan > > > > -Original Message- > > Sent: Tuesday, April 02, 2002 12:38 PM > > To: Multiple recipients of list ORACLE-L > > > > > > yep... but it's because the database is being > used, > > even if you don't > > use it for read-only the fact that the > > executables are running and > > the database is mounted is why you need the > license. > > > > Now, if you have a copy of all the files, and the > > executables on > > another machine, but DON'T run anything, THEN you > > don't need another > > license > > > > > > --- [EMAIL PROTECTED] wrote: > > > Jon, > > > > > > Wrong. You must license the second server > > identically to the > > > original. The > > > reason is that a standby database can be used as > a > > read only copy of > > > the > > > original. > > > > > > Dick Goulet > > > > > > Reply > > Separator > > > Author: Jon Baker <[EMAIL PROTECTED]> > > > Date: 4/2/2002 8:03 AM > > > > > > I believe as long as it is only stand-by, no > > additional licensing > > > required. > > > Only one system is "functional" at a time. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Post, Ethan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > 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! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sakthi , Raj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > -
RE: RE: License standby database?
HA is different from Standby. Standby is an Oracle DB in recovery, i.e. Oracle running on 2 servers. HA is a DB Server waiting to become the prod DB via shared storage, i.e. Oracle running on 1 server. >>> [EMAIL PROTECTED] 04/03/02 09:28AM >>> Yea...I vaguely remember something like that being said to our company back in 2000. I spoke to couple of Oracle Reps and they said as long as you are using the DB for HA environment you don't need to license it separately. I don't know whats going on now. Cheers, RS --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > Not sure this is correct Rachel. I sat in a > conference call today with some > folks and an Oracle rep and it was stated that any > type of HA software being > used would require additional licenses for the all > possible servers in the > failover cluster. So even if Oracle is not running > on server B until A > fails I would need a license for B. Of course the > whole reason for the call > was to discuss Oracles "evolving" licensing model. > Can anyone else confirm > or deny? > > - Ethan > > -Original Message- > Sent: Tuesday, April 02, 2002 12:38 PM > To: Multiple recipients of list ORACLE-L > > > yep... but it's because the database is being used, > even if you don't > use it for read-only the fact that the > executables are running and > the database is mounted is why you need the license. > > Now, if you have a copy of all the files, and the > executables on > another machine, but DON'T run anything, THEN you > don't need another > license > > > --- [EMAIL PROTECTED] wrote: > > Jon, > > > > Wrong. You must license the second server > identically to the > > original. The > > reason is that a standby database can be used as a > read only copy of > > the > > original. > > > > Dick Goulet > > > > Reply > Separator > > Author: Jon Baker <[EMAIL PROTECTED]> > > Date: 4/2/2002 8:03 AM > > > > I believe as long as it is only stand-by, no > additional licensing > > required. > > Only one system is "functional" at a time. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Post, Ethan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: License standby database?
Yea...I vaguely remember something like that being said to our company back in 2000. I spoke to couple of Oracle Reps and they said as long as you are using the DB for HA environment you don't need to license it separately. I don't know whats going on now. Cheers, RS --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > Not sure this is correct Rachel. I sat in a > conference call today with some > folks and an Oracle rep and it was stated that any > type of HA software being > used would require additional licenses for the all > possible servers in the > failover cluster. So even if Oracle is not running > on server B until A > fails I would need a license for B. Of course the > whole reason for the call > was to discuss Oracles "evolving" licensing model. > Can anyone else confirm > or deny? > > - Ethan > > -Original Message- > Sent: Tuesday, April 02, 2002 12:38 PM > To: Multiple recipients of list ORACLE-L > > > yep... but it's because the database is being used, > even if you don't > use it for read-only the fact that the > executables are running and > the database is mounted is why you need the license. > > Now, if you have a copy of all the files, and the > executables on > another machine, but DON'T run anything, THEN you > don't need another > license > > > --- [EMAIL PROTECTED] wrote: > > Jon, > > > > Wrong. You must license the second server > identically to the > > original. The > > reason is that a standby database can be used as a > read only copy of > > the > > original. > > > > Dick Goulet > > > > Reply > Separator > > Author: Jon Baker <[EMAIL PROTECTED]> > > Date: 4/2/2002 8:03 AM > > > > I believe as long as it is only stand-by, no > additional licensing > > required. > > Only one system is "functional" at a time. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Post, Ethan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: License standby database?
That's new policy. Last time I talked to Oracle about it (a while ago, I admit) it was "if you aren't using it and the server is not accessible, then you don't need a license" --- "Post, Ethan" <[EMAIL PROTECTED]> wrote: > Not sure this is correct Rachel. I sat in a conference call today > with some > folks and an Oracle rep and it was stated that any type of HA > software being > used would require additional licenses for the all possible servers > in the > failover cluster. So even if Oracle is not running on server B until > A > fails I would need a license for B. Of course the whole reason for > the call > was to discuss Oracles "evolving" licensing model. Can anyone else > confirm > or deny? > > - Ethan > > -Original Message- > Sent: Tuesday, April 02, 2002 12:38 PM > To: Multiple recipients of list ORACLE-L > > > yep... but it's because the database is being used, even if you don't > use it for read-only the fact that the executables are running > and > the database is mounted is why you need the license. > > Now, if you have a copy of all the files, and the executables on > another machine, but DON'T run anything, THEN you don't need another > license > > > --- [EMAIL PROTECTED] wrote: > > Jon, > > > > Wrong. You must license the second server identically to the > > original. The > > reason is that a standby database can be used as a read only copy > of > > the > > original. > > > > Dick Goulet > > > > Reply Separator > > Author: Jon Baker <[EMAIL PROTECTED]> > > Date: 4/2/2002 8:03 AM > > > > I believe as long as it is only stand-by, no additional licensing > > required. > > Only one system is "functional" at a time. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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:RE: RE: License standby database?
Dennis, You've hit on the three constants of life, death, taxes, and Oracle's bill. Actually I think the last causes the first. Dick Goulet Reply Separator Author: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 4/2/2002 12:33 PM Thanks to Rachel, Dick, Jon, and everyone for clarifying this issue. The answer falls into a disturbing pattern I'm seeing in Oracle licensing -- lots of confusion, conflicting opinions, and in the end a large invoice from Oracle. I participated in a META Group teleconference this morning. A number of press reporters participated also, so you will probably be seeing press releases over the next few days. META offered pretty good proof that Oracle is interpreting the named licensing to be that if your data warehouse is being loaded with data from another system that has 200 users, then your data warehouse needs that many named user licenses. -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: > Jon, > > Wrong. You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > original. > > Dick Goulet > > Reply Separator > Author: Jon Baker <[EMAIL PROTECTED]> > Date: 4/2/2002 8:03 AM > > I believe as long as it is only stand-by, no additional licensing > required. > Only one system is "functional" at a time. > > > Jon > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, April 02, 2002 10:28 AM > To: Multiple recipients of list ORACLE-L > > > Can someone tell me - if you have a standby database, must you carry > a full > Oracle license on it? Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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: License standby database? > > > > I believe as long as it is only stand-by, no > additional > licensing required. Only one system is "functional" > at a > time. > > > > Jon > [EMAIL PROTECTED] > > > -Original Message- > From: DENNIS WILLIAMS [ HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 10:28 AM > To: Multiple recipients of list ORACLE-L > Subject: License standby database? > > > > Can someone tell me - if you have a standby database, > must you > carry a full > Oracle license on it? Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: HREF="http://www.orafaq.com"; > TARGET="_blank">http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > > Fat City Network Services -- (858) > 538-5051 FAX: (858) 538-5051 > San Diego, > California > -- Public Internet access / Mailing Lists > SIZE=2>< /FON > T> > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-
RE: RE: License standby database?
Not sure this is correct Rachel. I sat in a conference call today with some folks and an Oracle rep and it was stated that any type of HA software being used would require additional licenses for the all possible servers in the failover cluster. So even if Oracle is not running on server B until A fails I would need a license for B. Of course the whole reason for the call was to discuss Oracles "evolving" licensing model. Can anyone else confirm or deny? - Ethan -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: > Jon, > > Wrong. You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > original. > > Dick Goulet > > Reply Separator > Author: Jon Baker <[EMAIL PROTECTED]> > Date: 4/2/2002 8:03 AM > > I believe as long as it is only stand-by, no additional licensing > required. > Only one system is "functional" at a time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: License standby database?
Thanks to Rachel, Dick, Jon, and everyone for clarifying this issue. The answer falls into a disturbing pattern I'm seeing in Oracle licensing -- lots of confusion, conflicting opinions, and in the end a large invoice from Oracle. I participated in a META Group teleconference this morning. A number of press reporters participated also, so you will probably be seeing press releases over the next few days. META offered pretty good proof that Oracle is interpreting the named licensing to be that if your data warehouse is being loaded with data from another system that has 200 users, then your data warehouse needs that many named user licenses. -Original Message- Sent: Tuesday, April 02, 2002 12:38 PM To: Multiple recipients of list ORACLE-L yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: > Jon, > > Wrong. You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > original. > > Dick Goulet > > Reply Separator > Author: Jon Baker <[EMAIL PROTECTED]> > Date: 4/2/2002 8:03 AM > > I believe as long as it is only stand-by, no additional licensing > required. > Only one system is "functional" at a time. > > > Jon > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, April 02, 2002 10:28 AM > To: Multiple recipients of list ORACLE-L > > > Can someone tell me - if you have a standby database, must you carry > a full > Oracle license on it? Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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: License standby database? > > > > I believe as long as it is only stand-by, no > additional > licensing required. Only one system is "functional" > at a > time. > > > > Jon > [EMAIL PROTECTED] > > > -Original Message- > From: DENNIS WILLIAMS [ HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 10:28 AM > To: Multiple recipients of list ORACLE-L > Subject: License standby database? > > > > Can someone tell me - if you have a standby database, > must you > carry a full > Oracle license on it? Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: HREF="http://www.orafaq.com"; > TARGET="_blank">http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > > Fat City Network Services -- (858) > 538-5051 FAX: (858) 538-5051 > San Diego, > California > -- Public Internet access / Mailing Lists > SIZE=2>< /FON > T> > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (not
Re:RE: License standby database?
yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anything, THEN you don't need another license --- [EMAIL PROTECTED] wrote: > Jon, > > Wrong. You must license the second server identically to the > original. The > reason is that a standby database can be used as a read only copy of > the > original. > > Dick Goulet > > Reply Separator > Author: Jon Baker <[EMAIL PROTECTED]> > Date: 4/2/2002 8:03 AM > > I believe as long as it is only stand-by, no additional licensing > required. > Only one system is "functional" at a time. > > > Jon > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, April 02, 2002 10:28 AM > To: Multiple recipients of list ORACLE-L > > > Can someone tell me - if you have a standby database, must you carry > a full > Oracle license on it? Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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: License standby database? > > > > I believe as long as it is only stand-by, no > additional > licensing required. Only one system is "functional" > at a > time. > > > > Jon > [EMAIL PROTECTED] > > > -Original Message- > From: DENNIS WILLIAMS [ HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 10:28 AM > To: Multiple recipients of list ORACLE-L > Subject: License standby database? > > > > Can someone tell me - if you have a standby database, > must you > carry a full > Oracle license on it? Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: HREF="http://www.orafaq.com"; > TARGET="_blank">http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > > Fat City Network Services -- (858) > 538-5051 FAX: (858) 538-5051 > San Diego, > California > -- Public Internet access / Mailing Lists > SIZE=2> T> > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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:RE: License standby database?
Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker <[EMAIL PROTECTED]> Date: 4/2/2002 8:03 AM I believe as long as it is only stand-by, no additional licensing required. Only one system is "functional" at a time. Jon [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: License standby database? I believe as long as it is only stand-by, no additional licensing required. Only one system is "functional" at a time. Jon [EMAIL PROTECTED] -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: License standby database? Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com"; TARGET="_blank">http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: License standby database?
Title: RE: License standby database? I believe as long as it is only stand-by, no additional licensing required. Only one system is "functional" at a time. Jon [EMAIL PROTECTED] -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: License standby database? Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
License standby database?
Can someone tell me - if you have a standby database, must you carry a full Oracle license on it? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby Database Problem
Title: Standby Database Problem Hussain, As long as none of your datafiles were corrupted by what I assume was the crash of your Standby Instance, you can reinstall 8i and bring up the Standby just as you describe. The datafiles don't care at all where Oracle Home is. I recently had to reconfigure our Production and Standby database servers to add a global hot spare drive to each. Because of that I had to reinstall 8i and moved Oracle Home on both of them. However, 90% of the datafiles stayed just like they were - a few had to move to a new drive. Both DBs came up just fine and I'm now back in Managed Standby mode. Of course your Listener.ora will have to reference the new Oracle Home, but since you're reinstalling 8i, I'm guessing you'll create a Listener from scratch anyway. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hussain Ahmed QadriSent: Tuesday, March 19, 2002 12:13 AMTo: Multiple recipients of list ORACLE-LSubject: Standby Database Problem Hi While trying to install developer6 on our standby database test server (OS NT4, Oracle 8.1.7), I have some how corrupted the 8i, and hence the standby database is not working. Its actually the Oracle Suite tools which are not working. I am going to configure it again, that is install the Oracle8i again. But what I want to know is that do I have to copy the datafiles from the main server again and recreate the control file. Or just reinstall the oracle database, copy the archive redologs, which are missing, apply them and then mount the standby database in recover managed mode with the existing Datafile copies? The reason I am asking this is that the configuration of database is not changed nor the database has been brought from standby to active mode, just registry entries have been changed/deleted becuase of selecting a different home for Developer6 (Thats another problem that after installing Oracle 8i, when u want to install Dev6,it doesn't allow installation in the same Oracle home and neither in a separate home, but if you try it again in a separate home, like I did, it removes the entries of first Oracle home, so no Oracle 8i! ) So in such case WHAT happens to the STAND BY Database??? Looking forward to your replies Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
Standby Database Problem
Title: Standby Database Problem Hi While trying to install developer6 on our standby database test server (OS NT4, Oracle 8.1.7), I have some how corrupted the 8i, and hence the standby database is not working. Its actually the Oracle Suite tools which are not working. I am going to configure it again, that is install the Oracle8i again. But what I want to know is that do I have to copy the datafiles from the main server again and recreate the control file. Or just reinstall the oracle database, copy the archive redologs, which are missing, apply them and then mount the standby database in recover managed mode with the existing Datafile copies? The reason I am asking this is that the configuration of database is not changed nor the database has been brought from standby to active mode, just registry entries have been changed/deleted becuase of selecting a different home for Developer6 (Thats another problem that after installing Oracle 8i, when u want to install Dev6,it doesn't allow installation in the same Oracle home and neither in a separate home, but if you try it again in a separate home, like I did, it removes the entries of first Oracle home, so no Oracle 8i! ) So in such case WHAT happens to the STAND BY Database??? Looking forward to your replies Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
Re: Automated Standby Database tool for Unix & Linux
And how is this different from OEM data guard manager/broker? joe James Forgy wrote: > March 5, 2002: > Relational Database Consultants, Inc. (RDC) - Proudly > announces the release of the Standby Wizard For Unix & > Linux. The Standby Wizard is a GUI interface that > automates the creation, maintenance, and fail-over > functions of Oracle's standby database paradigm. With > the Standby Wizard you can create an unlimited number > of exact duplicate databases from your production > database. The Standby Wizard also makes a great QA > and testing tool with its ability to duplicate even > the most complex of databases in only a few minutes. > 30-Day evaluations are available for download at: > > http://www.relationalwizards.com/html/standby_database_download.html > > > __ > Do You Yahoo!? > Try FREE Yahoo! Mail - the world's greatest free email! > http://mail.yahoo.com/ > -- Joe Testa, Oracle DBA Nothing new to put here, hmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Automated Standby Database tool for Unix & Linux
March 5, 2002: Relational Database Consultants, Inc. (RDC) - Proudly announces the release of the Standby Wizard For Unix & Linux. The Standby Wizard is a GUI interface that automates the creation, maintenance, and fail-over functions of Oracle's standby database paradigm. With the Standby Wizard you can create an unlimited number of exact duplicate databases from your production database. The Standby Wizard also makes a great QA and testing tool with its ability to duplicate even the most complex of databases in only a few minutes. 30-Day evaluations are available for download at: http://www.relationalwizards.com/html/standby_database_download.html __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Forgy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem with standby database & listener
Could it be that the standby is auto-registering itself with the listener for the production database? We've had a couple of incidents where a development DBA copied the init.ora file from a production database configured for MTS. But the listener parameters were not changed and all new connections were redirected to the development database. I suspect that the standby is auto-registering itself with the listener and bumping of production. Bouncing the production server then does it back to the standby. HTH Tony Aponte -Original Message-From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 21, 2002 3:59 PMTo: Multiple recipients of list ORACLE-LSubject: Problem with standby database & listener Fellow dba's, We have come across a weird problem with a standby database. Every time we issue "alter database mount standby database" on the standby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted of course this can is not an acceptable solution since the standby will be opened every week for reporting. Anyone experience this before? Any direction would be appreciated. Thanks Stephen AndertScottsdale, Arizona
RE: Problem with standby database & listener
I have 8.1.7.0 on Solaris 8 and also had this problem. Somehow the way I get around this is to go back to the Primary db and reset the log_archive_dest_2 to whatever the identifier of the standby db is. (even if the log_archive_dest_2 is already set). Then I do the standby recovery, then managed recovery. This probably explains why yours work after you bounce your Primary db. You must have the standby db location set in the init.ora file. What I do, however, is force a reset of the standby db location after I startup the standby db. This way I don't have to bounce my Primary db. Everything's scripted. Clear as mud? HTH. Ross -Original Message- Sent: Friday, 22 February 2002 7:59 To: Multiple recipients of list ORACLE-L Fellow dba's, We have come across a weird problem with a standby database. Every time we issue "alter database mount standby database" on the standby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted of course this can is not an acceptable solution since the standby will be opened every week for reporting. Anyone experience this before? Any direction would be appreciated. Thanks Stephen Andert Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Problem with standby database & listener
Fellow dba's, We have come across a weird problem with a standby database. Every time we issue "alter database mount standby database" on the standby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted — of course this can is not an acceptable solution since the standby will be opened every week for reporting. Anyone experience this before? Any direction would be appreciated. Thanks Stephen AndertScottsdale, Arizona
How to find current mode of standby database
Which dynamic performance view can provide me information whether a standby database (mounted) is in a) managed recovery mode or b) manual recovery mode or c) just mounted. Thanks. Anand Prakash
RE: Standby database question
On Mon, 28 Jan 2002, Molina, Gerardo wrote: > The status of the data file (on the standby database) shows > "RECOVER" unless the standby control file is refreshed. This status makes no difference in recovering/opening/using the standby. I believe the assertion in the doc is incorrect. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > Sent: Monday, January 28, 2002 2:25 PM > To: Multiple recipients of list ORACLE-L > > According to the "Oracle8i Standby Database Concepts and Administration > Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD). > > Page 4-15 Refreshing the Standby Database Control File > > The following steps describe how to refresh, or create a copy, of changes > you have made to the primary database control file. Refresh the standby > database control file after making major structural changes to the primary > database, such as adding or dropping files. > > (Then the steps for refreshing the control file are given). > > Let me know if this is not the case. > > One thing we've noticed is that the status (from v$datafile) of the added > data file shows "RECOVER" unless standby control file is not refreshed. > > -Original Message- > Sent: Friday, January 25, 2002 2:00 PM > To: Multiple recipients of list ORACLE-L > > On Fri, 25 Jan 2002, Molina, Gerardo wrote: > > > There is one last, but important step. > > > > You need to recreate standby control file... > > Why do you have to do that? It doesn't say to do that in the > documentation. The new datafiles are reflected in the standby > controlfile through normal recovery and by issuing the 'alter database > create datafile' command. > > There is no need to re-dump and copy a new standby controlfile, and > definitely no need to shut any database down. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby database question
Please pardon my poor grammar. I should have said... The status of the data file (on the standby database) shows "RECOVER" unless the standby control file is refreshed. Thanks, Gerardo -Original Message- Sent: Monday, January 28, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Jeremiah, According to the "Oracle8i Standby Database Concepts and Administration Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD). Page 4-15 Refreshing the Standby Database Control File The following steps describe how to refresh, or create a copy, of changes you have made to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -Original Message- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -Original Message- > Sent: Friday, January 25, 2002 12:01 PM > To: Multiple recipients of list ORACLE-L > > > On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > > > One of the co-workers has a hot standby database. Logs are applied > > at some interval. He has to add a tablespace. What is necessay to > > make standby database aware of this? > > This is clearly documented in the Oracle8i Standby Database Concepts > and Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538
RE: Standby database question
Jeremiah, According to the "Oracle8i Standby Database Concepts and Administration Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD). Page 4-15 Refreshing the Standby Database Control File The following steps describe how to refresh, or create a copy, of changes you have made to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -Original Message- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -Original Message- > Sent: Friday, January 25, 2002 12:01 PM > To: Multiple recipients of list ORACLE-L > > > On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > > > One of the co-workers has a hot standby database. Logs are applied > > at some interval. He has to add a tablespace. What is necessay to > > make standby database aware of this? > > This is clearly documented in the Oracle8i Standby Database Concepts > and Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby database question
On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -Original Message- > Sent: Friday, January 25, 2002 12:01 PM > To: Multiple recipients of list ORACLE-L > > > On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > > > One of the co-workers has a hot standby database. Logs are applied > > at some interval. He has to add a tablespace. What is necessay to > > make standby database aware of this? > > This is clearly documented in the Oracle8i Standby Database Concepts > and Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby database question
There is one last, but important step. You need to recreate standby control file... on primary: alter database create standby controlfile as ''; ftp this new file to standby on standby: shutdown immediate copy new control file to appropriate locations with correct file name. startup nomount alter database mount standby database HTH, Gerardo -Original Message- Sent: Friday, January 25, 2002 12:01 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > One of the co-workers has a hot standby database. Logs are applied > at some interval. He has to add a tablespace. What is necessay to > make standby database aware of this? This is clearly documented in the Oracle8i Standby Database Concepts and Administration Manual. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76995/standbys.htm#27363 In short, you just add the tablespace to the primary, wait for the standby to fail with ORA-01157, then issue the following command on the standby: SQL> alter database create datafile '' as ''; Where foo is the location of the datafile on the primary, and bar is the location on the standby (usually the same). If you create a tablespace with several datafiles, you will have to issue this command a few times after recovering the standby and waiting for the ORA-01157 each time. Don't fall into the trap some people do where they think they have to copy the new file over to the standby every time they create a datafile. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby database question
On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > One of the co-workers has a hot standby database. Logs are applied > at some interval. He has to add a tablespace. What is necessay to > make standby database aware of this? This is clearly documented in the Oracle8i Standby Database Concepts and Administration Manual. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbys.htm#27363 In short, you just add the tablespace to the primary, wait for the standby to fail with ORA-01157, then issue the following command on the standby: SQL> alter database create datafile '' as ''; Where foo is the location of the datafile on the primary, and bar is the location on the standby (usually the same). If you create a tablespace with several datafiles, you will have to issue this command a few times after recovering the standby and waiting for the ORA-01157 each time. Don't fall into the trap some people do where they think they have to copy the new file over to the standby every time they create a datafile. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Standby database question
Hi DBAs, One of the co-workers has a hot standby database. Logs are applied at some interval. He has to add a tablespace. What is necessay to make standby database aware of this? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Standby database foible
Allright listers, I have been experimenting with creating a standby database for our production server. After moving all the required files files, configuring the init files, and initiating recovery on the standby instance, I saw the following error. 01547:warning RECOVER succeeded but OPEN RESETLOGS would get error below. 01152:file 1 was not restored from a sufficiently old backup So apparently I mucked up my SYSTEM tablespace somehow in the interim. Here are the steps I followed. I am curious where I went wrong. I twice started to bring up the standby database. both times I was able to issue 'startup nomount'. The first time I attempted to mount the standby database I was greeted with a message that the control file I was pointing to was not a standby control file. I had used the control file from my hot backup, instead of following my instructions. So shutdown the DB 'shutdown normal', and created a standby control file, copied it to the three control file locations on my standby box, and started again. 'startup nomount' went as expected, then I mounted the DB in stanby mode, and then issued the recover command. Upon this completing, I was greeted with the warning I quoted above. In writing this I am pretty sure that I screwed myself up by issuing a 'shutdown normal' after my first mount attempt failed, but I figured I would go ahead and send this off to the list anyway. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby Database - Log Shipping
Ron, There is an excellent paper on how to set it up step-by-step for managed recovery (logs applied automatically) on metalink. I like to follow these to start with and read the manual for details. They are 149286.1, 97010.1, 120855.1, 67488.1 etc. to start with. Also consieder dataguard I am testing it as of now and looks good so far. HTH "Smith, Ron L." wrote: > Does anyone know where I can find a paper on how to set up a standby > database? I am talking > about a database that is always in recovery mode and archive logs are > applied throughout the > day to keep it up to date. > > Thanks! > Ron Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
Re: Standby Database - Log Shipping
check out metalink and search for anything by Lawrence To he's in Oracle's Center for Expertise and he concentrates on standby. his papers are fantastic -- he's my idol :) --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > Does anyone know where I can find a paper on how to set up a standby > database? I am talking > about a database that is always in recovery mode and archive logs are > applied throughout the > day to keep it up to date. > > Thanks! > Ron Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > 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!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Standby Database - Log Shipping
Lawrence To has a couple. I believe I got both of them from metalink Oracle8i Standby Database (try 76451.1 Graceful Switchover and Switchback HTH Barb > -- > From: Smith, Ron L.[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Wednesday, December 12, 2001 9:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Database - Log Shipping > > Does anyone know where I can find a paper on how to set up a standby > database? I am talking > about a database that is always in recovery mode and archive logs are > applied throughout the > day to keep it up to date. > > Thanks! > Ron Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
