RMAN automatic backup Schedule in a Batch file on Windows:

1) Create a batch file 'test.bat'  and insert the following commands in batch.

set oracle_sid=orcl
rman target=/ @cmdfile.txt

2) Create a text file 'cmdfile.txt' and include the following commands in text file.

run
{
backup incremental level 0 database plus archivelog delete input;
backup archivelog all delete input;
delete force noprompt obsolete;
backup current controlfile spfile;
}


- Adjust the parameters according to your needs in text file.

3) Now, run the batch file and test if it is running fine.

4) Schedule the batch file in Windows task scheduler.


Cheers!