Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-00556: could not open CMDFILE

Noname123Jun 13 2016 — edited Jun 15 2016

I am using oracle 11g,   windows server 2008 R2

I am getting the following error in the backup log i created whenever I execute the backup batch.

RMAN-00556: could not open CMDFILE "C:\fnetprod_backup_scripts\fnetprod_full_weekly_backup\fnetprod_full_weekly_RMANbackup.rmn

  1. I have created one batch file that is scheduled to take full backup once weekly named  (fnetprod_full_weekly_backup.bat)
  2. I have created one file that includes RMAN backup script with the extension of .rmn   (fnetprod_full_weekly_RMANbackup.rmn)
  3. I have created an empty file to append the output of the backup there.  (fnetprod_full_weekly_backup_output)

All the three above scripts are in this folder:

C:\fnetprod_backup_scripts\fnetprod_full_weekly_backup

Here is the batch file content ( fnetprod_full_weekly_backup.bat):

set ORACLE_SID=fnetprod

cd\

E:

cd Oracle

cd product

cd 11.1.0

cd db_2                      

cd BIN

rman target / cmdfile 'C:\fnetprod_backup_scripts\fnetprod_full_weekly_backup\fnetprod_full_weekly_RMANbackup.rmn'  log 'C:\fnetprod_backup_scripts\fnetprod_full_weekly_backup\fnetprod_full_weekly_backup_output.txt'

Here is the RMAN backup script file (fnetprod_full_weekly_RMANbackup.rmn)

run{

allocate channel d1 type disk;

allocate channel d2 type disk;

allocate channel d3 type disk;

configure controlfile autobackup format for device type disk to 'C:\fnetprod_db_backup/%F';

backup as compressed backupset incremental level 0 tag hot_db_bk_level0  filesperset 30 format

'C:\fnetprod_db_backup/BAKUP%d_%u.F_bkp'(database) plus archivelog delete all input;

delete noprompt obsolete;

delete noprompt expired backup;

RELEASE CHANNEL d1;

RELEASE CHANNEL d2;

RELEASE CHANNEL d3;

BACKUP SPFILE format "C:\fnetprod_db_backup/SPFILE_%s_%p_%d_%u.bak";

}

I have searched the error:

RMAN-00556 could not open CMDFILE "string"

Cause: An error occurred when trying to open the file.

Action: Check that the file name was specified correctly and that the file exists and that the user running RMAN has read permission for the file.

  1. I checked the file name , and it was specified correctly.
  2. I checked that the file exists
  3. I checked the permission whether my user has read permission on the file .  The user has full control and given all permissions including read on the folder that contain the scripts.

I followed the error message provided by documentation but i couldn't reach to a solution.  I am kind of lost here.  Any idea?

This post has been answered by javeedmd on Jun 15 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2016
Added on Jun 13 2016
15 comments
10,365 views