Home » RDBMS Server » Backup & Recovery » rman backup fails on windows when using batch file (11g)
rman backup fails on windows when using batch file [message #505564] Tue, 03 May 2011 21:34 Go to next message
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 Go to previous messageGo to next message
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

Re: rman backup fails on windows when using batch file [message #506959 is a reply to message #505564] Thu, 12 May 2011 01:00 Go to previous message
Michel Cadot
Messages: 65561
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear from where you execute the command:
Quote:
target /

So you are on the database server not on your PC, so E:\sgdba\rman\sit_arch_rman_backup.log must refer a path on the server not on the PC.

Regards
Michel
Previous Topic: Recovery from 'create tables as'
Next Topic: RMAN
Goto Forum:
  


Current Time: Mon Jul 16 23:15:59 CDT 2018