RMAN Backup using .bat file for use in creating a scheduled task in Windows
Hi All,
I am trying to backup a small 10G Oracle (noarchivemode+no catalog) Database on a Windows 2003 Server.
I want to use a scheduled task in windows to do this (not EM as I also have 9i databases I wish to utalise the script on) and am going wrong somewhere with the scripting.
I have set other parameters like backup control file within RMAN config
Can anyone tell me what I am doing wrong? I get invalid SQL on the first command 'shutdown immediate'
Bat File Contains
RMAN target user/password@database nocatalog CMDFILE C:\RMAN_FULLBACKUP.RCV LOG C:\RMAN_FULLBACKUP.LOG
RCV file Contains
SQL "shutdown immediate";
SQL "startup mount";
backup as compressed backupset database;
SQL "alter database open";