Connection to dataserver from backup server is taking more time. What
could be the reason.....?
We also checked OS level DISK IO, Network side....etc..
We are using AIX, and 15.0.3 ESD#4.
Some times it takes more than 3-4 minutes too.
Have a look at below sample backup logs:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Apr 29 14:28:23 2011: Backup Server: 2.23.1.1: Connection from Server
DBPRISRV on Host appsrv with HostProcid 13123.
Apr 29 14:29:29 2011: Backup Server: 4.41.1.1: Creating new disk file /
dbdump/04291439.empdb.
Apr 29 14:29:29 2011: Backup Server: 1.70.1.2: Configuring the shared
memory per stripe to 589824 bytes.
Apr 29 14:29:29 2011: Backup Server: 6.28.1.1: Dumpfile name
'empdb111190CB87' section number 1 mounted on disk file '/dbdump/
04291439.empdb'
Apr 29 14:29:30 2011: Backup Server: 4.58.1.1: Database empdb: 63982
kilobytes DUMPED.
Apr 29 14:29:31 2011: Backup Server: 4.58.1.1: Database empdb: 128244
kilobytes DUMPED.
Apr 29 14:29:32 2011: Backup Server: 4.58.1.1: Database empdb: 140898
kilobytes DUMPED.
Apr 29 14:29:32 2011: Backup Server: 4.58.1.1: Database empdb: 158962
kilobytes DUMPED.
Apr 29 14:29:32 2011: Backup Server: 3.43.1.1: Dump phase number 3
completed.
Apr 29 14:29:32 2011: Backup Server: 4.58.1.1: Database empdb: 158966
kilobytes DUMPED.
Apr 29 14:29:32 2011: Backup Server: 3.42.1.1: DUMP is complete
(database empdb).
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Apr 29 14:57:42 2011: Backup Server: 2.23.1.1: Connection from Server
DBPRISRV on Host appsrv with HostProcid 19512.
Apr 29 14:59:37 2011: Backup Server: 4.41.1.1: Creating new disk file /
dbdump/04291508.empdb.
Apr 29 14:59:37 2011: Backup Server: 1.70.1.2: Configuring the shared
memory per stripe to 589824 bytes.
Apr 29 14:59:37 2011: Backup Server: 6.28.1.1: Dumpfile name
'empdb111190D266' section number 1 mounted on disk file '/dbdump/
04291508.empdb'
Apr 29 14:59:38 2011: Backup Server: 4.58.1.1: Database empdb: 64116
kilobytes DUMPED.
Apr 29 14:59:39 2011: Backup Server: 4.58.1.1: Database empdb: 128378
kilobytes DUMPED.
Apr 29 14:59:40 2011: Backup Server: 4.58.1.1: Database empdb: 192640
kilobytes DUMPED.
Apr 29 14:59:44 2011: Backup Server: 4.58.1.1: Database empdb: 256902
kilobytes DUMPED.
Apr 29 14:59:46 2011: Backup Server: 4.58.1.1: Database empdb: 312212
kilobytes DUMPED.
Apr 29 14:59:46 2011: Backup Server: 3.43.1.1: Dump phase number 3
completed.
Apr 29 14:59:46 2011: Backup Server: 4.58.1.1: Database empdb: 312216
kilobytes DUMPED.
Apr 29 14:59:46 2011: Backup Server: 3.42.1.1: DUMP is complete
(database empdb).
-----------------------------------------------------------------------------------------------------------------------------------------------------------
All suggessions are welcome.!!
Regards,
Murali Minchala