Schedule rman backup in windows

We are going to learn about the steps which we will use for schedule rman backup in windows. Most probably Organisations use Linux and Unix OS as per there requirements but sometimes as per company’s requirements, we have to use windows. Here we are going to have look at the process of schedule rman backup in windows.

Let’s have look at it.

–rman.cmd need to schedule only this which call another script.

set oracle_sid=orcl
rman target sys/passwd nocatalog cmdfile=’d:\oracle\rman\dbrman.cmd’ log=’d:\oracle\rman\bk_log_1.log’

–dbrman.cmd

run
{
allocate channel d1 type disk;
backup
tag whole_database_open
format ‘d:\oracle\archive\db_%t_%s_p%p’
database;
sql ‘alter database switch logfile’;
sql ‘alter database switch logfile’;
backup arch_1ivelog all
format ‘d:\oracle\archive\al_%t_%s_p%p’
delete all input;
delete noprompt obsolete;
backup current controlfile
tag =cf1
format ‘d:\oracle\archive\cf_%t_%s_p%p’;
}

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp