Netsoftmate

Schedule Rman backup on windows operating system

Written by

Netsoftmate

in


Overview:

Oracle
Recovery Manager (RMAN) provides a comprehensive foundation for efficiently
backing up and recovering the Oracle databases, it provides a common interface, via command line
and Enterprise Manager, for backup tasks across different host operating systems, automates
administration of your backup strategies.


Prerequisites:

  • Database should be in archive log mode.
  • We need to have super user credentials.

Steps to schedule Rman backup:

  • Create Rman scripts
Open
textpad
Set
ORACLE_SID=<DB_Name>

D:oracle11204product11.2.0dbhome_1BINrman.exe
target / cmdfile= ‘F:Backup_scriptsdbname_rman_target.sql’ log=’F:Backup_scriptsdbname_target_backup.log’

Save
and exit

Run

{
Allocate
channel c1 device type disk;
Allocate
channel c2 device type disk;
Allocate
channel c3 device type disk;

Crosscheck
backup;
Crosscheck
archivelog all;

Delete
noprompt expired backup;
Delete
noprompt expired archivelog all;

Backup
as compressed backupset database;
Backup
as compressed backupset archivelog all;

Delete
noprompt backup completed before ‘sysdate-3’;
Delete
noprompt archivelog all completed before ‘sysdate-2’;

Backup
current controlfile;

} 


  • Open the task scheduler from start menu then right click and
    click on create new Task.


  • Give name
    and description of Backup in General Tab.



  • Click on trigger tab then click on new to
    schedule.



  • Provide backup
    date and time then click on OK.



  • Now click
    on action tab then new.


  • On this
    screen browse and supply Rman script name and location then click ok.



  • Now
    go to condition tab and check the conditions.

Check
setting tab and click OK



  • Once click ok, it will prompt for password, provide Administrator
    password and click ok



  • Backup has been schedule
    now.



Conclusion:

In above article we have learned that, how
to schedule Rman backup on windows environment, where we have prepared Rman
scripts and schedule it through task scheduler.


BY

Name: Mirza Hidayathullah Baig

Designation: Senior Database Engineer

Organization: Netsoftmate IT Solutions. 

Email: info@netsoftmate.com

 







Comments

2 responses to “Schedule Rman backup on windows operating system”

  1. Anonymous Avatar
    Anonymous

    Hi Mirza,

    Thank you for the tutorial. I'd like to know, if the environment setting and backup script are placed on one file which is the dbname_rman_target.sql?

    Thank you.

    Regards,
    Violet.

    Reply
    1. Sherzad Zahid Avatar
      Sherzad Zahid

      Thank brother,
      violet, you need to save two files one file with anyname.cmd this file need to contains the following data
      ============================
      Set ORACLE_SID=prod

      D:OraHomeappproduct11.2.0dbhome_1BINrman.exe target / cmdfile= 'D:rman.sql' log='D:dbname_target_backup.log'
      ====================================
      second file you need to put your database RMAN Backup script as mentioned bellow.
      =============
      RUN {
      ALLOCATE CHANNEL c1 DEVICE TYPE disk;
      ALLOCATE CHANNEL c2 DEVICE TYPE disk;
      ALLOCATE CHANNEL c3 DEVICE TYPE disk;
      ALLOCATE CHANNEL c4 DEVICE TYPE disk;
      CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
      BACKUP
      FULL
      FORMAT '%d_%U'
      DATABASE
      INCLUDE CURRENT CONTROLFILE
      PLUS ARCHIVELOG
      ;
      RELEASE CHANNEL c1;
      RELEASE CHANNEL c2;
      RELEASE CHANNEL c3;
      RELEASE CHANNEL c4;
      }
      =======================
      save the file with anyname.sql and schedule it

      thanks
      Zahid

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts