12c 新特性--在RMAN中执行SQL语句

monkeybird

看到标题你也许会产生质疑，在12c之前的版本的RMAN中不是也可以执行SQL语句吗，但是不同之处在于在12c中，你可以在不需要SQL前缀的情况下在RMAN中执行任何SQL和PL/SQL命令，即你可以从RMAN直接执行任何SQL和PL/SQL命令。如下便是在RMAN中执行SQL语句的示例：

[oracle@dbserver12c ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Fri Aug 16 10:13:55 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL12C (DBID=653932544)

RMAN> select file_name from dba_data_files;

using target database control file instead of recovery catalog

FILE_NAME                                                                      
--------------------------------------------------------------------------------

/oracle/oradata/orcl12c/system01.dbf
 

/oracle/oradata/orcl12c/sysaux01.dbf
 

/oracle/oradata/orcl12c/undotbs01.dbf
 

/oracle/oradata/orcl12c/users01.dbf
 

RMAN> select member from v$logfile;

 

MEMBER                                                                         
--------------------------------------------------------------------------------

/oracle/oradata/orcl12c/redo03.log
 

/oracle/oradata/orcl12c/redo02.log
 

/oracle/oradata/orcl12c/redo01.log
 

RMAN>