Ele informou que a versão é standard, logo, não pode paralelizar.
Em qua, 27 de jan de 2016 às 11:22, Ricardo Arnoud ricardo...@gmail.com
[oracle_br] <oracle_br@yahoogrupos.com.br> escreveu:
>
>
> Experimente aumentar o número de canais.
>
>
> On Wed, Jan 27, 2016 at 11:11 AM, palomacbarb...@yahoo.com.br [oracle_br]
> <oracle_br@yahoogrupos.com.br> 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
>>
>>
>>
>
>
> --
> --
> Thanks,
> * Ricardo Arnoud*
>
> *Bacharel em Ciência da Computação* - 2013/1
>
>
>
>
>
> (51) 9511-4658 VIVO / (51) 9259-2333 CLARO / Porto Alegre - RS
> http://www.ricardoarnoud.com
> http://www.alterdatabaseopen.com
> FB http://www.facebook.com/ricardo.arnoud
> Linkedin http://br.linkedin.com/pub/ricardo-arnoud/15/127/3b1
>
>
--
Att,/Regards,
Vitor Jr.
Infraestrutura / Infrastructure Team
Oracle 12c DBA Certified Professional - OCP 12c
Oracle 11g DBA Certified Professional - OCP 11g
Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid
Infrastructure Administrator - OCE
Oracle Database 11g Performance Tuning Certified Expert - OCE
Oracle Exadata 11g Certified Implementation Specialist
Oracle Certified Associate, MySQL 5
mail, gtalk e msn: vitorj...@gmail.com
http://certificacaobd.com.br/
skype: vjunior1981
https://mybizcard.co/vitor.jr.385628
