Re: Oracle Standby.
Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? I found Oracle Backup Recovery 101 by Stephan Haisley and Kenny Smith to be useful. Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Standby.
Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Standby.
There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Standby.
Thanks, I've grabbed the whitepaper by Lawrence To (from http://otn.oracle.com/deploy/availability/pdf/stby8i_twp.pdf if anyone is interested). I'll take that home for bed time reading ;) If I have any more specific questions I'll give you all a shout again! ;) Many thanks Mark -Original Message- Shrake, Jolene Sent: 09 January 2004 14:39 To: Multiple recipients of list ORACLE-L There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Shrake, Jolene 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Standby.
Hi Mark... I have a good one... if you wanna copy email me off-list... Regards! JL --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Standby.
--- Shrake, Jolene [EMAIL PROTECTED] wrote: There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene Mark, I have a few questions for you. Oracle version? (9i R2, I'd assume) Enterprise Edition or Standard? Database size? Volume of logs generated per day? standby server on local LAN or remote network? (do you want to use compression of logs) NetBIOS enabled over WAN/VPN? (what protocols are available to transfer logs) NOLOGGING operations permitted? (frequency of full refreshes, use of FORCE LOGGING) We run home-grown scripts for Standard Edition, but I have a project coming up where the Client is running Enterprise Edition, so when they are migrated to 9i R2, we're planning on using DataGuard to handle the physical standby. you're likely going to want to automate creation of initial backupset used for standby, and for automated refreshing of entire db. gotta run. Pd -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Standby database.
We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Standby database.
Avnish: That is not possible in 8.1.7. You need to be atleast 9.2 to do that. --- [EMAIL PROTECTED] wrote: We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Standby database.
Its possible 'cause we are two different OS and DB versions. Would it be possible if we upgrade source database from 816 to 8174 and then use Standby database. -Original Message- Sent: Thursday, September 25, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Avnish: That is not possible in 8.1.7. You need to be atleast 9.2 to do that. --- [EMAIL PROTECTED] wrote: We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Standby Database Backups.
Arup,Indy, List Some Clarifications please If the Primary Database is in ARCHIVELOG Mode (Physical Standby) archived files there from are being shipped applied to the Standby Database, What is the need to run the Standby Database in ARCHIVELOG Mode? Are you implying 9i Dataguard with a Standby which works on a mechanism Other than Log-shipping? Please give detail Thanks -Original Message- From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Standby Database Backups. Tom, You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word imply rather than state, since the docs have been kind of ambiguous, the archivedlogbackups from the standby are perfectly alright to be used for recoveries.. You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok. We are using it to backup out 7 TB OLTP database. HTH. Arup - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk.We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional
Re: Oracle Standby Database Backups.
Vivek,
The origianl poster inquired on Physical Standby
(in 8i and 9i) as opposed to logical standby (only in 9i).
In physical standby, you don't have a choice of
running the standby in noarchivelog mode. The control file is created from the
primary as "standby controlfile" which is then implanted at the standby site.
Therefore the LOGMODE is V$DATABASE is always ARCHIVELOG and the
CONTROLFILE_TYPE is always "STANDBY".
I guess you are confused on the potential issue -
when the logmode is archivelog, whether the standby generates archived log
files. No, the standby does not generate archived logs since it does not excute
transactions; it just applies the logs shipped from the primary. When you
activate the standby to make it the primary, however, the archived logs are
generated.
Hope this clears any confusion. Do let us know if
you have more questions on this.
Arup Nanda
www.proligence.com
- Original Message -
From:
VIVEK_SHARMA
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 05, 2003 3:09
AM
Subject: RE: Oracle Standby Database
Backups.
Arup,Indy,
List
Some
Clarifications please
If the Primary
Database is in ARCHIVELOG Mode (Physical Standby) archived files there
from are being shipped applied to the Standby Database, What is the need
to run the Standby Database in ARCHIVELOG Mode?
Are you
implying 9i Dataguard with a Standby which works on a mechanism Other than
Log-shipping?
Please give
detail
Thanks
-Original
Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED] Sent: Thursday, September
04, 2003 12:35
AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Oracle
Standby Database Backups.
Tom,
You
should perform backups from the Standby database, regular RMAN backups, no
need to shutdown the database. Make sure you backup the archived log files
from there too. Contrary to what the docs might _imply_, I use the word
"imply" rather than "state", since the docs have been kind of ambiguous, the
archivedlogbackups from the standby are perfectly alright to be used for
recoveries..
You could
use the RMAN backup on the primary, but why? You would rather want to offload
the CPU cycles for RMAN to the standby database. In case of a failure in the
primary, your first option is to get the files from standby and recover them.
If standby is down too (as in case of a complete disaster), you would
reinstate the standby backup files to primary and you will be
ok.
We are
using it to backup out 7 TB OLTP database.
HTH.
Arup
-
Original Message -
From: Mercadante, Thomas F
To: Multiple recipients of list
ORACLE-L
Sent: Wednesday, September
03, 2003 2:29
PM
Subject: Oracle Standby
Database Backups.
All,
We are in the
beginning stages of designing a database with Oracle Standby
capability. The initial size of the database will be 600-800
Gig. The proposed database will be run on a IBM P690 with a mirrored
fail-over machine. Two separate machines with separate
disk.We are considering using Oracle Standby to have the
database available as much as possible.
Do I
need to perform regular backups of the Standby database? Sounds like a
silly question, but how do I do this? Using Rman? Or do I shut
it down and perform a cold backup? I will definitely use Rman on the
primary database. Just curious what you all would
suggest.
Thanks
in advance!
Tom
Mercadante
Oracle Certified
Professional
RE: Oracle Standby Database Backups.
Arup, Thanks for the reply. So I am assuming that the Standby database is in archivelog mode? Good idea performing the backup on the standby rather than the Primary. Our Primary is supposed to grow to 3TB, so your idea has merit. And our servers will be in two different buildings, so it makes sense. In case of a disaster, we switch to the Standby and recover the Primary when it becomes available again, right? Thanks again. Tom Mercadante Oracle Certified Professional -Original Message-From: Arup Nanda [mailto:]Sent: Wednesday, September 03, 2003 3:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Standby Database Backups. Tom, You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word "imply" rather than "state", since the docs have been kind of ambiguous, the archivedlogbackups from the standby are perfectly alright to be used for recoveries.. You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok. We are using it to backup out 7 TB OLTP database. HTH. Arup - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk.We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional
RE: Oracle Standby Database Backups.
Jose, I've taken nothing into account. I'm still asking theoretical questions, trying to prepare for a discussion I will be having this afternoon. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, September 04, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Tom I was wondering about the last log file on your primary database that still hasn't been sent to your standby database until a switch log occurs... (thinking about sustained mode too) Have you taken that into account?? JL --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Arup, Thanks for the reply. So I am assuming that the Standby database is in archivelog mode? Good idea performing the backup on the standby rather than the Primary. Our Primary is supposed to grow to 3TB, so your idea has merit. And our servers will be in two different buildings, so it makes sense. In case of a disaster, we switch to the Standby and recover the Primary when it becomes available again, right? Thanks again. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 03, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Tom, You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word imply rather than state, since the docs have been kind of ambiguous, the archivedlog backups from the standby are perfectly alright to be used for recoveries.. You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok. We are using it to backup out 7 TB OLTP database. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 2:29 PM All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk. We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Standby Database Backups.
Tom it's me again... I have a (I consider) really good document about stand by databases... (old, maybe, but still applies to 8i standby databases)... if you are interested... I can send you a copy... it focuses about the 'details' with theses databases... HTH JL --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Jose, I've taken nothing into account. I'm still asking theoretical questions, trying to prepare for a discussion I will be having this afternoon. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, September 04, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Tom I was wondering about the last log file on your primary database that still hasn't been sent to your standby database until a switch log occurs... (thinking about sustained mode too) Have you taken that into account?? JL --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Arup, Thanks for the reply. So I am assuming that the Standby database is in archivelog mode? Good idea performing the backup on the standby rather than the Primary. Our Primary is supposed to grow to 3TB, so your idea has merit. And our servers will be in two different buildings, so it makes sense. In case of a disaster, we switch to the Standby and recover the Primary when it becomes available again, right? Thanks again. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 03, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Tom, You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word imply rather than state, since the docs have been kind of ambiguous, the archivedlog backups from the standby are perfectly alright to be used for recoveries.. You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok. We are using it to backup out 7 TB OLTP database. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 2:29 PM All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk. We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you
Oracle Standby Database Backups.
All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk.We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional
Re: Oracle Standby Database Backups.
Tom, You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word "imply" rather than "state", since the docs have been kind of ambiguous, the archivedlogbackups from the standby are perfectly alright to be used for recoveries.. You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok. We are using it to backup out 7 TB OLTP database. HTH. Arup - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk.We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional
Re: Oracle Standby Database Backups.
Tom As long as your standby database is Physical Standby DB [ Not for Logical Standby Database where you also need to take the standby database backup] If the Database size is very big [ Not even in TB but few hundred GB ], If the Database is 24*7 If the Network connection is good [ We are not using this for some of the Server that are in remote location as Disaster recovery Server and Network connection is not good] It is good idea to perform the Oracle Backup thru RMAN on Standby Database as this way you can avoid any Resource issue on the Primary Database.Arup has already pointed out the detailed benefits. We are using this for lots of big databases. Indy Johal Manager, Database Administration PR Newswire [EMAIL PROTECTED] http://www.prnewswire.com (201) 946-5687 [W] (201) 400-3960 [M] We tell your story to the world. Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/03/03 03:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle Standby Database Backups. Tom, You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word imply rather than state, since the docs have been kind of ambiguous, the archivedlog backups from the standby are perfectly alright to be used for recoveries.. You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok. We are using it to backup out 7 TB OLTP database. HTH. Arup - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 03, 2003 2:29 PM Subject: Oracle Standby Database Backups. All, We are in the beginning stages of designing a database with Oracle Standby capability. The initial size of the database will be 600-800 Gig. The proposed database will be run on a IBM P690 with a mirrored fail-over machine. Two separate machines with separate disk. We are considering using Oracle Standby to have the database available as much as possible. Do I need to perform regular backups of the Standby database? Sounds like a silly question, but how do I do this? Using Rman? Or do I shut it down and perform a cold backup? I will definitely use Rman on the primary database. Just curious what you all would suggest. Thanks in advance! Tom Mercadante Oracle Certified Professional
RE: Oracle standby strange behavior
Title: Oracle standby strange behavior Hi, FYI , the problem is an Oracle bug 1504967 described as Inconsistency between Dictionary Cache and Dictionary on Standby DatabaseSee Metalink for Doc id 150222.1 for explanation how to workaround it. Yuval. -Original Message-From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in the original DB. Before you activate standby, do 1. On production SQL alter system switch logfile; 2. Transfer all archived logs to standby and make sure they are applied. Hopefully, no more problem. Vadim -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 1:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle standby strange behavior Hi, I ran into a strange behavior of a standby database. On the primary db I have an application schema and a query schema. All tables from the appl schema have public synonyms and a grant select to public. User query is created with connect and resource roles. Once I switch over to the standby db , and put it in read only mode, and then connect to the query user, I can not perform a select against 2 of the 35 tables. I get object OBJECT_NAME does not exist. I can connect to the system user on the standby database and I have no problem selecting from all the tables. Any idea what am I missing?? Yuval. -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Rachel IS kind but her words are also true and I think this was her main focus in this case. ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i? -Original Message- Sent: Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- "SARKAR, Samir" [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: IN
Oracle standby strange behavior
Title: Oracle standby strange behavior Hi, I ran into a strange behavior of a standby database. On the primary db I have an application schema and a query schema. All tables from the appl schema have public synonyms and a grant select to public. User query is created with connect and resource roles. Once I switch over to the standby db , and put it in read only mode, and then connect to the query user, I can not perform a select against 2 of the 35 tables. I get object OBJECT_NAME does not exist. I can connect to the system user on the standby database and I have no problem selecting from all the tables. Any idea what am I missing?? Yuval. -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Rachel IS kind but her words are also true and I think this was her main focus in this case. ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i? -Original Message- Sent: Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- SARKAR, Samir [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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). ___ 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
RE: Oracle standby strange behavior
Title: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in the original DB. Before you activate standby, do 1. On production SQL alter system switch logfile; 2. Transfer all archived logs to standby and make sure they are applied. Hopefully, no more problem. Vadim -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 1:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle standby strange behavior Hi, I ran into a strange behavior of a standby database. On the primary db I have an application schema and a query schema. All tables from the appl schema have public synonyms and a grant select to public. User query is created with connect and resource roles. Once I switch over to the standby db , and put it in read only mode, and then connect to the query user, I can not perform a select against 2 of the 35 tables. I get object OBJECT_NAME does not exist. I can connect to the system user on the standby database and I have no problem selecting from all the tables. Any idea what am I missing?? Yuval. -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Rachel IS kind but her words are also true and I think this was her main focus in this case. ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i? -Original Message- Sent: Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- "SARKAR, Samir" [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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 s
RE: Oracle standby strange behavior
Title: Oracle standby strange behavior Vadim, Thanks for the input but I already made sure all arc files have been transferred and applied and that an 'alter system switch logfile' was executed prior to that. Yuval. -Original Message-From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle standby strange behavior Hi, Yuval. Did you make sure, you've got latest data transferred and applied? I bet, these two tables have largest OBJECT_ID in the original DB. Before you activate standby, do 1. On production SQL alter system switch logfile; 2. Transfer all archived logs to standby and make sure they are applied. Hopefully, no more problem. Vadim -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002 1:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle standby strange behavior Hi, I ran into a strange behavior of a standby database. On the primary db I have an application schema and a query schema. All tables from the appl schema have public synonyms and a grant select to public. User query is created with connect and resource roles. Once I switch over to the standby db , and put it in read only mode, and then connect to the query user, I can not perform a select against 2 of the 35 tables. I get object OBJECT_NAME does not exist. I can connect to the system user on the standby database and I have no problem selecting from all the tables. Any idea what am I missing?? Yuval. -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Performance Tuning Rachel IS kind but her words are also true and I think this was her main focus in this case. ;-) My Alomari book was for v7 and was good but is now dated... Is it up to date for 8i/9i? -Original Message- Sent: Wednesday, January 30, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Rachel, Thank you so much for you kind words and the very interesting comparison.. :) - Kirti -Original Message- Sent: Wednesday, January 30, 2002 9:50 AM To: Multiple recipients of list ORACLE-L I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's book (if you had to make a choice). the 101 book conforms most closely to Oracle's current thinking on performance tuning --- "SARKAR, Samir" [EMAIL PROTECTED] wrote: Practically, u should get two books to have a full grasp on Oracle Performance Tuning : 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari If u r in an exceptionally high development environment where u have lots of SQL tuning to do, consider buying the SQL High Performance Tuning by Don Burleson. Otherwise, the above two books should suffice for both production and development databases. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 30 January 2002 10:25 To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle Cerified DBA London *** Binay Kumar Focus 3 -Technical Support P O Nedllyod London 0044 207 441 1648 *** --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat Ci
