Unsolved
This post is more than 5 years old
3 Posts
0
984
August 6th, 2019 15:00
Backup L0 and L1 Cumulative - Module Oracle Database - High backup runtime
Hello everyone.
I`m new on this community and i need your help.
We have a Oracle database and the size is 30 TB
What the best configuration for L0 Cumulative backup ?
- The database backup during +40 hours and executed by ddboost device. I need reduce the time exec.
All pieces/channels complete in 15~16 hours, only one channel remains running and affects the backup schedule
cfg:
Backup Database Level 0 Cumulative - INCLUDE CURRENT CONTROLFILE - PLUS ARCHIVELOG DELETE INPUT - 12 RMAN channels - Parallelism 400 ( I think this option is wrong ) - Priority 500 - Using client direct (Backup archives running every 30 minutes / Backup Cumulative L0 one day a week / Cumulative L1 all day, skipping day at L0 exec)
And the backup Cumulative Level 0 or 1 sometimes failed with log below
RMAN-10038: database session for channel CH1 terminated unexpectedly channel CH1 disabled, job failed on it will be run on another channel
I think the parallelism(400) option is affecting backups and the entire environment.
Any idea ? Thanks guys
bingo.1
2.4K Posts
0
August 7th, 2019 04:00
The 'parallelism' only applies indirectly. Here it limits the max no of save streams which are allowed to be opened at a certain time.
For RMAN backups it is the number of channels you open/allocate. The more the better, depending on your backup scenario. As I remember, the max. is 256 for Oracle so this alone would never drive NW into a bottleneck position.