Forum Discussion

Robert_Backup's avatar
Robert_Backup
Level 3
4 years ago

Oracle Rac multi node restore

Hi Everyone,


Do you know if Netbackup can support multi node restore for Oracle Rac?

Our DBA says it can improve a lot the restore times and would like to test it.


Tks
Rob
Linux
  • bhdrkzltn's avatar
    bhdrkzltn
    Level 4
    4 years ago

    Here is the script distributes RMAN channels over 8 RAC nodes.

    SPOOL LOG TO '/home/oracle/rman/log/validate_ABC_FULLDB_MSDP.log' APPEND;
    connect target 'SYS/xxx@ABC1'
    run
    {
    set command id to 'full_backup';
    host 'export NLS_DATE_FORMAT="DD-Mon-YYYY HH24:MI:SS"';
    allocate channel ch01 device type SBT connect 'SYS/xxx@ABC1' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch02 device type SBT connect 'SYS/xxx@ABC2' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch03 device type SBT connect 'SYS/xxx@ABC3' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch04 device type SBT connect 'SYS/xxx@ABC4' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch05 device type SBT connect 'SYS/xxx@ABC5' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch06 device type SBT connect 'SYS/xxx@ABC6' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch07 device type SBT connect 'SYS/xxx@ABC7' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    allocate channel ch08 device type SBT connect 'SYS/xxx@ABC8' maxopenfiles 1 format 'DB_ABC_MSDP_L0_%d_%T_%U';
    SEND 'NB_ORA_POLICY=DB_ABC_FULL, NB_ORA_SERV=nbmaster.lab';
    restore database validate; }

    Bahadir.