ORACLE 12C RELEASE 2 (12.2.0.1.0) GRID INFRASTRUCTURE UPGRADE

I recently performed an upgrade of an Oracle 12c Release 1 (12.1.0.2) Grid Infrastructure environment hosted on a RAC Virtual Box environment on my laptop to the latest release 12c Release 2 12.2.0.1.0 version.
Here are some points to be noted related to the upgrade process:

• The Grid Infrastructure 12c Release 2 (12.2) software is now available as a single image file for direct download and installation. This greatly simplifies and enables a much quicker installation of the Grid Infrastructure software.

How to use STANDBYS Clause to Disable recovery for Specific PDBs

Starting with Oracle Database 12.1.0.2 we have a new clause called "STANDBYS" in the sentence "CREATE PLUGGABLE DATABASE". This new clause is useful to specify if a new PDB will be recovered in the Standby Databases. This way you can have a Primary Container Database that have some PDBs where redo is not applied in the Standby Container Database.

This doesn't mean that the PDB will not exist in the Standby Container Database. The PDB exists, but only the general structure of that PDB is created in the Standby CDB, All its datafiles are not created in Standby CDB. Its datafiles are marked as UNNAMED and that PDB will have Recovery disabled and of course that PDB will not receive redo to get recovered. The PDB also cannot be open but will not impact the others PDBs in the Standby Container.

How to create database link in oracle 11gr2

                                 Database link Details:

Database link is a schema object in one database which enables us to access objects

 on another databases.And the other databases not need to be an Oracle Database

 system.But here, to access non-Oracle systems we should use Oracle different 

Services.

Rolling Forward a Physical Standby Database Using the RECOVER Command . 12C New Features

A standby database is a transactionally-consistent copy of the production database. It enables production Oracle database to survive disasters and data corruption. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch a standby database to the production role, minimizing the downtime associated with the outage. Moreover, performance of production database can be improved by offloading resource-intensive backup and reporting operations to standby systems. As you can see, it’s always desirable to have standby database synchronized with the primary database.

12c database New features list

The below is Gathered from various sources and listed out here, thanks to all who shared those in their respective blogs, Optimizer Blog, Tim hall, Ask Tom etc.

Installing 12c RAC on Linux VM: Install Oracle Database software and create RAC database

Today we will see how we can install 12c Release 1 RAC (Real Application Clusters) database on 2 Linux 64 bit Virtual Machines using VMWare or Oracle VirtualBox. The “c” in Oracle 12c stands for “Cloud“

There are a few important and interesting changes when it comes to installing 12c as compared to 11g RAC. Oracle seems to have added a lot of new interesting features in 12c.

Please note that we will need 2 Virtual Machines each with 3 GB of RAM. So if you have sufficient memory on your laptop/PC or server then you can host both VMs in same box or you can use 2 boxes which are connected to each other via local network.