Oracle 12c ; RMAN supports SELECT statements

June 26th, 2013 | Posted in 12c, Blog, RMAN | 3 Comments

With the new Oracle 12c R1, RMAN now supports run select statements;

This is output from an 11.2.0.3 database;

sandbox1(dev):/home/oracle>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 26 06:28:28 2013

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

connected to target database: DEV (DBID=4095242660)

RMAN> desc v$rman_backup_job_details

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
RMAN-01008: the bad identifier was: desc
RMAN-01007: at line 1 column 1 file: standard input

RMAN> exit

From new 12.1 database;




3 Comments to “Oracle 12c ; RMAN supports SELECT statements”

  1. [...] Wissem El Khlifi – RMAN now supports SELECT statements [...]


Leave a Comment





Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • Adrian Iriarte: Saludos, Que buen articulo, casi siempre al momento de querer implementar soluciones para el...
  • Patricia: Hi Wissem, is there a workaround for this? I mean I want to use the sqlnet.authentication_services =none,...
  • Brian: I created the cdb manually using the instruction, but then I tried to create pdb within in, it failed. have...
  • Farmer Johnson: Hi Wissem. How did you avoid the error you had previsouly encountered: “sudo opatch auto...
  • Héctor Moro: Querido Nelson; Después de entrevistar a mas de 50 profesionales de primer nivel en Uruguay, al fin te...
  • What is NO2 Maximus: I genuinely apрreciated your site! You shoulԁ update it wiϳth new info!
  • Nav: Indeed helpful, to the point article..
  • Koti: Can you please explain all the sections of AWR report in RAC. I mean to ask output produced by awrgrpt.sql...
  • Himanshu: Nice post.can you please comment on this Why RMAN restored the DATA_REORTING datafie to +DATA diskgroup?
  • Enrique: Great post.
  • gabriel: what version of sqldeveloper support plugable database?
  • Kal: Quality – thanks…
  • wissem: Well , like I mentioned in the post, delete service and add service using IP.
  • Kelly: were you able to solve this? Thanks!
  • wissem: Hello, You can buy the book from PakT: http://www.packtpub.com/oracle -data-guard-11gr2-administr...
  • goutham: hi i want to buy this book.could you please let me know how can i buy this book. i am in Malaysia. thanks...
  • cesar Lopez: Hola me gustaria saber tu punto de vista de MYSQl vs ORACLE para una sistema de Nomina de unos 1500...
  • wissem: Check my previous article in English; Oracle 12c: RMAN recover Table http://www.oracle-class.com/?p =2866
  • NILESH: Sir, English please
  • Ramakrishna: I want step by step installation of Hyper-table in windows and also usage of Hyper-table like data...