| rman backup fails on windows when using batch file [message #505564] |
Tue, 03 May 2011 21:34  |
 |
ashish_dba
Messages: 1
Registered: May 2011
Location: Singapore
|
Junior Member |
|
|
Hello 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
|
|
|
|
| Re: rman backup fails on windows when using batch file [message #506928 is a reply to message #505564] |
Wed, 11 May 2011 21:30  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
ashish_dba wrote on Tue, 03 May 2011 22:34..Etc... 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...
RMAN-00556: could not open CMDFILE "E:\sgdba\rman\bkp_arch.rcv"
...Etc...
You need to execute rman from the source server NOT your LOCAL desktop.
DUH!
[Updated on: Thu, 12 May 2011 00:56] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
