12 Things about Oracle 12c -- Part 2

RMAN: SQL commands 

Description:

This is one of those 'duh' features that makes so much sense that Oracle decided to implement four version after the introduction of RMAN.

Previous to 12c, RMAN would execute SQL statements like so:

NOTE: the SELECT statement is executed, but no results are returned to the user. While this is useful for scripting DDL statements.

Now, with Oracle 12c, we get results like so:

Voila! Results.

Use Cases:

1. Verifying that object recovery is successful. 
2. Scripting additional changes to be implemented immediately upon recovery. 
3. Enabling Data Guard commands

Any shell scripts which execute RMAN commands, and then exits RMAN to connect to SQLPlus can be immediately simplified to perform these actions in one context. 

NOTE: RMAN !=SQLPlus. Formatting options are not available here. RMAN is providing better SQL Client functionality, but nothing nearly as robust as SQLPlus.