From: Praveen Patle (ppatletru64@yahoo.com)
Date: Mon Oct 11 2004 - 00:52:23 EDT
Hello Managers:
We are facing some problems in using RMAN for backing
up the databases. The read performance is very-very
slow.
Following is the hardware configuration:
--------------
DS15 Clustered using 100 MB Ethernet as cluster
interconnect, running 5.1B
MSA1000 - 2 Controllers running in Active/Standby
Configuration
2 GB SAN
72 and 146 GB Disks on MSA1000
--------------
Currently, we are trying to backup the database to a
disk only. The database is on a mirrored 146 GB disk.
Using RMAN, we are putting the backup files on MSA1000
as well (72 GB mirrored disk). The data in entire
database is not more than 2 GB. It took more than 4
hours to backup 2 GB.
Here is the RMAN cmdfile
-------------------
connect target /
run {
configure device type disk parallelism 2;
allocate channel t1 type disk maxopenfiles=8 rate=50M;
allocate channel t2 type disk maxopenfiles=8 rate=50M;
allocate channel t3 type disk maxopenfiles=8 rate=50M;
allocate channel t4 type disk maxopenfiles=8 rate=50M;
backup incremental level 0 filesperset 8
format '/arch/backup/inc0_%D_%U' database
include current controlfile for standby;
sql"alter system switch logfile";
}
-------------------
IOSTAT output shows only 50-60 bps of I/O from the
database disk.
While the backup is going on, no one can access the
database. If we do sqlplus, it hangs in middle and
never comes back.
Has someone seen this problem? Is is possible that
there is a problem in mirroring on MSA1000? How can I
check it?
I greatly appreciate your help in solving this
problem.
Thanks,
Praveen
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:50:09 EDT