Far Sync Standby Database
A Far Sync Standby Database is a cascading Standby Database which acts as a Redo Log Repository for a Terminal Database. It does not contain any Datafiles. Only Log Transport Services are active on a Far Sync Standby Database. The Advantage of a Far Sync Standby Database is that it can be a local ArchiveLog Repository for the Primary Database acting in Maximum Availability Mode where the Physical or Logical Standby Database can be on a far remote Site.
Creating a Far Sync Standby Instance
You can prepare your Environment for a Far Sync Instance the same Way like for a Physical Standby Database, see
Note 1475344.1 Creating a Physical Standby Database on Oracle 11.2.0.x
-> Preparing the Environment and Standby Instance
for an Example.
Instead of a Physical Standby Controlfile we are creating a Far Sync Standby Controlfile from the Primary Database and use this Controlfile to mount the Far Sync Instance:
SQL> alter database create far sync instance controlfile as ‘
You can then setup Log Transport Services to the Cascaded Standby just like for normal Cascaded Standby Databases
Data Guard Broker and Far Sync Standby Database
The Data Guard Broker also supports Far Sync Standby Databases and Cascaded Standby Databases. You can add a Far Sync Standby to your Data Guard Broker Configuration using
DGMGRL> add far_sync
Then set the Data Guard Broker Property ‘RedoRoutes’ for the Databases accordingly. You can find an Explanation about ‘RedoRoutes’ in
Note 1542969.1 Cascaded Standby Databases in Oracle 12c