OraFAQ Forum: Backup & Recovery » RMAN Another Processing Is Running

Home » RDBMS Server » Backup & Recovery » RMAN Another Processing Is Running (Oracle, 11g, Windows)

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

RMAN Another Processing Is Running [message #666549]

Sun, 12 November 2017 21:40

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

Member

I've scheduled following RMAN backups. The Zero Level Backup failed with error message "the process cannot access the file because it is being used by another process". How to check within from RMAN script that another RMAN process is not running already

a) Zero Level RMAN Backup 11:30 PM every Sunday
b) Level-1 RMAN Backup 01:00 PM every day
c) Archivelog Backup repeat every hour
d) Control File Auto backup

[Updated on: Sun, 12 November 2017 21:55]

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666550 is a reply to message #666549]

Sun, 12 November 2017 22:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Windows throws error when second process tries to open a file that is already open.
What file is common to the various RMAN scripts?

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666551 is a reply to message #666550]

Sun, 12 November 2017 22:44

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

Member

I think Archivelogs backup was in-process when 0-Level Database backup started.

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666552 is a reply to message #666551]

Sun, 12 November 2017 22:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

1982Hashmi wrote on Sun, 12 November 2017 20:44

I think Archivelogs backup was in-process when 0-Level Database backup started.

You control what runs & when it runs.
We have met the enemy & they is us.
How can we make things better for you?

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666554 is a reply to message #666552]

Sun, 12 November 2017 23:44

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

Member

Is it possible to include a check in RMAN script to wait until another running RMAN process finishes?

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666555 is a reply to message #666554]

Mon, 13 November 2017 01:48

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

There is no reason not to run several RMAN jobs at the same time. Can you show what is happening? Use copy/paste of the complete RMAN session.

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666560 is a reply to message #666549]

Mon, 13 November 2017 10:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2052.htm#REFRN30391

You can always check the status.
You can make it any fancier to wait / sleep etc by just wrapping around the script.
As the wise folks have already told before,
It all depends on how you are doing it now and there is no reason to run several jobs in parallel.

Report message to a moderator

Re: RMAN Another Processing Is Running [message #666576 is a reply to message #666560]

Tue, 14 November 2017 22:39

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

Member

Thank you very much.

Report message to a moderator

Previous Topic:	Old backups not getting deleted
Next Topic:	ORA-19504 - "failed to create file"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:11:57 CST 2025