| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: URGENT: Trying to duplicate database from cold backup - auxi
We use RMAN all the time to duplicate our Production database to other databases, especially when there are production problems. I especially like the fact that we can do it in the daytime, while Production is running and capture changes made up to a point in time (based on the archive sequence# specified). Correct me if I'm wrong, but unless you are archiving, the "set until" statement is not required. We have duplicated non-logging databases as well as databases in archive mode. Duplicating from one server to another can be difficult but is possible. When we upgraded to our current Production server, we used RMAN backups. RMAN is a wonderful tool for backup/recovery. The use of the "set newname" command makes it even easier to clone using the same DB name or different. The only problem I've encountered is deleting old backup sets. Once old tapes have been removed from the tape library (using Veritas), the procedure to remove the backup pieces is more involved and "Good Luck" removi..
Belinda K. Taylor
Database Analyst, Database Support
Database Application Services, Technology Systems Division
Information Technology Unit
George Mason University
Office: (703) 993-3346
Fax: (703) 993-3403
attached mail follows:
ORACLE-L Digest Wed, 06 Aug 2003 Volume 2003, Number 218
In This Issue:
Subject Author ------------------------------------------- -------------------------------- Re: Unix process tree "Tanel Poder" <tanel.poder.003_at_m Re: Tuning ideas requested "Tanel Poder" <tanel.poder.003_at_m Re: what is BAARF? --- OFA Piet de Visser <piet.de.visser_at_l RE: More On 10G "Boivin, Patrice J" <BoivinP_at_mar Re: Tuning ideas requested "M Rafiq" <rafiq9857_at_hotmail.com Q. To RAC or go vertical tjambu_fatcity_at_yahoo.com.au RE: Q. To RAC or go vertical "Odland, Brad" <Brad.Odland_at_qtiw RE: what is BAARF? "Thater, William" <William.Thate RE: DECODE or not to DECODE Denham Eva <EvaD_at_TFMC.co.za> RE: 9i-OCP Question Stephen Lee <Stephen.Lee_at_DTAG.Co RE: drop user Stephen Lee <Stephen.Lee_at_DTAG.Co RE: More On 10G "Jesse, Rich" <Rich.Jesse_at_qtiwor RE: what is BAARF? "Wolfe Stephen S GS-11 6 MDSS/SG Re: oracle logical standby Joan Hsieh <joan.hsieh_at_tufts.edu RE: URGENT: Trying to duplicate database f DENNIS WILLIAMS <DWILLIAMS_at_LIFET RE: what is BAARF? --- OFA "Jesse, Rich" <Rich.Jesse_at_qtiwor RE: Q. To RAC or go vertical Stephen Lee <Stephen.Lee_at_DTAG.Co Using external Authentication with LDAP Munish Bajaj <mbajaj_at_quark.co.in Re: what is BAARF? --- OFA "Tanel Poder" <tanel.poder.003_at_m RE: URGENT: Trying to duplicate database f Paula_Stankus_at_doh.state.fl.us RE: URGENT: Trying to duplicate database f Paula_Stankus_at_doh.state.fl.us RE: URGENT: Trying to duplicate database f DENNIS WILLIAMS <DWILLIAMS_at_LIFET RE: Q. To RAC or go vertical Jared Still <jkstill_at_cybcon.com> tivoli/oracle monitoring Joe Testa <jtesta_at_dmc-it.com> OCP Question "Jay Wade" <fish_dba_at_hotmail.com Re: what is BAARF? --- OFA Tim Gorman <tim_at_sagelogix.com> RE: OCP Question "Mercadante, Thomas F" <NDATFM_at_l RE: 9i-OCP Question "Ron Thomas" <rthomas_at_hypercom.c RE: URGENT: Trying to duplicate database f Paula_Stankus_at_doh.state.fl.us RE: 9i - Dynamic SGA - SGA_MAX_SIZE Kirtikumar Deshpande <kirtikumar RE: Q. To RAC or go vertical "Matthew Zito" <mzito_at_gridapp.co Downloading patchests from Metalink "Mladen Gogala" <mladen_at_wangtrad Re: Opatch Kirtikumar Deshpande <kirtikumar RE: Opatch "Rognes, Sten" <Sten.Rognes_at_schw RE: 9i - Dynamic SGA - SGA_MAX_SIZE "Mladen Gogala" <mladen_at_wangtrad RE: what is BAARF? --- OFA "Jesse, Rich" <Rich.Jesse_at_qtiwor RE: URGENT: Trying to duplicate database f DENNIS WILLIAMS <DWILLIAMS_at_LIFET RE: Downloading patchests from Metalink "Jesse, Rich" <Rich.Jesse_at_qtiwor RE: Downloading patchests from Metalink "Nelson, Allan" <anelson_at_midf.co RE: Q. To RAC or go vertical Jared.Still_at_radisys.com RE: Downloading patchests from Metalink "Willett, Mark" <mwillett_at_sunnen RE: Q. To RAC or go vertical tjambu_fatcity_at_yahoo.com.au After Logon Trigger and Import Prasada.Gunda_at_hartfordlife.com Re: After Logon Trigger and Import Prasada.Gunda_at_hartfordlife.com Snapshot too old in undo tablespace in 9i? "Guerra, Abraham J" <AGUERRA_at_amf RE: Q. To RAC or go vertical tjambu_fatcity_at_yahoo.com.au RE: Q. To RAC or go vertical Jared.Still_at_radisys.com Re: Snapshot too old in undo tablespace in "Thomas Day" <tday6_at_csc.com> RE: Q. To RAC or go vertical tjambu_fatcity_at_yahoo.com.au RE: Q. To RAC or go vertical Stephen Lee <Stephen.Lee_at_DTAG.Co RE: 9i - Dynamic SGA - SGA_MAX_SIZE Stephen Lee <Stephen.Lee_at_DTAG.Co RE: Q. To RAC or go vertical tjambu_fatcity_at_yahoo.com.au RE: Snapshot too old in undo tablespace in "Guerra, Abraham J" <AGUERRA_at_amf RE: Q. To RAC or go vertical Stephen Lee <Stephen.Lee_at_DTAG.Co RE: Q. To RAC or go vertical "Odland, Brad" <Brad.Odland_at_qtiw RE: Q. To RAC or go vertical "Matthew Zito" <mzito_at_gridapp.co Re: Snapshot too old in undo tablespace in Daniel Fink <daniel.fink_at_sun.com RE: what is BAARF? --- OFA Kirtikumar Deshpande <kirtikumar RE: URGENT: Trying to duplicate database f Freeman Robert - IL <FREEMANR_at_tu RE: URGENT: Trying to duplicate database f Paula_Stankus_at_doh.state.fl.us RE: URGENT: Trying to duplicate database f DENNIS WILLIAMS <DWILLIAMS_at_LIFET RE: URGENT: Trying to duplicate database f Jared.Still_at_radisys.com RE: URGENT: Trying to duplicate database f Jared.Still_at_radisys.com RE: URGENT: Trying to duplicate database f DENNIS WILLIAMS <DWILLIAMS_at_LIFET RE: 9i - Dynamic SGA - SGA_MAX_SIZE Jessica Mao <jmao_at_portal.com> RE: URGENT: Trying to duplicate database f Freeman Robert - IL <FREEMANR_at_tu RE: URGENT: Trying to duplicate database f Freeman Robert - IL <FREEMANR_at_tu RE: 9i - Dynamic SGA - SGA_MAX_SIZE "Roger Xu" <roger_xu_at_dp7uptx.com RE: 9i - Dynamic SGA - SGA_MAX_SIZE Kirtikumar Deshpande <kirtikumar Re: Opatch Gilles PARC <gparc_at_online.fr> Re: Tuning ideas requested "Mark Richard" <mrichard_at_transur Log buffer and Shared Pool tuning. <Avnish.Rastogi_at_providence.org> RE: URGENT: Trying to duplicate database f Jared.Still_at_radisys.com RE: Opatch "MacGregor, Ian A." <ian_at_SLAC.St Re: More On 10G Brian_P_MacLean_at_eFunds.Com Re: URGENT: Trying to duplicate database f "Tanel Poder" <tanel.poder.003_at_m Re: After Logon Trigger and Import "Arup Nanda" <orarup_at_hotmail.com RE: Q. To RAC or go vertical Jack Daniels <ha_dba_at_yahoo.com> Re: After Logon Trigger and Import Prasada.Gunda_at_hartfordlife.com RE: Unix process tree Jeremy Bainbridge-Smith <BainbrJ ------------------------------------------------------------
From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
Date: Tue, 5 Aug 2003 12:21:05 +0300
Subject: Re: Unix process tree
This is a multi-part message in MIME format.
------=_NextPart_000_07F6_01C35B4C.0B228680 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Unix process treeRedhat AS 2.1 at least has something, probably others as well. It's "pstree" if I recall correctly.
Also, ps has some options to print process dependencies out.
Tanel.
Hi Team
Firstly apologies for a slightly OT question.
Solaris has a great little command called "ptree" which given a process id as an argument, will present a tree of all the process' related to the given process id.
Question: Is there a similar command for Linux?
Cheers
Jeremy
Ph. +64 7 838 6428
Mob. +64 21 894481
------=_NextPart_000_07F6_01C35B4C.0B228680 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Unix process tree</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#e0e0e0>
<DIV><FONT face=Arial size=2>Redhat AS 2.1 at least has something, probably
others as well. It's "pstree" if I recall correctly.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Also, ps has some options to print process
dependencies out.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Tanel.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=BainbrJ_at_hcc.govt.nz href="mailto:BainbrJ_at_hcc.govt.nz">Jeremy
Bainbridge-Smith</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=ORACLE-L_at_fatcity.com
href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, August 05, 2003 5:49
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Unix process tree</DIV> <DIV><BR></DIV> <P><FONT face=Arial size=2>Hi Team</FONT> </P> <P><FONT face=Arial size=2>Firstly apologies for a slightly OTquestion.</FONT> </P>
<P><FONT face="Courier New" size=2>~~~~~~~~~~~~~~~~~~~~~~~~</FONT> <BR><FONT face="Courier New" size=2>Jeremy Bainbridge-Smith</FONT> <BR><FONTface="Courier New" size=2>Database Administrator</FONT> <BR><FONT face="Courier New" size=2>Hamilton City Council</FONT> </P> <P><FONT face="Courier New" size=2>Ph. +64 7 838 6428</FONT> <BR><FONT face="Courier New" size=2>Mob. +64 21 894481</FONT> <BR><FONT
face="Courier New" size=2>~~~~~~~~~~~~~~~~~~~~~~~</FONT>
------=_NextPart_000_07F6_01C35B4C.0B228680--
From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
Date: Tue, 5 Aug 2003 13:34:16 +0300
Subject: Re: Tuning ideas requested
Hi!
How much memory do you have in server? With sort_area_size of 1GB,
hash_area_size will default to 2GB.
When looking at your execution plan, I think that there are two slaves for
reading data (one for each table), two slaves for doing hash join (both can
allocate up to 2GB for hashing!) and after first slaves have finished, these
can start order by (can allocate additional 1GB memory per slave, or even
more in some circumstances!).
Thus, if you don't have that much memory in your server, go with smaller sort_area_size. But, since you are forcing hash join, setting hash_area_size too small will degrade joins performance and hit your temporary tablespace IO a lot. You should have analyzed your data well and should trace hash joins with event 10104, to at least verify you don't have "Number of rows iterated over" lines in your trace file (I means that because of incorrect statistics and small hash_area_size even a single build partition doesn't fit into memory and the same probe partition has to be re-read again and again for every part of build partition).
You can get parallel execution & table queue information from v$pq_tqstat - but I believe you have to run your query (with small amount of rows) first, then check the view in the same session where you executed your query.
Btw, is your IO fast enough to cope with this kind of parallel degree? You should also test, what happens with smaller degree, or modifying your cursors to perform serial operations in parallel on different sets of data. Actually, you should first look at insert /*+ APPEND PARALLEL */ select .... statement without any pl/sql cursors and cursor loops to move data to another tablespace and create additional columns, it can be a lot faster, especially with parallel execution.
Btw, I wouldn't delete records from temporary product listing table, I'd just update some rows status to say that it's corresponding values have been processed...
Tanel.
> ERROR at line 8: > ORA-12801: error signaled in parallel query server P001 > ORA-04030: out of process memory when trying to allocate 8192 bytes (sort > subheap,sort key) > > An autotrace of the 100,000 execution provided the following: > > Execution Plan > ---------------------------------------------------------- > 0 SELECT STATEMENT Optimizer OOSE (Costs9255 Card™979 By > tesY98740) > > 1 0 WINDOW* (SORT) > :Q607440 > 03 > > 2 1 HASH JOIN* (Costs8220 Card™979 BytesY98740) > :Q607440 > 02 > > 3 2 TABLE ACCESS* (FULL) OF 'DRIVING' (Costv1 Card™979 By > :Q607440 > tes99685) 00 > > 4 2 TABLE ACCESS* (FULL) OF 'HISTORY' (Costs7374 :Q607440 > Card9171321 Bytesg12709445) 01 > Statistics > ---------------------------------------------------------- > 229 recursive calls > 2811 db block gets > 4875215 consistent gets > 5055303 physical reads > 652 redo size > 1297355183 bytes sent via SQL*Net to client > 117980660 bytes received via SQL*Net from client > 1062887 SQL*Net roundtrips to/from client > 12 sorts (memory) > 2 sorts (disk) > 15943284 rows processed > > This is being executed on Oracle 8.1.7.4 on a 6-CPU Sun E4500. The test > query was executed using SQL*Plus locally on the server using "set > autotrace traceonly". During the actual execution another similarly > demanding, yet different, script may also be executed. > > Questions: > 1) Does my approach (cursoring through several iterations to manage sort > size) seem valid? Is there a better approach? > 2) Are there other parameters to consider tuning to suit this type of > query? Normally this is a busy OLTP system with a 2M sort area size sothe
> system isn't configured for this type of query normally. > 3) Is there anything in particular I should be monitoring? I was watching > "DML Processes" using TOAD during the first execution and it appeared that > only 1 or 2 parallel slaves were reading at any one time - is this > expected? > > Thanks for your advice. In return, I will write a summary when the > exercise is complete. > > Regards, > Mark. > >>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>> > Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message > (or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender > by reply e-mail or by telephone on (61 3) 9612-6999. > Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it.
>>>> > > > > >
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: mrichard_at_transurban.com.au > > 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: ListGuru_at_fatcity.com (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). >
From: Piet de Visser <piet.de.visser_at_logicacmg.com>
Date: Tue, 5 Aug 2003 12:41:47 +0200
Subject: Re: what is BAARF? --- OFA
Tim, James, Mogens, Group,
Another BAARF advocate here...
However, I recognize Tim's problem when HW vendors:
a) push raid5 or some form of autoraid.
b) push for 8 separate disks of 125G each with only redo-files on them...
While the BAARF initiative should continue in its simple, elegant and forcefull form (hammer the msg home), I want to place a call to Gary, Tim and others, to undertake A Revamp of the original OFA paper.
Determine the new requirements (most of the old ones still stand!) and from the requirements, enhance the OFA-structure. It should take into account:
Any Takers ?
Any ideas for a joint-effort ?
Regards,
PdV
Oracle DBA.
DTMWFI, FWIW, JMTC and YMWV (of course it will)
PS: Frustration cost me my lunch break.
Me too, Got bitten badly by a hardware vendor recently for _not_
putting aside 35% of my multi-TB disk-capacity exclusively for redos.
Salesman dreams to sell an additional nr of disks at 5% utilization
because of the trueism:
"redo files should be on private, physical, devices".
He even knew of OFA, the Oracle-FILE-Architecture :-).
Any advertising, as long as they spell the name right....
From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 05 Aug 2003 07:39:59 -0300
Subject: RE: More On 10G
Oracle 12???
Patrice.
-----Original Message-----
Sent: Monday, August 04, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L
Came across this article thought the group might be interested. Any ideas on a release date for 10G, I know they are going to unveil it at OpenWorld, any quess on the release date?
http://www.eweek.com/article2/0,3959,1209597,00.asp
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: fish_dba_at_hotmail.com 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: ListGuru_at_fatcity.com (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). ------------------------------ From: "M Rafiq" <rafiq9857_at_hotmail.com> Date: Tue, 05 Aug 2003 07:17:45 -0400 Subject: Re: Tuning ideas requested I shall add one more thing..In case of hash join/parallel sorts also watch usage of temp tablespace which may go very high with large sorts and may require a alrge temp tablespace. Regards Rafiq Reply-To: ORACLE-L_at_fatcity.com To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 05 Aug 2003 03:34:24 -0800 Hi! How much memory do you have in server? With sort_area_size of 1GB, hash_area_size will default to 2GB. When looking at your execution plan, I think that there are two slaves for reading data (one for each table), two slaves for doing hash join (both can allocate up to 2GB for hashing!) and after first slaves have finished, these can start order by (can allocate additional 1GB memory per slave, or even more in some circumstances!). Thus, if you don't have that much memory in your server, go with smaller sort_area_size. But, since you are forcing hash join, setting hash_area_size too small will degrade joins performance and hit your temporary tablespace IO a lot. You should have analyzed your data well and should trace hash joins with event 10104, to at least verify you don't have "Number of rows iterated over" lines in your trace file (I means that because of incorrect statistics and small hash_area_size even a single build partition doesn't fit into memory and the same probe partition has to be re-read again and again for every part of build partition). You can get parallel execution & table queue information from v$pq_tqstat - but I believe you have to run your query (with small amount of rows) first, then check the view in the same session where you executed your query. Btw, is your IO fast enough to cope with this kind of parallel degree? You should also test, what happens with smaller degree, or modifying your cursors to perform serial operations in parallel on different sets of data. Actually, you should first look at insert /*+ APPEND PARALLEL */ select .... statement without any pl/sql cursors and cursor loops to move data to another tablespace and create additional columns, it can be a lot faster, especially with parallel execution. Btw, I wouldn't delete records from temporary product listing table, I'd just update some rows status to say that it's corresponding values have been processed... Tanel. > ERROR at line 8: > ORA-12801: error signaled in parallel query server P001 > ORA-04030: out of process memory when trying to allocate 8192 bytes (sort > subheap,sort key) > > An autotrace of the 100,000 execution provided the following: > > Execution Plan > ---------------------------------------------------------- > 0 SELECT STATEMENT Optimizer OOSE (Costs9255 Card™979 By > tesY98740) > > 1 0 WINDOW* (SORT) > :Q607440 > 03 > > 2 1 HASH JOIN* (Costs8220 Card™979 BytesY98740) > :Q607440 > 02 > > 3 2 TABLE ACCESS* (FULL) OF 'DRIVING' (Costv1 Card™979 By > :Q607440 > tes99685) 00 > > 4 2 TABLE ACCESS* (FULL) OF 'HISTORY' (Costs7374 :Q607440 > Card9171321 Bytesg12709445) 01 > Statistics > ---------------------------------------------------------- > 229 recursive calls > 2811 db block gets > 4875215 consistent gets > 5055303 physical reads > 652 redo size > 1297355183 bytes sent via SQL*Net to client > 117980660 bytes received via SQL*Net from client > 1062887 SQL*Net roundtrips to/from client > 12 sorts (memory) > 2 sorts (disk) > 15943284 rows processed > > This is being executed on Oracle 8.1.7.4 on a 6-CPU Sun E4500. The test > query was executed using SQL*Plus locally on the server using "set > autotrace traceonly". During the actual execution another similarly > demanding, yet different, script may also be executed. > > Questions: > 1) Does my approach (cursoring through several iterations to manage sort > size) seem valid? Is there a better approach? > 2) Are there other parameters to consider tuning to suit this type of > query? Normally this is a busy OLTP system with a 2M sort area size so the > system isn't configured for this type of query normally. > 3) Is there anything in particular I should be monitoring? I was watching > "DML Processes" using TOAD during the first execution and it appeared that > only 1 or 2 parallel slaves were reading at any one time - is this > expected? > > Thanks for your advice. In return, I will write a summary when the > exercise is complete. > > Regards, > Mark. > >Received on Wed Aug 06 2003 - 08:44:25 CDT
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>> > Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message > (or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender > by reply e-mail or by telephone on (61 3) 9612-6999. > Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. >
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>> > > > > >
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> > Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. > In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. > Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. >
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: mrichard_at_transurban.com.au > > 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: ListGuru_at_fatcity.com (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: tanel.poder.003_at_mail.ee 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page%features/featuredemail ------------------------------ From: tjambu_fatcity_at_yahoo.com.au Date: Tue, 05 Aug 2003 21:37:58 +1000 Subject: Q. To RAC or go vertical --===========_2643200=_.ALT Content-Type: text/plain; charset="us-ascii" Hi All I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu) Background Txn - OLTP like txn during day but batch extracts at night and very big batch extract periodically Data Volume - 5-10 TByte Data volatility - 99 % of data is very much like a ware house (unchanged) other 1% is read/update/delete/insert Options 1. Say a very large server like a HP Superdome or SUN E12000 with 8 CPUs Server already exist so cost is in obtaining additional CPU/Blades ie Traditional Server using plain old vanilla Oracle EE - can still increase head room. - batch programs can utilise all 8 CPUs - storage system need not cater for clustering 2, Same large server like a HP Superdome or SUN E12000 but partitioned into two. Each with 4 CPU. Oracle RDBMS + RAC option - storage server need to cater for cluster config - max performance for batch is with 4 CPUs only Which would you prefer and why. I am not convinced with the RAC option. Now if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and purchase say 4 nodes of 4 cpus each, that would be a different story. In this case I have the equipment and ability to grow vertically. ta tony --===========_2643200=_.ALT Content-Type: text/html; charset="us-ascii"
<html>
Hi All<br><br> I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu)<br><br>
<u>Background<br><br>
</u>Txn - OLTP like txn during day but batch extracts at night and <br>
<x-tab> </x-tab>very big
batch extract periodically<br> Data Volume - 5-10 TByte<br> Data volatility - 99 % of data is very much like a ware house (unchanged)<br>
<x-tab> </x-tab><x-tab> </x-tab>other
1% is read/update/delete/insert<br><br> Options<br> 1. Say a very large server like a HP Superdome or SUN E12000<br>
<x-tab> </x-tab>with 8
CPUs<br>
<x-tab> </x-tab>Server
already exist so cost is in obtaining additional CPU/Blades<br>
<x-tab> </x-tab>ie
Traditional Server using plain old vanilla Oracle EE<br>
<x-tab> </x-tab>- can
still increase head room. <br>
<x-tab> </x-tab>- batch
programs can utilise all 8 CPUs<br>
<x-tab> </x-tab>- storage
system need not cater for clustering<br><br> 2, Same large server like a HP Superdome or SUN E12000 but partitioned<br>
<x-tab> </x-tab>into two.
Each with 4 CPU.<br>
<x-tab> </x-tab>Oracle
RDBMS + RAC option<br>
<x-tab> </x-tab>- storage
server need to cater for cluster config<br>
<x-tab> </x-tab>- max
performance for batch is with 4 CPUs only<br><br>
<br>
Which would you prefer and why. I am not convinced with the RAC option. Now<br> if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and<br> purchase say 4 nodes of 4 cpus each, that would be a different story. In this case<br> I have the equipment and ability to grow vertically.<br><br> ta<br> tony<br><br>
<br><br>
</html>
--===========_2643200=_.ALT-- ------------------------------ From: "Odland, Brad" <Brad.Odland_at_qtiworld.com> Date: Tue, 5 Aug 2003 07:54:47 -0500 Subject: RE: Q. To RAC or go vertical This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35B50.C0370B50 Content-Type: text/plain; charset="iso-8859-1" RAC - Intel is not yet proven as far as I can tell. So be very cautious about choosing this path for such a large project. I would probably stick with the big box and concentrate on as fast as IO as possible. No wait please do the RAC with Intel quads, figure out all the bugs and pitfalls and then let us know so we can avoid them... :) (We are in the process now of getting a lab setup with RAC and Intel to do some testing.) Brad O. -----Original Message----- Sent: Tuesday, August 05, 2003 7:30 AM To: Multiple recipients of list ORACLE-L Hi All I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu) Background Txn - OLTP like txn during day but batch extracts at night and very big batch extract periodically Data Volume - 5-10 TByte Data volatility - 99 % of data is very much like a ware house (unchanged) other 1% is read/update/delete/insert Options 1. Say a very large server like a HP Superdome or SUN E12000 with 8 CPUs Server already exist so cost is in obtaining additional CPU/Blades ie Traditional Server using plain old vanilla Oracle EE - can still increase head room. - batch programs can utilise all 8 CPUs - storage system need not cater for clustering 2, Same large server like a HP Superdome or SUN E12000 but partitioned into two. Each with 4 CPU. Oracle RDBMS + RAC option - storage server need to cater for cluster config - max performance for batch is with 4 CPUs only Which would you prefer and why. I am not convinced with the RAC option. Now if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and purchase say 4 nodes of 4 cpus each, that would be a different story. In this case I have the equipment and ability to grow vertically. ta tony ------_=_NextPart_001_01C35B50.C0370B50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3502.5390" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=140394912-05082003>RAC -
Intel is not yet proven as far as I can tell. So be very cautious about choosing this path for such a large project.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=140394912-05082003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=140394912-05082003>I
would probably stick with the big box and concentrate on as fast as IO as possible. No wait please do the RAC with Intel quads, figure out all the bugs and pitfalls and then let us know so we can avoid them... :)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=140394912-05082003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=140394912-05082003>(We
are in the process now of getting a lab setup with RAC and Intel to do some testing.)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=140394912-05082003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=140394912-05082003>Brad
O.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=140394912-05082003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=140394912-05082003></SPAN></FONT> </DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> tjambu_fatcity_at_yahoo.com.au [mailto:tjambu_fatcity_at_yahoo.com.au]<BR><B>Sent:</B> Tuesday, August 05, 2003 7:30 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Q. To RAC or go vertical<BR><BR></DIV></FONT>Hi All<BR><BR>I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu)<BR><BR><U>Background<BR><BR></U>Txn - OLTP like txn during day but batch extracts at night and <BR><X-TAB> </X-TAB>very big batch extract periodically<BR>Data Volume - 5-10 TByte<BR>Data volatility - 99 % of data is very much like a ware house (unchanged)<BR><X-TAB> </X-TAB><X-TAB> </X-TAB>other 1% is read/update/delete/insert<BR><BR>Options<BR>1. Say a very large server like a HP Superdome or SUN E12000<BR><X-TAB> </X-TAB>with 8 CPUs<BR><X-TAB> </X-TAB>Server already exist so cost is in obtaining additional CPU/Blades<BR><X-TAB> </X-TAB>ie Traditional Server using plain old vanilla Oracle EE<BR><X-TAB> </X-TAB>- can still increase head room. <BR><X-TAB> </X-TAB>- batch programs can utilise all 8 CPUs<BR><X-TAB> </X-TAB>- storage system need not cater for clustering<BR><BR>2, Same large server like a HP Superdome or SUN E12000 but partitioned<BR><X-TAB> </X-TAB>into two. Each with 4 CPU.<BR><X-TAB> </X-TAB>Oracle RDBMS + RAC option<BR><X-TAB> </X-TAB>- storage server need to cater for cluster config<BR><X-TAB> </X-TAB>- max performance for batch is with 4 CPUs only<BR><BR><BR>Which would you prefer and why. I am not convinced with the RAC option. Now<BR>if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and<BR>purchase say 4 nodes of 4 cpus each, that would be a different story. In this case<BR>I have the equipment and ability to grow vertically.<BR><BR>ta<BR>tony<BR><BR><BR><BR></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C35B50.C0370B50-- ------------------------------ From: "Thater, William" <William.Thater_at_carrier.utc.com> Date: Tue, 5 Aug 2003 08:51:31 -0400 Subject: RE: what is BAARF? Rachel Carmichael scribbled on the wall in glitter crayon: > if nominated I will not run, if elected I shall not serve.... but think of the distraction if you wear THE DRESS.;-) -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 william.thater_at_carrier.utc.com ------------------------------------------------------------------------ There's nothing I like less than bad arguments for a view that I hold dear. - Daniel Dennett ------------------------------ From: Denham Eva <EvaD_at_TFMC.co.za> Date: Tue, 5 Aug 2003 15:03:43 +0200 Subject: RE: DECODE or not to DECODE Thanks To all for the support! I managed to use a combination of thesuggestions which worked great! Denham -----Original Message----- Sent: Monday, August 04, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Hello Listers, I need some help please, I am trying to create a DECODE statement, on a date column and looks something like this, but does not work. SELECT COL1, COL2, DECODE((SYSDATE - COL_DATE), <= 30, '30_days', NULL) Days30, DECODE((SYSDATE - COL_DATE), (between 31 and 60), '60 Days', NULL) Days60, ...... ...... FROM ACCOUNT_TBL WHERE COL = '0' Obviously, I have worked out that this can not be done. The problem is also that the server is 7.3.4 and I need to use the code in a view. Does anyone have any solutions/work arounds for this? Any help will be appraciated. TIA Denham Eva Oracle DBA ____________________________________________________________________________ _________ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com ____________________________________________________________________________ _________ ############################################################################ ######### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: EvaD_at_TFMC.co.za 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: ListGuru_at_fatcity.com (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 e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com ____________________________________________________________________________ _________ _____________________________________________________________________________________ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _____________________________________________________________________________________ ##################################################################################### Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. ------------------------------ From: Stephen Lee <Stephen.Lee_at_DTAG.Com> Date: Tue, 5 Aug 2003 08:11:54 -0500 Subject: RE: 9i-OCP Question There is scientific research that shows that moderate consumption of alcohol while learning and while testing improves scores. NOW you have a good excuse! > -----Original Message----- > > In high school, I took the SAT exams and got a great score, > enough to be > satisfied with. My guidance counselor insisted I gild the > lily and take the > exams again. I showed up that morning with no sleep, a > throbbing hangover, > and eyes looking like fried eggs pasted to my head... > > ...scored 60 points better... > > > > on 8/4/03 11:49 AM, Stephen Lee at Stephen.Lee_at_DTAG.Com wrote: > > > > > An invaluable aid for test taking is -- I learned this when > I took Organic > > Chemistry -- bourbon in water with ice in your favorite > convenience drink > > cup. Everyone at the test site is sure you have a soft drink. > > > >> -----Original Message----- > >> > >> Experience with various flavors of storage technology plus a > >> decade of DBA > >> experience can't possibly prepare me for what I haven't read > >> (i.e. "Oracle's > >> recommendations"). In a multiple-choice test format, unlike > >> real life, I > >> can't possibly argue with what Oracle has recommended... > >> > >> No wonder I failed my first try at the 9iOCP upgrade exam. > >> Yes, I'll try > >> again, once the lobotomy scars heal... > >> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > INET: tim_at_sagelogix.com > > 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: ListGuru_at_fatcity.com (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). > ------------------------------ From: Stephen Lee <Stephen.Lee_at_DTAG.Com> Date: Tue, 5 Aug 2003 08:14:20 -0500 Subject: RE: drop user Not Elizabeth Hurley ... :-))))))) !! > -----Original Message----- > > > Everything looks like a big hammer to you, > doesn't it Stephen? > > ;) > \ ------------------------------ From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> Date: Tue, 5 Aug 2003 08:15:00 -0500 Subject: RE: More On 10G That's 12X -- eXtreme databasing!!!!! (eXtra bangs added for eXtra emphasis) I just wish some software company -- ANY software company -- would get the bugs out before feature-creeping and bloating the hell out of a product.
<sigh>
Rich Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] > Sent: Tuesday, August 05, 2003 6:49 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: More On 10G > > > Oracle 12??? > > Patrice. > > -----Original Message----- > Sent: Monday, August 04, 2003 2:24 PM > To: Multiple recipients of list ORACLE-L > > > Came across this article thought the group might be interested. > Any ideas on a release date for 10G, I know they are going to > unveil it at > OpenWorld, any quess on the release date? > > > http://www.eweek.com/article2/0,3959,1209597,00.asp ------------------------------ From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <Stephen.Wolfe_at_macdill.af.mil> Date: Tue, 5 Aug 2003 08:20:42 -0500 Subject: RE: what is BAARF? This is a multi-part message in MIME format. ------_=_NextPart_001_01C35B54.5F08CB0D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Interesting discussion. this is the first time I have seen objections to RAID technology. My cohort in crime, my senior developer (Lee Achorn), and I discussed this at length yesterday and without knowing the compelling arguments came to the conclusion that at least for a database system that maintains transaction logs (are these Redo logs for Oracle?) on off-server real estate and a good back up regimen is in place then why would one need RAID 5? We are running RAID 5 here at MacDill and we have had 4 single disk failures in the last 14 months. The rebuild time has essentially been 45 minutes to 90 minutes with degraded server operations. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager stephen.wolfe_at_macdill.af.mil (813) 827-9974 DSN 651-9974 -----Original Message----- Sent: Monday, August 04, 2003 6:49 PM To: Multiple recipients of list ORACLE-L It is good to see Oracle and Informix DBAs agree on something once in a while. Art Kagel and many others from the Informix list have been fighting the good fight for a long time. http://www.smooth1.demon.co.uk/ifaq06.htm#6.58 I sent this baarf link to a former co-worker still in the Informix world. I got this response: Bob, That is impeccable timing. I was in Dallas last week with Victor and James looking at SAN systems from Hitachi and IBM. Both vendors were heavily pushing RAID-5 and treated me like a leper when I objected. Troy. My question is what to do from a practical point of view. How have others approached convincing management that RAID 5 is the devil. I guess what I want is a list of the most effective questions and facts that will make these vendors look like idiots when they refuse to give up on RAID 5. -----Original Message----- Sent: Monday, August 04, 2003 2:29 PM To: Multiple recipients of list ORACLE-L See www.baarf.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- rgaffuri_at_cox.net Sent: Monday, August 04, 2003 1:20 PM To: Multiple recipients of list ORACLE-L I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <rgaffuri_at_cox.net INET: rgaffuri_at_cox.net 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: ListGuru_at_fatcity.com (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: Cary Millsap INET: cary.millsap_at_hotsos.com 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: ListGuru_at_fatcity.com (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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ------_=_NextPart_001_01C35B54.5F08CB0D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=324412312-05082003><FONT color=#0000ff>Interesting
discussion. this is the first time I have seen objections to RAID technology. My cohort in crime, my senior developer (Lee Achorn), and I discussed this at length yesterday and without knowing the compelling arguments came to the conclusion that at least for a database system that maintains transaction logs (are these Redo logs for Oracle?) on off-server real estate and a good back up regimen is in place then why would one need RAID 5?</FONT></SPAN></DIV>
<DIV><SPAN class=324412312-05082003><FONT
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=324412312-05082003><FONT color=#0000ff>We are running RAID 5
here at MacDill and we have had 4 single disk failures in the last 14 months. The rebuild time has essentially been 45 minutes to 90 minutes with degraded server operations.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV>
<P><B><FONT face=Arial color=#0000ff size=2>v/r</FONT></B> </P>
<P><B><FONT face=Arial color=#0000ff size=2>Stephen S. Wolfe, GS-11,
DAFC</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>Data Services Manager</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>stephen.wolfe_at_macdill.af.mil</FONT></B> <BR><B><FONT face=Arial color=#0000ff size=2>(813) 827-9974 DSN 651-9974</FONT></B> </P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Bob Lofstrand [mailto:blofstrand_at_csedge.com] <BR><B>Sent:</B> Monday, August 04, 2003 6:49 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: what is BAARF?<BR><BR></FONT></DIV> <P><FONT size=2>It is good to see Oracle and Informix DBAs agree on something once in a while.</FONT> <BR><FONT size=2>Art Kagel and many others from the Informix list have been fighting the good fight for a long time.</FONT> <BR><FONT size=2><A href="http://www.smooth1.demon.co.uk/ifaq06.htm#6.58" target=_blank>http://www.smooth1.demon.co.uk/ifaq06.htm#6.58</A></FONT> </P> <P><FONT size=2>I sent this baarf link to a former co-worker still in the Informix world. I got this response:</FONT> </P> <P><FONT size=2>Bob,</FONT> </P> <P><FONT size=2>That is impeccable timing. I was in Dallas last week with Victor and James looking at SAN systems from Hitachi and IBM. Both vendors were heavily pushing RAID-5 and treated me like a leper when I objected. </FONT></P> <P><FONT size=2>Troy.</FONT> </P> <P><FONT size=2>My question is what to do from a practical point of view. How have others approached convincing management that RAID 5 is the devil. I guess what I want is a list of the most effective questions and facts that will make these vendors look like idiots when they refuse to give up on RAID 5.</FONT></P> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Cary Millsap [<A href="mailto:cary.millsap_at_hotsos.com">mailto:cary.millsap_at_hotsos.com</A>]</FONT> <BR><FONT size=2>Sent: Monday, August 04, 2003 2:29 PM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: what is BAARF?</FONT> </P><BR> <P><FONT size=2>See www.baarf.com. </FONT></P><BR> <P><FONT size=2>Cary Millsap</FONT> <BR><FONT size=2>Hotsos Enterprises, Ltd.</FONT> <BR><FONT size=2><A href="http://www.hotsos.com" target=_blank>http://www.hotsos.com</A></FONT> </P> <P><FONT size=2>Upcoming events:</FONT> <BR><FONT size=2>- Hotsos Clinic 101 in Denver, Sydney</FONT> <BR><FONT size=2>- Hotsos Symposium 2004, March 7-10 Dallas</FONT> <BR><FONT size=2>- Visit www.hotsos.com for schedule details...</FONT> </P><BR> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>rgaffuri_at_cox.net</FONT> <BR><FONT size=2>Sent: Monday, August 04, 2003 1:20 PM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> </P> <P><FONT size=2>I see it here all the time. Any articles on it? Im assuming its some</FONT> <BR><FONT size=2>kind of storage system right? </FONT></P> <P><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.net" target=_blank>http://www.orafaq.net</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: <rgaffuri_at_cox.net</FONT> <BR><FONT size=2> INET: rgaffuri_at_cox.net</FONT> </P> <P><FONT size=2>Fat City Network Services -- 858-538-5051 <A href="http://www.fatcity.com" target=_blank>http://www.fatcity.com</A></FONT> <BR><FONT size=2>San Diego, California -- Mailing list and web hosting services</FONT> <BR><FONT size=2>---------------------------------------------------------------------</FONT> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>also send the HELP command for other information (like subscribing).</FONT>
</P><BR>
<P><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.net" target=_blank>http://www.orafaq.net</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: Cary Millsap</FONT> <BR><FONT size=2> INET: cary.millsap_at_hotsos.com</FONT> </P> <P><FONT size=2>Fat City Network Services -- 858-538-5051 <A href="http://www.fatcity.com" target=_blank>http://www.fatcity.com</A></FONT> <BR><FONT size=2>San Diego, California -- Mailing list and web hosting services</FONT> <BR><FONT size=2>---------------------------------------------------------------------</FONT> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>also send the HELP command for other information (like subscribing).</FONT> </P> <TABLE> <TBODY> <TR> <TD bgColor=#ffffff><FONT color=#000000><PRE>The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
</PRE></FONT></TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C35B54.5F08CB0D-- ------------------------------ From: Joan Hsieh <joan.hsieh_at_tufts.edu> Date: Tue, 05 Aug 2003 09:32:46 -0400 Subject: Re: oracle logical standby Thanks Paul, Paul Baumgartel wrote: > > My mistake, it's the doc set that came with 9.2.0.2.0: > > download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ls.htm#1073769 > > --- Joan Hsieh <joan.hsieh_at_tufts.edu> wrote: > > Hi Paul, > > > > Do you have url handy on the subject how to setup the logical standby > > database? I had trouble to find the 9.2.3 doc. I really appreciate > > for > > your help. > > > > Joan > > > > Paul Baumgartel wrote: > > > > > > We were going to use logical standby but quickly abandoned the idea > > > after testing. > > > > > > 1. The APPLY process on the standby crashed regularly (every 10 > > > minutes or so). Oracle claimed it was a fixed bug, but there was > > no > > > port to Windows, so we'd have had either to wait for the next RDBMS > > > release or request a patch...with implementation a month or so > > away, we > > > didn't want to take the chance. > > > 2. DDL in the apply stream is problematic, also causing apply > > slave > > > crashes. > > > 3. Performance of the apply slave is horrendous. Since Logical > > > Standby uses LogMiner to construct SQL statements from redo > > > information, and since redo information consists of block change > > > vectors, a 10,000-row delete in the redo becomes...10,000 DELETE > > > statements in the apply process. I found that the time for > > application > > > of changes on the standby was about an order of magnitude greater > > than > > > the time taken for the original changes on the master; and this was > > > after applying a few (but not all) of Oracle's standby tuning > > > suggestions. > > > > > > Also, we are planning to use Oracle Label Security, but it is not > > > compatible with Logical Standby. > > > > > > There are a number of Documentation bugs (including bugs in Notes > > > posted on MetaLink that are supposed to correct earlier Doco bugs!) > > in > > > the sections regarding how to set up a logical standby; be sure you > > > follow the 9.2.0.3.0 docs' instructions for that. Don't use the > > notes > > > on MetaLink! > > > > > > Now, for the good stuff. > > > > > > Well, it worked sometimes.... > > > > > > Really, it's a brand-new feature, and performs as brand-new Oracle > > > features typically do--it's buggy and it's slow. > > > > > > Well, > > > > > > --- "Loughmiller, Greg" <Greg.Loughmiller_at_cingular.com> wrote: > > > > folks - > > > > listening to a preso from a vendor where they will use logical > > > > standby to > > > > accomplish some of the 99.999999999999999 availability > > > > requirements... so > > > > I'm wondering, does anyone have some extensive experience with > > the > > > > logical > > > > standby to share? the good stuff, the bad stuff, pitfalls, > > gotcha's, > > > > and > > > > general things to run away from.. Then on the other hand-what > > things > > > > should > > > > someone try to leverage? > > > > > > > > thanks in advance! > > > > > > > > > > > > Greg Loughmiller > > > > > > > > > > > > > > > > > > ==> > > Paul Baumgartel > > > Transcentive, Inc. > > > www.transcentive.com > > > > > > __________________________________ > > > 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: Paul Baumgartel > > > INET: treegarden_at_yahoo.com > > > > > > 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: ListGuru_at_fatcity.com (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: Joan Hsieh > > INET: joan.hsieh_at_tufts.edu > > > > 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Paul Baumgartel > INET: treegarden_at_yahoo.com > > 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: ListGuru_at_fatcity.com (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). ------------------------------ From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Date: Tue, 5 Aug 2003 08:39:33 -0500 Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was "imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database". Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -----Original Message-----
<mailto:FREEMANR_at_tusc.com> ]
Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > ]
Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -----Original Message----- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -----Original Message----- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
-- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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). ------------------------------ From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> Date: Tue, 5 Aug 2003 08:48:31 -0500 Subject: RE: what is BAARF? --- OFA Not a "taker", but I'll put in my disdain for OFA, taken from the OFA doc at http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm : 1) Who in their right minds thought it was a good idea to name the redos with a ".log" extention? It's asking for trouble, if not from a DBA, then from an SA or a script that's used to clean up old log files. Why the risk? 2) For similar reasons, I refuse to create the database files under $ORACLE_BASE. How often does a DBA peruse that file tree? Daily, for me. Put them on a separate directory off of "/" on Unix, or their own drive letter for Winders. Then, anyone wanting to mess with the files from the O/S level usually needs to go there on purpose and not by accident (unless "root" does an "rm -R *" from "/", in which case there ain't a whole lot you can do anyway). 3) Having the administrative directory structure (table G-8 on the above link) is impractical at best, and dangerous at worst. If you lose one MP (mount point; one set of drives), you lose all instances. To prevent this, you'd need to create SEVERAL MPs for each DB, even on a small system. This just isn't going to happen. Instead, we make an "admin" directory under $ORACLE_BASE, then a "DBNAME" directory for each DB underneath that. The appropriate adump, bdump, cdump, udump, pfile, etc. directories are then created for each DBNAME. Then, if necessary, each DBNAME directory can have their own MP, for recoverability and scalability (I wouldn't stretch it to include "performance"!). 4) I think the "/u01", "/u02", etc. MP naming is a pain. They mean nothing. In a disaster recovery, the last thing you want is to have someone forget what "/u01" is. This is the 21st century, people! We have the power to NAME DIRECTORIES something meaningful! NOFA! :) Rich Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Piet de Visser [mailto:piet.de.visser_at_logicacmg.com] > Sent: Tuesday, August 05, 2003 6:39 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: what is BAARF? --- OFA > > > Tim, James, Mogens, Group, > > Another BAARF advocate here... > > However, I recognize Tim's problem when HW vendors: > a) push raid5 or some form of autoraid. > b) push for 8 separate disks of 125G each with only > redo-files on them... > > While the BAARF initiative should continue in its simple, > elegant and forcefull form (hammer the msg home), > I want to place a call to Gary, Tim and others, > to undertake A Revamp of the original OFA paper. > > Determine the new requirements (most of the old ones still stand!) > and from the requirements, enhance the OFA-structure. > It should take into account: > - SAN capabilities (snapshotting and snapshot-logs or caches) > - RAC and Clustered file systems, anticipate on 10G. > - easy of admin: single point of admin per database, not per > instance. > - make provisions for (physical) copies > (acceptance/testing/development) > - standby-db constructions (including for RAC-dbs, and > favour good-old-and-simple sqlplus ;-). > - Weigh the importance of redo-speed against things like > archive-storage and recoverability based on snap-copies. > Separate redo-files only if redo is your bottleneck. Tip: Redo-files > are the easiest db-files to move around: just add new groups... > > Any Takers ? > Any ideas for a joint-effort ? > > > Regards, > > PdV > > Oracle DBA. > > DTMWFI, FWIW, JMTC and YMWV (of course it will) > > > PS: Frustration cost me my lunch break. > Me too, Got bitten badly by a hardware vendor recently for _not_ > putting aside 35% of my multi-TB disk-capacity exclusively for redos. > Salesman dreams to sell an additional nr of disks at 5% utilization > because of the trueism: > "redo files should be on private, physical, devices". > He even knew of OFA, the Oracle-FILE-Architecture :-). > Any advertising, as long as they spell the name right.... ------------------------------ From: Stephen Lee <Stephen.Lee_at_DTAG.Com> Date: Tue, 5 Aug 2003 08:55:16 -0500 Subject: RE: Q. To RAC or go vertical I think the point of RAC is fault tolerance, not scalability. If it's performance you want then you want a bigger box, not more boxes. 8 CPUs is not big. You sure don't need the expensive hardware if all you want to run is 8 CPUs. It would be better to go with a smaller frame and use the money you save to get more CPUs and additional I/O capacity. For example, instead of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans to push the E12K out to its limits in the future. Don't forget to consider the backup requirements of a 5 - 10 TByte database. Another consideration, I think, is that those big, fancy boxes require additional sys admin skills. -----Original Message----- Hi All I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu) Background Txn - OLTP like txn during day but batch extracts at night and very big batch extract periodically Data Volume - 5-10 TByte Data volatility - 99 % of data is very much like a ware house (unchanged) other 1% is read/update/delete/insert Options 1. Say a very large server like a HP Superdome or SUN E12000 with 8 CPUs Server already exist so cost is in obtaining additional CPU/Blades ie Traditional Server using plain old vanilla Oracle EE - can still increase head room. - batch programs can utilise all 8 CPUs - storage system need not cater for clustering 2, Same large server like a HP Superdome or SUN E12000 but partitioned into two. Each with 4 CPU. Oracle RDBMS + RAC option - storage server need to cater for cluster config - max performance for batch is with 4 CPUs only Which would you prefer and why. I am not convinced with the RAC option. Now if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and purchase say 4 nodes of 4 cpus each, that would be a different story. In this case I have the equipment and ability to grow vertically. ta tony ------------------------------ From: Munish Bajaj <mbajaj_at_quark.co.in> Date: Tue, 5 Aug 2003 19:18:27 +0530 Subject: Using external Authentication with LDAP This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35B58.3F5635D0 Content-Type: text/plain; charset="iso-8859-1" Hi Listers, I am presently working on Oracle 9iR2 latest patchset. I'd like to configure user authentication using external LDAP server. Do I need to Install Oracle9iAS to achive this??? Any Resources/Documentation/Links for reference Any kind of help will be appreciated. Thanks to all Regards Munish Bajaj _____
<http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3
bst%3b&SG=&RAND‘081> Upgrade Your Email - Click here! ------_=_NextPart_001_01C35B58.3F5635D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY
style="BACKGROUND-POSITION: left top; FONT-WEIGHT: normal; FONT-SIZE: 10pt; BACKGROUND-IMAGE: url(http://skins.hotbar.com/skins/mailskins/st/042102/042102geo_1.gif); MARGIN: 60px 0px 0px 6px; COLOR: #000000; BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff" bgColor=#ffffff stationery_tag_mark hbtype="st" hmark="hotbar_element">
<DIV><!--mail_content--><SPAN id=hotbar_element_used stationery_tag_mark><SPAN
class=949314913-05082003>Hi Listers,</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003></SPAN></SPAN> </DIV>
<DIV><SPAN stationery_tag_mark><SPAN class=949314913-05082003>I am presently
working on Oracle 9iR2 latest patchset. I'd like to configure user authentication using external LDAP server.</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003></SPAN></SPAN> </DIV>
<DIV><SPAN stationery_tag_mark><SPAN class=949314913-05082003>Do I need to
Install Oracle9iAS to achive this???</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003></SPAN></SPAN> </DIV>
<DIV><SPAN stationery_tag_mark><SPAN class=949314913-05082003>Any
Resources/Documentation/Links for reference</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003></SPAN></SPAN> </DIV>
<DIV><SPAN stationery_tag_mark><SPAN class=949314913-05082003>Any kind of help
will be appreciated.</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003></SPAN></SPAN> </DIV>
<DIV><SPAN stationery_tag_mark><SPAN class=949314913-05082003>Thanks to
all</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003></SPAN></SPAN> </DIV>
<DIV><SPAN stationery_tag_mark><SPAN
class=949314913-05082003>Regards</SPAN></SPAN></DIV>
<DIV><SPAN stationery_tag_mark><SPAN class=949314913-05082003>Munish
Bajaj</SPAN></SPAN></DIV>
<DIV id=hotbar_promo><BR>
<HR align=left width="100%" color=gray noShade SIZE=1>
<A
href="http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3bst%3b&SG=&RAND=91081"><IMG title="" alt="Upgrade Your Email - Click here!" src='http://promos.hotbar.com/promos/promodll.dll?GetPromo&El=hotbar%5felement%3bst%3b&SG=&RAND=91081"' border=0></A> </DIV></BODY></HTML> ------_=_NextPart_001_01C35B58.3F5635D0-- ------------------------------ From: "Tanel Poder" <tanel.poder.003_at_mail.ee> Date: Tue, 5 Aug 2003 17:14:47 +0300 Subject: Re: what is BAARF? --- OFA Hi! > 4) I think the "/u01", "/u02", etc. MP naming is a pain. They mean > nothing. In a disaster recovery, the last thing you want is to have someone > forget what "/u01" is. This is the 21st century, people! We have the power > to NAME DIRECTORIES something meaningful! I still like to use concept of /u[0-9][0-9]/oradata/$DBNAME, that means database name is included in directory path and I can use wildcards when playing around in file system. Other notation I've seen is somewhat opposite: /data/$DBNAME/[0-9][0-9]/ Other installations have used no standard for placing datafiles or have used "random" as standard :| Tanel. ------------------------------ From: Paula_Stankus_at_doh.state.fl.us Date: Tue, 5 Aug 2003 10:20:02 -0400 Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35B5C.A9128D30 Content-Type: text/plain Thanks for the confirmation - I really believe that was it as well!! - please see my earlier e-mail. -----Original Message----- Sent: Tuesday, August 05, 2003 5:24 AM To: Multiple recipients of list ORACLE-L Hi Paula Another issue you may encounter is that duplicate in 8.1.7 may not work w/o a "set until" clause see bug 2329702 Jack -----Original Message----- Sent: Monday, August 04, 2003 11:09 PM To: Multiple recipients of list ORACLE-L This is the type of script I am using: rman <<EOF connect target rman/rman_oracledba_at_test2 connect catalog rman/rman_oracledba_at_test1 connect auxiliary sys/oracledba_at_test3 run { resync catalog; allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk; set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf'; set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf'; set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf'; set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf'; sql 'alter system switch logfile'; duplicate target database to test3 LOGFILE '/data/oracle8/TEST3/redoTEST301.log' size 1M, '/data/oracle8/TEST3/redoTEST302.log' size 1M, '/data/oracle8/TEST3/redoTEST303.log' size 1M; } EOF -----Original Message----- Sent: Monday, August 04, 2003 4:12 PM To: 'ORACLE-L_at_fatcity.com' auxiliary database not mounted error!!! Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d ------_=_NextPart_001_01C35B5C.A9128D30 Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =
"urn:schemas-microsoft-com:office:office"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class7420414-05082003><FONT face ial color=#0000ff sizeThanks
for the confirmation - I really believe that was it as well!! - please see my earlier e-mail. </FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size-----Original Message-----<BR><B>From:</B> Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL]<BR><B>Sent:</B> Tuesday, August 05, 2003 5:24 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: URGENT: Trying to duplicate database from cold backup - auxi<BR><BR></FONT></DIV> <DIV class=Section1> <P class=MsoAutoSig><o:p></o:p></P></DIV> <DIV></DIV> <DIV><FONT face=Tahoma><FONT size<SPAN classy9245907-05082003><FONT face ial color=#0000ff>Hi Paula</FONT></SPAN></FONT></FONT></DIV> <DIV><FONT face=Tahoma><FONT size<SPAN classy9245907-05082003></SPAN></FONT></FONT> </DIV> <DIV><FONT face=Tahoma><FONT size<SPAN classy9245907-05082003><FONT face ial color=#0000ff>Another issue you may encounter is that duplicate in 8.1.7 may not work w/o a "set until" clause see bug <FONT color=#000000 size2329702</FONT></FONT></SPAN></FONT></FONT></DIV> <DIV><FONT face=Tahoma><FONT face ial size<SPAN classy9245907-05082003></SPAN></FONT></FONT> </DIV> <DIV><FONT face=Tahoma><FONT face ial size<SPAN classy9245907-05082003></SPAN></FONT></FONT> </DIV> <DIV><FONT face=Tahoma><FONT face ial size<SPAN classy9245907-05082003>Jack</SPAN></FONT></FONT></DIV> <DIV><FONT face=Tahoma><FONT size<SPAN classy9245907-05082003></SPAN></FONT></FONT> </DIV> <DIV><FONT face=Tahoma><FONT size<SPAN classy9245907-05082003> </SPAN>-----Original Message-----<BR><B>From:</B> Paula_Stankus_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us] <BR><B>Sent:</B> Monday, August 04, 2003 11:09 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: URGENT: Trying to duplicate database from cold backup - auxi<BR><BR></FONT></FONT></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV><SPAN classr7371220-04082003><FONT face ial color=#0000ff sizeThis is the type of script I am using:</FONT></SPAN></DIV> <DIV><SPAN classr7371220-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classr7371220-04082003><FONT face ial color=#0000ff sizerman <<EOF<BR>connect target rman/rman_oracledba_at_test2<BR>connect catalog rman/rman_oracledba_at_test1<BR>connect auxiliary sys/oracledba_at_test3<BR>run {<BR>resync catalog;<BR>allocate auxiliary channel d1 type disk;<BR>allocate auxiliary channel d2 type disk;<BR>set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf';<BR>set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf';<BR>set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf';<BR>set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf';<BR>sql 'alter system switch logfile';<BR>duplicate target database to test3<BR>LOGFILE<BR>'/data/oracle8/TEST3/redoTEST301.log' size 1M,<BR>'/data/oracle8/TEST3/redoTEST302.log' size 1M,<BR>'/data/oracle8/TEST3/redoTEST303.log' size 1M;<BR>}<BR>EOF</FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size-----Original Message-----<BR><B>From:</B> Stankus, Paula G <BR><B>Sent:</B> Monday, August 04, 2003 4:12 PM<BR><B>To:</B> 'ORACLE-L_at_fatcity.com'<BR><B>Subject:</B> RE: URGENT: Trying to duplicate database from cold backup - auxiliary database not mounted error!!!<BR><BR></FONT></DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff sizeGuys,</FONT></SPAN></DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff sizeWhen trying to duplicate database with this script</FONT></SPAN></DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff sizeI have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. </FONT></SPAN></DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff sizeGet error:</FONT></SPAN></DIV> <DIV><SPAN classD6270120-04082003><FONT face ial color=#0000ff size</FONT></SPAN> </DIV> <DIV><SPAN classD6270120-04082003><FONT size <P>RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte</P> <P>d</P></FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face ial color=#0000ff size</FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C35B5C.A9128D30-- ------------------------------ From: Paula_Stankus_at_doh.state.fl.us Date: Tue, 5 Aug 2003 10:21:54 -0400 Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35B5C.EB66AF40 Content-Type: text/plain; charset="iso-8859-1" I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "until....clause" I feel is the key. BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. -----Original Message----- Sent: Tuesday, August 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L auxi Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was "imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database". Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -----Original Message-----
<mailto:FREEMANR_at_tusc.com> ]
Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > ]
Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -----Original Message----- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -----Original Message----- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
-- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01C35B5C.EB66AF40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: URGENT: Trying to duplicate database from cold backup - auxi</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "until....clause" I feel is the key. BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. </FONT></P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: DENNIS WILLIAMS [<A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, August 05, 2003 10:44 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: URGENT: Trying to duplicate database from cold backup -</FONT>
<BR><FONT SIZE=2>auxi</FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula - How is your duplication going? Well I hope. Are you basically trying</FONT>
<BR><FONT SIZE=2>to perform a disaster recovery? That was basically what I was requested to</FONT>
<BR><FONT SIZE=2>do. The statement was "imagine the computer room was taken out by</FONT>
<BR><FONT SIZE=2>terrorists, and all you have are the tapes from the off-site storage. You</FONT>
<BR><FONT SIZE=2>are provided another server, now recover the database". Is this anything</FONT>
<BR><FONT SIZE=2>like what you are trying to do? As I recall, DUPLICATE wouldn't work because</FONT>
<BR><FONT SIZE=2>it just copies the production database, not using the backup tape. With help</FONT>
<BR><FONT SIZE=2>from a local consultant I accomplished that.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Dennis Williams </FONT>
<BR><FONT SIZE=2>DBA, 80%OCP, 100% DBA </FONT>
<BR><FONT SIZE=2>Lifetouch, Inc. </FONT>
<BR><FONT SIZE=2>dwilliams_at_lifetouch.com </FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 6:14 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Dear Robert, </FONT>
</P>
<P><FONT SIZE=2>Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate</FONT>
<BR><FONT SIZE=2>an existing database to a new database. Therefore, I don't have an existing</FONT>
<BR><FONT SIZE=2>control file and when I have done this with same database name from Host A</FONT>
<BR><FONT SIZE=2>to Host B as part of the duplication command it basically recreates the</FONT>
<BR><FONT SIZE=2>control file. I have gotten that type of clone to work.</FONT>
</P>
<P><FONT SIZE=2>I have also gotten clones to work where I was on host A and wanted to clone</FONT>
<BR><FONT SIZE=2>database A to database B by copying from a shutdown database, editing the</FONT>
<BR><FONT SIZE=2>"backup controlfile to trace" file. </FONT>
</P>
<P><FONT SIZE=2>This case is different from either one above. In this case I am trying to</FONT>
<BR><FONT SIZE=2>use RMAN and one Host A take a backup of database A and restore it as</FONT>
<BR><FONT SIZE=2>database B all from the backup itself. This operation I have not been able</FONT>
<BR><FONT SIZE=2>to do so I wait for off-hours to do the second option listed above. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2><<A HREF="mailto:FREEMANR_at_tusc.com">mailto:FREEMANR_at_tusc.com</A>> ] </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 6:34 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>auxi </FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula, </FONT>
</P>
<P><FONT SIZE=2>Try to mount the auxillary database manually, and see what error you get. </FONT>
<BR><FONT SIZE=2>That might help point you in the right direction in solving the problem. </FONT>
<BR><FONT SIZE=2>probably 70% of the time it's an issue with the configuration of the aux </FONT>
<BR><FONT SIZE=2>database (e.g. parameter set wrong, etc...). Manual startup will show you if</FONT>
</P>
<P><FONT SIZE=2>that is the case most of the time. </FONT>
</P>
<P><FONT SIZE=2>RF </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>Sent: 8/4/2003 5:14 PM </FONT>
</P>
<P><FONT SIZE=2>Hmmm. </FONT>
</P>
<P><FONT SIZE=2>Got Robert's book on 9i </FONT>
<BR><FONT SIZE=2>This database and clone is in 8.1.7 hmmm. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>< <A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A> <<A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A>> > ] </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 5:49 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>auxi </FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula - I was never able to get this working, but then I didn't have </FONT>
<BR><FONT SIZE=2>Robert </FONT>
<BR><FONT SIZE=2>Freeman's book at that time. Do you have his book as a resource? </FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Dennis Williams </FONT>
<BR><FONT SIZE=2>DBA, 80%OCP, 100% DBA </FONT>
<BR><FONT SIZE=2>Lifetouch, Inc. </FONT>
<BR><FONT SIZE=2>dwilliams_at_lifetouch.com </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 4:39 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<P><FONT SIZE=2>I did. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 5:24 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<P><FONT SIZE=2>you need to : startup nomount pfile=xxx.ora </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 4:09 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<P><FONT SIZE=2>Guys, </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>When trying to duplicate database with this script </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>I have my auxiliary setup as new database, target setup as old database </FONT>
<BR><FONT SIZE=2>and </FONT>
<BR><FONT SIZE=2>am using duplicate database command along with logfile command to create </FONT>
<BR><FONT SIZE=2>new </FONT>
<BR><FONT SIZE=2>logfiles. </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Get error: </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database </FONT>
<BR><FONT SIZE=2>not </FONT>
<BR><FONT SIZE=2>mounte </FONT>
</P>
<P><FONT SIZE=2>d </FONT>
</P>
<P><FONT SIZE=2> </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2><http://www.orafaq.net> </FONT>
<BR><FONT SIZE=2>< http://www.orafaq.net <http://www.orafaq.net> > </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: DENNIS WILLIAMS </FONT>
<BR><FONT SIZE=2> INET: DWILLIAMS_at_LIFETOUCH.COM </FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2><http://www.fatcity.com> </FONT>
<BR><FONT SIZE=2>< http://www.fatcity.com <http://www.fatcity.com> > </FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services </FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------- </FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message </FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in </FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L </FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may </FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing). </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2><http://www.orafaq.net> </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Freeman Robert - IL </FONT>
<BR><FONT SIZE=2> INET: FREEMANR_at_tusc.com </FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2><http://www.fatcity.com> </FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services </FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------- </FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message </FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in </FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L </FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may </FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing). </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: DENNIS WILLIAMS</FONT>
<BR><FONT SIZE=2> INET: DWILLIAMS_at_LIFETOUCH.COM</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services</FONT>
<BR><FONT SIZE=2>---------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C35B5C.EB66AF40-- ------------------------------ From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Date: Tue, 5 Aug 2003 09:33:55 -0500 Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi Paula - Okay, when you say you brought the database down, copied the files, etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in that post, but your original post was all about RMAN. -----Original Message----- Sent: Tuesday, August 05, 2003 10:19 AM To: Multiple recipients of list ORACLE-L I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "until....clause" I feel is the key. BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. -----Original Message-----
<mailto:DWILLIAMS_at_LIFETOUCH.COM> ]
Sent: Tuesday, August 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L auxi Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was "imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database". Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -----Original Message-----
< mailto:FREEMANR_at_tusc.com <mailto:FREEMANR_at_tusc.com> > ]
Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> <
mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > > ] Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -----Original Message----- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -----Original Message----- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net
<http://www.orafaq.net> > >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <http://www.fatcity.com> >
< http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
-- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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). ------------------------------ From: Jared Still <jkstill_at_cybcon.com> Date: 05 Aug 2003 07:55:40 -0700 Subject: RE: Q. To RAC or go vertical While fault tolerance is certainly one of the features of RAC, it isn't correct to say that it is not also for scalability. Buy a bigger box? That works fine until you're in the biggest box you can get, then what? I realize that it's a small market segment that requires that kind of hardware, but it still exists. Sun has been testing a cluster of 15k servers with RAC, ostensibly for scalability. Some nodes are populated with 78 CPU's and 288 Gig of RAM. ( yes, that is correct ). Jared On Tue, 2003-08-05 at 07:54, Stephen Lee wrote: > > I think the point of RAC is fault tolerance, not scalability. If it's > performance you want then you want a bigger box, not more boxes. 8 CPUs is > not big. You sure don't need the expensive hardware if all you want to run > is 8 CPUs. It would be better to go with a smaller frame and use the money > you save to get more CPUs and additional I/O capacity. For example, instead > of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans > to push the E12K out to its limits in the future. Don't forget to consider > the backup requirements of a 5 - 10 TByte database. Another consideration, > I think, is that those big, fancy boxes require additional sys admin skills. > > -----Original Message----- > Hi All > > I would like to ask for your thoughts on whether to RAC or just go vertical > (more cpu) > > Background > > Txn - OLTP like txn during day but batch extracts at night and > very big batch extract periodically > Data Volume - 5-10 TByte > Data volatility - 99 % of data is very much like a ware house (unchanged) > other 1% is read/update/delete/insert > > Options > 1. Say a very large server like a HP Superdome or SUN E12000 > with 8 CPUs > Server already exist so cost is in obtaining additional CPU/Blades > ie Traditional Server using plain old vanilla Oracle EE > - can still increase head room. > - batch programs can utilise all 8 CPUs > - storage system need not cater for clustering > > 2, Same large server like a HP Superdome or SUN E12000 but partitioned > into two. Each with 4 CPU. > Oracle RDBMS + RAC option > - storage server need to cater for cluster config > - max performance for batch is with 4 CPUs only > > > Which would you prefer and why. I am not convinced with the RAC option. > Now > if I was going with cheaper Intel servers like Dell servers with 4 CPUS > each, and > purchase say 4 nodes of 4 cpus each, that would be a different story. In > this case > I have the equipment and ability to grow vertically. > > ta > tony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: Stephen.Lee_at_DTAG.Com > > 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: ListGuru_at_fatcity.com (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). > ------------------------------ From: Joe Testa <jtesta_at_dmc-it.com> Date: Tue, 05 Aug 2003 10:53:17 -0400 Subject: tivoli/oracle monitoring is anyone using tivoli to do oracle monitoring, good/bad, etc. thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 ------------------------------ From: "Jay Wade" <fish_dba_at_hotmail.com> Date: Tue, 05 Aug 2003 11:01:50 -0400 Subject: OCP Question Hello: I was going through some OCP questions and wanted to make sure that my answers where correct. This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct. I've done some testing and think that my answers might be correct but would like to double check as well as get anyone elses option on the answers and the reasoning for option E. When the status of the tablespace moves from read-only to read write, which tow events occur? (Choose Two) A) Redo-log switch must take place B) Normal checkpoints on the file now occur C) Oracle automatically marks the file for backup D) All objects in the tablespace are checked for integrity E) The the DBWn process writes to the data files of the tablespace I believe the answers are A, B Reason: A) I tested moving the a tablespace from read-only to read write and have noticed a log switch after moving the tablespace to a writeable state. B) Since it is on longer Read-Only it will be updated during the checkpoint process C) Doesn't happen, at least in my reading or testing D) No verify structure is issued, or any of the other oracle tools for object checking are used E) I'm alittle unsure of this one, it should update the headers how since it is in a Read Write mode, although this should only happen at a checkpoint right? Thanks in Advance, Jay _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page%features/virus ------------------------------ From: Tim Gorman <tim_at_sagelogix.com> Date: Tue, 05 Aug 2003 09:11:39 -0700 Subject: Re: what is BAARF? --- OFA Rich, The original author of OFA is an active contributor to this list, but I don't know whether there will be a response, so I thought I'd jump in. Optimal Flexible Architecture (OFA) was such a fundamental dose of common sense 13-14 years ago that it's very revolution has lost it's sting over the years. Kind of like the way that nobody finds the Marx Brothers movies to be funny anymore, because every other comedy movie immediately fell into the same pattern, causing everyone to forget that movies comedies previosly meant people bashing each other in the head and dangling from clock towers and stuff... Oracle used to ship everything under the $ORACLE_HOME directory, which was bad in so many ways it can't be counted. If I were to summarize OFA, it was recognition that at least three major sets of directory structures were needed: * software distribution * administrative, trace, and log files * database files Each had to be separated, because each gets treated differently. Software distribution would be updated and upgraded. Admin files had to persist across updates/upgrades but not be lumped in with the actual database. The actual database had to be treated differently than either software or admin files for obvious reasons. Yes, naming online redo log files with ".log" extensions is bad; I went to recommending ".rdo" extensions long ago for that reason. OFA isn't hung up on specific names, in fact the original paper specifically avoids suggesting names other than for illustration purposes. Same with the MTPT names... Just as with the Marx Brothers movies, imagine a world where OFA didn't exist, where the author didn't push and push and push and push the Oracle product folks to see the light and stop installing product as if every server was a desktop PC... Hope this helps... -Tim on 8/5/03 7:49 AM, Jesse, Rich at Rich.Jesse_at_qtiworld.com wrote: > Not a "taker", but I'll put in my disdain for OFA, taken from the OFA doc at > http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm : > > 1) Who in their right minds thought it was a good idea to name the redos > with a ".log" extention? It's asking for trouble, if not from a DBA, then > from an SA or a script that's used to clean up old log files. Why the risk? > > 2) For similar reasons, I refuse to create the database files under > $ORACLE_BASE. How often does a DBA peruse that file tree? Daily, for me. > Put them on a separate directory off of "/" on Unix, or their own drive > letter for Winders. Then, anyone wanting to mess with the files from the > O/S level usually needs to go there on purpose and not by accident (unless > "root" does an "rm -R *" from "/", in which case there ain't a whole lot you > can do anyway). > > 3) Having the administrative directory structure (table G-8 on the above > link) is impractical at best, and dangerous at worst. If you lose one MP > (mount point; one set of drives), you lose all instances. To prevent this, > you'd need to create SEVERAL MPs for each DB, even on a small system. This > just isn't going to happen. Instead, we make an "admin" directory under > $ORACLE_BASE, then a "DBNAME" directory for each DB underneath that. The > appropriate adump, bdump, cdump, udump, pfile, etc. directories are then > created for each DBNAME. Then, if necessary, each DBNAME directory can have > their own MP, for recoverability and scalability (I wouldn't stretch it to > include "performance"!). > > 4) I think the "/u01", "/u02", etc. MP naming is a pain. They mean > nothing. In a disaster recovery, the last thing you want is to have someone > forget what "/u01" is. This is the 21st century, people! We have the power > to NAME DIRECTORIES something meaningful! > > NOFA! :) > > Rich > > Rich Jesse System/Database Administrator > rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA > > > >> -----Original Message----- >> From: Piet de Visser [mailto:piet.de.visser_at_logicacmg.com] >> Sent: Tuesday, August 05, 2003 6:39 AM >> To: Multiple recipients of list ORACLE-L >> Subject: Re: what is BAARF? --- OFA >> >> >> Tim, James, Mogens, Group, >> >> Another BAARF advocate here... >> >> However, I recognize Tim's problem when HW vendors: >> a) push raid5 or some form of autoraid. >> b) push for 8 separate disks of 125G each with only >> redo-files on them... >> >> While the BAARF initiative should continue in its simple, >> elegant and forcefull form (hammer the msg home), >> I want to place a call to Gary, Tim and others, >> to undertake A Revamp of the original OFA paper. >> >> Determine the new requirements (most of the old ones still stand!) >> and from the requirements, enhance the OFA-structure. >> It should take into account: >> - SAN capabilities (snapshotting and snapshot-logs or caches) >> - RAC and Clustered file systems, anticipate on 10G. >> - easy of admin: single point of admin per database, not per >> instance. >> - make provisions for (physical) copies >> (acceptance/testing/development) >> - standby-db constructions (including for RAC-dbs, and >> favour good-old-and-simple sqlplus ;-). >> - Weigh the importance of redo-speed against things like >> archive-storage and recoverability based on snap-copies. >> Separate redo-files only if redo is your bottleneck. Tip: Redo-files >> are the easiest db-files to move around: just add new groups... >> >> Any Takers ? >> Any ideas for a joint-effort ? >> >> >> Regards, >> >> PdV >> >> Oracle DBA. >> >> DTMWFI, FWIW, JMTC and YMWV (of course it will) >> >> >> PS: Frustration cost me my lunch break. >> Me too, Got bitten badly by a hardware vendor recently for _not_ >> putting aside 35% of my multi-TB disk-capacity exclusively for redos. >> Salesman dreams to sell an additional nr of disks at 5% utilization >> because of the trueism: >> "redo files should be on private, physical, devices". >> He even knew of OFA, the Oracle-FILE-Architecture :-). >> Any advertising, as long as they spell the name right.... ------------------------------ From: "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us> Date: Tue, 5 Aug 2003 11:15:16 -0400 Subject: RE: OCP Question Jay, I would guess B and E. I see no reason for a redo-log switch. Looks like a trick question. B is one correct answer. The other correct is either E or A. I would go for E. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Tuesday, August 05, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hello: I was going through some OCP questions and wanted to make sure that my answers where correct. This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct. I've done some testing and think that my answers might be correct but would like to double check as well as get anyone elses option on the answers and the reasoning for option E. When the status of the tablespace moves from read-only to read write, which tow events occur? (Choose Two) A) Redo-log switch must take place B) Normal checkpoints on the file now occur C) Oracle automatically marks the file for backup D) All objects in the tablespace are checked for integrity E) The the DBWn process writes to the data files of the tablespace I believe the answers are A, B Reason: A) I tested moving the a tablespace from read-only to read write and have noticed a log switch after moving the tablespace to a writeable state. B) Since it is on longer Read-Only it will be updated during the checkpoint process C) Doesn't happen, at least in my reading or testing D) No verify structure is issued, or any of the other oracle tools for object checking are used E) I'm alittle unsure of this one, it should update the headers how since it is in a Read Write mode, although this should only happen at a checkpoint right? Thanks in Advance, Jay _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page%features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: fish_dba_at_hotmail.com 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: ListGuru_at_fatcity.com (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). ------------------------------ From: "Ron Thomas" <rthomas_at_hypercom.com> Date: Tue, 5 Aug 2003 09:22:17 -0600 Subject: RE: 9i-OCP Question I've seen some of that research many moons ago. One of the conclusions was to always be in the same state of mind when you take the test as you were in when you studied. Now, where the .... did I put that bottle! Ron Thomas Hypercom, Inc rthomas_at_hypercom.com Each new user of a new system uncovers a new class of bugs. -- Kernighan Stephen.Lee_at_DTAG. Com To: ORACLE-L_at_fatcity.com Sent by: cc: ml-errors_at_fatcity Subject: RE: 9i-OCP Question .com 08/05/2003 08:09 AM Please respond to ORACLE-L There is scientific research that shows that moderate consumption of alcohol while learning and while testing improves scores. NOW you have a good excuse! > -----Original Message----- > > In high school, I took the SAT exams and got a great score, > enough to be > satisfied with. My guidance counselor insisted I gild the > lily and take the > exams again. I showed up that morning with no sleep, a > throbbing hangover, > and eyes looking like fried eggs pasted to my head... > > ...scored 60 points better... > > > > on 8/4/03 11:49 AM, Stephen Lee at Stephen.Lee_at_DTAG.Com wrote: > > > > > An invaluable aid for test taking is -- I learned this when > I took Organic > > Chemistry -- bourbon in water with ice in your favorite > convenience drink > > cup. Everyone at the test site is sure you have a soft drink. > > > >> -----Original Message----- > >> > >> Experience with various flavors of storage technology plus a > >> decade of DBA > >> experience can't possibly prepare me for what I haven't read > >> (i.e. "Oracle's > >> recommendations"). In a multiple-choice test format, unlike > >> real life, I > >> can't possibly argue with what Oracle has recommended... > >> > >> No wonder I failed my first try at the 9iOCP upgrade exam. > >> Yes, I'll try > >> again, once the lobotomy scars heal... > >> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > INET: tim_at_sagelogix.com > > 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: ListGuru_at_fatcity.com (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: Stephen Lee INET: Stephen.Lee_at_DTAG.Com 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: ListGuru_at_fatcity.com (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). ------------------------------ From: Paula_Stankus_at_doh.state.fl.us Date: Tue, 5 Aug 2003 11:32:46 -0400 Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35B66.D1D64C20 Content-Type: text/plain; charset="iso-8859-1" With DR did use RMAN. Again: (1) using RMAN worked fine from one host to another of same database (2) using cold backup and editing backup controlfile worked fine for same host different database name (3) using RMAN for duplicating one database to same host with different database name in Version 8.1.7.X seemed to require "until...." -----Original Message----- Sent: Tuesday, August 05, 2003 11:39 AM To: Multiple recipients of list ORACLE-L auxi Paula - Okay, when you say you brought the database down, copied the files, etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in that post, but your original post was all about RMAN. -----Original Message----- Sent: Tuesday, August 05, 2003 10:19 AM To: Multiple recipients of list ORACLE-L I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "until....clause" I feel is the key. BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. -----Original Message-----
<mailto:DWILLIAMS_at_LIFETOUCH.COM> ]
Sent: Tuesday, August 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L auxi Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was "imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database". Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -----Original Message-----
< mailto:FREEMANR_at_tusc.com <mailto:FREEMANR_at_tusc.com> > ]
Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> <
mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > > ] Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -----Original Message----- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -----Original Message----- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net
<http://www.orafaq.net> > >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <http://www.fatcity.com> >
< http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
-- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01C35B66.D1D64C20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: URGENT: Trying to duplicate database from cold backup - auxi</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>With DR did use RMAN. Again:</FONT>
</P>
<P><FONT SIZE=2>(1) using RMAN worked fine from one host to another of same database</FONT>
<BR><FONT SIZE=2>(2) using cold backup and editing backup controlfile worked fine for same host different database name</FONT>
<BR><FONT SIZE=2>(3) using RMAN for duplicating one database to same host with different database name in Version 8.1.7.X seemed to require "until...."</FONT></P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: DENNIS WILLIAMS [<A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, August 05, 2003 11:39 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: URGENT: Trying to duplicate database from cold backup -</FONT>
<BR><FONT SIZE=2>auxi</FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula - Okay, when you say you brought the database down, copied the files,</FONT>
<BR><FONT SIZE=2>etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in</FONT>
<BR><FONT SIZE=2>that post, but your original post was all about RMAN.</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, August 05, 2003 10:19 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>I have done DR just fine using the same database name and creating (with</FONT>
<BR><FONT SIZE=2>links or otherwise) the same file system names. This was using a complete</FONT>
<BR><FONT SIZE=2>backup to restore a database to the same host with a different name and the</FONT>
<BR><FONT SIZE=2>bug alluded to using the "until....clause" I feel is the key. BTW, I just</FONT>
<BR><FONT SIZE=2>waited till afterhours brought the database down, copied the file and cloned</FONT>
<BR><FONT SIZE=2>the easy way. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2><<A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A>> ] </FONT>
<BR><FONT SIZE=2>Sent: Tuesday, August 05, 2003 10:44 AM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>auxi </FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula - How is your duplication going? Well I hope. Are you basically trying</FONT>
</P>
<P><FONT SIZE=2>to perform a disaster recovery? That was basically what I was requested to </FONT>
<BR><FONT SIZE=2>do. The statement was "imagine the computer room was taken out by </FONT>
<BR><FONT SIZE=2>terrorists, and all you have are the tapes from the off-site storage. You </FONT>
<BR><FONT SIZE=2>are provided another server, now recover the database". Is this anything </FONT>
<BR><FONT SIZE=2>like what you are trying to do? As I recall, DUPLICATE wouldn't work because</FONT>
</P>
<P><FONT SIZE=2>it just copies the production database, not using the backup tape. With help</FONT>
</P>
<P><FONT SIZE=2>from a local consultant I accomplished that. </FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Dennis Williams </FONT>
<BR><FONT SIZE=2>DBA, 80%OCP, 100% DBA </FONT>
<BR><FONT SIZE=2>Lifetouch, Inc. </FONT>
<BR><FONT SIZE=2>dwilliams_at_lifetouch.com </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 6:14 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Dear Robert, </FONT>
</P>
<P><FONT SIZE=2>Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate </FONT>
<BR><FONT SIZE=2>an existing database to a new database. Therefore, I don't have an existing</FONT>
</P>
<P><FONT SIZE=2>control file and when I have done this with same database name from Host A </FONT>
<BR><FONT SIZE=2>to Host B as part of the duplication command it basically recreates the </FONT>
<BR><FONT SIZE=2>control file. I have gotten that type of clone to work. </FONT>
</P>
<P><FONT SIZE=2>I have also gotten clones to work where I was on host A and wanted to clone </FONT>
<BR><FONT SIZE=2>database A to database B by copying from a shutdown database, editing the </FONT>
<BR><FONT SIZE=2>"backup controlfile to trace" file. </FONT>
</P>
<P><FONT SIZE=2>This case is different from either one above. In this case I am trying to </FONT>
<BR><FONT SIZE=2>use RMAN and one Host A take a backup of database A and restore it as </FONT>
<BR><FONT SIZE=2>database B all from the backup itself. This operation I have not been able </FONT>
<BR><FONT SIZE=2>to do so I wait for off-hours to do the second option listed above. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>< <A HREF="mailto:FREEMANR_at_tusc.com">mailto:FREEMANR_at_tusc.com</A> <<A HREF="mailto:FREEMANR_at_tusc.com">mailto:FREEMANR_at_tusc.com</A>> > ] </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 6:34 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>auxi </FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula, </FONT>
</P>
<P><FONT SIZE=2>Try to mount the auxillary database manually, and see what error you get. </FONT>
<BR><FONT SIZE=2>That might help point you in the right direction in solving the problem. </FONT>
<BR><FONT SIZE=2>probably 70% of the time it's an issue with the configuration of the aux </FONT>
<BR><FONT SIZE=2>database (e.g. parameter set wrong, etc...). Manual startup will show you if</FONT>
</P>
<BR>
<P><FONT SIZE=2>that is the case most of the time. </FONT>
</P>
<P><FONT SIZE=2>RF </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>Sent: 8/4/2003 5:14 PM </FONT>
</P>
<P><FONT SIZE=2>Hmmm. </FONT>
</P>
<P><FONT SIZE=2>Got Robert's book on 9i </FONT>
<BR><FONT SIZE=2>This database and clone is in 8.1.7 hmmm. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>< <A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A> <<A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A>> <</FONT>
<BR><FONT SIZE=2><A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A> <<A HREF="mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</A>> > > ] </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 5:49 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
<BR><FONT SIZE=2>auxi </FONT>
</P>
<BR>
<P><FONT SIZE=2>Paula - I was never able to get this working, but then I didn't have </FONT>
<BR><FONT SIZE=2>Robert </FONT>
<BR><FONT SIZE=2>Freeman's book at that time. Do you have his book as a resource? </FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Dennis Williams </FONT>
<BR><FONT SIZE=2>DBA, 80%OCP, 100% DBA </FONT>
<BR><FONT SIZE=2>Lifetouch, Inc. </FONT>
<BR><FONT SIZE=2>dwilliams_at_lifetouch.com </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 4:39 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<P><FONT SIZE=2>I did. </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 5:24 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<P><FONT SIZE=2>you need to : startup nomount pfile=xxx.ora </FONT>
</P>
<P><FONT SIZE=2>-----Original Message----- </FONT>
<BR><FONT SIZE=2>Sent: Monday, August 04, 2003 4:09 PM </FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L </FONT>
</P>
<BR>
<P><FONT SIZE=2>Guys, </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>When trying to duplicate database with this script </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>I have my auxiliary setup as new database, target setup as old database </FONT>
<BR><FONT SIZE=2>and </FONT>
<BR><FONT SIZE=2>am using duplicate database command along with logfile command to create </FONT>
<BR><FONT SIZE=2>new </FONT>
<BR><FONT SIZE=2>logfiles. </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Get error: </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database </FONT>
<BR><FONT SIZE=2>not </FONT>
<BR><FONT SIZE=2>mounte </FONT>
</P>
<P><FONT SIZE=2>d </FONT>
</P>
<P><FONT SIZE=2> </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2><http://www.orafaq.net> </FONT>
<BR><FONT SIZE=2>< http://www.orafaq.net <http://www.orafaq.net> > </FONT>
<BR><FONT SIZE=2>< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net</FONT>
<BR><FONT SIZE=2><http://www.orafaq.net> > > </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: DENNIS WILLIAMS </FONT>
<BR><FONT SIZE=2> INET: DWILLIAMS_at_LIFETOUCH.COM </FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2><http://www.fatcity.com> </FONT>
<BR><FONT SIZE=2>< http://www.fatcity.com <http://www.fatcity.com> > </FONT>
<BR><FONT SIZE=2>< http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com</FONT>
<BR><FONT SIZE=2><http://www.fatcity.com> > > </FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services </FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------- </FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message </FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in </FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L </FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may </FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing). </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2><http://www.orafaq.net> </FONT>
<BR><FONT SIZE=2>< http://www.orafaq.net <http://www.orafaq.net> > </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Freeman Robert - IL </FONT>
<BR><FONT SIZE=2> INET: FREEMANR_at_tusc.com </FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2><http://www.fatcity.com> </FONT>
<BR><FONT SIZE=2>< http://www.fatcity.com <http://www.fatcity.com> > </FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services </FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------- </FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message </FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in </FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L </FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may </FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing). </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2><http://www.orafaq.net> </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: DENNIS WILLIAMS </FONT>
<BR><FONT SIZE=2> INET: DWILLIAMS_at_LIFETOUCH.COM </FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2><http://www.fatcity.com> </FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services </FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------- </FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message </FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in </FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L </FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may </FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing). </FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.net</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: DENNIS WILLIAMS</FONT>
<BR><FONT SIZE=2> INET: DWILLIAMS_at_LIFETOUCH.COM</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- 858-538-5051 http://www.fatcity.com</FONT>
<BR><FONT SIZE=2>San Diego, California -- Mailing list and web hosting services</FONT>
<BR><FONT SIZE=2>---------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C35B66.D1D64C20-- ------------------------------ From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> Date: Tue, 5 Aug 2003 08:37:13 -0700 (PDT) Subject: RE: 9i - Dynamic SGA - SGA_MAX_SIZE U R Welcome. Although, reducing SGA size is technically possible, it can be a very expensive operation in a busy environemt and can take a long time to complete. I have not run any specific tests to see how long it takes to reduce SGA by a certain amount, but you can imagine what must be done (find least used blocks/age out blocks, keep them from re-use, and finally 'detach' them etc..) - Kirti --- Mohammed Shakir <mshakir08816_at_yahoo.com> wrote: > Kirti > > Thanks for the info. > > I could not raise dynamically the size of db_cache_size and did not > know why, until I noticed the new parameter sga_max_size. Anyway, I > tried to lower the size of db_cache_size dynamically and I did not have > a problem. So sgma_max_size does play its role in db_cache_sizing. > > I have not tested where I increase the size of sga_max_size using > init.ora and then try to increase the size of db_cache_size dynamically > by the same size as the increase in sga_max_size. That is the test for > coming weekend. > > > --- Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> wrote: > > SGA_MAX_SIZE was introduced in 9i to allow dynamic sizing of SGA > > (Dynamic Sizing feature) > > components such as, shared pool, large pool, buffer cache etc. In > > versions up to 8i, such changes > > required bouncing the instance. > > This parameter assumes the value of the SGA at instance startup. > > Various components of the SGA can > > then be increased/reduced as and when needed. The total SGA, thus, > > can reach a maximum value set > > by SGA_MAX_SIZE (if set in the init.ora file). That's the idea. > > However, the implementation is > > different on various platforms. With ISM, and DISM, on Solaris, there > > are other issues when it > > comes to using Dynamic SGA. You may want to search Metalink for > > specific notes/articles for > > Solaris. > > On AIX 5L as I found out, Oracle uses SGA_MAX_SIZE, if set in > > init.ora, at the instanace startup, > > and allocates the excess (difference in computed SGA value and set > > SGA_MAX_SIZE) to 'variable > > size'. Hence there is no room for any dynamic sizing (upward) of any > > SGA component. I did not try > > to downsize shared pool first, and 'upsize' buffer cache later. May > > be that would work, but that > > is not the intention of using this parameter. > > > > PGA_AGRREGATE_TARGET is completely different from this parameter. It > > sets an instance-wide upper > > limit for the memory used by sorting, hashing processes. > > > > Hope this helps.. > > > > - Kirti > > > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ------------------------------ From: "Matthew Zito" <mzito_at_gridapp.com> Date: Tue, 5 Aug 2003 11:40:37 -0400 Subject: RE: Q. To RAC or go vertical The point of RAC is both fault tolerance AND scalability. More specifically, the ability to recover from a multi-node failure as well as use commodity hardware and scale on demand are the major motivating factors. Besides that, the cost difference between a mid-size SSI server and a RAC cluster is simply stunning. We've done the TCO analysis over and over again, and there's simply no fiscal justification in today's world to put a mid-size database instance on anything _besides_ RAC. If you look at the hardware cost difference alone between an 8-way sun box and two 4-way linux boxes, its more than a 10-fold cost difference. That's before you take into account you often need a volume manager, a cluster server, and a whole second node to cluster it with to achieve the same level of reliability you get with a RAC cluster. As always, full disclosure says I should say that I have a vested interest in the success of RAC, but I'm not even including our product in the cost comparison. Just vanilla RAC-on-linux vs. big-UNIX is a pretty compelling story in and of itself. Now, I said there's no _fiscal_ justification. RAC is obviously not a hammer for every nail. There are both applications and workloads that either require special tuning or are just not optimal for message-passing clusters. Also, there are scalability limitations due to interconnect latency in terms of the number of nodes you can have in a cluster - this is something we're working on addressing here. RAC's other big problem is that Oracle's RAC documentation is....artistic...by which I mean misleading, difficult to understand, and sometimes just wrong. This keeps organizations off of RAC or convinces them to hire consultants, and the vast majority of RAC consultants out there are even worse than the vast majority of Oracle/Sun consultancy practices - cookie cutter solutions and ill-informed consultants. The above notes and my company aside, I would be shocked if I ever implemented a large single-image Oracle instance ever again. *clambers off soapbox* Thanks, Matt -- Matthew Zito GridApp Systems Email: mzito_at_gridapp.com Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -----Original Message----- > From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On > Behalf Of Stephen Lee > Sent: Tuesday, August 05, 2003 10:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Q. To RAC or go vertical > > > > I think the point of RAC is fault tolerance, not scalability. > If it's performance you want then you want a bigger box, not > more boxes. 8 CPUs is not big. You sure don't need the > expensive hardware if all you want to run is 8 CPUs. It > would be better to go with a smaller frame and use the money > you save to get more CPUs and additional I/O capacity. For > example, instead of E12K with 8 CPUs, get 4810 with 12 CPUs > -- unless you have definite plans to push the E12K out to its > limits in the future. Don't forget to consider the backup > requirements of a 5 - 10 TByte database. Another > consideration, I think, is that those big, fancy boxes > require additional sys admin skills. > > -----Original Message----- > Hi All > > I would like to ask for your thoughts on whether to RAC or > just go vertical (more cpu) > > Background > > Txn - OLTP like txn during day but batch extracts at night and > very big batch extract periodically > Data Volume - 5-10 TByte > Data volatility - 99 % of data is very much like a ware house > (unchanged) > other 1% is read/update/delete/insert > > Options > 1. Say a very large server like a HP Superdome or SUN E12000 > with 8 CPUs > Server already exist so cost is in obtaining > additional CPU/Blades > ie Traditional Server using plain old vanilla Oracle EE > - can still increase head room. > - batch programs can utilise all 8 CPUs > - storage system need not cater for clustering > > 2, Same large server like a HP Superdome or SUN E12000 but > partitioned > into two. Each with 4 CPU. > Oracle RDBMS + RAC option > - storage server need to cater for cluster config > - max performance for batch is with 4 CPUs only > > > Which would you prefer and why. I am not convinced with the > RAC option. Now if I was going with cheaper Intel servers > like Dell servers with 4 CPUS each, and purchase say 4 nodes > of 4 cpus each, that would be a different story. In this > case I have the equipment and ability to grow vertically. > > ta > tony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: Stephen.Lee_at_DTAG.Com > > 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: ListGuru_at_fatcity.com (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). > ------------------------------ From: "Mladen Gogala" <mladen_at_wangtrading.com> Date: Tue, 5 Aug 2003 11:41:40 -0400 Subject: Downloading patchests from Metalink This is a multi-part message in MIME format. ------=_NextPart_000_001F_01C35B46.89456290 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Has anybody been able to download a patch from Metalink? I'm getting an error saying that "The opration timed out when attempting to contact oracle-updates-west.conxion.com". Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been refusing any contact with me for two days now. -- Mladen Gogala Oracle DBA -------------------------------------------------------- Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. --------------------------------------------------------- ------=_NextPart_000_001F_01C35B46.89456290 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>Has anybody been
able to download a patch from Metalink? I'm getting an error saying that</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>"The opration
timed out when attempting to contact oracle-updates-west.conxion.com".</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>Did oracle
subcontract their downloading facilities to Iraq or Afganistan? This host has been</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>refusing any contact
with me for two days now. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left>--<BR>Mladen Gogala<BR>Oracle DBA <BR></DIV>
<DIV> </DIV>
<HR>
<DIV><STRONG>Note:</STRONG></DIV>
<DIV>This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. <STRONG><FONT color=#ff8000>Wang Trading LLC </FONT></STRONG>and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.</DIV>
<DIV>Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.</DIV>
<DIV> </DIV><STRONG></STRONG>
<HR>
</BODY></HTML>
------=_NextPart_000_001F_01C35B46.89456290-- ------------------------------ From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> Date: Tue, 5 Aug 2003 08:45:32 -0700 (PDT) Subject: Re: Opatch Is the correct perl lib in the PATH? - Kirti --- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> wrote: > I'm trying to use opatch and receive the following error > > oracle_at_slac-xxxxxx $ opatch apply > PERL5LIB=; export PERL5LIB > /usr/local/bin/perl > /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPat > ch/opatch.pl apply > Can't call method "build_option_details" on an undefined value at > /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPatch/opatch_modules/Apply.pm line > 2299. > ---------------------------------------------------------------------------------------- > ORACLE_HOME is correctly set, PATH is correct as well. Any idea what the problem may be. > > Every opatch command fails with the above error including such things as opatch -version. > > Ian MacGregor > Stanford Linear Accelerator Center > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: MacGregor, Ian A. > INET: ian_at_SLAC.Stanford.EDU > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ------------------------------ From: "Rognes, Sten" <Sten.Rognes_at_schwab.com> Date: Tue, 5 Aug 2003 08:46:19 -0700 Subject: RE: Opatch Looks like PERL5LIB is not set in your environment. If perl is installed under /usr/local, the libraries are located in PERL5LIB=/usr/local/perl/lib/<perl ver#> Regards, Sten -----Original Message----- Sent: Monday, August 04, 2003 7:34 PM To: Multiple recipients of list ORACLE-L I'm trying to use opatch and receive the following error oracle_at_slac-xxxxxx $ opatch apply PERL5LIB=; export PERL5LIB /usr/local/bin/perl /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPat ch/opatch.pl apply Can't call method "build_option_details" on an undefined value at /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPatch/opatch_module s/Apply.pm line 2299. ---------------------------------------------------------------------------- ------------ ORACLE_HOME is correctly set, PATH is correct as well. Any idea what the problem may be. Every opatch command fails with the above error including such things as opatch -version. Ian MacGregor Stanford Linear Accelerator Center -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: ian_at_SLAC.Stanford.EDU 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: ListGuru_at_fatcity.com (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). ------------------------------ From: "Mladen Gogala" <mladen_at_wangtrading.com> Date: Tue, 5 Aug 2003 11:53:11 -0400 Subject: RE: 9i - Dynamic SGA - SGA_MAX_SIZE To continue down the Stephen's path, "shutdown abort" will complete very quickly and will drastically decrease the size of SGA. What is more, the "very busy environment" Will not be very busy any more. Perhaps very loud, but not very busy. -- Mladen Gogala Oracle DBA -----Original Message----- Kirtikumar Deshpande Sent: Tuesday, August 05, 2003 12:35 PM To: Multiple recipients of list ORACLE-L U R Welcome. Although, reducing SGA size is technically possible, it can be a very expensive operation in a busy environemt and can take a long time to complete. I have not run any specific tests to see how long it takes to reduce SGA by a certain amount, but you can imagine what must be done (find least used blocks/age out blocks, keep them from re-use, and finally 'detach' them etc..) - Kirti --- Mohammed Shakir <mshakir08816_at_yahoo.com> wrote: > Kirti > > Thanks for the info. > > I could not raise dynamically the size of db_cache_size and did not > know why, until I noticed the new parameter sga_max_size. Anyway, I > tried to lower the size of db_cache_size dynamically and I did not > have a problem. So sgma_max_size does play its role in > db_cache_sizing. > > I have not tested where I increase the size of sga_max_size using > init.ora and then try to increase the size of db_cache_size > dynamically by the same size as the increase in sga_max_size. That is > the test for coming weekend. > > > --- Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> wrote: > > SGA_MAX_SIZE was introduced in 9i to allow dynamic sizing of SGA > > (Dynamic Sizing feature) components such as, shared pool, large > > pool, buffer cache etc. In versions up to 8i, such changes > > required bouncing the instance. > > This parameter assumes the value of the SGA at instance startup. > > Various components of the SGA can > > then be increased/reduced as and when needed. The total SGA, thus, > > can reach a maximum value set > > by SGA_MAX_SIZE (if set in the init.ora file). That's the idea. > > However, the implementation is > > different on various platforms. With ISM, and DISM, on Solaris, there > > are other issues when it > > comes to using Dynamic SGA. You may want to search Metalink for > > specific notes/articles for > > Solaris. > > On AIX 5L as I found out, Oracle uses SGA_MAX_SIZE, if set in > > init.ora, at the instanace startup, > > and allocates the excess (difference in computed SGA value and set > > SGA_MAX_SIZE) to 'variable > > size'. Hence there is no room for any dynamic sizing (upward) of any > > SGA component. I did not try > > to downsize shared pool first, and 'upsize' buffer cache later. May > > be that would work, but that > > is not the intention of using this parameter. > > > > PGA_AGRREGATE_TARGET is completely different from this parameter. It > > sets an instance-wide upper limit for the memory used by sorting, > > hashing processes. > > > > Hope this helps.. > > > > - Kirti > > > > __________________________________ 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: Kirtikumar Deshpande INET: kirtikumar_deshpande_at_yahoo.com 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: ListGuru_at_fatcity.com (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). -------------------------------------------------------- Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. --------------------------------------------------------- ------------------------------ From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> Date: Tue, 5 Aug 2003 10:57:12 -0500 Subject: RE: what is BAARF? --- OFA Hey Tim, D'oh! The problem with e-mail is that it takes an hour to convey what would take 5 minutes in person... :) While I stand by my original e-mail, I do understand that OFA was designed to do exactly what the acronym says: be optimal and flexible. My problem with it is that I do not see OFA as optimal, at least not anymore. Perhaps it's just me, but I just don't understand the reasoning of the parts of OFA I had outlined now nor 14 years ago. Maybe it's because I had much more hair 13-14 years ago (more on my head, at least, with less in other places), and the combined human caused faults/accidents over those years has caused me to be much more strict in the way I'd like to see hardware and software set up. Or perhaps it's because I cut my teeth on VMS and haven't conformed to accepted Unix practice, nor do I see a need to if an alternative can be established as being subjectively "better" (re: "/unn" mountpoints). OK, enough of my babble. I would LOVE to see OFA updated! I won't hold my breath that any of my suggestions would be incorporated, but then again I'm just one person. I'll happily continue using a mostly-OFA setup. Except on VMS, which Oracle Corp does not conform to OFA at least thru v8.1.7. Then again, we have no more VMS... :( BTW, wasn't dangling from a clock tower Harold Lloyd's trademark? :) Thanks for listening to my whining, Rich Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Tim Gorman [mailto:tim_at_sagelogix.com] > Sent: Tuesday, August 05, 2003 11:09 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: what is BAARF? --- OFA > > > Rich, > > The original author of OFA is an active contributor to this > list, but I > don't know whether there will be a response, so I thought I'd jump in. > > Optimal Flexible Architecture (OFA) was such a fundamental > dose of common > sense 13-14 years ago that it's very revolution has lost it's > sting over the > years. Kind of like the way that nobody finds the Marx > Brothers movies to > be funny anymore, because every other comedy movie > immediately fell into the > same pattern, causing everyone to forget that movies comedies > previosly > meant people bashing each other in the head and dangling from > clock towers > and stuff... > > Oracle used to ship everything under the $ORACLE_HOME > directory, which was > bad in so many ways it can't be counted. If I were to > summarize OFA, it was > recognition that at least three major sets of directory > structures were > needed: > > * software distribution > * administrative, trace, and log files > * database files > > Each had to be separated, because each gets treated > differently. Software > distribution would be updated and upgraded. Admin files had > to persist > across updates/upgrades but not be lumped in with the actual > database. The > actual database had to be treated differently than either > software or admin > files for obvious reasons. > > Yes, naming online redo log files with ".log" extensions is > bad; I went to > recommending ".rdo" extensions long ago for that reason. OFA > isn't hung up > on specific names, in fact the original paper specifically > avoids suggesting > names other than for illustration purposes. Same with the > MTPT names... > > Just as with the Marx Brothers movies, imagine a world where > OFA didn't > exist, where the author didn't push and push and push and > push the Oracle > product folks to see the light and stop installing product as if every > server was a desktop PC... > > Hope this helps... > > -Tim > > > on 8/5/03 7:49 AM, Jesse, Rich at Rich.Jesse_at_qtiworld.com wrote: > > > Not a "taker", but I'll put in my disdain for OFA, taken > from the OFA doc at > > http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm : > > > > 1) Who in their right minds thought it was a good idea to > name the redos > > with a ".log" extention? It's asking for trouble, if not > from a DBA, then > > from an SA or a script that's used to clean up old log > files. Why the risk? > > > > 2) For similar reasons, I refuse to create the database files under > > $ORACLE_BASE. How often does a DBA peruse that file tree? > Daily, for me. > > Put them on a separate directory off of "/" on Unix, or > their own drive > > letter for Winders. Then, anyone wanting to mess with the > files from the > > O/S level usually needs to go there on purpose and not by > accident (unless > > "root" does an "rm -R *" from "/", in which case there > ain't a whole lot you > > can do anyway). > > > > 3) Having the administrative directory structure (table > G-8 on the above > > link) is impractical at best, and dangerous at worst. If > you lose one MP > > (mount point; one set of drives), you lose all instances. > To prevent this, > > you'd need to create SEVERAL MPs for each DB, even on a > small system. This > > just isn't going to happen. Instead, we make an "admin" > directory under > > $ORACLE_BASE, then a "DBNAME" directory for each DB > underneath that. The > > appropriate adump, bdump, cdump, udump, pfile, etc. > directories are then > > created for each DBNAME. Then, if necessary, each DBNAME > directory can have > > their own MP, for recoverability and scalability (I > wouldn't stretch it to > > include "performance"!). > > > > 4) I think the "/u01", "/u02", etc. MP naming is a pain. They mean > > nothing. In a disaster recovery, the last thing you want > is to have someone > > forget what "/u01" is. This is the 21st century, people! > We have the power > > to NAME DIRECTORIES something meaningful! > > > > NOFA! :) > > > > Rich > > > > Rich Jesse System/Database Administrator > > rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA > > > > > > > >> -----Original Message----- > >> From: Piet de Visser [mailto:piet.de.visser_at_logicacmg.com] > >> Sent: Tuesday, August 05, 2003 6:39 AM > >> To: Multiple recipients of list ORACLE-L > >> Subject: Re: what is BAARF? --- OFA > >> > >> > >> Tim, James, Mogens, Group, > >> > >> Another BAARF advocate here... > >> > >> However, I recognize Tim's problem when HW vendors: > >> a) push raid5 or some form of autoraid. > >> b) push for 8 separate disks of 125G each with only > >> redo-files on them... > >> > >> While the BAARF initiative should continue in its simple, > >> elegant and forcefull form (hammer the msg home), > >> I want to place a call to Gary, Tim and others, > >> to undertake A Revamp of the original OFA paper. > >> > >> Determine the new requirements (most of the old ones still stand!) > >> and from the requirements, enhance the OFA-structure. > >> It should take into account: > >> - SAN capabilities (snapshotting and snapshot-logs or caches) > >> - RAC and Clustered file systems, anticipate on 10G. > >> - easy of admin: single point of admin per database, not per > >> instance. > >> - make provisions for (physical) copies > >> (acceptance/testing/development) > >> - standby-db constructions (including for RAC-dbs, and > >> favour good-old-and-simple sqlplus ;-). > >> - Weigh the importance of redo-speed against things like > >> archive-storage and recoverability based on snap-copies. > >> Separate redo-files only if redo is your bottleneck. Tip: > Redo-files > >> are the easiest db-files to move around: just add new groups... > >> > >> Any Takers ? > >> Any ideas for a joint-effort ? > >> > >> > >> Regards, > >> > >> PdV > >> > >> Oracle DBA. > >> > >> DTMWFI, FWIW, JMTC and YMWV (of course it will) > >> > >> > >> PS: Frustration cost me my lunch break. > >> Me too, Got bitten badly by a hardware vendor recently for _not_ > >> putting aside 35% of my multi-TB disk-capacity exclusively > for redos. > >> Salesman dreams to sell an additional nr of disks at 5% utilization > >> because of the trueism: > >> "redo files should be on private, physical, devices". > >> He even knew of OFA, the Oracle-FILE-Architecture :-). > >> Any advertising, as long as they spell the name right.... > ------------------------------ From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Date: Tue, 5 Aug 2003 10:52:27 -0500 Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi Paula - Now you've got my attention. Can you describe in more detail what you mean by "editing backup controlfile". I use a backup controlfile to create test databases / validate RMAN backups, so this sounds like something I could use. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Tuesday, August 05, 2003 11:29 AM To: Multiple recipients of list ORACLE-L With DR did use RMAN. Again: (1) using RMAN worked fine from one host to another of same database (2) using cold backup and editing backup controlfile worked fine for same host different database name (3) using RMAN for duplicating one database to same host with different database name in Version 8.1.7.X seemed to require "until...." -----Original Message-----
<mailto:DWILLIAMS_at_LIFETOUCH.COM> ]
Sent: Tuesday, August 05, 2003 11:39 AM To: Multiple recipients of list ORACLE-L auxi Paula - Okay, when you say you brought the database down, copied the files, etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in that post, but your original post was all about RMAN. -----Original Message----- Sent: Tuesday, August 05, 2003 10:19 AM To: Multiple recipients of list ORACLE-L I have done DR just fine using the same database name and creating (with links or otherwise) the same file system names. This was using a complete backup to restore a database to the same host with a different name and the bug alluded to using the "until....clause" I feel is the key. BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. -----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > ]
Sent: Tuesday, August 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L auxi Paula - How is your duplication going? Well I hope. Are you basically trying to perform a disaster recovery? That was basically what I was requested to do. The statement was "imagine the computer room was taken out by terrorists, and all you have are the tapes from the off-site storage. You are provided another server, now recover the database". Is this anything like what you are trying to do? As I recall, DUPLICATE wouldn't work because it just copies the production database, not using the backup tape. With help from a local consultant I accomplished that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Dear Robert, Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work. I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file. This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above. -----Original Message-----
< mailto:FREEMANR_at_tusc.com <mailto:FREEMANR_at_tusc.com> <
mailto:FREEMANR_at_tusc.com <mailto:FREEMANR_at_tusc.com> > > ] Sent: Monday, August 04, 2003 6:34 PM To: Multiple recipients of list ORACLE-L auxi Paula, Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time. RF -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM Hmmm. Got Robert's book on 9i This database and clone is in 8.1.7 hmmm. -----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> <
mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > < mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> < mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > > > ] Sent: Monday, August 04, 2003 5:49 PM To: Multiple recipients of list ORACLE-L auxi Paula - I was never able to get this working, but then I didn't have Robert Freeman's book at that time. Do you have his book as a resource? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -----Original Message----- Sent: Monday, August 04, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I did. -----Original Message----- Sent: Monday, August 04, 2003 5:24 PM To: Multiple recipients of list ORACLE-L you need to : startup nomount pfile=xxx.ora -----Original Message----- Sent: Monday, August 04, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net
<http://www.orafaq.net> > >
< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net
<http://www.orafaq.net> > < http://www.orafaq.net <http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> > > >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <http://www.fatcity.com> >
< http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com
<http://www.fatcity.com> > >
< http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com
<http://www.fatcity.com> > < http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net
<http://www.orafaq.net> > >
-- Author: Freeman Robert - IL INET: FREEMANR_at_tusc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <http://www.fatcity.com> >
< http://www.fatcity.com <http://www.fatcity.com> < http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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). ------------------------------ From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> Date: Tue, 5 Aug 2003 11:06:26 -0500 Subject: RE: Downloading patchests from Metalink Over 600KBytes/s from: http://oracle-updates-west.conxion.com:8000/ARUConnect/dGREMDJJdVRxZGtxQjdNT Ud1UHFxUTo0MDE5OTI4OnAyNzYxMzMyXzkyMDNfSFA2NC56aXA6UVRJREJBOjE2MS40OS4yMS40M joxMDYwMDk4OTczOk5PX1BBU1M@/p2761332_9203_HP64.zip Get yerself a new pipe. :) Rich Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA -----Original Message----- Sent: Tuesday, August 05, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Has anybody been able to download a patch from Metalink? I'm getting an error saying that "The opration timed out when attempting to contact oracle-updates-west.conxion.com". Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been refusing any contact with me for two days now. -- Mladen Gogala Oracle DBA ------------------------------ From: "Nelson, Allan" <anelson_at_midf.com> Date: Tue, 5 Aug 2003 11:03:51 -0500 Subject: RE: Downloading patchests from Metalink This is a multi-part message in MIME format. ------_=_NextPart_001_01C35B6B.298625E8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable yep, ftp to update.oracle.com. Login with your metalink credentials and cd to the patch directory using the number with no p on the prefix. That has worked for me today. Allan -----Original Message----- From: Mladen Gogala [mailto:mladen_at_wangtrading.com] Sent: Tuesday, August 05, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: Downloading patchests from Metalink Has anybody been able to download a patch from Metalink? I'm getting an error saying that "The opration timed out when attempting to contact oracle-updates-west.conxion.com". Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been refusing any contact with me for two days now. -- Mladen Gogala Oracle DBA _____ Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. _____ ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] ------_=_NextPart_001_01C35B6B.298625E8 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 5.50.4923.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=675335115-05082003><FONT face=Arial color=#0000ff size=2>yep,
ftp to update.oracle.com. Login with your metalink credentials and cd to the patch directory using the number with no p on the prefix. That has worked for me today.</FONT></SPAN></DIV>
<DIV><SPAN class=675335115-05082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=675335115-05082003><FONT face=Arial color=#0000ff
size=2>Allan</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Mladen Gogala [mailto:mladen_at_wangtrading.com] <BR><B>Sent:</B> Tuesday, August 05, 2003 11:40 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Downloading patchests from Metalink<BR><BR></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>Has anybody been able to download a patch from Metalink? I'm getting an error saying that</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>"The opration timed out when attempting to contact oracle-updates-west.conxion.com".</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=662283415-05082003>refusing any contact with me for two days now. </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV align=left>--<BR>Mladen Gogala<BR>Oracle DBA <BR></DIV> <DIV> </DIV> <HR> <DIV><STRONG>Note:</STRONG></DIV> <DIV>This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. <STRONG><FONT color=#ff8000>Wang Trading LLC </FONT></STRONG>and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.</DIV> <DIV>Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.</DIV> <DIV> </DIV><STRONG></STRONG> <HR>
</BLOCKQUOTE></BODY></HTML>
<P>______________________________________________________________________________<br>
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]<br>
</P>
------_=_NextPart_001_01C35B6B.298625E8-- ------------------------------ From: Jared.Still_at_radisys.com Date: Tue, 5 Aug 2003 09:04:03 -0700 Subject: RE: Q. To RAC or go vertical .. though now that I've read the original post ( missed it somehow ) I would say that you may just want a bigger box. See Mogen's article "You Probably Don't Need RAC" at selectonline.org. You may want to ask Mogens for an alternative version of the article, in fact, I think you should. Jared Jared Still <jkstill_at_cybcon.com> Sent by: ml-errors_at_fatcity.com 08/05/2003 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: RE: Q. To RAC or go vertical While fault tolerance is certainly one of the features of RAC, it isn't correct to say that it is not also for scalability. Buy a bigger box? That works fine until you're in the biggest box you can get, then what? I realize that it's a small market segment that requires that kind of hardware, but it still exists. Sun has been testing a cluster of 15k servers with RAC, ostensibly for scalability. Some nodes are populated with 78 CPU's and 288 Gig of RAM. ( yes, that is correct ). Jared On Tue, 2003-08-05 at 07:54, Stephen Lee wrote: > > I think the point of RAC is fault tolerance, not scalability. If it's > performance you want then you want a bigger box, not more boxes. 8 CPUs is > not big. You sure don't need the expensive hardware if all you want to run > is 8 CPUs. It would be better to go with a smaller frame and use the money > you save to get more CPUs and additional I/O capacity. For example, instead > of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans > to push the E12K out to its limits in the future. Don't forget to consider > the backup requirements of a 5 - 10 TByte database. Another consideration, > I think, is that those big, fancy boxes require additional sys admin skills. > > -----Original Message----- > Hi All > > I would like to ask for your thoughts on whether to RAC or just go vertical > (more cpu) > > Background > > Txn - OLTP like txn during day but batch extracts at night and > very big batch extract periodically > Data Volume - 5-10 TByte > Data volatility - 99 % of data is very much like a ware house (unchanged) > other 1% is read/update/delete/insert > > Options > 1. Say a very large server like a HP Superdome or SUN E12000 > with 8 CPUs > Server already exist so cost is in obtaining additional CPU/Blades > ie Traditional Server using plain old vanilla Oracle EE > - can still increase head room. > - batch programs can utilise all 8 CPUs > - storage system need not cater for clustering > > 2, Same large server like a HP Superdome or SUN E12000 but partitioned > into two. Each with 4 CPU. > Oracle RDBMS + RAC option > - storage server need to cater for cluster config > - max performance for batch is with 4 CPUs only > > > Which would you prefer and why. I am not convinced with the RAC option. > Now > if I was going with cheaper Intel servers like Dell servers with 4 CPUS > each, and > purchase say 4 nodes of 4 cpus each, that would be a different story. In > this case > I have the equipment and ability to grow vertically. > > ta > tony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: Stephen.Lee_at_DTAG.Com > > 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: ListGuru_at_fatcity.com (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: Jared Still INET: jkstill_at_cybcon.com 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: ListGuru_at_fatcity.com (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). ------------------------------ From: "Willett, Mark" <mwillett_at_sunnen.com> Date: Tue, 5 Aug 2003 11:10:11 -0500 Subject: RE: Downloading patchests from Metalink This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C35B6C.0C147A10 Content-Type: text/plain I just downloaded a patch a few minutes ago from oracle-updates-west.conxion.com - no problem. Mark Mark Willett Corporate Database Administrator ---------------------------------------------------------------------------- - The statements and opinions expressed here are my own and do not necessarily reflect those of Sunnen Products Company. In addition, this communication, including any attachments, may contain confidential information and is intended only for the individual or entity to whom it is addressed. Any review, dissemination, or copying of this communication in part or in whole by anyone other than the intended recipient is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message. -----Original Message----- Sent: Tuesday, August 05, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Has anybody been able to download a patch from Metalink? I'm getting an error saying that "The opration timed out when attempting to contact oracle-updates-west.conxion.com". Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been refusing any contact with me for two days now. -- Mladen Gogala Oracle DBA _____ Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. _____ ------_=_NextPart_001_01C35B6C.0C147A10 Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Message</title>
<style>
<!--
/* Font Definitions */ @font-face {font-family:Helvetica; panose-1:2 11 5 4 2 2 2 2 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} span.EmailStyle18 {font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} -->
</style>
</head>
<body lang-US link ue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font sizecolor=navy face ial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I just downloaded a patch a few minutes ago from oracle-updates-west.conxion.com - no problem.</span></font></p>
<p class=MsoNormal><font sizecolor=navy face ial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<p class=MsoAutoSig><font sizecolor=navy face ial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mark</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face ial><span style='font-size:
12.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoAutoSig><b><font sizecolor=navy face ial><span
style='font-size:11.0pt;font-family:Arial;color:navy;font-weight:bold'>Mark Willett</span></font></b></p>
<p class=MsoAutoSig><font sizecolor=navy face ial><span style='font-size:
8.0pt;font-family:Arial;color:navy'>Corporate Database Administrator</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face ial><span style='font-size:
8.0pt;font-family:Arial;color:navy'>-----------------------------------------------------------------------------</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>The statements and opinions expressed here are my own and do not</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>necessarily reflect those of Sunnen Products Company. In addition, this</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>communication, including any attachments, may contain confidential</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>information and is intended only for the individual or entity to whom it is</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>addressed. Any review, dissemination, or copying of this communication</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>in part or in whole by anyone other than the intended recipient is strictly </span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>prohibited. If you are not the intended recipient, please contact the sender</span></font></p>
<p class=MsoAutoSig><font sizecolor=navy face=Helvetica><span
style='font-size:6.0pt;font-family:Helvetica;color:navy'>by reply email and delete and destroy all copies of the original message.</span></font></p>
</div>
<p class=MsoNormal><font sizecolor=navy face ial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font sizeface=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Mladen Gogala
[mailto:mladen_at_wangtrading.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, August 05, 2003
11:40 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Multiple recipients of list
ORACLE-L<br>
<b><span style='font-weight:bold'>Subject:</span></b> Downloading patchests
from Metalink</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface ial><span
style='font-size:10.0pt;font-family:Arial'>Has anybody been able to download a patch from Metalink? I'm getting an error saying that</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface ial><span
style='font-size:10.0pt;font-family:Arial'>"The opration timed out when attempting to contact oracle-updates-west.conxion.com".</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface ial><span
style='font-size:10.0pt;font-family:Arial'>Did oracle subcontract their downloading facilities to Iraq or Afganistan? This host has been</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface ial><span
style='font-size:10.0pt;font-family:Arial'>refusing any contact with me for two days now. </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'>--<br> Mladen Gogala<br> Oracle DBA </span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div class=MsoNormal alignÎnter style='margin-left:.5in;text-align:center'><font
sizeface="Times New Roman"><span style='font-size:12.0pt'>
<hr sizewidth="100%" alignÎnter>
</span></font></div>
<div>
<p class=MsoNormal style='margin-left:.5in'><strong><b><font size
face="Times New Roman"><span style='font-size:12.0pt'>Note:</span></font></b></strong></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'>This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. <strong><b><font color="#ff8000" face="Times New Roman"><span style='color:#FF8000'>Wang Trading LLC </span></font></b></strong>and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'>Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font sizeface="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div class=MsoNormal alignÎnter style='margin-left:.5in;text-align:center'><font
sizeface="Times New Roman"><span style='font-size:12.0pt'>
<hr sizewidth="100%" alignÎnter>
</span></font></div>
</div>
</body>
</html>
------_=_NextPart_001_01C35B6C.0C147A10-- ------------------------------ From: tjambu_fatcity_at_yahoo.com.au Date: Wed, 06 Aug 2003 02:23:28 +1000 Subject: RE: Q. To RAC or go vertical Stephen I agree with your comments re scalability vs fault tolerance. Actually the configuration I am looking at is 16 CPUS. So it is either one domain (vertical) of 16 CPUS or 4 nodes of 4 CPUs each or 2 nodes of 8 CPUS each. And on top of this I have to cater for a Standby environment as well. The standby will definitely not be a big box like an E12K but maybe (if talking SUN) say V880 or 4800 . tony At 06:54 AM 05/08/2003 -0800, you wrote: >I think the point of RAC is fault tolerance, not scalability. If it's >performance you want then you want a bigger box, not more boxes. 8 CPUs is >not big. You sure don't need the expensive hardware if all you want to run >is 8 CPUs. It would be better to go with a smaller frame and use the money >you save to get more CPUs and additional I/O capacity. For example, instead >of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans >to push the E12K out to its limits in the future. Don't forget to consider >the backup requirements of a 5 - 10 TByte database. Another consideration, >I think, is that those big, fancy boxes require additional sys admin skills. > >-----Original Message----- >Hi All > >I would like to ask for your thoughts on whether to RAC or just go vertical >(more cpu) > >Background > >Txn - OLTP like txn during day but batch extracts at night and > very big batch extract periodically >Data Volume - 5-10 TByte >Data volatility - 99 % of data is very much like a ware house (unchanged) > other 1% is read/update/delete/insert > >Options >1. Say a very large server like a HP Superdome or SUN E12000 > with 8 CPUs > Server already exist so cost is in obtaining additional CPU/Blades > ie Traditional Server using plain old vanilla Oracle EE > - can still increase head room. > - batch programs can utilise all 8 CPUs > - storage system need not cater for clustering > >2, Same large server like a HP Superdome or SUN E12000 but partitioned > into two. Each with 4 CPU. > Oracle RDBMS + RAC option > - storage server need to cater for cluster config > - max performance for batch is with 4 CPUs only > > >Which would you prefer and why. I am not convinced with the RAC option. >Now >if I was going with cheaper Intel servers like Dell servers with 4 CPUS >each, and >purchase say 4 nodes of 4 cpus each, that would be a different story. In >this case >I have the equipment and ability to grow vertically. > >ta >tony >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Stephen Lee > INET: Stephen.Lee_at_DTAG.Com > >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: ListGuru_at_fatcity.com (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). ------------------------------ From: Prasada.Gunda_at_hartfordlife.com Date: Tue, 5 Aug 2003 12:21:20 -0400 Subject: After Logon Trigger and Import Hi, I put the 'alter session set skip_unusable_indexes=true' in the logon trigger of a particular user and tested it in the sql*plus session. It is working fine there. I tested it by making an index unusable and inserting the data into the table. But, when I tried to import (using the same user) the data into that table, It gives an error saying that 'Index is in unusable state'. Does logon trigger fire for the Import? Is there any way to verify that the skip_unusable_indexes is set to 'true' for a particular session. Thanks in advance for your help. Best Regards, Prasad 860 843 8377 ------------------------------ From: Prasada.Gunda_at_hartfordlife.com Date: Tue, 5 Aug 2003 12:23:04 -0400 Subject: Re: After Logon Trigger and Import Sorry, I forgot to mention the OS and Oracle Version. It is Hp-UX v11 and Oracle 8.1.7.4 Thanks. Best Regards, Prasad 860 843 8377 Prasada R Gunda To: ORACLE-L_at_fatcity.com 08/05/2003 12:21 cc: PM Subject: After Logon Trigger and Import(Document link: Prasada R Gunda) Hi, I put the 'alter session set skip_unusable_indexes=true' in the logon trigger of a particular user and tested it in the sql*plus session. It is working fine there. I tested it by making an index unusable and inserting the data into the table. But, when I tried to import (using the same user) the data into that table, It gives an error saying that 'Index is in unusable state'. Does logon trigger fire for the Import? Is there any way to verify that the skip_unusable_indexes is set to 'true' for a particular session. Thanks in advance for your help. Best Regards, Prasad 860 843 8377 ------------------------------ From: "Guerra, Abraham J" <AGUERRA_at_amfam.com> Date: Tue, 5 Aug 2003 11:24:05 -0500 Subject: Snapshot too old in undo tablespace in 9i? This is a multi-part message in MIME format. ------_=_NextPart_001_01C35B6D.FD8A09BA Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C35B6D.FD8A09BA" ------_=_NextPart_002_01C35B6D.FD8A09BA Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hello Group, I just upgraded a database to Oracle 9.2.0.3 from 8.1.7. I created an undo tablespace with 10 (default) undo segments... however, during an export I got the following message: ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15$" too small I thought this was a thing of the past... According to the documentation, if an undo segment gets full, it starts using idle ones... also, the undo tablespace still had a lot of room to grow... Any insights will be welcome. Thanks Abraham Guerra Oracle DBA American Family Insurance ------_=_NextPart_002_01C35B6D.FD8A09BA Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE>P.msoNormal {
FONT-WEIGHT: normal; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "MS Sans Serif", "sans serif" } LI.msoNormal { FONT-WEIGHT: normal; FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: "MS Sans Serif", "sans serif" } BODY { FONT-WEIGHT: normal; FONT-SIZE: 12pt; MARGIN-LEFT: 50px; COLOR: black; FONT-FAMILY: "MS Sans Serif", "sans serif" } HR { WIDTH: 100%; COLOR: #00ffff; HEIGHT: 1px }
</STYLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff background=cid:109501816_at_05082003-10DB>
<DIV><SPAN class=109501816-05082003><FONT face='"MS Sans Serif"'>Hello
Group,</FONT></SPAN></DIV>
<DIV><SPAN class=109501816-05082003></SPAN> </DIV>
<DIV><SPAN class=109501816-05082003><FONT face='"MS Sans Serif"'>I just upgraded
a database to Oracle 9.2.0.3 from 8.1.7. I created an undo tablespace with 10 (default) undo segments... however, during an export I got the following message:</FONT></SPAN></DIV>
<DIV><FONT face='"MS Sans Serif"'></FONT> </DIV>
<DIV><FONT face='"MS Sans Serif"'>ORA-01555: snapshot too old: rollback segment
number 15 with name "_SYSSMU15$" too small<BR></FONT></DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN class=109501816-05082003><FONT
face='"MS Sans Serif"'>I thought this was a thing of the past... According to the documentation, if an undo segment gets full, it starts using idle ones... also, the undo tablespace still had a lot of room to grow...</FONT></SPAN></FONT></DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN
class=109501816-05082003></SPAN></FONT> </DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN class=109501816-05082003><FONT
face='"MS Sans Serif"'>Any insights will be welcome.</FONT></SPAN></FONT></DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN
class=109501816-05082003></SPAN></FONT> </DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN class=109501816-05082003><FONT
face='"MS Sans Serif"'>Thanks</FONT></SPAN></FONT></DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN
class=109501816-05082003></SPAN></FONT> </DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN class=109501816-05082003><FONT
face='"MS Sans Serif"'>Abraham Guerra</FONT></SPAN></FONT></DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN class=109501816-05082003>Oracle
DBA</SPAN></FONT></DIV>
<DIV><FONT face='"MS Sans Serif"'><SPAN class=109501816-05082003>American Family
Insurance</SPAN></DIV></FONT></BODY></HTML> ------_=_NextPart_002_01C35B6D.FD8A09BA-- ------_=_NextPart_001_01C35B6D.FD8A09BA Content-Type: image/jpeg; name="Notebook.jpg" Content-Transfer-Encoding: 7bit
<encoded content removed -- binaries not allowed by ListGuru>
To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Type: text/x-vcard; charset=us-ascii; Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="iso-8859-1" To: Multiple recipients of list ORACLE-L Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> To: Multiple recipients of list ORACLE-L To: Multiple recipients of list ORACLE-L To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Content-Type: text/plain; charset=us-ascii Content-Type: text/html; charset=us-ascii To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Content-Type: text/plain; charset="iso-8859-1" To: Multiple recipients of list ORACLE-L To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L Content-Type: text/html; charset="iso-8859-1" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: btaylor3_at_gmu.edu 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: ListGuru_at_fatcity.com (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).
 |
 |
