12c New Feature – RMAN RECOVER TABLE

Posted by Gavin Soorma
On July 26, 2013
0 Comments

One of the good new features in Oracle 12c is the ability to restore a single table or a single partition of a partitioned table from an RMAN backup via the RECOVER TABLE command. Prior to 12c restoring a table was a long drawn out and difficult affair. So when may we use this fearure? […]

Posted by Gavin Soorma
On July 18, 2013
0 Comments

In one of my earlier posts we had seen how we can create a 12c CDB (container database) using DBCA and we had also seen how we can upgrade a database from 11.2.0.3 to Oracle 12c Release 1. The Container database cdb12c originally has one pluggable database testdb1 (as well as the seed PDB). We […]

Posted by Gavin Soorma
On July 15, 2013
1 Comments

Container and Pluggable databases is one of the main new features introduced in 12c nd is referred to as the Multitenant Option. A Container database (CDB) is made up of the following containers: There is one root container which stores the Oracle supplied metadata like the PL/SQL data dictionary packages and the common users. This […]

Posted by Gavin Soorma
On July 5, 2013
0 Comments

I recently tested the upgrade of an Oracle 11.2.0.3 database to 12c Release 1 and here are the screen shots as well as some new things in found in the 12c Database Upgrade Assistant. The DBUA GUI interface has now changed as compared to previous releases. It is like the OUI with split screen layout […]

Restore RMAN backup to another server for testing disaster recovery procedures as well as for cloning

Posted by Gavin Soorma
On July 5, 2013
0 Comments

This note explains the procedure used to restore an Oracle Suggested Strategy incremental backup on another server. This is useful when we have to do periodic testing of disaster recovery procedures where we simulate a scenario when the complete database server has crashed and a new server has been provisioned. But let us assume that […]

Posted by Gavin Soorma
On July 4, 2013
0 Comments

Unlike previous releases OEM 12c can now detect and discover targets even before the management agents are deployed on managed hosts. This agentless technology is based on using nmap which is an IP scanning utility. Once targets are discovered, we can use the promotion process to convert these unmanaged hosts into managed hosts by deploying […]

News

12c New Feature – RMAN RECOVER TABLE

12c How to plugin a non-CDB database to a Container Database (CDB)

12c New Feature – Container and Pluggable Databases (Multitenant Option)

12c Database Upgrade – 11.2.0.3 to 12.1.0.1 upgrade using DBUA

Restore RMAN backup to another server for testing disaster recovery procedures as well as for cloning

Enterprise Manager 12c Agentless Automatic Target Discovery