Operating System - HP-UX
1748256 Members
3885 Online
108760 Solutions
New Discussion юеВ

Re: delay in backing up using RMAN

 
Noel Daniel
Advisor

delay in backing up using RMAN

I have an RMAN related problem, where all of a sudden all threads backing up take more than an hour to backup a simple file, no larger than a KBs. I have copied an extract from the report which shows that at a certain arbitrary point, the backup takes so much time on all availble threads. During the remainder of the backup, the speeds are okay.

Any experience with a similar issue ?
14 REPLIES 14
Yogeeraj_1
Honored Contributor

Re: delay in backing up using RMAN

hi,

are you doing your backup directly to tape or disk?

did the problem repeat itself for several days?

It could be related to your database performance.

what version of Oracle are you using?

revert

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Noel Daniel
Advisor

Re: delay in backing up using RMAN

1- Backing up is done to tape.

2- The issues are of an intermittent nature, but very frequent.

3- Oracle 9i

Thanks
Eric Antunes
Honored Contributor

Re: delay in backing up using RMAN

Hi Noel,

Is the CONTENT size of "/finsys/fdata/data/igwd01.dbf" similar to the "/finsys/fdata/data/iscx01.dbf" CONTENT size?

Eric

Each and every day is a good day to learn.
Noel Daniel
Advisor

Re: delay in backing up using RMAN

Hello,
The answer to your question is:

Status Name Tablespace Size (M) Free (MB) Free %
ONLINE /finsys/fdata/data/igwd01.dbf IGWD 10.000 4.922 49.22
ONLINE /finsys/fdata/data/iscx01.dbf ISCX 10.000 3.398 33.98

Thank you for our interest,

Eric Antunes
Honored Contributor

Re: delay in backing up using RMAN

Hi Noel,

So the difference between those 2 datafiles are 45% and channel dev_2 takes more 30% time than dev_1. I dont't see any problems here...

What I see is that you seem to be using a channel for each datafile which is bad for performance. Can you post the result of "show all" in rman?

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Noel Daniel
Advisor

Re: delay in backing up using RMAN

I have attached the full session report.

I have also highlighted whenever a certain file has taken an unaccoutably long time for backing up. There are 2 instances of 50 odd minutes, & 1, 27 minute instance. And when there is a delay all handles which handle backups are delayed. I have marked the fore-mentioned instances in Red.

Thank you,

Eric Antunes
Honored Contributor

Re: delay in backing up using RMAN

Hi Noel,

Are you using the DP default RMAN scripts? I'm asking because those scripts are based on RMAN 8i and don't take full advantage of RMAN 9i...

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: delay in backing up using RMAN

Noel,

What I want to say is that you should have several datafiles being backed up in each channel instead of 1 datafile set you have.

See my example:

channel dev_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/disc1/oradata/TST/apps_undots1_01.dbf
input datafile fno=00085 name=/disc1/oradata/TST/transaction_table.dbf
input datafile fno=00093 name=/disc1/oradata/TST/transaction_index_2.dbf
input datafile fno=00107 name=/disc1/oradata/TST/APPS_TS_TX_DATA04.dbf
input datafile fno=00126 name=/disc1/oradata/TST/APPS_TS_INTERFACE02.dbf
input datafile fno=00130 name=/disc1/oradata/TST/APPS_TS_ARCHIVE02.dbf
input datafile fno=00132 name=/disc1/oradata/TST/APPS_TS_MEDIA02.dbf
input datafile fno=00112 name=/disc1/oradata/TST/APPS_TS_TX_DATA09.dbf
input datafile fno=00114 name=/disc1/oradata/TST/APPS_TS_TX_DATA11.dbf
input datafile fno=00004 name=/disc1/oradata/TST/sysaux01.dbf
input datafile fno=00120 name=/disc1/oradata/TST/APPS_TS_TX_IDX10.dbf
input datafile fno=00086 name=/disc1/oradata/TST/eul01.dbf
input datafile fno=00084 name=/disc1/oradata/TST/olap01.dbf
channel dev_1: starting piece 1 at 03/16/2007 [16:53:35]
...
channel dev_1: finished piece 1 at 03/16/2007 [17:10:22]
piece handle=Database & Controlfiles<617388815:1>.dbf comment=API Version 2.0,MMS Version 65.5.50.74
channel dev_1: backup set complete, elapsed time: 00:16:47



So the question is: how did you define the backup specification? What template did you used (if any)?


Cheers,

Eric
Each and every day is a good day to learn.
Noel Daniel
Advisor

Re: delay in backing up using RMAN

Sorry for the long lay off.

I have copied the rman scripts for the omniback ignited backup, below.

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Full_PROD_FRI-1)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Full_PROD_FRI-1)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Full_PROD_FRI-1)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=Full_PROD_FRI-1)';
crosscheck archivelog all ;
backup
incremental level
filesperset 1
format 'Full_PROD_FRI-1.dbf'
database
include current controlfile ;
sql 'alter system switch logfile';
backup
filesperset 1
format 'Full_PROD_FRI-1.dbf'
archivelog all ;
}


Any suggestions as to what we tend to be doing wrong ?