Configure RMAN Backup On Windows :

Database is supported on windows and some people using Windows As Production and RMAN need to be configured to ensure backup for Database in such failure or something to do this follow the below steps :-


    Create first text file called backup and change the format to "bat", inside the file add the following lines :-

    C:
    cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
    rman @E:\RMAN\Scripts\backup.rman


    Create 3 folders in E for example :-
        backup
        Archivelog
        Controlfile

    Create second file name it Backup.rman and add the Rman Script like below

    connect target /
    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;
    backup AS COMPRESSED BACKUPSET tag Full_database_open format 'E:\RMAN\backup\db_%t_%s_p%p.bkp' database;
    backup AS COMPRESSED BACKUPSET archivelog all format 'E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch' delete all input;
    backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format 'E:\RMAN\backup\cf_%t_%s_p%p.bkp';
    backup tag ORCL_CONTROL current controlfile format 'E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL';
    delete noprompt expired backup;
    release channel c1;
    release channel c2;
    release channel c3;
    release channel c4;
    }


  - Follow the screen now :-




    - Add Task Name and Description


    - Add The Time for this Task in this tab




    Another Screen :-




    In This Screen Add Bat File in our case backup.bat






Thanks.
NJ