Re: backup controlfile to trace

From: Philip Douglass <philipd_at_sirs.com>
Date: Tue, 17 Sep 2002 14:28:25 -0800
Message-ID: <F001.004D1DBD.20020917142825@fatcity.com>

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" <ORACLE-L_at_fatcity.com> 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 stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
--

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-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

--

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