Home » RDBMS Server » Backup & Recovery » RMAN backup hangs !!!!
icon9.gif  RMAN backup hangs !!!! [message #119024] Tue, 10 May 2005 05:55 Go to next message
ankurgodambe
Messages: 45
Registered: March 2005
Member
HI,
I am trying to set up RMAN backup for my 8.1.6 database. Catalog database version is 9.2.0.6.0. When I start the backup with following command
run {
2> allocate channel di type disk;
3> backup format '/backups/rman/mmprod/test.rman' datafile 19;
4> }
the command just hangs for hours. No error messages are received. when generated a trace the by rman debug trace=trace.log, the last few lines of the trace shows:
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246
krmxr: sleeping for 10 seconds
krmxpoq: xc=6670976, action="0000010 STARTED", col_l=15, ind=0, sid=246


In v$session_wait I see the session waiting for "file open". What can be the problem???

Thanks.
Ankur

Re: RMAN backup hangs !!!! [message #119035 is a reply to message #119024] Tue, 10 May 2005 06:32 Go to previous messageGo to next message
ankurgodambe
Messages: 45
Registered: March 2005
Member
If I try to take the backup on a different location, it works!!
Now the two locations, one where RMAN hangs and the other where RMAN doesnt hang are both NFS mounted. Can some one help me out in finding the difference between the two and identify the problem?

Thanks,
Ankur
Re: RMAN backup hangs !!!! [message #119052 is a reply to message #119035] Tue, 10 May 2005 08:02 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
your unix admin should help with that.
There might be some i/o problems in the share.
Previous Topic: Database Growth
Next Topic: Want to Export User of 24x7 database... do i have to shutdown my database for it?
Goto Forum:
  


Current Time: Tue Apr 23 23:58:27 CDT 2024