RMAN Enhancements in 12c — Part 1

To execute a SQL statement in RMAN prompt , we would need to prefix “sql” in Oracle 11g and below . In Oracle 12c , we can issue sqls directly from RMAN prompt. This enhancement is helpful in scripting RMAN backup jobs.

Here are the examples.

C:\>rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Mon Oct 20 11:13:56 2014
Copyright © 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: TEST12DB (DBID=367699687)

RMAN> create user backupuser identified by bkup1user ;

using target database control file instead of recovery catalog
Statement processed

RMAN> alter user backupuser default tablespace users;
Statement processed

RMAN> alter user backupuser quota unlimited on users;
Statement processed

RMAN> select banner from v$version ;

using target database control file instead of recovery catalog
BANNER
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0–64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for 64-bit Windows: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production

Originally published at https://zahirmohideen.blogspot.com/2014/10/rman-enhancements-in-12c-part-1.html