DB backup is hung
15 pts.
0
Q:
DB backup is hung
What are the different ways to know if DB backup & archive log backup process have hung. How can we know the average run time of db backup & archive log backup ?

What are the advisable checks to be performed / steps to be taken if we observe the backup is slow (determined by average) or has hung.
ASKED: Jul 5 2009  9:39 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Jul 5 2009  9:39 PM GMT by Jayeshmb   15 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

BrentSheets   6535 pts.  |   Jul 6 2009  12:30PM GMT

Moderator Note: Hi Jayeshmb and welcome to IT Knowledge Exchange. You didn’t mention any details about what platform or database you are working with - but you can click the “Add to Discussion” button to provide more information. The more details you provide, the easier it is for other members to try to help. Thanks.

 

Jayeshmb   15 pts.  |   Jul 6 2009  2:00PM GMT

OS - AIX 5.3
DB Oracle 10.2

I usually check the detailed log but m not able to find any update since 20 hours. However, I can see a backup process at unix level via ps command.

 

Nidhisp   40 pts.  |   Jul 14 2009  12:34PM GMT

Hi Jayesh,

What type of backup you are running? physical or logical?physical means cold or hot ?through RMAN or any scripts?…give the details .

Shiva

 
0