In earlier version of Oracle Database 11g, you can execute SQL commands and PL/SQL procedures from the RMAN command line which Require Sql Prefix and quotes as below: –

RMAN>sql ‘ALTER TABLESPACE Users Add Datafile ‘/u01/app/oracle/oradata/ORCL/USERS02.dbf’ size 100M’;

Now from Oracle Database 12c, you don’t require SQL prefix and quotes as below: –

RMAN>ALTER Tablespace Users Add DATAFILE ‘/u01/app/oracle/oradata/ORCL/USERS02.dbf’ size 100M;

RMAN>SELECT NAME, OPEN_MODE from V$DATABASE;

RMAN>SELECT SYSDATE from dual;

The post Using SQL in Recovery Manager (RMAN) in Oracle Database 12c appeared first on DBA Trainer.