Re: SEQ#, DUAL and Oracle literacy
Well, does this question get the same place in the 'hall of oracle list' as the legendary 'are you an idiot..?'...;) --- Jared Still [EMAIL PROTECTED] wrote: On Wednesday 19 June 2002 00:48, Farnsworth, Dave wrote: Hallo, What is dual? Are you a dummy? ;) g -Original Message- Sent: Tuesday, June 18, 2002 2:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Combine 2 fields into single field using sql loader
Couple of methods, 1. Use Position instead of delimited control file specification and use SQL to massage to the ata For eaxmple my_date position(1:19) substr(:mydate,1,10)||substr(:mydate,11) Of course you can do this directly as METHOD 2: my_date position(1:10) filler, my_time position(11:19) filler, my_final_date position(1:1) :my_date || :my_time HTH RS --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Hi DBAs, I am trying to combine 2 fields into 1 field to insert into a date field using sql loader. The csv files has the first 2 fields as follows 01/01/2002,00:00:01,..., Can someone help on how to combine the 1st two fields to insert into a single date field. Thanks Rick man sed ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Import PUBLIC
Hi All How to import PUBLIC from a Full export ? Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? Thanks Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7.4 64-Bit Solaris 7 Patchset Issues?
Listers, Anyone encounter problems/successes with the 8.1.7.4 64 bit patchset on Solaris 7? We would normally like to do extensive testing in the dev and QA environments before throwing down a patch, and we've already searched Metalink and asked Oracle about any known issues (they say none). But we find ourselves in a situation where we will have to apply the patch, rather soon, to *hopefully* get around a production issue. Say hopefully because Oracle says there is a bug that kind of sounds like what we are running into, and it is fixed in 8.1.7.4. Of course, they will not disclose *details* about the bug since it is not publicly viewable. And they will not move forward on the TAR until the patch is applied. Not much of a choice here. We don't mind going to the latest patchset, just wish we had a bit more time for testing. Curious about the experiences of others. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import PUBLIC
Hi Kamel Please explain why you want to import the PUBLIC user ! GL2Z/ INF DBA BENLATRECHE wrote: Hi All How to import PUBLIC from a Full export ? Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? Thanks Regards Kamel Benlatreche -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
RE: Import PUBLIC
Hi Peter Because I have PUBLIC DBLINKS to import. When importing Objects By User, I did not get these DBLINKS and I don't want to make a full import. -Message d'origine- De : Peter Gram [mailto:[EMAIL PROTECTED]] Envoyé : dimanche 23 juin 2002 12:13 À : Multiple recipients of list ORACLE-L Objet : Re: Import PUBLIC Hi Kamel Please explain why you want to import the PUBLIC user ! GL2Z/ INF DBA BENLATRECHE wrote: Hi All How to import PUBLIC from a Full export ? Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? Thanks Regards Kamel Benlatreche -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import PUBLIC
sounds like you dont have much choice except to either: 1. do a full export and extract the ddl from the .dmp file 2. extract the ddl for the db link via some gui tool, a bunch of you use toad i think, i prefer oem since i dont do windoze. joe GL2Z/ INF DBA BENLATRECHE wrote: Hi Peter Because I have PUBLIC DBLINKS to import. When importing Objects By User, I did not get these DBLINKS and I don't want to make a full import. -Message d'origine- De : Peter Gram [mailto:[EMAIL PROTECTED]] Envoyé : dimanche 23 juin 2002 12:13 À : Multiple recipients of list ORACLE-L Objet : Re: Import PUBLIC Hi Kamel Please explain why you want to import the PUBLIC user ! GL2Z/ INF DBA BENLATRECHE wrote: Hi All How to import PUBLIC from a Full export ? Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? Thanks Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import PUBLIC
Thanks, It's what I have done also for PUBLIC SYNONYMS. -Message d'origine- De : Joe Testa [mailto:[EMAIL PROTECTED]] Envoyé : dimanche 23 juin 2002 13:43 À : Multiple recipients of list ORACLE-L Objet : Re: Import PUBLIC sounds like you dont have much choice except to either: 1. do a full export and extract the ddl from the .dmp file 2. extract the ddl for the db link via some gui tool, a bunch of you use toad i think, i prefer oem since i dont do windoze. joe GL2Z/ INF DBA BENLATRECHE wrote: Hi Peter Because I have PUBLIC DBLINKS to import. When importing Objects By User, I did not get these DBLINKS and I don't want to make a full import. -Message d'origine- De : Peter Gram [mailto:[EMAIL PROTECTED]] Envoyé : dimanche 23 juin 2002 12:13 À : Multiple recipients of list ORACLE-L Objet : Re: Import PUBLIC Hi Kamel Please explain why you want to import the PUBLIC user ! GL2Z/ INF DBA BENLATRECHE wrote: Hi All How to import PUBLIC from a Full export ? Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? Thanks Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import PUBLIC
Use DBATool: http://www.cool-tools.co.uk/products/dbatool.html It's free! HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- DBA BENLATRECHE Sent: 23 June 2002 15:33 To: Multiple recipients of list ORACLE-L Thanks, It's what I have done also for PUBLIC SYNONYMS. -Message d'origine- De : Joe Testa [mailto:[EMAIL PROTECTED]] Envoyé : dimanche 23 juin 2002 13:43 À : Multiple recipients of list ORACLE-L Objet : Re: Import PUBLIC sounds like you dont have much choice except to either: 1. do a full export and extract the ddl from the .dmp file 2. extract the ddl for the db link via some gui tool, a bunch of you use toad i think, i prefer oem since i dont do windoze. joe GL2Z/ INF DBA BENLATRECHE wrote: Hi Peter Because I have PUBLIC DBLINKS to import. When importing Objects By User, I did not get these DBLINKS and I don't want to make a full import. -Message d'origine- De : Peter Gram [mailto:[EMAIL PROTECTED]] Envoyé : dimanche 23 juin 2002 12:13 À : Multiple recipients of list ORACLE-L Objet : Re: Import PUBLIC Hi Kamel Please explain why you want to import the PUBLIC user ! GL2Z/ INF DBA BENLATRECHE wrote: Hi All How to import PUBLIC from a Full export ? Can we do FROMUSER=PUBLIC TOUSER=PUBLIC ? Thanks Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: REPLICATION QUESTION - LOng and strange
Sakthi , Raj wrote: Hi Listers, alright I've exhausted almost all my resources and I am turning to my last resource. We have 3 databases. Database A - OLTP Database B - OLTP Database c - DSS ORACLE 8.1.6.3 ON HP-UX 11.0 Database A has a table which is being replicated to C as a read only snapshot and we have long and complex summary process (relic of 1998?s) that works off this snapshot. Now due to some new merger same table need to be created in database B. And yes?the data in table B also need to be replicated to the SAME snapshot in database C so that the summary process can summarize the collective data. The problem is I am sure this could be accomplished. THAT IS TWO MASTERS SITES FEEDING SAME SNAPSHOT?.!!! I have checked the replication manual and Unless I am so sleep deprived that I am missing lines I didn?t find any reference to this kinda replication setup. Any pointers welcome. I am exhausted, so if you don?t mind, if RTFMs could refer the relevant section I am supposed to RTFM, then it would be great. Rewriting the summary process is not an option due to unrealistic deadline. TIA. RS Wouldn't it be possible to replace your current snapshot by a view, the union of one snapshot on A and one snapshot on B? C could the summarize both. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Ahem... Are you an idiot? ;) On Sunday 23 June 2002 11:38, Eric D. Pierce wrote: HELP On 23 Jun 2002 at 1:13, Sakthi , Raj wrote: Well, does this question get the same place in the 'hall of oracle list' as the legendary 'are you an idiot..?'...;) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: distributed timeout error
If you set the errorstack level to 3 then support should at least be able to give you the cause of the error as it will give the process state and stack of the process at the time of the error. If they didn't find this helpful it is likely that they are pursuing the application of the bug I spoke of previously. If this doesn't solve your problem these trace files will be essential in identifying the cause. Good Luck! Mike Thanks for the input, Michael. You are correct in your error number assumption. It is the 2064 error. We did set the 2064 event in a logon trigger and last week and got a trace, not much help there either. I tried to get the analyst to choose between oradebug and dbms_system.set_ev so that I could set it independently of the session, but we finally just put a good old alter session in our load script. We ran a 10053 trace since the problem seems that it might be some sort of parse error on the source side. We wanted the 10046 trace to see exactly where the error was occuring since it is in a stored procedure and what it was waiting on. In working the theory that it might be object/stats/parse related I rebuilt the tables and recreated the indexes, no effect. The strange thing is that this error just started showing up two weeks ago, in two stored procedures (both doing the same thing, different tables) having the exact same frequency, scope, and duration of error. There must be a connection, but unfortunately this is a very hot problem for us and I don't have the window to figure it out. It is too bad, it is a very good puzzle. Almost hate to solve it with an upgrade. The main reason that I am upgrading is that Oracle support has tentatively identified a possible bug (although it is internal, so no details) that will be fixed by 8.1.7.4. Their position is that unless I upgrade they won't pursue this further. So, upgrading I am, even though I do not feel that they have really nailed the problem, but they won't give further support. Reasonable on their part, since they might find that we have a bug that is already solved. jack --- Michael P Sale [EMAIL PROTECTED] wrote: Ahh yes, the elusive Why. If you are already working with support then I would set an errorstack on the ora-2064 error number you are getting(I suspect that is what it is, you never say). This will give them extensive information as to the state of the call at the time of the error. If you are running a high enough version of the db this statement will work: alter system set events '2064 trace name errorstack level 3'; Otherwise you can set it in the init.ora: event = 2064 trace name errorstack level 3 Where 2064 is the error number you are getting. You can also set it at the session level with the alter session syntax and on another session with oradebug. This is obviously the much more painful route. The 10053 would only be relevant if you were running into a CBO issue, not likely unless you are running with certain events and/or underscore parameters in place, and the 10046 should show the sql being run (if taken at the proper level) but not why the error message, only that this particular sql was run and resulted in this error. An upgrade to address this problem directly might not solve it **UNLESS** you are running into bug 2140287 CREATE TABLE AS SELECT WITH DECODE CORRUPTING DATA (see the 8.1.7.4 patchset readme or metalink note 120613.1). In which case you could possibly have serious issues that would require you move to this patchset!!! Either way, the errorstack will give you the why even though only Oracle support or development would likely be able to interpret this for you. Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Silvey Sent: Friday, June 21, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Oracle support is saying much the same thing. They are advising an upgrade to 8.1.7.4 (from 8.1.7.2). Doesn't give us the reason WHY it is happening, but it might fix it. We have run 10053 and 10046 traces and can see no obvious issues. --- Michael P Sale [EMAIL PROTECTED] wrote: Without seeing more information, I have seen this type of a response where either the instance is not registered with the listener, or the db is not accepting connections for a variety of reasons (e.g. no more memory all the way to the db is shut down). Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Silvey Sent: Friday, June 21, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Listers, We have two stored procedures that are suddenly throwing random distributed operation not supported errors.
Re: SEQ#, DUAL and Oracle literacy
what is dual? On 23 Jun 2002 at 14:45, Jared Still wrote: Ahem... Are you an idiot? ;) On Sunday 23 June 2002 11:38, Eric D. Pierce wrote: HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms 4.5, views and instead-of triggers
Hi, We're using Forms 4.5 against an 8.1.7.1.4 database. The database is on NT4 and clients are on NT4, W2K XP. 1 of the forms is based on a view which joins 2 tables (by an equi-join on 2 fields) and has an instead-of trigger in place. If I update a field in that view from SQLPlus, a lock gets taken out on both of the base tables - as I would expect. When a record is modified in a Form based on that view, a lock initially only gets taken out on 1 table - the lock is always on the same table and sometimes not even on the table the field being modified is from. The problem is this allows another form to change the same record and we can end up with changes get overwritten by other users. I'm not a Forms developer but am hoping someone else may have a suggestion on how to get the form to put locks on both tables or whatever other suggestions come forth. I can then pass these onto our Developer. Also, is anyone else using Forms 4.5 with Instead-of triggers? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN QUestion
I'll bite I don't have a clue about RMAN and you say it is a trick question. I think control files from time a and time b are the same and should work. At 08:47 AM 6/21/2002 -0800, you wrote: Sorry, posted using wrong subject header, DUH! Use the following Exhibit to answer this question (note: This is not a hacked OCP question. This question came about out of the experience of one of our junior DBA's that I had to come in and figure out...Several Sr. DBA's that I know have gotten it wrong already... but we got some smart fokls here! :-) RMAN backup. Autobackup of control file is not enabled. Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup To restore successfully, with RMAN (no manual fiddling) to time point b, you will first need to restore a control file. Which backup would you want to restore the control file from... (more than one answer may well be correct, I'm not telling). a. Control file from point a b. Control file from point b c. Control file from before point c d. Control file from after point c e. Control file from point d f. Recovery is not possible. I'll reveal the answer in the next 2 days...(and this *IS* a trick question, so think carefully). Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script to find free space in an index
Hi All
Jared notified me that the attachment did not come through, so I am
attaching again. I am also enclosing it in the body of the email.
Credits go to Jared who wrote the shell of this some time back (98 was it
Jared ?). I just modified an excellent foundation.
tblindspace.sql
set linesize 80
set verify off
set echo off
set feed off
undef tab_name;
undef object_type;
undef schema_name;
prompt Enter the schema and table name, and you are shown the space that the
table
prompt and each associated index uses in the database
prompt
accept schema_name prompt 'Enter Schema: '
accept tab_name prompt 'Enter TABLE: '
prompt
set serverout on size 100
declare
ind_namevarchar2(30);
total_blocksnumber;
unused_blocks number;
total_bytes number;
unused_bytesnumber;
last_used_extent_file_idnumber;
last_used_extent_block_id number;
last_used_block number;
cursor find_ind is
select index_name from all_indexes where
owner=upper('schema_name') and
table_name=upper('tab_name') ;
begin
dbms_space.unused_space(upper('schema_name'),upper('tab_name'),
'TABLE',total_blocks, total_bytes,unused_blocks,
unused_bytes,
last_used_extent_file_id,last_used_extent_block_id,last_used_block);
dbms_output.put_line('Total space used by TABLE '||
upper('schema_name')||'.' ||upper('tab_name'));
dbms_output.put_line('TOTAL BLOCKS USED_BLOCKS FREE BLOCKS');
dbms_output.put_line(' === ===');
dbms_output.put_line(to_char(total_blocks) ||' '||
to_char(total_blocks - unused_blocks)||' '||
to_char(unused_blocks));
dbms_output.put_line(' ');
open find_ind ;
loop
fetch find_ind into ind_name ;
exit when find_ind%NOTFOUND or find_ind%NOTFOUND is null ;
dbms_space.unused_space(upper('schema_name'),upper(ind_name),'INDEX',
total_blocks, total_bytes,
unused_blocks, unused_bytes,
last_used_extent_file_id ,
last_used_extent_block_id,
last_used_block );
dbms_output.put_line('Total space used by INDEX '||
upper('schema_name')||'.' ||upper(ind_name)||'
'||
to_char(total_blocks) ||'
'||to_char(total_blocks - unused_blocks)||
' '|| to_char(unused_blocks));
end loop ;
if find_ind%ISOPEN then close find_ind;
end if;
end;
/
set feed on
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday
tblindspace.sql
Description: Binary data
Virtual drive on Solaris
Hi All does anyone have any white paper or info on how to configure a dedicated portion of real memory as a virtual drive on Solaris ? I want to move my online redo logs (4 X 128 M single threaded) for a 300 GB DW onto it, to speed up Informatica ETL, since Informatica does not allow me to specify /*+ APPEND */ mode of insert. I know I will not bypass the SQL layer this way, but at least, the LGWR will be writing to memory instead of disk. Thanks in advance. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Saturday, 22 June 2002 9:03 PM To: Multiple recipients of list ORACLE-L On Solaris ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM -opmem,pcpu,user,args use: psrinfo -v prtconf | grep Mem format uname -a HTH Richard -Original Message- Sent: Saturday, June 22, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix related - need some info
uname -a top dmesg df -h On Sat, 22 Jun 2002, Ray Stell wrote: On Sat, Jun 22, 2002 at 09:38:25AM -0800, Vladimir Barac - posao wrote: Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... try using top * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? look at /etc/syslog.conf which will tell you where your system messages are, there should be some helpful info there. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
HELP -Original Message- Sent: Sunday, June 23, 2002 7:48 PM To: Multiple recipients of list ORACLE-L Ahem... Are you an idiot? ;) On Sunday 23 June 2002 11:38, Eric D. Pierce wrote: HELP On 23 Jun 2002 at 1:13, Sakthi , Raj wrote: Well, does this question get the same place in the 'hall of oracle list' as the legendary 'are you an idiot..?'...;) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Virtual drive on Solaris
Have you considered setting _DISABLE_LOGGING = TRUE instead? It could be just as disastrous... ;-) Buying an NVRAM unit would probably be more sensible, since at least then you have some probability of the file-system on such a unit surviving node failure or restart. I don't use Informatica, but I believe it mainly does single-row inserts, so not using the APPEND hint is a blessing anyway. After all, who likes one row in each database block? However, I could be wrong about that and it may actually be performing multi-row/array insertions... I don't know what your loads are like, but how about something like this instead? - create a small database with _DISABLE_LOGGING set to TRUE - use Informatica to load into a tablespace on that small, sacrificial db - use transportable tablespace to copy the tablespace to your real DW Just an idea (better you than me to try it!)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 23, 2002 8:53 PM Hi All does anyone have any white paper or info on how to configure a dedicated portion of real memory as a virtual drive on Solaris ? I want to move my online redo logs (4 X 128 M single threaded) for a 300 GB DW onto it, to speed up Informatica ETL, since Informatica does not allow me to specify /*+ APPEND */ mode of insert. I know I will not bypass the SQL layer this way, but at least, the LGWR will be writing to memory instead of disk. Thanks in advance. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Saturday, 22 June 2002 9:03 PM To: Multiple recipients of list ORACLE-L On Solaris ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM -opmem,pcpu,user,args use: psrinfo -v prtconf | grep Mem format uname -a HTH Richard -Original Message- Sent: Saturday, June 22, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Sharing sessions. Keeping cursors open.
Hello, Jeff and Cary (Hotsos) mention these in their document on Scaling Applications to Massive Concurrent Users. A real eye opener for me. I've convinced myself that I have to have some type of application server between the Web and the database to make session sharing work: yes? There is no way to create a session in the database that maintains state data and to which external processes (Apache) can connect? (Is this a coherent question?) The next notion, not closing cursors, is even more intriguing. So I pull out the PL/SQL book and discover it is dated 1992 (now I'm feeling really old). So I pull out the 8i documentation CD and can't find anything about not closing a cursor. When the data is all fetched, the data is all fetched. Clearly, I am not understanding. Would some kind soul point me in the right direction? BTW, still in production on Oracle 7.3.4. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions on MV Implementation !!!!!!!
Jack , DG and ALL, I Have problem in creating the Fast Refresh MVs, from the existing code , which i can not change in present situation. So I am still looking for another option to minimize the down time( blank web pages at the time of MV refresh ) , even by using the COMPLETE refresh . For me space is not a problem .. I would like to hear some more ideas to eliminate the down time , with the existing MVs ( Complete Refresh ) Hope i hear you all soon , Thanks again Madhu -Original Message- Sent: Friday, June 21, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Thanks Mahu. Do you get the feeling that I might have done that a few times? ;) Snapshots and materialized views are the same thing. I guess I might start calling them materialized views in the next version or two, but it is so hard to give up old habits. Another thing you might need to know - you can't easily change a job in the Oracle job queue unless you are the owner, which means that you can't do it as DBA. There is a package called dbms_ijob that will allow you to change jobs as a dba even if you don't own them. There is usually no public synonym for this package, so you will have to refer to it as sys.dbms_ijob. I believe that this package is not officially supported, so you might not find a lot of documentation on it, but I have used it for over a year without any problems. To turn off a snapshot refresh, use the sys.dbms_ijob.broken function. *BE ADVISED* If you unbreak a job in the Oracle job queue, it will try to run immediately. This includes snapshot jobs. If you unbreak a *complete* snapshot refresh job, the first thing it does is truncate the target table. Unbreak a complete snapshot refresh job in the middle of the day and viola, the users suddenly have no data. Be careful. hth, jack --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Jack, Nice picture of the whole thing . Through out your solution , mentioned SNAPSHOT , you mean Materialized view ??? Thanks, Madhu -Original Message- Sent: Friday, June 21, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Recreate the snapshot to allow fast refresh, (you will have to create a snapshot log on your source table) and refresh once every 5/10/20/30 minutes. Fast refreshes are just one commit that is either committed or rolled back at the end. Viola, fresh data instantaneously. You can do a refresh immediate when you recreate the snapshots so it will build the data right away. To do it really fast, create a new snapshot with the correct definition, rename the old snapshot, rename the new snapshot to the old name, recompile your packages and procedures, drop the old snapshot, and viola, new snapshot. Snapshots refresh via a job in the Oracle job queue. You can adjust timing on this job to adjust your refresh frequency. Make sure you get your indexes, stats, and grants in place on the new snap too. Check your synonyms as well. hth, jack --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello All, I have a set of Materialized views in my DB . we refresh ( COMPLETE) these MVs, couple of times a day. Web server ( application ) will hit these MVs to show the data on web pages. But the complete Refresh of MVs are consuming much time and , at this point of time , Application is not able to show right data on web pages. This is like a down time. I need some suggestions from you all, in order to minimize or zeroing this down time. The first thing I can think of is , FAST refresh , but one of my Sr.DBA told me that the MV definition will not allow us for a FAST refresh( Are there any limitations for FAST refresh ). Here is a sample MV Definition : CREATE MATERIALIZED VIEW GENRELOB NOLOGGING BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND DISABLE QUERY REWRITE AS SELECT DISTINCT '1' AS CLIP, LOB.LOB_ID, LOB.LOB_CD, GENRE.GENRE_ID, GENRE.GENRE_DESC, GENRE.GENRE_DESC AS INSTANCENAME FROM GENRE, GENRE_LOB_XREF, LOB, GENRE_PRODUCT_XREF WHERE GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND GENRE.DSPLY_IND = 'Y' ORDER BY LOB_CD, GENRE_DESC ; My Goal is to view the FRESH data on web pages all the time , irrespective of MV Refresh. Would anybody suggest me some bright ideas , to have no or less down time ??? Thanks in advance Madhu V Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
Re: Unix related - need some info
You didn't specify the flavor of your OS. Although they all have similarities, they're also vastly different. Start here: http://bhami.com/rosetta.html Buy O'Reilly's Essential System Administration. Good basic 'NIX book, even if it doesn't answer your specific question, it'll point you in the right direction. Welcome back Ferenc. David A. Barbour AISD Vladimir Barac - posao To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] vladob@aster. cc: si Subject: Unix related - need some info Sent by: [EMAIL PROTECTED] om 06/22/2002 12:38 PM Please respond to ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by ps, but what aditional parameters I have to provide? At a first glance, output of man ps vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: Online vs offline backups
Hi, guys, We have discussed this topic many times on this list. Actually a good DBA should design a good backup and restore strategy instead of online or offline according to business situation. From my opinion, both online and offline are necessary, for example, I do monthly offline line cold backup and daily online hot backup on my production db. The only thing you need to know is that if you do offline backup, you should backup every thing, include online redo logs, otherwise, you may lost some data; if you do online hot backup, the online redo logs are useless when you do restore. Cheers! Shine Sha Snr. Oracle DBA iGINE Pte. Ltd. -Original Message- Thomas F Sent: Thursday, June 20, 2002 12:44 AM To: Multiple recipients of list ORACLE-L chaos, if you believe everything you read in the oracle docs, then your are NOT a thinking DBA. just because they failed to mention that you should backup the log files does NOT mean you should not back them up. as everyone who knows anything has stated in this thread, this is a very bad idea. never mind the what if scenario you mentioned. anyone who is performing a database restore had better know exactly what and where they are restoring to (what point in time), and the condition of all of the database files on the disk before they begin. if they don't, they are in for trouble. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 19, 2002 11:43 AM To: Multiple recipients of list ORACLE-L hi, Mercadante, Thomas F£¬ÄúºÃ£¡ But according to Oracle Document(which i believe), oracle backup and recovery guide (version 8.1.6)page 4-4: it said: Use operating system commands or a backup utility to make backups of all datafiles and all control files specified by the CONTROL_FILES parameter of the initialization parameter file. Also back up the initialization parameter file and other Oracle product initialization files. To find them, do a search for *.ora starting in your Oracle home directory and recursively search all of its subdirectories. You can see, oracle mentions everything it need, but it does not mention the online redo log. And: Is the online redo log useful in recovery since you do a full clean cold backup? Just do a clear logfile group 1,2,3 and you cleanly opened your database when you Just restore the datafile,controlfiles.If you want to make full recovery, the online redo log is also totally USELESS. And if you carelessly overlay the old online redo log, the CURRENT ACTIVE ONLINE REDO LOG WILL BE DESTROYED! so , you cannot do complete recovery. This is my opinions.Though i also do not do coldbackup. Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-19 06:43:00 You wrote: chal_ping What? Makes no sense. Why NOT backup everything if you are taking a Cold Backup. Why make yourself perform an open reset logs upon a recovery? This is bad advice. Personally, I use Rman performing hot backups all the time. My database is *always* open to the world. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 19, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Ferenc Mantfeld£¬ The same person that advocated a cold backup did not back up the online redo logs, so what use was it anyway, since the only way they would force open their DB is with a resetlogs option anyway. For cold backup, oracle does not recommend backup the online redo log. And if you restore the whole cold backup, why need the online redo log? I am sure people doing cold backup will do shutdown normal/immediate, not shutdown abort.So there is no need to backup the online redo log at all! Backup the online redo log also take the risk of damage the current online redo log when you want to do full recovery. So, never backup the online redo log when doing cold backup. Ö Àñ£¡ chal_ping [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chal_ping INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
