Message-Id: <10578.113739@fatcity.com> From: "Koivu, Lisa" Date: Thu, 3 Aug 2000 11:29:04 -0400 Subject: 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@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; release channel d1; } Any help is appreciated. Thanks, -- Janardhana Babu -- Author: Janardhana Babu INET: jbdonga@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@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" RE: RMAN question...spool command

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@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;
release channel d1;
}

Any help is appreciated.

Thanks,
-- Janardhana Babu
--
Author: Janardhana Babu
  INET: jbdonga@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@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).