RMAN Enhancements in Oracle 12c

Share via:

Dear Readers,

In this article, we will see the following RMAN Enhancements in Oracle 12c.

1.SQL Interface Improvements
In Oracle 12c, you can run SQL commands in RMAN without preceding the command with the SQL keyword.

You also no longer need to enclose the SQL command in quotes.
The RMAN DESCRIBE provides the same functionality of SQL*Plus DESCRIBE:
You can run DDL/DML Commands from RMAN Command prompt, but note that in order to insert you need to use.

The user can SHUTDOWN/STARTUP the database and also can use ALTER commands.
With this new SQL Interface improvement‘s, users don‘t need to switch between RMAN and SQL*
Plus prompts during Backup & Recovery, administration…etc.

Connecting User called ATGCORE using RMAN Target.

Execute some of  SQL  statements in RMAN Prompt.

Create a object under ATGCORE user but issuing commands on RMAN Prompt.

The RMAN DESCRIBE provides the same functionality of SQL*Plus DESCRIBE:

2. Sysbackup Privilege
Prior to 12c, users needed SYSDBA privilege to backup the database. The new Sysbackup privilege allows the user the permissions to perform only backup operations.
The Sysbackup privilege allows the DBA to perform RMAN backup commands without additional privileges.
Using this new role in 12c, you can segregate Administration and Backup operations.
With RMAN you have same authentication options that are available with SQL*Plus, which are operating system authentication and password file authentication.
To connect to RMAN using OS Authentication, Authentication with the Sysbackup

Authentication with the SYSDBA privilege use:

You can also implicitly connect using below command:

 

3.  Recover a single Table
Oracle 12c is now providing a packaged technique which recovers only the necessary tables so as to get the data dictionary and any undo/redo segments necessary to get all the data back to a specific point in time whether that be a SCN or a timestamp.

Special Note: The default size of the SGA is 1G. It is a hard-coded parameter as it is not dependent on the existing database SGA size.

The file recover.bsq file in
$ORACLE_HOME/rdbms/admin/ contain the functions used to size the SGA .
Steps involved to bring back the table T1 into database using RMAN:

step 1 : A Full Database backup  already exists
Step 2 :The dropped table is ―T1‖
Step 3 :The owner of the table is ―TEST‖
Step  4 :Recovery is done as user ―SYSBACKUP‖
Step  5 :Auxiliary Destination used is ―AUX‖
Step 6 :Table is restored as ―T1_PREV‖ to check the contents of dropped table
Directory ―TSPITR_DIROBJ_DPDIR‖ is automatically created by RMAN

Step  7 : Creates a export dumpfile tspitr_<name>.dmp
Step 8 : Imports the table as T1_PREV into the database
Step 9 : Deletes all auxiliary destination files used for the recovery.

SQL> select current_scn from v$database;
CURRENT_SCN
—————————
1423211 —-

This is the time the table TEST.T1 is dropped from the database.

Run The script in RMAN Prompt.

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)
Loading...

Add Comment