Home » RDBMS Server » Backup & Recovery » RMAN Another Processing Is Running (Oracle, 11g, Windows)
RMAN Another Processing Is Running [message #666549] Sun, 12 November 2017 21:40 Go to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
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 Go to previous messageGo to next message
BlackSwan
Messages: 25751
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?
Re: RMAN Another Processing Is Running [message #666551 is a reply to message #666550] Sun, 12 November 2017 22:44 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
Member
I think Archivelogs backup was in-process when 0-Level Database backup started.
Re: RMAN Another Processing Is Running [message #666552 is a reply to message #666551] Sun, 12 November 2017 22:49 Go to previous messageGo to next message
BlackSwan
Messages: 25751
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?
Re: RMAN Another Processing Is Running [message #666554 is a reply to message #666552] Sun, 12 November 2017 23:44 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
Member
Is it possible to include a check in RMAN script to wait until another running RMAN process finishes?
Re: RMAN Another Processing Is Running [message #666555 is a reply to message #666554] Mon, 13 November 2017 01:48 Go to previous messageGo to next message
John Watson
Messages: 7186
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.
Re: RMAN Another Processing Is Running [message #666560 is a reply to message #666549] Mon, 13 November 2017 10:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10679
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.
Re: RMAN Another Processing Is Running [message #666576 is a reply to message #666560] Tue, 14 November 2017 22:39 Go to previous message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
Member
Thank you very much.
Previous Topic: Old backups not getting deleted
Next Topic: ORA-19504 - "failed to create file"
Goto Forum:
  


Current Time: Sat Dec 16 15:21:35 CST 2017

Total time taken to generate the page: 0.01321 seconds