Monday, October 20, 2014

RMAN Enhancements in 12c - Part 1



To execute a SQL statement in RMAN prompt , we would need to prefix  "sql" in  Oracle 11g and below . In Oracle 12c , we can issue sqls directly from RMAN prompt.   This enhancement is helpful in scripting RMAN backup jobs.

Here are the examples.

C:\>rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Mon Oct 20 11:13:56 2014

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

connected to target database: TEST12DB (DBID=367699687)

RMAN> create user backupuser identified by bkup1user ;

using target database control file instead of recovery catalog
Statement processed

RMAN> alter user backupuser default tablespace users;

Statement processed

RMAN> alter user backupuser quota unlimited on users;

Statement processed


RMAN> select banner from v$version ;

using target database control file instead of recovery catalog
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE    12.1.0.1.0      Production
TNS for 64-bit Windows: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production

No comments:

Post a Comment