Netsoftmate

Tag: schedule rman backup on windows

  • Schedule Rman backup on windows operating system


    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