12c New Feature: RMAN SQL Interface Improvements

rmanIn RMAN 12c, you can now execute SQL commands and PL/SQL procedures from the RMAN command line without prefixing the command with the SQL keyword.


[oracle@# trace]$ rman target sys

Recovery Manager: Release - Production on Tue Jul 9 23:10:09 2013

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

target database Password: 
connected to target database: DB1211 (DBID=1666640222)

RMAN> SELECT dbms_flashback.get_system_change_number FROM dual;

using target database control file instead of recovery catalog

RMAN> desc v$logfile

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP#                                             NUMBER                      
 STATUS                                             VARCHAR2(7)                 
 TYPE                                               VARCHAR2(7)                 
 MEMBER                                             VARCHAR2(513)               
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)                 
 CON_ID                                             NUMBER                      


As always comments are welcome

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:


Du kommentierst mit Deinem WordPress.com-Konto. Abmelden /  Ändern )

Google Foto

Du kommentierst mit Deinem Google-Konto. Abmelden /  Ändern )


Du kommentierst mit Deinem Twitter-Konto. Abmelden /  Ändern )


Du kommentierst mit Deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s