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 (c) 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
