OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » RMAN backup hangs (Oracle 18.3, OEL 7.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN backup hangs [message #684756]

Sun, 15 August 2021 12:25

ApnaDBA
Messages: 1
Registered: August 2021

Junior Member

Dear Support,

I am in a difficult scenario and i need your suggestions.

On the production server we have installed Oracle database 18.3.

The database instance is Up from last 4 months.

I have just started working on the DB and tried to take the backup of the database using RMAN and even try to EXPDP.

The size of the Database is around 20 gb. During backup process RMAN goes in to non responsive mode and time goes up to 1 hour 30 minuts plus.

some of the sessions blocks the backup operation. their detail is available below from alertlog file.

Alertlog file detail:

2021-08-04T23:57:21.531412+05:00
DIA0 Critical Database Process As Root: Hang ID 177 blocks 1 sessions
Final blocker is session ID 3399 serial# 17211 OSPID 17979 on Instance 1
No resolution will be attempted by Hang Manager
2021-08-04T23:59:21.033792+05:00
DIA0 Critical Database Process As Root: Hang ID 178 blocks 1 sessions
Final blocker is session ID 1136 serial# 65020 OSPID 17984 on Instance 1
No resolution will be attempted by Hang Manager

My action:
When this error is raised and DB response time goes to around 800 milliseconds I killed the RMAN session

the OSPID process detail is as below

ps -ef | grep 17979
oracle 17979 1 0 Mar30 ? 02:25:45 ora_dbw0_orclTAG
oracle 31270 2140 0 11:06 pts/0 00:00:00 grep --color=auto 17979

ps -ef | grep 17984
oracle 17984 1 0 Mar30 ? 02:39:27 ora_ckpt_orclTAG
oracle 31455 2140 0 11:10 pts/0 00:00:00 grep --color=auto 17984

Please advise me to solve this issue.
Also if I want to upgrade the DB from 18c to 19c How can i do that.

Regards,

Report message to a moderator

Re: RMAN backup hangs [message #684757 is a reply to message #684756]

Sun, 15 August 2021 18:00

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

how can we tell what's wrong with your rman job without seeing the rman script/commands that you used? Please post the _formatted_ code.

Report message to a moderator

Re: RMAN backup hangs [message #684867 is a reply to message #684757]

Tue, 14 September 2021 09:27

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

In addition to Ed's post, you say DataPump (EXPDP) hangs too? Could you also show us any output from that also please? Additionally O/S details may be useful too.

Report message to a moderator

Re: RMAN backup hangs [message #684868 is a reply to message #684867]

Tue, 14 September 2021 10:33

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

@Gazzag - easy mistake, I've made it myself on occasion. The OP hasn't responded in about a month, so we can only guess that he is no longer "in a difficult situation".

Cool

Report message to a moderator

Re: RMAN backup hangs [message #684869 is a reply to message #684868]

Tue, 14 September 2021 10:40

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

Thanks, Ed. Smile

Report message to a moderator

Previous Topic:	Broken Job
Next Topic:	understanding user profile resource parameter CPU_PER_CALL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 30 19:15:39 CDT 2023