| RMAN job very slow [message #73959] |
Wed, 11 August 2004 01:14  |
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 #73961 is a reply to message #73960] |
Wed, 11 August 2004 03:55  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
