cancel
Showing results for 
Search instead for 
Did you mean: 

can RMAN actions be restricted/controlled?

NBU 7.6.0.3

Solaris 10, Oracle 11.0.2.3

 

is it possible to somehow restrict RMAN from doing restores without NBU admin concurrence?

1 Solution

Accepted Solutions
Accepted Solution!

Re: can RMAN actions be restricted/controlled?

Yes. 

You can disable client browse and restore.
Or leave browse enabled and disable restore.

This will force them to notify you when they want to perform a restore so that you can enable client initiated restores.

Use Host Properties -> Master -> Client Attributes to either globally disable client browse / restore, or else disable on per-client basis by adding client name in Client Attributes to select/disable individually.

Hopefully this will not worsten your relationship with dba's....
Have a discussion and see if you can improve communication without going to extreme levels....

View solution in original post

3 Replies
Accepted Solution!

Re: can RMAN actions be restricted/controlled?

Yes. 

You can disable client browse and restore.
Or leave browse enabled and disable restore.

This will force them to notify you when they want to perform a restore so that you can enable client initiated restores.

Use Host Properties -> Master -> Client Attributes to either globally disable client browse / restore, or else disable on per-client basis by adding client name in Client Attributes to select/disable individually.

Hopefully this will not worsten your relationship with dba's....
Have a discussion and see if you can improve communication without going to extreme levels....

View solution in original post

that's good to know. this

that's good to know.

this will be implemented only after discussion/agreement on proper procedures.

thanks.

Re: can RMAN actions be restricted/controlled?

i know this has been over a year now but it has become handy when i discovered unauthorized restores (well attempted). so now i disabled client restores globally.

thank you for this tip.