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!

RMAN backup taking to much time

User_QPHL4Jul 5 2022 — edited Jul 5 2022

Hii
Our oracle 12cR2 database running on AIX POWER 9 and database size is arround 6 TB.RMAN takes 28 to 34 hours for complete. I have shared the database script below.
How I can improve the backup speed?

$ORACLE_HOME/bin/rman target / << EOF
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
allocate channel ch6 device type disk;
allocate channel ch7 device type disk;
allocate channel ch8 device type disk;
allocate channel ch9 device type disk;
allocate channel ch10 device type disk;
allocate channel ch11 device type disk;
allocate channel ch12 device type disk;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup of database;
delete noprompt expired backup of database;
backup format '/pegabackup/RMAN/full/CTL_%d_%T_%s_%p_%u.bkp' current controlfile;
backup spfile format '/pegabackup/RMAN/full/spfile_%d_%T.ora';
backup filesperset=4 incremental level 0 as compressed backupset tag='PEGADB_LEVEL0_BKP' format '/pegabackup/RMAN/full/dbf_%d_%T_%p_%U.dbf' (database);
backup as compressed backupset tag='PEGADB_ARCH' archivelog all format '/pegabackup/RMAN/full/arch_%d_%T_%p_%U.arc';
backup format '/pegabackup/RMAN/full/CTL_%d_%T_%s_%p_%u.bkp' current controlfile;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
release channel ch6;
release channel ch7;
release channel ch8;
release channel ch9;
release channel ch10;
release channel ch11;
release channel ch12;
}
EOF

Comments
Post Details
Added on Jul 5 2022
0 comments
302 views