Discussion:
How to suspend all EM backup jobs
LK
2018-09-17 04:12:57 UTC
Permalink
Hi all,

I've got 130 RMAN backup jobs scheduled via EM 13C.

We need to suspend all EM RMAN backup jobs all at once, and re-instate them
at a later time.

Does anyone have a quick way of going about it? At the moment I have to
suspend one at a time.

TIA,

Leng.
Pete Sharman
2018-09-17 04:28:16 UTC
Permalink
Hey Leng, best way it probably via emctl commands.



Pete



From: oracle-l-***@freelists.org <oracle-l-***@freelists.org> On Behalf Of LK
Sent: Monday, September 17, 2018 02:13 PM
To: ORACLE-L <Oracle-***@freelists.org>
Subject: How to suspend all EM backup jobs



Hi all,

I've got 130 RMAN backup jobs scheduled via EM 13C.

We need to suspend all EM RMAN backup jobs all at once, and re-instate them at a later time.

Does anyone have a quick way of going about it? At the moment I have to suspend one at a time.

TIA,

Leng.
LK
2018-09-17 06:14:48 UTC
Permalink
Have you got the commands handy, Pete? I've only ever done them via the EM
GUI and it's extremely time consuming.
Post by Pete Sharman
Hey Leng, best way it probably via emctl commands.
Pete
Behalf Of *LK
*Sent:* Monday, September 17, 2018 02:13 PM
*Subject:* How to suspend all EM backup jobs
Hi all,
I've got 130 RMAN backup jobs scheduled via EM 13C.
We need to suspend all EM RMAN backup jobs all at once, and re-instate
them at a later time.
Does anyone have a quick way of going about it? At the moment I have to
suspend one at a time.
TIA,
Leng.
n***@gmail.com
2018-09-17 13:51:17 UTC
Permalink
It's possible Pete means emcli and the relevant reference would be
https://docs.oracle.com/cd/E24628_01/em.121/e17786/cli_verb_ref.htm#EMCLI1457
or
https://docs.oracle.com/cd/E73210_01/EMCLI/GUID-56DA29F5-5678-4FBE-A12E-4B3D81A5789D.htm#GUID-5686137A-9B8C-481D-ACE6-82ECFED71A75
for 13.2

The usual trick I'd use is a sql query against the EM repository to
generate the emcli commands.
Post by LK
Have you got the commands handy, Pete? I've only ever done them via the EM
GUI and it's extremely time consuming.
Post by Pete Sharman
Hey Leng, best way it probably via emctl commands.
Pete
Behalf Of *LK
*Sent:* Monday, September 17, 2018 02:13 PM
*Subject:* How to suspend all EM backup jobs
Hi all,
I've got 130 RMAN backup jobs scheduled via EM 13C.
We need to suspend all EM RMAN backup jobs all at once, and re-instate
them at a later time.
Does anyone have a quick way of going about it? At the moment I have to
suspend one at a time.
TIA,
Leng.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Pete Sharman
2018-09-17 19:37:43 UTC
Permalink
Sigh! Niall is, of course, correct - emcli, not emctl! :(

Pete

Sent while mobile, please excuse my typos!
It's possible Pete means emcli and the relevant reference would be https://docs.oracle.com/cd/E24628_01/em.121/e17786/cli_verb_ref.htm#EMCLI1457 or https://docs.oracle.com/cd/E73210_01/EMCLI/GUID-56DA29F5-5678-4FBE-A12E-4B3D81A5789D.htm#GUID-5686137A-9B8C-481D-ACE6-82ECFED71A75 for 13.2
The usual trick I'd use is a sql query against the EM repository to generate the emcli commands.
Have you got the commands handy, Pete? I've only ever done them via the EM GUI and it's extremely time consuming.
Post by Pete Sharman
Hey Leng, best way it probably via emctl commands.
Pete
Sent: Monday, September 17, 2018 02:13 PM
Subject: How to suspend all EM backup jobs
Hi all,
I've got 130 RMAN backup jobs scheduled via EM 13C.
We need to suspend all EM RMAN backup jobs all at once, and re-instate them at a later time.
Does anyone have a quick way of going about it? At the moment I have to suspend one at a time.
TIA,
Leng.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
LK
2018-09-18 01:48:06 UTC
Permalink
Thanks so much, Pete and Niall!!

I think I got it working.
Post by Pete Sharman
Sigh! Niall is, of course, correct - emcli, not emctl! :(
Pete
Sent while mobile, please excuse my typos!
It's possible Pete means emcli and the relevant reference would be
https://docs.oracle.com/cd/E24628_01/em.121/e17786/cli_verb_ref.htm#EMCLI1457
or
https://docs.oracle.com/cd/E73210_01/EMCLI/GUID-56DA29F5-5678-4FBE-A12E-4B3D81A5789D.htm#GUID-5686137A-9B8C-481D-ACE6-82ECFED71A75
for 13.2
The usual trick I'd use is a sql query against the EM repository to
generate the emcli commands.
Post by LK
Have you got the commands handy, Pete? I've only ever done them via the
EM GUI and it's extremely time consuming.
On Mon, Sep 17, 2018 at 2:28 PM Pete Sharman <
Post by Pete Sharman
Hey Leng, best way it probably via emctl commands.
Pete
Behalf Of *LK
*Sent:* Monday, September 17, 2018 02:13 PM
*Subject:* How to suspend all EM backup jobs
Hi all,
I've got 130 RMAN backup jobs scheduled via EM 13C.
We need to suspend all EM RMAN backup jobs all at once, and re-instate
them at a later time.
Does anyone have a quick way of going about it? At the moment I have to
suspend one at a time.
TIA,
Leng.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Loading...