| 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: RMAN question...spool command
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFFD5F.8EBCDA48
Content-Type: text/plain;
charset="iso-8859-1"
Janardhana, if no one has answered you yet, here's how I've done it in the past from a ksh script:
rman rcvcat rman/rman@$CATALOG msglog=\'$LOG_FILE\' << EOF connect target;
run { execute script archive_log_current;
execute script back_it_up; }
EOF
-----Original Message-----
From: Janardhana Babu [mailto:jbdonga_at_ucdavis.edu]
Sent: Wednesday, August 02, 2000 2:47 PM
To: Multiple recipients of list ORACLE-L
Subject: RMAN question...spool command
Dear list,
Could someone tell me how to spool to a file, the output of rman script. Spool command is not working. Is there any command that I can use to spool the output of the following RMAN script. Iam on HP-UX 11.0 Oracle8.1.5.
run {
allocate channel d1 type disk;
setlimit channel d1 kbytes 2048000 maxopenfiles 10 readrate 200;
backup
incremental level 0 filesperset 10 format '/u01/oracle/rtest_bkup/%d_L0_%t_%s_%p' database;
Any help is appreciated.
Thanks,
-- Janardhana Babu
-- Author: Janardhana Babu INET: jbdonga_at_ucdavis.edu 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: 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). ------_=_NextPart_001_01BFFD5F.8EBCDA48 Content-Type: text/html; charset="iso-8859-1"Received on Thu Aug 03 2000 - 10:29:04 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: RMAN question...spool command</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Janardhana, if no one has answered you yet, here's how I've done it in the past from a ksh script:</FONT>
</P>
<BR>
<P><FONT SIZE=2>rman rcvcat rman/rman@$CATALOG msglog=\'$LOG_FILE\' << EOF</FONT>
<BR><FONT SIZE=2>connect target;</FONT>
</P>
<P><FONT SIZE=2>run { execute script archive_log_current; </FONT>
<BR><FONT SIZE=2> execute script back_it_up; }</FONT>
<BR><FONT SIZE=2>EOF</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Janardhana Babu [<A HREF="mailto:jbdonga_at_ucdavis.edu">mailto:jbdonga_at_ucdavis.edu</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, August 02, 2000 2:47 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RMAN question...spool command</FONT>
</P>
<BR>
<P><FONT SIZE=2>Dear list,</FONT>
</P>
<P><FONT SIZE=2>Could someone tell me how to spool to a file, the output of rman script.</FONT>
<BR><FONT SIZE=2>Spool command is not working. Is there any command that I can use to spool</FONT>
<BR><FONT SIZE=2>the output of the following RMAN script. Iam on HP-UX 11.0 Oracle8.1.5.</FONT>
</P>
<P><FONT SIZE=2>run { </FONT>
<BR><FONT SIZE=2>allocate channel d1 type disk;</FONT>
<BR><FONT SIZE=2>setlimit channel d1 kbytes 2048000 maxopenfiles 10 readrate 200;</FONT>
<BR><FONT SIZE=2>backup</FONT>
<BR> <FONT SIZE=2>incremental level 0</FONT>
<BR> <FONT SIZE=2>filesperset 10</FONT>
<BR> <FONT SIZE=2>format '/u01/oracle/rtest_bkup/%d_L0_%t_%s_%p'</FONT>
<BR> <FONT SIZE=2>database;</FONT>
<BR><FONT SIZE=2>release channel d1; </FONT>
<BR><FONT SIZE=2>}</FONT>
</P>
<P><FONT SIZE=2>Any help is appreciated.</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
<BR><FONT SIZE=2>-- Janardhana Babu</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Janardhana Babu</FONT>
<BR><FONT SIZE=2> INET: jbdonga_at_ucdavis.edu</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
 |
 |