Multiple choice

Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?

  1. SYSDBA

  2. SYSOPER

  3. No system privileges are required for the RMAN user

  4. Only SYS user can connect and execute RMAN commands on a target database
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

RMAN (Recovery Manager) requires the SYSDBA privilege to connect to a target database and perform backup and recovery operations. This is because RMAN needs to read and write critical database files, including data files, control files, and redo logs - operations that demand database administrator level privileges. SYSOPER (option B) provides more limited privileges. Option C is incorrect - privileges are mandatory. Option D is false because users other than SYS can connect if granted SYSDBA.

Keep practicing — related questions