Setting up Oracle 12c Active Data Guard Database

In the Multitenant world, the PDB Database is considered an independent database but the operational tasks performed at the CDB level effect all the PDB databases plugged into it. The task of setting up of a Data Guard, switching or failing over are all performed at the CDB level. When the Data Guard is initially setup, with the CDB database, all PDB’s are also replicated to the target. Read more here.

ORA-27054: NFS file system not mounted with correct options

For the about a week I have been getting an “ORA-27054: NFS file system not mounted with correct options” error when running an RMAN backup to a NFS mount point. The system administrator has not been successful in identifying the cause as it shows that the correct mount point options are being used. Metalink Doc […]

New SYSBACKUP, SYSDG and SYSKM Administrative Users in Oracle 12c

Large enterprise database environments have dedicated DBAs performing specific database roles. Some of these specific roles include database storage management, tuning, backup and recovery, etc. Inside these organizations there has been growing concern to further ensure the use of the SOD (Segregation of Duties) concept, to fulfill duties for these roles.

Oracle GoldenGate 12c: Silent Install

Starting with GoldenGate 12c, Oracle has moved the installation mechanism into the familiar Oracle Universal Installer, GUI framework. It’s a good move not only in terms of ease of use but also for the uniformity of the install process across all Oracle products.