ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How to improve RMAN Backup Timing or how to take Quick / Fast RMAN Backup either by using multiple channels or increasing Large Pool Size?

user-image
تم إضافة السؤال من قبل Kamran Saeed Kamran , Oracle Apps DBA , DHA Lahore
تاريخ النشر: 2016/01/18
Sufian Khader
من قبل Sufian Khader , Oracle Database Administration Consultant , Sita

  Increasing the Large pool size and using multiple channels will improve the RMAN Job:

1- Large pool: you can enable the oracleg andc feature: automatic memory management (AMM), this will resize the Large Pool dynamically when needed by the RMAN processes.

2- Multiple channels: Increase the parallelism degree from1 (default), to3 or4 as needed, by running the following command on RMAN command prompt, where N is the new parallelism value:

RMAN> parallelism configure device type disk parallelism N backup type to backupset ;

 

Best Regards

Sufian Khader

 

Kamran Saeed Kamran
من قبل Kamran Saeed Kamran , Oracle Apps DBA , DHA Lahore

What is oracleg andc feature?

 

Mohammed Irfan Hussain
من قبل Mohammed Irfan Hussain , Oracle DBA ( Database Administrator) , Ministry of environment water and agriculture, Saudi Arabia

Fast RMAN Backup using multiple channels

RUN

{

  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT '/disk1/%U'; 

  ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT '/disk2/%U'; 

  BACKUP DATABASE PLUS ARCHIVELOG ;

  RELEASE CHANNEL ch1;

  RELEASE CHANNEL ch2;

}

المزيد من الأسئلة المماثلة