Re: backup controlfile to trace
If you want to do this method without a log file... your_file=$( sqlplus -s < Sent: Wednesday, September 18, 2002 10:23 AM What about: sqlplus -s <logfile / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF your_file=`tail -1 logfile` echo $your_file Regards, Waleed -Original Message- Sent: Tuesday, September 17, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:03 PM SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Servi
Re: backup controlfile to trace
Yes, you can certainly do that -- I was just disappointed that the script would have to be a shell script instead of just a sql script. I usually do it without creating an intermediate logfile at all by using ksh's bidirectional pipe feature. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 10:23 AM What about: sqlplus -s <logfile / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF your_file=`tail -1 logfile` echo $your_file Regards, Waleed -Original Message- Sent: Tuesday, September 17, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:03 PM SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACL
RE: backup controlfile to trace
What about: sqlplus -s <logfile / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF your_file=`tail -1 logfile` echo $your_file Regards, Waleed -Original Message- Sent: Tuesday, September 17, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:03 PM SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
What about: sqlplus -s <logfile / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF your_file=`tail -1 logfile` echo $your_file Regards, Waleed -Original Message- Sent: Tuesday, September 17, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:03 PM SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace (retry)
What about: sqlplus -s <logfile / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF your_file=`tail -1 logfile` echo $your_file Regards, Waleed -Original Message- Sent: Tuesday, September 17, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:03 PM SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backup controlfile to trace
On Tue, Sep 17, 2002 at 09:03:18PM -0800, Rahul wrote: > why not just simplay *name* it !!! > > SQL> alter database backup controlfile to '/oracle/ctrl.trc'; This is what I've been doing in my backup set, but I wanted to add the flat version as a backup to the backup. I never would have thought it would be such painful experience. I think I have similar file redirection problems on my Apple I. Way to go, big o! Is the debug method bullet proof? In other words, is there any way for some other trc file to get in the middle? If so, then the grep for the commands is appropriate. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
;-( typed too fast the poster asked for the "trace" .. not the binary copy of the file me wrong.. me appologise... > -- > From: Rahul[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Wednesday, September 18, 2002 12:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: backup controlfile to trace > > why not just simplay *name* it !!! > > SQL> alter database backup controlfile to '/oracle/ctrl.trc'; > > > > -- > > From: Ray Stell[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Wednesday, September 18, 2002 1:13 AM > > To: Multiple recipients of list ORACLE-L > > Subject:backup controlfile to trace > > > > > > 8.1.7 > > > > For scripting purposes, what is the logic for finding the trc file from > > alter database backup controlfile to trace cmd? This seems really > > stupid not being able to direct the output. > > === > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ray Stell > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
why not just simplay *name* it !!! SQL> alter database backup controlfile to '/oracle/ctrl.trc'; > -- > From: Ray Stell[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Wednesday, September 18, 2002 1:13 AM > To: Multiple recipients of list ORACLE-L > Subject: backup controlfile to trace > > > 8.1.7 > > For scripting purposes, what is the logic for finding the trc file from > alter database backup controlfile to trace cmd? This seems really > stupid not being able to direct the output. > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
Dependent on platform, but it almost always contains the OS process id which you can get from v$process. So something like select c.value || '/' || 'appropriate_format_string'|| a.spid || '.trc' from v$process a, v$session b, v$parameter c where a.addr = b.paddr and b.sid = ( select sid from v$mystat where rownum = 1) and c.name = 'user_dump_dest' hth connor --- Kevin Lange <[EMAIL PROTECTED]> wrote: > The way we do it is not 100% but it seems close > enough. We run the backup > command and then do a descending order listing by > date from the trace > directory. The first file is the one containing > the trace. > > If anyone has a beter idea, I am all ears. > > Kevin > > -Original Message- > Sent: Tuesday, September 17, 2002 1:13 PM > To: Multiple recipients of list ORACLE-L > > > > 8.1.7 > > For scripting purposes, what is the logic for > finding the trc file from > alter database backup controlfile to trace cmd? > This seems really > stupid not being able to direct the output. > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kevin Lange > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backup controlfile to trace
Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv &trcfile /backups/ -- Philip - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:03 PM SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
Arg. There's at least one caveat in that "AUDSID" won't work if you're logged in as SYSDBA, since it'll be 0, just like the background processes (I did my testing on 9iR2). Oh well... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Jesse, Rich > Sent: Tuesday, September 17, 2002 3:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: backup controlfile to trace > > > Cool idea, Kirti, but wouldn't it be better to filter the results with > > AND s.audsid = USERENV('SESSIONID') > > instead of running thru v$mystat? USERENV is available at > least as far back > as 8.0.5. > > Not that it matters greatly for this particular purpose, but > I know that > code around here tends to multiply. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
SQL> oradebug setmypid Statement processed. SQL> alter database backup controlfile to trace; Database altered. SQL> oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
Cool idea, Kirti, but wouldn't it be better to filter the results with AND s.audsid = USERENV('SESSIONID') instead of running thru v$mystat? USERENV is available at least as far back as 8.0.5. Not that it matters greatly for this particular purpose, but I know that code around here tends to multiply. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 2:59 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: backup controlfile to trace > > > Here is a snippet from one of our scripts: > - Kirti > > > ($SQLPLUS -s / < set head off > set pages 0 > set feedback off > set termout off > spool /tmp/$$trace_name.lst > SELECT m.value || '/ora_'||p.spid||'_'|| lower(d.name)||'.trc' > FROM v\$session s, > v\$process p, > v\$parameter m, > v\$database d > WHERE > m.name = 'user_dump_dest' > AND > p.addr = s.paddr > AND > s.sid in (select distinct a.sid >from v\$mystat a > ); [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
Here is a snippet from one of our scripts: - Kirti ($SQLPLUS -s / < /dev/null TRCFILE=`cat /tmp/$$trace_name.lst` rm /tmp/$$trace_name.lst cp ${TRCFILE} ${CR_CONTROL_FILE_SQL} -Original Message- Sent: Tuesday, September 17, 2002 2:15 PM To: Multiple recipients of list ORACLE-L The way we do it is not 100% but it seems close enough. We run the backup command and then do a descending order listing by date from the trace directory. The first file is the one containing the trace. If anyone has a beter idea, I am all ears. Kevin -Original Message- Sent: Tuesday, September 17, 2002 1:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
Snippet of code I use: ls -t ${UDUMP} | while read line ; do ${GREP} -q 'CREATE CONTROLFILE' ${UDUMP}/${line} if [ $? -eq 0 ] ; then echo " Processing file ${ORACLE_SID}.ccf" cp "${UDUMP}/${line}" "${ORACLE_SID}.ccf" break fi done Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/17/02 12:14 PMcc: Please respond to Subject: RE: backup controlfile to trace ORACLE-L The way we do it is not 100% but it seems close enough. We run the backup command and then do a descending order listing by date from the trace directory. The first file is the one containing the trace. If anyone has a beter idea, I am all ears. Kevin -Original Message- Sent: Tuesday, September 17, 2002 1:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
The way we do it is not 100% but it seems close enough. We run the backup command and then do a descending order listing by date from the trace directory. The first file is the one containing the trace. If anyone has a beter idea, I am all ears. Kevin -Original Message- Sent: Tuesday, September 17, 2002 1:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backup controlfile to trace
Not pretty, but this is how I do it: —- snippet of my hot backup script —- sqlplus / <>> [EMAIL PROTECTED] 09/17/02 02:13PM >>> 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backup controlfile to trace
Title: RE: backup controlfile to trace a non-full proof method that I use is T_FILE=$(ls -1rt /$ORACLE_HOME/admin/udump | tail -1) this will assign $T_FILE to the newest file existing in UDUMP. -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: backup controlfile to trace 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
backup controlfile to trace
8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).