Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
amitkj Absent Member.
Absent Member.
4332 views

RMAN backup taking too much time for completion

Jump to solution

Hi,

 

We have DP integrated with RMAN where we have two database one is primary database and another is logical standby database,total data is around 3.5TB & 5.5TB respectively and time taken for completion is more than 15 to16 hrs, which we have to abort as we cannot run these backup during business hours.(backup start time 7:15pm logical standby & 8:pm primary db ) as per IST.

 

Can anyone help me to know whtr time it is taking for backup completion is correct or any issue is there?

 

Cell Manager OS windows 2003 enterprise edition

DP version 7.0

DB server HP-unix 11.31

medium we are using to take backup LTO-4(1.6 TB)

 

Thanks in advance...

 

 

0 Likes
1 Solution

Accepted Solutions
amitkj Absent Member.
Absent Member.

Re: RMAN backup taking too much time for completion

Jump to solution
Ok Thank you so much...
0 Likes
9 Replies
Absent Member.. svollrat Absent Member..
Absent Member..

Re: RMAN backup taking too much time for completion

Jump to solution

Assuming you only use one LTO4-Drive and the Data does not compress much your Backup would easily take 20-22h for those 9TB.

Best way to speed things up is to increase the number of concurrent Tapedrives and RMAN-Streams and to distribute the Datafiles as evenly as possible across all Stream.s

To see the max. possible Speed try a Backup to local Null-Device with 8 or 16 Streams.

amitkj Absent Member.
Absent Member.

Re: RMAN backup taking too much time for completion

Jump to solution

Hi Svollrat

 

Thanks  but I think I have given incomplete information...

 

My Primary Database and Logical standby database backup runs in different Tape Drive parallelly and yes only one LTO4-Drive we use for both the backup,allocated different medium(Tape). These backup we run with 5 channel...

 

let us take an example:-

 

ABC(Primary Database)------>running in drive1-----tape from slot 1 & 2

 

XYZ(Logical Standby Database)------->drive2------tape from slot 3,4 and 5

 

 from above example u can see  XYZ database uses 3 number of tape.

 

 

also  "increase the number of concurrent Tapedrives" my question is can we run same backup(in this case ABC or XYZ)in two different drive at same time? 

 

Please help me to understand this" RMAN-Streams and to distribute the Datafiles as evenly as possible across all Stream.s" what is stream? is it channel?

 

 

 

 

 

0 Likes
Absent Member.. svollrat Absent Member..
Absent Member..

Re: RMAN backup taking too much time for completion

Jump to solution

An RMAN-Channel is only a logical Target where Data-Streams can be written to.

Did I understand you correctly that each of your two Databases writes with 5 concurrent Channels to one LTO-Drive?

You can try increasing the Drive-Concurrency and the Channels f.E. to 8 to back up more Datafiles at once.

Also adding another Tapedrive to the Barlist and saving additional 5 or 8 Streams in parallel will increase speed.

Absent Member.. svollrat Absent Member..
Absent Member..

Re: RMAN backup taking too much time for completion

Jump to solution

Example for a Backup writing to two Drives in parallel with 6 Streams each:

 

BARLIST "Test"
OWNER "oracle" "oinstall" "oda01"
GROUP "Backuptest"
DYNAMIC 2 2
DEVICE "Drive1"
{

     -concurrency 6
    -sync
}

DEVICE "Drive2"
{

     -concurrency 6
    -sync
}

CLIENT "PROD" oda01
{
    -exec ob2rman.exe
    -args {
        "-backup"
    }
    -input {
        "run {"
        "allocate channel 'dev_0' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_1' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_2' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_3' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_4' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_5' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_6' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_7' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_8' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_9' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_10' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "allocate channel 'dev_11' type 'sbt_tape'"
        " parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Test)';"
        "backup incremental level <incr_level>"
        " format 'Test<PROD_%s:%t:%p>.dbf'"
        " database"
        " filesperset 1;"
        "backup"
        " format 'Test<PROD_%s:%t:%p>.dbf'"
        " recovery area;"
        "backup"
        " format 'Test<PROD_%s:%t:%p>.dbf'"
        " current controlfile;"
        "}"
    }
    -public
}  -protect days 14

amitkj Absent Member.
Absent Member.

Re: RMAN backup taking too much time for completion

Jump to solution

Hi Svollrat,

 

I will try with the Plan u have mentioned but What I want to know is why my primary database backup duration changes everyday that is fewdays it take 7 hours fewdays it takes 12 hrs..

 

Can you suggest on this?

 

 

0 Likes
Absent Member.. svollrat Absent Member..
Absent Member..

Re: RMAN backup taking too much time for completion

Jump to solution

Do you back up Primary and Secondary in one Job or as separate ones?

If they are separate, is the primary backed up using a lokal path to Backup-Tape, mean locally installed MediaServer?

With the DB directly writing to the Tape, omiting Network transfers you should have pretty stable Backup-Times.

Only two things that can mess up that are Server Load (more or less user activity, background-jobs, db-checks) and varying distribution of the Backup-Data in the RMAN-Channels (once even distibuted, once most data in one stream).

amitkj Absent Member.
Absent Member.

Re: RMAN backup taking too much time for completion

Jump to solution

Hi Svollrat,

 

Todays Primary database Backup showed below given message 

 

RMAN-03009: failure of backup command on dev_3 channel at 02/13/2015 08:50:19
ORA-19598: can not backup SPFILE because the instance was not started with SPFILE
RMAN-12018: channel dev_3 disabled, job failed on it will be run on another channel

 

 

Can this be the reason for backup running slow?

 

Regards

Amit

0 Likes
Absent Member.. svollrat Absent Member..
Absent Member..

Re: RMAN backup taking too much time for completion

Jump to solution

That message just states that you try to backup something you cannot.

Not related to performance.

amitkj Absent Member.
Absent Member.

Re: RMAN backup taking too much time for completion

Jump to solution
Ok Thank you so much...
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.