Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EBS R12.2.4 RMAN Backup taking 5 hrs?

Beauty_and_dBestDec 28 2016 — edited Mar 28 2017

Hi ALL,

EBS R12.2.4

OL6

11gR2

Our database RMAN  backup starts at midnight and completes at around 5AM.

Is this backup time too long? or just enough?

I am only using default single parallelism.

run

{

backup as compressed backupset database plus archivelog;

backup current controlfile ;

crosscheck archivelog all;

crosscheck backup;

delete noprompt expired backup;

delete noprompt expired archivelog all;

delete noprompt obsolete;

delete force noprompt  ARCHIVELOG ALL completed before 'SYSDATE-12/24';

}

RMAN> show all ;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name PROD are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

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 '/home/oraprod/PROD/11.2.0/dbs/snapcf_PROD.f'; # default

Supposing our CPU is  8 cores, How do I speedup the RMAN backup?

Can I speed it up if I run >  CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET ?

Or do I need to edit  my "run" script and add new parameter settings? or no need and just the above configure command is enough?

Please help,

Kind regards,

jc

This post has been answered by Dude! on Dec 29 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2017
Added on Dec 28 2016
28 comments
2,053 views