Hi All
We have outsourced our backups to another company.
So far we have been doing our own backups using netbackup, but now that we have a segregation of duties we need to be able to create a user for the outsource company who will be able to backup the oracle database.
However in the Netbackup admin guide it states the following:
On UNIX systems,how you log onto NetBackup depends on how your Oracle authentication is configured:
- OS authentication for Oracle:
- Log onto NetBackup as an Oracle DBA UNIX account that includes sysdba privileges.
- Oracle authentication by password file:
- Log onto NetBackup using any UNIX account,including root.You need to provide additional Oracle logon information later in the backup process
This is a problem for us as we can't allow a third party to log onto the server as oracle user as well as creating a database user for them with sysdba privileges.
In 12c we are able to grant them SYSBACKUP role, but this does not exist in 11g.
How can we create a user for the Netbackup team to be able to backup our databases without giving them access to the oracle user on OS level as well as creating a database user for them without SYSDBA privileges but similar to the SYSBACKUP privileges found in 12c.
Regards,
Charlton