RMAN Miscellaneous New Features
SQL Commands for the RMAN prompt
You can now execute SQL statements from the RMAN prompt. You no longer need to prefix the SQL Command and you do not need to enclose the statement in quotes.
Duplicate Database Enhancements
A new clause, noopen, is available that indicates that the duplicated database should not be opened using resetlogs after the duplication is complete. This clause can be usefull if you want to disable some jobs or services, prior to opening the database.
Because sysdba has some very high-level privileges, like "select any table", this new privilege is created for backup purposes only.
SQL> grant sysback to scott;