Gavinsoorma - gavinsoorma.com - Oracle DBA - Tips and Techniques « Oracle DBA - Tips and Techniques
General Information:
Latest News:
Oracle 12c New Feature – Temporal Validity 21 Aug 2013 | 07:53 am
The Temporal Validity feature adds a time dimension to each row in the table consisting of two date-time columns to denote validity of data. Data that is older or no longer valid or not yet valid can ...
Oracle 12c new feature In-Database Archiving 5 Aug 2013 | 08:57 am
Very often in our databases we have some very large tables which have a lot of historical and legacy data and the challenge is deciding what is old data and what is current data and even if we do iden...
Minimal downtime rolling database upgrade to 12c Release 1 2 Aug 2013 | 09:01 am
This note describes the procedure used to perform a rolling database upgrade from 11.2.0.3 to Oracle 12c Release 1 using a Data Guard physical standby database and transient logical standby database. ...
12c New Feature – RMAN RECOVER TABLE 26 Jul 2013 | 08:08 am
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 restori...
12c How to plugin a non-CDB database to a Container Database (CDB) 18 Jul 2013 | 01:52 pm
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 Contai...
12c New Feature – Container and Pluggable Databases (Multitenant Option) 15 Jul 2013 | 08:23 am
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: Th...
12c Database Upgrade – 11.2.0.3 to 12.1.0.1 upgrade using DBUA 5 Jul 2013 | 08:52 am
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 int...
Restore RMAN backup to another server for testing disaster recovery procedures as well as for cloning 5 Jul 2013 | 06:05 am
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...
Enterprise Manager 12c Agentless Automatic Target Discovery 4 Jul 2013 | 12:14 pm
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 s...
Oracle12c database creation using DBCA 28 Jun 2013 | 06:29 am
In an earlier post we had discussed the installation process of the Release 12.1 Oracle database software and highlighted a few differences we can get to notice in some of the screens. Let us now loo...
