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).