Database Backup and Recovery (MOSC)

MOSC Banner

Using C##rmanuser with sysbackup to backup control file to trace fails ORA-1031

edited Feb 29, 2024 9:33AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓

Oracle Enterprise Database (19.9)

Looking at switching backups run as sys to using user with sysbackup role.

Existing rman backup script , contains "alter database backup controlfile to trace;"

This fails with ORA-01031: insufficient privileges

Note : sqlplus as C##rmanuser with sysbackup also gives same error,

sysbackup ment to have "alter database" privileges.

Anybody know minimum extra needed by user to be able to "alter database backup controlfile to trace;"


2024/02/29 - update (others asking basic questions).

Rman script "connect target "c##rmanuser/rmanuserpw@targetCDB as sysbackup"

Looking in v$pwfile_users both sysbackup and c##rmanuser in passwordfile.

rman has

run {

# set of backup commands, then

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center