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 : quote 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 /quote 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 : quote 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 /quote 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 ?
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).
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 : quote 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 /quote 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 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: 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).
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.
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.
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.
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] wisernet100@cc: yahoo.com 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 the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
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).
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.
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 todo 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?
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?
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?
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?
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 appled 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?
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?
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 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: 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. Irecently 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 Homeon 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
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
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 'file_name'; 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 'foo' as 'bar'; 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
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 'file_name'; 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 'foo' as 'bar'; 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-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
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 'foo' as 'bar'; 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).
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 'file_name'; 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 'foo' as 'bar'; 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 - Log Shipping
Metalink Note : 120855.1 Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 12 December 2001 16:16 To: Multiple recipients of list ORACLE-L 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
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
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
Kay, thanks for the explanation. Sorry for being a pain in butt. But I see that the C program will write IMMEDIATELY AS SOON AS the log is written. But this is not the same as doing it simultaneously. So there is a chance (very very small of course) that after LGWR writes the committed transaction and before your C program copies the block which contains the change vector that the system crash and online redo is lost. Therefore you can guarantee 99.99% but not 100%? Am I correct? Thanks again. Richard [EMAIL PROTECTED] 11/29/01 10:45PM Richard, Comments inline.. -Original Message- Sent: Thursday, November 29, 2001 6:40 AM To: Multiple recipients of list ORACLE-L This sounds good, but I have a couple of questions. How do you guarantee that you won't lose any committed transactions? I mean, the C program could lag behind the LGWR since it's only reading it without lock and it's copying the online redo over to a remote machine. So for a busy database, the LGWR will just keep writing and the C program won't be able to keep up with it's pace. The external program uses X$KCCCP as a feedback for copying process. X$KCCCP will have the current log block (Disk RBA) and this will have the change vectors for last commit. So you copy the change vectors/ redo records immediately as soon as it is written. If LGWR can keep writing the files means why can't your C program copy the files? Are you copying the whole partially filled online redo? or just the difference since the last commit? Difference from last copy.. (last commit ) Did I miss understand it? Please advise. [EMAIL PROTECTED] 11/29/01 12:40AM If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: Standby Database
Richard, You are right. It is close to Zero data loss. Not exactly Zero Data loss. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Friday, November 30, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Kay, thanks for the explanation. Sorry for being a pain in butt. But I see that the C program will write IMMEDIATELY AS SOON AS the log is written. But this is not the same as doing it simultaneously. So there is a chance (very very small of course) that after LGWR writes the committed transaction and before your C program copies the block which contains the change vector that the system crash and online redo is lost. Therefore you can guarantee 99.99% but not 100%? Am I correct? Thanks again. Richard [EMAIL PROTECTED] 11/29/01 10:45PM Richard, Comments inline.. -Original Message- Sent: Thursday, November 29, 2001 6:40 AM To: Multiple recipients of list ORACLE-L This sounds good, but I have a couple of questions. How do you guarantee that you won't lose any committed transactions? I mean, the C program could lag behind the LGWR since it's only reading it without lock and it's copying the online redo over to a remote machine. So for a busy database, the LGWR will just keep writing and the C program won't be able to keep up with it's pace. The external program uses X$KCCCP as a feedback for copying process. X$KCCCP will have the current log block (Disk RBA) and this will have the change vectors for last commit. So you copy the change vectors/ redo records immediately as soon as it is written. If LGWR can keep writing the files means why can't your C program copy the files? Are you copying the whole partially filled online redo? or just the difference since the last commit? Difference from last copy.. (last commit ) Did I miss understand it? Please advise. [EMAIL PROTECTED] 11/29/01 12:40AM If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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
Re: Standby Database
Quick question, long answer... You are not only making sense, you have hit the primary issue with the Oracle standby database directly on the head. With DataGuard in 9i (or 8i on HP-UX or Solaris only), you can *try* to retrieve redo log files. You could also do it manually - with any version. In either case, there are no guarantees. If the primary site goes away in a tornado, the redo logs and possibly one or more unfinished (w.r.t. sent or archived) archive logs go with it - and the standby does not have all the transactions. The 9i marketing rhetoric says that this is not an issue with 9i DataGuard since it allows synchronous logfile writes to a remote site and some other enhancements. I haven't tried it yet, but I'm not drinking all their Kool-Aid. I'm sure that even Oracle9i didn't change the laws of physics (186,000 miles/second isn't just a good idea - its the law! And light doesn't travel in anything vaguely resembling a straight line inside a fiber optic cable.). Synchronous writes, especially of redo logs, to a geographically remote standby have to be a significant performance hit on any non-trivial primary. Even locally, synchronous host-based writes usually have a very significant performance impact. There are options of geo-mirroring both the online redo logs and archive logs with something like EMC SRDF to create a true no loss standby database. There is a white paper on it somewhere on EMC's site and I've seen a more generic white paper / presentation on it from Oracle (from Wei Hu or Ron Weiss probably). I've designed something like this with a long-haul multi-hop EMC implementation (local synchronous SRDF with R2 in bunkered Symmetrix, BCV split in bunkered Sym, adaptive copy of the BCV to remote standby). It works well, but doesn't look much like an automagically managed normal standby database. This required custom scripts - to enforce a delay, manage recovery and such. The idea is to synchronously mirror to a safe location (in the EMC scenario, a bunkered Symmetrix a short distance away) and then asynchronously/periodically update the more remote standby system from there. It is an expensive solution, but if you truly can't afford any data loss there are no cheap ones. This one in particular has the added advantage that the heavy lifting grunge work is done in the Symmetrix so there is no noticeable host load on the primary. Some other storage vendors - Hitachi, etc. - have similar capability. You could do it with host-based software (e.g. Veritas) also, but then you have host load, potential/probability of OS write performance degradation, and perhaps some other issues (e.g. multi-hop capability?). I don't even know what DoubleTake is. However, local clustering is an entirely different critter compared to a standby database. It provides a standby instance for fast failover in the event of a system/instance failure, but doesn't provide any intrinsic media protection or a disaster recovery solution. A standby database is typically a disaster recovery (DR) solution, but a poor high availability (HA) solution - but, as Bill Clinton might say that depends on the meaning of 'high'. ;-). Local clustering (either model: OPS/RAC or HA/takeover) typically provides excellent HA, but no DR at all. The best business continuity solutions for extremely critical 24xForever, no data loss is ever acceptable systems demand hybrid solutions. I've built a few for a major brokerage using clustered Sun E10Ks, 8i OPS, Net8 TAF, EMC Symms, TimeFinder, SRDF, and (delayed) standby databases at a backup site 200 miles away. Extreme HA, extreme DR, and extreme expense! There are some interesting HA, DR, scalability blueprints at www.eECOstructure.com - in multiple phases. Phase I is the Resilient Blueprint - a hardened single site with HA. Phase II is the Recovery blueprint - adding multi-site and DR. Phase III is the Accelerated blueprint - higher scalability, security, etc. Each phase builds upon the previous. Remember, they are blueprints, not commandments. Nobody ever builds a house without modifications to the standard model, and nobody is likely to build an infrastructure that way either. The concepts can be adapted to other components (e.g. WebLogic and/or Tuxedo instead of iAS). -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 5:35 PM Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or
Re: Standby Database
K Gopalakrishnan wrote: If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs .. In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed Very interesting thread. If I understand Ed's idea, it would be to have at least one redo log file in each group written at the remote location, through a NFS mount or similar (indeed, I'd rather have 'similar' than 'NFS mount', for having tried once a NFS-mounted tablespace). I fear that it wouldn't work, because Oracle waits for the log to be physically written to disk before saying 'committed' to you, and I don't think that it says 'committed' once it has been written successfully to ONE log file but to ALL log files (has anybody tested the impact of the number of log files on performance?). In the best of case, it would seriously impair performance. In the worst one (network glitch) you may have failing transactions; its a bit like two-phase commit, succeed everywhere or fail everywhere is nice only as long as everything succeeds. I presume (it's a functionality I have not had the opportunity to test yet) that 9i handles this by writing synchronously (in respect to COMMITs) local redo logs and asynchronously remote copies. Being sceptical by nature, I have serious doubts about 'zero loss' ('total quality' and 'zero default', anyone? Do you realise how dull your life would be without patches?); it is certainly OK with small or not much updated databases, but having seen 'Checkpoint not complete' a number of times in alert log files I wonder how it can catch up with intense OLTP. Most standby databases I know are used for disaster recovery plans, in physically remote locations, which means that the link is not exactly an ultra-fast LAN. I really love the C program solution, even if it probably shares the limitations I mention above. That said, with your code you can improve it, open several connections, etc. Would certainly be fun to write. But I also find it difficult to sell the idea of financing this kind of development to management, with the Oracle salesman whispering 'no loss with 9i' to their ears (I guess that all of them only have a very faint idea of what a standby database is and what it can be used for). Ultimately, the expensive hardware solution would probably be the easiest sell. But perhaps accepting that minimizing loss, not making it disappear, would be the wisest solution. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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
RE: Standby Database
There may be some solutions available at the hardware level as well.. For example-SRDF on an EMC cabinet... and define the online redo logs/archive logs as part of the data transfer.. But there are performance problems with that as well. greg -Original Message- Sent: Thursday, November 29, 2001 12:40 AM To: Multiple recipients of list ORACLE-L If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Loughmiller, Greg 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
Excellent post Don! This one's going straight in to my special folder :P -Original Message- Granaman Sent: 29 November 2001 08:05 To: Multiple recipients of list ORACLE-L Quick question, long answer... You are not only making sense, you have hit the primary issue with the Oracle standby database directly on the head. With DataGuard in 9i (or 8i on HP-UX or Solaris only), you can *try* to retrieve redo log files. You could also do it manually - with any version. In either case, there are no guarantees. If the primary site goes away in a tornado, the redo logs and possibly one or more unfinished (w.r.t. sent or archived) archive logs go with it - and the standby does not have all the transactions. The 9i marketing rhetoric says that this is not an issue with 9i DataGuard since it allows synchronous logfile writes to a remote site and some other enhancements. I haven't tried it yet, but I'm not drinking all their Kool-Aid. I'm sure that even Oracle9i didn't change the laws of physics (186,000 miles/second isn't just a good idea - its the law! And light doesn't travel in anything vaguely resembling a straight line inside a fiber optic cable.). Synchronous writes, especially of redo logs, to a geographically remote standby have to be a significant performance hit on any non-trivial primary. Even locally, synchronous host-based writes usually have a very significant performance impact. There are options of geo-mirroring both the online redo logs and archive logs with something like EMC SRDF to create a true no loss standby database. There is a white paper on it somewhere on EMC's site and I've seen a more generic white paper / presentation on it from Oracle (from Wei Hu or Ron Weiss probably). I've designed something like this with a long-haul multi-hop EMC implementation (local synchronous SRDF with R2 in bunkered Symmetrix, BCV split in bunkered Sym, adaptive copy of the BCV to remote standby). It works well, but doesn't look much like an automagically managed normal standby database. This required custom scripts - to enforce a delay, manage recovery and such. The idea is to synchronously mirror to a safe location (in the EMC scenario, a bunkered Symmetrix a short distance away) and then asynchronously/periodically update the more remote standby system from there. It is an expensive solution, but if you truly can't afford any data loss there are no cheap ones. This one in particular has the added advantage that the heavy lifting grunge work is done in the Symmetrix so there is no noticeable host load on the primary. Some other storage vendors - Hitachi, etc. - have similar capability. You could do it with host-based software (e.g. Veritas) also, but then you have host load, potential/probability of OS write performance degradation, and perhaps some other issues (e.g. multi-hop capability?). I don't even know what DoubleTake is. However, local clustering is an entirely different critter compared to a standby database. It provides a standby instance for fast failover in the event of a system/instance failure, but doesn't provide any intrinsic media protection or a disaster recovery solution. A standby database is typically a disaster recovery (DR) solution, but a poor high availability (HA) solution - but, as Bill Clinton might say that depends on the meaning of 'high'. ;-). Local clustering (either model: OPS/RAC or HA/takeover) typically provides excellent HA, but no DR at all. The best business continuity solutions for extremely critical 24xForever, no data loss is ever acceptable systems demand hybrid solutions. I've built a few for a major brokerage using clustered Sun E10Ks, 8i OPS, Net8 TAF, EMC Symms, TimeFinder, SRDF, and (delayed) standby databases at a backup site 200 miles away. Extreme HA, extreme DR, and extreme expense! There are some interesting HA, DR, scalability blueprints at www.eECOstructure.com - in multiple phases. Phase I is the Resilient Blueprint - a hardened single site with HA. Phase II is the Recovery blueprint - adding multi-site and DR. Phase III is the Accelerated blueprint - higher scalability, security, etc. Each phase builds upon the previous. Remember, they are blueprints, not commandments. Nobody ever builds a house without modifications to the standard model, and nobody is likely to build an infrastructure that way either. The concepts can be adapted to other components (e.g. WebLogic and/or Tuxedo instead of iAS). -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 5:35 PM Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases).
Re: Standby Database
Ditto this. Pretty much exactly what I suspected, but I was certain someone here had dealt with this already and might have better insight. Thanks, Ed - Original Message - Excellent post Don! This one's going straight in to my special folder :P -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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
This sounds good, but I have a couple of questions. How do you guarantee that you won't lose any committed transactions? I mean, the C program could lag behind the LGWR since it's only reading it without lock and it's copying the online redo over to a remote machine. So for a busy database, the LGWR will just keep writing and the C program won't be able to keep up with it's pace. Are you copying the whole partially filled online redo? or just the difference since the last commit? Did I miss understand it? Please advise. [EMAIL PROTECTED] 11/29/01 12:40AM If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Richard Ji 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
RE: Standby Database
Title: RE: Standby Database /begin_plug I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately. What is really the problem we are trying to solve here? Maybe we are using the wrong tool. If you are looking for data protection in the event of a failure, or disaster... Or if you are trying to create a real time reporting instance. And you are using standby databases... there is a better solution. We provide a product called SharePlex for Oracle... it continually scans the online redo logs for any transactions on the tables that are critical to your environment. It takes these transactions, and sends them to a target machine over TCP communication, and posts them via standard Oracle SQL. The target system is completely open and available, while we are posting to it, for reporting and/or verifying that the data is there and available for use in case of a failure or disaster at the primary site. It can even be used in a peer to peer replication scheme as well. /end_plug /begin_shameless_plug for more information you can go to http://www.quest.com/shareplex/ /end_shameless_plug Sorry about the 'sales announcement' but this list is for helping people, and trying to solve their problems... I see this as a solution. Nick Wagner Technical PM Quest Software -Original Message- From: Ed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Standby Database Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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
Title: RE: Standby Database Shareplex is a great tool, i have heard anecdotally. Of course, it ain't cheap, either. Both facts need to be addressed. Is there any interest in sharing that kind of sales information? For, say, a Sun 6500, 12 processors, 8GB RAM, "shareplexing" to another box of same type... Just a question. Ross -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Standby Database /begin_plug I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately. What is really the problem we are trying to solve here? Maybe we are using the wrong tool. If you are looking for data protection in the event of a failure, or disaster... Or if you are trying to create a real time reporting instance. And you are using standby databases... there is a better solution. We provide a product called SharePlex for Oracle... it continually scans the online redo logs for any transactions on the tables that are critical to your environment. It takes these transactions, and sends them to a target machine over TCP communication, and posts them via standard Oracle SQL. The target system is completely open and available, while we are posting to it, for reporting and/or verifying that the data is there and available for use in case of a failure or disaster at the primary site. It can even be used in a peer to peer replication scheme as well. /end_plug /begin_shameless_plug for more information you can go to http://www.quest.com/shareplex/ /end_shameless_plug Sorry about the 'sales announcement' but this list is for helping people, and trying to solve their problems... I see this as a solution. Nick Wagner Technical PM Quest Software -Original Message- From: Ed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject: Standby Database Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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
Thanks for this Don. You and Patrice ( Unix vs. NT thread ) have together justified the time I spend on this list. Jared Don Granaman granaman@home To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: Re: Standby Database [EMAIL PROTECTED] om 11/29/01 12:05 AM Please respond to ORACLE-L Quick question, long answer... You are not only making sense, you have hit the primary issue with the Oracle standby database directly on the head. With DataGuard in 9i (or 8i on HP-UX or Solaris only), you can *try* to retrieve redo log files. You could also do it manually - with any version. In either case, there are no guarantees. If the primary site goes away in a tornado, the redo logs and possibly one or more unfinished (w.r.t. sent or archived) archive logs go with it - and the standby does not have all the transactions. The 9i marketing rhetoric says that this is not an issue with 9i DataGuard since it allows synchronous logfile writes to a remote site and some other enhancements. I haven't tried it yet, but I'm not drinking all their Kool-Aid. I'm sure that even Oracle9i didn't change the laws of physics (186,000 miles/second isn't just a good idea - its the law! And light doesn't travel in anything vaguely resembling a straight line inside a fiber optic cable.). Synchronous writes, especially of redo logs, to a geographically remote standby have to be a significant performance hit on any non-trivial primary. Even locally, synchronous host-based writes usually have a very significant performance impact. There are options of geo-mirroring both the online redo logs and archive logs with something like EMC SRDF to create a true no loss standby database. There is a white paper on it somewhere on EMC's site and I've seen a more generic white paper / presentation on it from Oracle (from Wei Hu or Ron Weiss probably). I've designed something like this with a long-haul multi-hop EMC implementation (local synchronous SRDF with R2 in bunkered Symmetrix, BCV split in bunkered Sym, adaptive copy of the BCV to remote standby). It works well, but doesn't look much like an automagically managed normal standby database. This required custom scripts - to enforce a delay, manage recovery and such. The idea is to synchronously mirror to a safe location (in the EMC scenario, a bunkered Symmetrix a short distance away) and then asynchronously/periodically update the more remote standby system from there. It is an expensive solution, but if you truly can't afford any data loss there are no cheap ones. This one in particular has the added advantage that the heavy lifting grunge work is done in the Symmetrix so there is no noticeable host load on the primary. Some other storage vendors - Hitachi, etc. - have similar capability. You could do it with host-based software (e.g. Veritas) also, but then you have host load, potential/probability of OS write performance degradation, and perhaps some other issues (e.g. multi-hop capability?). I don't even know what DoubleTake is. However, local clustering is an entirely different critter compared to a standby database. It provides a standby instance for fast failover in the event of a system/instance failure, but doesn't provide any intrinsic media protection or a disaster recovery solution. A standby database is typically a disaster recovery (DR) solution, but a poor high availability (HA
RE: Standby Database
Richard, Comments inline.. -Original Message- Sent: Thursday, November 29, 2001 6:40 AM To: Multiple recipients of list ORACLE-L This sounds good, but I have a couple of questions. How do you guarantee that you won't lose any committed transactions? I mean, the C program could lag behind the LGWR since it's only reading it without lock and it's copying the online redo over to a remote machine. So for a busy database, the LGWR will just keep writing and the C program won't be able to keep up with it's pace. The external program uses X$KCCCP as a feedback for copying process. X$KCCCP will have the current log block (Disk RBA) and this will have the change vectors for last commit. So you copy the change vectors/ redo records immediately as soon as it is written. If LGWR can keep writing the files means why can't your C program copy the files? Are you copying the whole partially filled online redo? or just the difference since the last commit? Difference from last copy.. (last commit ) Did I miss understand it? Please advise. [EMAIL PROTECTED] 11/29/01 12:40AM If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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 --
RE: Standby Database
I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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
If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table X$KCCLE and X$KCCCP to find how much is written in the log files. The partially filled log file can be shipped to the standby location and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken care of in oracle 9i version. The other solution could be to buy an expensive Veritas Cluster server/Database edition. Thanks, -- Janardhana babu -Original Message- Sent: Wednesday, November 28, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Janardhana Babu 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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
Hi I forgot to mention that the database I'm to create the standby for is not alone on this machine. IP-switching is therefore not an option (I'm not doing standby for the whole system). We are currently using HACMP with EMC but this is giving us much grieve (UNIX people anyway) so they want to get rid of it. Thx Jack Ray Stell [EMAIL PROTECTED]@fatcity.com on 04-09-2001 00:00:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) On Mon, Sep 03, 2001 at 08:45:24AM -0800, [EMAIL PROTECTED] wrote: Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. -- I don't think you want to do what you are saying. For standby environment you would need to have some manual intervention at the prod failure (well, I guess you could script it, but I wouldn't). What I'd do is configure the old prod host ip address on the new prod host (the old standby that has been activated). That way you don't have to mess with a dns restart. You may need to clear some arp caches in some layer 2 3 network elements along the way, however. As an alternative, you could move the dns pointer record for the db from the old prod host dns entry to the old standby entry, which isn't a standby anymore, it is the new prod host. Whichever is easier. === 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 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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
Re: Standby database
Jack Hadn't thought of that yet. Thanks That'll do the trick for us. Jack Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 04-09-2001 00:36:47 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Well, you can configure the tnsnames.ora to check multiple listeners, so you do that... the first listener/port you check is the primary, the second is the standby From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Standby database Date: Mon, 03 Sep 2001 08:45:24 -0800 Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande
Re: Standby database
On Mon, Sep 03, 2001 at 08:45:24AM -0800, [EMAIL PROTECTED] wrote: Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. -- I don't think you want to do what you are saying. For standby environment you would need to have some manual intervention at the prod failure (well, I guess you could script it, but I wouldn't). What I'd do is configure the old prod host ip address on the new prod host (the old standby that has been activated). That way you don't have to mess with a dns restart. You may need to clear some arp caches in some layer 2 3 network elements along the way, however. As an alternative, you could move the dns pointer record for the db from the old prod host dns entry to the old standby entry, which isn't a standby anymore, it is the new prod host. Whichever is easier. === 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 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
Well, you can configure the tnsnames.ora to check multiple listeners, so you do that... the first listener/port you check is the primary, the second is the standby From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Standby database Date: Mon, 03 Sep 2001 08:45:24 -0800 Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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 Error
I was able to configure the standby database.I am not clear about the redo log files.Oracle Standby database creation dod doesn't talk of moving the redo log files.Do we have to move the redo log files from the primary database to the standby database.But the standby database iw working fine and i open it in READ only mode to check if the data is in sync with the primary database and i found it to be good. When I give selct member from v$logfile; it lists the redo logs but actually no files exist in that directory. Should we move the redo logs also to the standby database from the primary database. Thanks Ravindra -Original Message- Basavaraja Sent: Friday, August 10, 2001 6:05 PM To: Multiple recipients of list ORACLE-L I am getting the following error when applying the archive files from the production database to the standby database.I just configured the standby database and was applying the archive files from production. This error appeared after processing many archive files ORA-00308: cannot open archived log '/u03/ora/app/admin/sentica/arch/Prod_arch_1_9823.arc' ORA-27046: file size is not a multiple of logical block size Additional information: 1 What could be the problem.? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Ravindra Basavaraja 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 Error
Nope u do not have to copy the online redologfiles to the standby, this has to be done only in the case of switch over from production to the standby database. The online redos are only read when the database is getting opened it will not be read during recovery until and unless u specify the online redo log file during recovery or u specify recover database command at this moment if it has applied all the archive logs it will check the online redologs and recover complete from it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 12:22 PM I was able to configure the standby database.I am not clear about the redo log files.Oracle Standby database creation dod doesn't talk of moving the redo log files.Do we have to move the redo log files from the primary database to the standby database.But the standby database iw working fine and i open it in READ only mode to check if the data is in sync with the primary database and i found it to be good. When I give selct member from v$logfile; it lists the redo logs but actually no files exist in that directory. Should we move the redo logs also to the standby database from the primary database. Thanks Ravindra -Original Message- Basavaraja Sent: Friday, August 10, 2001 6:05 PM To: Multiple recipients of list ORACLE-L I am getting the following error when applying the archive files from the production database to the standby database.I just configured the standby database and was applying the archive files from production. This error appeared after processing many archive files ORA-00308: cannot open archived log '/u03/ora/app/admin/sentica/arch/Prod_arch_1_9823.arc' ORA-27046: file size is not a multiple of logical block size Additional information: 1 What could be the problem.? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Ravindra Basavaraja 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: arunc 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
Rich, no problems other than, the "performance" issue, if they are hitting it hard and oracle lags in trying to post the logs to the standby database. other than that it should be fine. Joe [EMAIL PROTECTED] 07/06/01 11:27AM Just wondering if anyone sees any problems with creating a second instanceand DB on a standby database server that would be used for reportingquerying against a small dataset??? Running the standby DB in read onlymode is not an option since I'm applying archived logs every 10 minutes. Ifanyone knows of any issues with doing this, could you please let me know.TIA,Richard Huntley-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Standby Database
Richard, As long as the 2nd instance doesn't interfere with the application of archived redo logs to the standby, I don't see a problem. I routinely use the extra CPU available on our standby server (Win2K) to zip up exports from production and other, similar tasks that would otherwise put extra load on our production server. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Huntley Sent: Friday, July 06, 2001 10:28 AM To: Multiple recipients of list ORACLE-L Just wondering if anyone sees any problems with creating a second instance and DB on a standby database server that would be used for reporting querying against a small dataset??? Running the standby DB in read only mode is not an option since I'm applying archived logs every 10 minutes. If anyone knows of any issues with doing this, could you please let me know. TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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 Replication
I need to implement the standby database for the Txn. Proc. Prod. system. I have a few doubts. If the failure/disaster happens to prod DB, and can't open the DB, then How to transfer the contents of online logs to standby database? My logs would switch once every hour, and so, I would lose atleast one hour worth of data if I need to activate the standby database. Is there any solution for this? My second question would be: Temporary network failures are quite common here. We use Veritas Netbackup to backup using RMAN. Archived logs would be deleted after the backup as the archived logs quickly fill up the diskspace. How to keep atleast one copy of the archived logs on a seperate bigger disk permanently, atleast one week without being deleted by RMAN backup script. I tried defining LOG_ARCHIVE_DEST_3as optional location in init.ora. But these files are also being deleted by RMAN backup script along with Mandatory archived logs. We would like RMAN backup script to delete the Archived logs from Mandatory location after the backups are done, but at the same time retain the Optional location archived logs. Is there any way to do this? Restoring from tape would be time consuming and so looking for a solution to retain one copy of the Archived logs on disk. My third question would be: Is anyone using Veritas Volume Replicator or similar product to recover the DB until the last transaction without production DB downtime, in case of disaster? Iam thinking of this product, but not sure this would solve the disaster Recovery problem until last transaction with no prod. down time. Any help would be appreciated. Thanks, -- Janardhana Babu -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Friday, July 06, 2001 9:46 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Standby Database Rich, no problems other than, the "performance" issue, if they are hitting it hard and oracle lags in trying to post the logs to the standby database. other than that it should be fine. Joe [EMAIL PROTECTED] 07/06/01 11:27AM Just wondering if anyone sees any problems with creating a second instanceand DB on a standby database server that would be used for reportingquerying against a small dataset??? Running the standby DB in read onlymode is not an option since I'm applying archived logs every 10 minutes. Ifanyone knows of any issues with doing this, could you please let me know.TIA,Richard Huntley-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Standby database
Lisa, did one for 8.1.5, what are you wanting to monitor? joe [EMAIL PROTECTED] 07/03/01 09:41AM Hi List,I would like to know if anyone has setup standby database in oracle8i.Also do you have any monitoring scripts developed?I would appreciate an insight/help since I need to setup one in production.Thanks,Lisa_Get your FREE download of MSN Explorer at http://explorer.msn.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: teeks nana INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Standby database
$ tail alert.log is all you require to monitor the logs being applied to the standby... -- From: JOE TESTA[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 8:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: Standby database Lisa, did one for 8.1.5, what are you wanting to monitor? joe [EMAIL PROTECTED] 07/03/01 09:41AM Hi List, I would like to know if anyone has setup standby database in oracle8i. Also do you have any monitoring scripts developed? I would appreciate an insight/help since I need to setup one in production. Thanks, Lisa _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: teeks nana 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: Rahul 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 - solved
can u please tell me how to monitor it . TIA Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria 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 - solved
read the documentatio on standby databases. it in the 8.1.7 docs(which nowadays are online), there is a whole book on standby databases. joe Anjan Thakuria wrote: can u please tell me how to monitor it . TIA Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- 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).