Runing SQL commands from within Rman


New in Oracle Database 12c , you can run many SQL commands directly from the Rman command line. Prior to Oracle Dtabase 12c you would have to specify that commnad as shown:
In Oracle 11g:
bash-3.2$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 10 14:44:38 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: ANARDB (DBID=1202765234)
RMAN> sql 'alter system switch logfile';
using target database control file instead of recovery catalog
sql statement: alter system switch logfile In Oracle 12c:
bash-3.2$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 10 14:44:38 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: ANARDB (DBID=1202765234)
RMAN> alter system switch logfile;
using target database control file instead of recovery catalog sql statement: alter system switch logfile
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: