cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle RMAN image delete restriction

Mohmec
Level 4

Is there a way to retain Oracle team rights to perform RMAN backups but restrict them from deleting images from the catalog?

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I seriously doubt that.

As owner of Oracle db, they will have backup rights as well as image expiration rights in RMAN.

Maybe this is a discussion that you need to have with your management?
Roles and responsibilities should be clearly documented....

See these TNs:

DOCUMENTATION: Best Practice for maintaining a consistent backup catalog between Oracle RMAN and NetBackup.

http://www.symantec.com/docs/TECH49868 :


Maintaining the RMAN repository
http://www.symantec.com/docs/HOWTO89530  

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I seriously doubt that.

As owner of Oracle db, they will have backup rights as well as image expiration rights in RMAN.

Maybe this is a discussion that you need to have with your management?
Roles and responsibilities should be clearly documented....

See these TNs:

DOCUMENTATION: Best Practice for maintaining a consistent backup catalog between Oracle RMAN and NetBackup.

http://www.symantec.com/docs/TECH49868 :


Maintaining the RMAN repository
http://www.symantec.com/docs/HOWTO89530  

I seriously doubt that too ..

But do you now where to find the information about this rman task on master/media server? in which logfile can I read  client x have executed nbdelete  of which image

(deleted)

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

It will not be nbdelete command. 
And user on Oracle client cannot run bpexpdate unless the Oracle server is NBU media server and the user is logged on as root. 
'Admin' log on the server where command is issued will log bpexpdate.

The rman commands that are covered in the TNs in my 2015 posts will simply remove entries from rman catalog if images are already expired in NBU.

If you need further assistance, please start a new discussion. 
This post has been answered/solved...