Paloma, A pasta '/backup1/rman' está gravando no SAS 7200 rpm ? Aliás, 7200 rpm é a mesma velocidade de hd de computador desktop comum
On 27 January 2016 at 11:11, [email protected] [oracle_br] < [email protected]> wrote: > > > Bom dia, > > > Oracle 11.2.0.4 stander (Rac 2 nós) > > Red Hat 5.7 enterprise > > Database em storage SSD > > Disco local SAS 7200 rpm > > > Temos um banco que possui 1.5TB que está em storage SSD com ASM e demora > 16 horas para fazer um backup full via RMAN. O backup está sendo gerado no > disco local conforme configuração acima. Estou achando muito demorado, o > que pode estar acontecendo? Segue abaixo a configuração do RMAN e o script > utilizado para a execução do backup. > > > > > > RMAN> show all; > > > RMAN configuration parameters for database with db_unique_name PRD are: > > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; > > CONFIGURE BACKUP OPTIMIZATION OFF; # default > > CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default > > CONFIGURE CONTROLFILE AUTOBACKUP ON; > > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO > '/backup1/rman/control%F'; > > CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM > 1; > > CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default > > CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default > > CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT > '/backup1/rman/ora_prod%t_s%s%p.bkp' MAXPIECESIZE 8 G; > > CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT > '/backup/rman/ora_prod%t_s%s_s%p.bkp' MAXPIECESIZE 2 G; > > CONFIGURE MAXSETSIZE TO UNLIMITED; # default > > CONFIGURE ENCRYPTION FOR DATABASE OFF; # default > > CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default > > CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE > FOR LOAD TRUE ; # default > > CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default > > CONFIGURE SNAPSHOT CONTROLFILE NAME TO > '+ORAFRA/PRD/CONTROLFILE/snapcf_prd1.f'; > > CONFIGURE SNAPSHOT CONTROLFILE NAME TO > '+ORAFRA/prd/controlfile/snapcf_prd1.f'; > > > > run { > > CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT > '/backup/rman/ora_prod%t_s%s_s%p.bkp' MAXPIECESIZE 2 G; > > CONFIGURE CONTROLFILE AUTOBACKUP ON; > > crosscheck backup; > > delete noprompt expired backup; > > crosscheck archivelog all; > > delete noprompt expired archivelog all; > > CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT > '/backup/rman/ora_prod%t_s%s_s%p.bkp' MAXPIECESIZE 2 G; > > backup database plus archivelog; > > delete noprompt archivelog all backed up 2 times to device type > disk; > > delete noprompt obsolete device type disk; > > CONFIGURE CONTROLFILE AUTOBACKUP OFF; > > } > > > Paloma Barbosa > > > >
