Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problems scheduling/running O8BACKUP with NT "AT" & RMAN

Problems scheduling/running O8BACKUP with NT "AT" & RMAN

From: <wac3_at_my-dejanews.com>
Date: Thu, 14 Jan 1999 20:38:24 GMT
Message-ID: <77lkjv$jue$1@nnrp1.dejanews.com>


I am trying to Schedule a Backup of an Oracle8 database using the Windows NT
"AT" Command & the Recovery Manager utility (RMAN). I have associated a .bat
file to run which opens RMAN, connects to the target database and the recovery catalog database. Also, I have instructed RMAN to process a Commandfile (.cmd/cmdfile) to actually execute a previously created backup script. In order to spool out the results I created a messagelog file (msglog)which is also part of the .bat file.

#Windows NT> AT 02:00 "oracle_nightlybkup.bat"

"oracle_nightlybkup.bat" =

rman80 target=\"internal/oracle_at_oracle.world\" rcvcat=\"rman/rman\@recovery" cmdfile '/D:/orant/RDBMS80/ADMIN/CommandFile/nightlybkup.cmd' msglog '/D:/orant/RDBMS80/ADMIN/MessageLog/nightly.msg' append

#Create Script to be called by cmdfile nightlybkup.cmd

Create script nightly_backup {
allocate channel c1 type disk;
backup full filesperset 4
(database format 'ORAWORLD.FULL.%n.%s.%p'); }

"nightlybkup.cmd" =

Run (EXECUTE SCRIPT nightly_backup);

Am I going about this the wrong way? Any suggestions...

Thanks,

Bill Connell

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 14 1999 - 14:38:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US