| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: backup controlfile to trace
What about:
sqlplus -s <<EOF >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/
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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: stellr_at_cns.vt.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Sep 18 2002 - 10:18:25 CDT
(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: Waleed.Khedr_at_FMR.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: philipd_at_sirs.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |