Opa Wadson vlw pela resposta.
qual seria o parametro pra mudar?
--- Em oracle_br@yahoogrupos.com.br, Wadson Ramon <wramon@...> escreveu
>
> Neto vc precisa utilizar a compactação HIGH de cara eu já te falo se vc
> não usa-la o tempo de backup já vai cair sensivelmente .
> Vc pode alocar mais canais e fazer um teste para ver se melhora em alguns
> casos sim.
>
> vlw.
>
>
> 2013/2/16 netodba <neto.longhi@...>
>
> > **
> >
> >
> > Fala Pessoal,
> >
> > migrei uma base de dados 2.5 TB 10G pro 11.2.0.3, o meu problema é que o
> > backup rman ta demorando de mais.
> >
> > Ambiente:
> > S.O: RH 6.3
> > RAC 4 nós Oracle 11.2.0.3 em ASM
> > Tamanho da base: 2.5 Tb
> > Local onde é armazenado o backup é em acfs compartilhado com os 4 nós.
> > O backup é executado apenas na instancia 1.
> >
> > política de backup:
> > Domingo 1:00 da manhã roda um full.
> > Segunda a sabado as 1:00 roda o incremental.
> > Todo dia de 8:00 as 18:00 roda o de archivelog.
> >
> > compigurações do rman:
> >
> > CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
> > CONFIGURE BACKUP OPTIMIZATION ON;
> > CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
> > CONFIGURE CONTROLFILE AUTOBACKUP ON;
> > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
> > default
> > CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED
> > BACKUPSET;
> > CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> > CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> > CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> > CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> > CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
> > CONFIGURE COMPRESSION ALGORITHM 'HIGH' OPTIMIZE FOR LOAD TRUE AS OF
> > RELEASE 'DEFAULT';
> > CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
> > CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DG02_R6/snapcf_PRODDB.f';
> >
> > script de backup full:
> >
> > run {
> > ALLOCATE CHANNEL ch00 TYPE disk ;
> > ALLOCATE CHANNEL ch01 TYPE disk ;
> > ALLOCATE CHANNEL ch02 TYPE disk ;
> > ALLOCATE CHANNEL ch03 TYPE disk ;
> > backup incremental level 0 tag = bkpL0_proddb
> > format
> > '/u01/app/acfsmounts/fradg_orabkplv/bkp/proddb/rman/backup/bkp_%d_%T_%s_%p_%U'
> > database;
> > sql 'alter system archive log current';
> > RELEASE CHANNEL ch00;
> > RELEASE CHANNEL ch01;
> > RELEASE CHANNEL ch02;
> > RELEASE CHANNEL ch03;
> >
> > ALLOCATE CHANNEL ch00 TYPE disk;
> > backup tag = contf_prodb
> > format
> > '/u01/app/acfsmounts/fradg_orabkplv/bkp/proddb/rman/backup/contf_%d_%T_%s_%p_%U'
> > current controlfile;
> > RELEASE CHANNEL ch00;
> >
> > ALLOCATE CHANNEL ch00 TYPE disk;
> > ALLOCATE CHANNEL ch01 TYPE disk;
> > backup tag = arch_prodb
> > format
> > '/u01/app/acfsmounts/fradg_orabkplv/bkp/proddb/rman/archive/arc_%d_%T_%s_%p_%U'
> > check logical archivelog all delete input;
> > RELEASE CHANNEL ch00;
> > RELEASE CHANNEL ch01;
> > }
> >
> > script backup incremental:
> >
> > run {
> > ALLOCATE CHANNEL ch00 TYPE disk ;
> > ALLOCATE CHANNEL ch01 TYPE disk ;
> > backup incremental level 1 tag = bkpL1_proddb
> > format
> > '/u01/app/acfsmounts/fradg_orabkplv/bkp/proddb/rman/backup/bkp_%d_%T_%s_%p_%U'
> > database;
> > sql 'alter system archive log current';
> > RELEASE CHANNEL ch00;
> > RELEASE CHANNEL ch01;
> >
> > ALLOCATE CHANNEL ch00 TYPE disk;
> > backup tag = contf_prodb
> > format
> > '/u01/app/acfsmounts/fradg_orabkplv/bkp/proddb/rman/backup/contf_%d_%T_%s_%p_%U'
> > current controlfile;
> > RELEASE CHANNEL ch00;
> >
> > ALLOCATE CHANNEL ch00 TYPE disk;
> > ALLOCATE CHANNEL ch01 TYPE disk;
> > backup tag = arch_prodb
> > format
> > '/u01/app/acfsmounts/fradg_orabkplv/bkp/proddb/rman/archive/arc_%d_%T_%s_%p_%U'
> > check logical archivelog all delete input;
> > RELEASE CHANNEL ch00;
> > RELEASE CHANNEL ch01;
> >
> > vcs podem me ajudar??
> > perguntem o que quiserem, mandei select's na view pra eu executar.
> >
> >
> >
>
>
> [As partes desta mensagem que não continham texto foram removidas]
>
