Pular para o conteúdo

Fóruns Banco de dados Oracle I/O – error RMAN I/O – error RMAN

#89115
vieri
Participante

    Rodrigo já testei com todos meus scripts de backup’s possiveis segue o ultimo. Outra informação meu ambiente é um rac de 2nodes.

    script de backup:
    configure retention policy to recovery window of 7 days;
    configure controlfile autobackup on;
    configure default device type to Disk;
    configure device type Disk parallelism 2;
    configure datafile backup copies for device type Disk to 1;
    set controlfile autobackup format for device type Disk to ‘/u02/backup/rman/deprac/level0/dbs/DEPRAC_ctl_%F’;

    run{
    debug on;
    allocate channel ch1 type Disk maxpiecesize = 2G ;
    backup incremental level 0 filesperset 1
    format ‘/dba/wis/rman/deprac/level0/dbs/dep_%U.rman’
    (database include current controlfile);
    release channel ch1;
    debug off;
    }

    run {
    allocate channel ch1 type Disk ;
    sql “alter system archive log current”;
    backup archivelog all filesperset 10
    format ‘/dba/wis/rman/deprac/level0/arch/arch_%U.rman’
    delete all input;
    release channel ch1;
    resync catalog;
    }

    CROSSCHECK BACKUP;
    ##RESTORE TABLESPACE SYSTEM VALIDATE;
    ##RESTORE ARCHIVELOG ALL VALIDATE;
    LIST BACKUP OF DATABASE;
    REPORT UNRECOVERABLE;
    REPORT SCHEMA;
    REPORT NEED BACKUP;
    REPORT OBSOLETE;
    quit
    EOF