RMAN Miscellaneous New Features

From Robs_Wiki
Revision as of 08:12, 11 February 2020 by Qadmin wiki (talk | contribs) (Created page with "__TOC__ == 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 enc...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.

Sysbackup privilege

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;