Posts

Showing posts from August, 2017

MaxAvailability DataGuard environment : Adding a far sync instance to the environment

An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with  standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database. Far Sync is a lightweight Oracle instance that has only a control file, spfile, password file and standby log files, there are no database files or online redo logs Oracle Far Sync provides the ability to perform a zero data loss failover to a remote standby database without requiring a second standby database or complex operation. Far Sync enables this by deploying a Far Sync inst...

Oracle 12.2 DBCA duplicate only for Sinlge Instance Standby Databases

The DBCA duplicate command in this release can only create a single instance standby database from single instance non- multitenant primary databases. 

Using DBCA to create a standby database

Image
In Oracle 12.2 there is a new feature added to the  dbca   commando. One of the new feature is creating a standby database [ DBCA Standby Creation ].   At the Standby server install the Oracle Software and start a listener. And start the command " dbca -silent - createDuplicateDB - createAsStandby ". This dbca command will create a standby database , and  nothing more. Get the new standby database operational as a standby database additional steps must be performed. The steps are conform the steps  for building a standby databases . Lets play with the DBCA option for creating a standby database.