Home » RDBMS Server » Backup & Recovery » RMAN job very slow
RMAN job very slow [message #73959] Wed, 11 August 2004 01:14 Go to next message
Franco
Messages: 50
Registered: August 2002
Member
Oracle 9i, patch set_04,two node fail safe cluster.
I have set up, with OEM, a RMAN job in order to backup the databaase of approx 20GB.
I use RMAN with a recovery catalog.
The job run for about 4 minutes, so very good performance I think.
Now something change and the job run for about 27 minutes, the db is always the same and the job is still succesfull.
What can you suggest in order to come bak to the previous perfomance?
Where do I hava to investigate?
Please advise.
Best regards.
Re: RMAN job very slow [message #73960 is a reply to message #73959] Wed, 11 August 2004 03:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. what is you archivelog retention period?
2. How many channels are u using?
Re: RMAN job very slow [message #73961 is a reply to message #73960] Wed, 11 August 2004 03:55 Go to previous messageGo to next message
Franco
Messages: 50
Registered: August 2002
Member
retention policy is 2.
I use only one channel.
There parameters ara the same as before, when backup takes about 4 minutes.
Here are the parameters for RMAN:

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'U:orabckbacku
pctrlfile%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # 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 SNAPSHOT CONTROLFILE NAME TO 'C:ORACLEORA92DATABASESNCFORAPROD1.OR
A'; # default
RMAN configuration has no stored or default parameters

RMAN>
Any idea?
Kinf regards.
Re: RMAN job very slow [message #73962 is a reply to message #73961] Wed, 11 August 2004 05:37 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i would set a mininimum parallelism of 2
and thus use atleast 2 channels.
and now since you are running this from OEM, there might be other factors need to be constidered.

Did you go through the docs?
else first have a look here
Tuning Recovery Manager
Previous Topic: problem while restoring cold backup
Next Topic: Oracle Control File Backup Error?
Goto Forum:
  


Current Time: Thu May 23 14:50:32 CDT 2024