Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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
Question added by Kamran Saeed Kamran , Oracle Apps DBA , DHA Lahore
Date Posted: 2016/01/18
Sufian Khader
by 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
by Kamran Saeed Kamran , Oracle Apps DBA , DHA Lahore

What is oracleg andc feature?

 

Mohammed Irfan Hussain
by 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;

}

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.