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
- I have created one batch file that is scheduled to take full backup once weekly named (fnetprod_full_weekly_backup.bat)
- I have created one file that includes RMAN backup script with the extension of .rmn (fnetprod_full_weekly_RMANbackup.rmn)
- 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.
- I checked the file name , and it was specified correctly.
- I checked that the file exists
- 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?