rman backup fails on windows when using batch file
845201May 3 2011 — edited May 4 2011Hello Gurus ..
I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.
D:\> \\3.193.211.19\sgdba\rman\bkp_acressit.bat
D:\>rman catalog rman/******@acressit target / cmd
file=E:\sgdba\rman\bkp_arch.rcv log E:\sgdba\rman\sit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:\sgdba\rman\sit_arch_rman_backup.log"
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:\sgdba\rman\bkp_arch.rcv"
------------------------------------------------------------------------------
Contents of the batch file and RCV file as below:
Batch File:
rman catalog rman/*******@acressit target / cmdfile=E:\sgdba\rman\bkp_arch.rcv log E:\sgdba\rman\sit_arch_rman_backup.log
RCV File:
RUN {
ALLOCATE CHANNEL ch1 TYPE
DISK FORMAT 'E:\ORA_RMAN_BACKUP\ARCH_%d_%u_%s_%p';
BACKUP ARCHIVELOG delete input;
RELEASE CHANNEL ch1;
}
EXIT;
--------------------------xxxxxxxxxxxxxx------------------------
* on my DB server I am login using my administrator account, on my PC I dont have admin account.
* I have checked remote execution using local user as well as admin user.
* I have checked the permission and my local ID & EVERYONE has all permission in that folder.
Any help will be appriciated.
Thanks & Regards
Ashish