OVERVIEW:                 With oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sources. SYS audit records ( which was written to os trail in traditional method, will now be written to db […]

Below are the partitioning enhancements that has been introduced in Oracle 12c version. 1. Online partition move: From oracle 12c, we can move partitions online without blocking the DML statements during that time. ALTER TABLE DBACLASS MOVE PARTITION DBA_JAN2014 ONLINE; — To maintain global indexes ALTER TABLE DBACLASS MOVE PARTITION DBA_JAN2014 ONLINE UPDATE GLOBAL INDEXES; […]

            RMAN active is one of cloning method used to clone a database on target host without taking backup of the source database.  Make sure that source database is in archivelog mode. Below are the steps. NOTE: In 11g, RMAN active cloning is done during image copy( which includes unused […]

        In oracle 12c, if datafile is missing is standby database, then it can be restored easily from primary database using RESTORE DATAFILE FROM SERVICE command. This is one of the new feature of dataguard 12c .    DEMO: PRIMDB – Primary database STYDB – Standby database Check status of primary and […]

                                  There can be situation , in dataguard setup, where archive logs are missing from primary , before it was being shipped to standby  . Till 11g , we can make standby db sync with primary by taking an incremental […]

                                                A new privilege GRANT READ privilege has been introduced in oracle 12c . While the function of GRANT READ privilege is almost same as that of GRANT SELECT privilege, but with a difference […]

              In oracle 12c , when we startup the CDB, the PDBS will be in MOUNTED stage. We need to open them manually using alter pluggable PDB open. To make the PDBS open automatically, we can use the saved state option . This feature is available from Oracle 12.1.0.2  onwards  […]

     Below are steps for converting a non CDB/PDB database to PDB database in oracle. i.e Plugging a normal 12c non pdb database to a container database.   READ more about CDB and PDB: Oracle 12c Multitenent architecture  DEMO: NON-CDB DB -NAME -> NONCDB CDB DB NAME -> DBATEST Prerequisites:  Make sure One container […]

     In oracle 12c, transportable tablespace feature has been enhanced a lot. We can do cross platform migration using this feature with zero downtime.  This method uses both RMAN and datapump utility . The first step will take a full backup of the script, when the tablespaces are online and restore the same in […]

 We can upgrade an oracle database using OEM 12c cloud control also.  Here I will show how to upgrade database from 12.1.0.1 to 12.1.0.2 .  Note – Make sure that 12.1.0.2 ORACLE_HOME is installed.  SOURCE ORACLE_HOME(12.1.0.1) – /oracle/app/oracle/product/12.1.0 TARGET ORACLE_HOME(12.1.0.2)  – /oracle/app/oracle/product/12.1.0.2_CRM/dbhome_1   Enable Flashback: Before starting the upgrade, Enable flashback in the database, so […]