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
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
What about:
sqlplus -s
What about:
sqlplus -s
What about:
sqlplus -s
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 thoug
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 S
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
>
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 = (
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
- O
L 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
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
2 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
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
T
e respond to Subject: 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
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
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
18 matches
Mail list logo
