RMAN 12C New Prompt Enhancement.

With RMAN 12c, We don’t need to switch prompt. In RMAN prompt it self we can do the operation and we don’t need to specify ‘sql’ for the command execution.

Sample Test:

RMAN> desc dba_profiles;
Name                              Null?           Type
—————————-      ——–         —————————-
PROFILE                           NOT NULL         VARCHAR2(128)
RESOURCE_NAME                     NOT NULL         VARCHAR2(32)
RESOURCE_TYPE                                      VARCHAR2(8)
LIMIT                                              VARCHAR2(128)
COMMON                                             VARCHAR2(3)

You can run DDL/DML Commands from RMAN Command prompt, but note that in order to insert you need to use:

RMAN> create table ora_table(col1 number, col2 varchar2(20));

Statement processed

RMAN> insert into ora_table values (1,’Test’);

Statement processed

RMAN> update ora_table set col1=2;

Statement processed

RMAN> drop table ora_table;

Statement processed

The user can SHUTDOWN/STARTUP the database and also can use ALTER commands:

RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down

RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area    1610612736 bytes
Fixed Size                  2924928 bytes
Variable Size               520097408 bytes
Database Buffers            1073741824 bytes
Redo Buffers                13848576 bytes

RMAN> alter database open;
Statement processed


With this new SQL Interface improvement’s, users don’t need to switch between RMAN and SQL* Plus prompts during Backup & Recovery, administration…etc.

  • September 23, 2018 | 15 views
  • Comments