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.

Example:

[oracle@# trace]$ rman target sys

Recovery Manager: Release 12.1.0.1.0 - 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
GET_SYSTEM_CHANGE_NUMBER
------------------------
                 2734536

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                      

RMAN>

As always comments are welcome

Advertisements

Kommentar verfassen

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

WordPress.com-Logo

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

Twitter-Bild

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

Facebook-Foto

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

Google+ Foto

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

Verbinde mit %s