• Arun Kumar

Schedule RMAN Backup on Windows

Create a .cmd file with rman run command block:

run{
crosscheck backup;
backup database plus archivelog;
};

Create a .bat extension file (this is windows bash shell file) which will call above .cmd file.

set oracle_sid=orcl
rman target sys/sys@ecccatalog rman_rc/rman_rc@rcatcmdfile=F:\backup.cmd’ log=F:\rman_backup_full\backup.log’

Schedule the above .bat script in windows scheduler.

  1. Launch the task scheduler from start menu.

  2. On the right-hand panel, click on create task.

Create Task

3. Give a name to your task.

Name to your Task

4. Click on Triggers tab à New and define the schedule.

Define the schedule

Make sure you set proper frequency like daily or weekly and set proper start date and time.


5. Click on Actions tab à New and provide the location of .bat file you created.


6. Click on OK and task will be created. You can even run the task for testing by right clicking on the task name and select Run.

Task will be created

Recent Posts

See All

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

How to check database backups

Checking Database backups are one of the main focus areas of a DBA. Time to time, DBA needs to check database backup status and see if its completed, failed, running etc. Also, DBA must be able to get

Automate RMAN Backups using Shell Scripts

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback