Verifique a taxa de transferência na view v$rman_backup_job_details, pode
estar com problema no disco local.
*Att,*
*Paulo Barbosa*
*Adm de Banco de Dados*
*skype: paulobarbosa.sp*
*Cel.: (11) 98869-0988*
2016-01-27 11:30 GMT-02:00 Vitor Junior vitorj...@gmail.com [oracle_br] <
oracle_br@yahoogrupos.com.br>:
>
>
> 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
>
>
>
