Cascaded Redo Transport Destinations: An Example of cascade Redo transfer, cascadedredo

Source: Internet
Author: User

Cascaded Redo Transport Destinations: An Example of cascade Redo transfer, cascadedredo

The following describes some other restrictions in earlier versions based on oracle 11.2.0.2.

Cascaded redo transport transfers redo data only from other standby databases.

For example, there is one master database A and two slave databases: B and C.

Then the log is transferred to A ---> B-> C. This is Cascaded Redo Transport.

A cascaded standby database can send redo logs to one or more other standby databases (physical, logical, or snapshot standby database). A maximum of 30 standby databases can be specified.

Serial redo data transmission can reduce the pressure of primary on log transmission.

After the redo data of the master database is transmitted to cascading standby, the redo data is not transmitted to other standby immediately, but is uploaded to other standby databases only after the cascading standby application. Therefore, the redo of cascaded destination has a latency than cascading standby.

Cascading has the following two restrictions:

(1) cascading standby can only be performed on physical standby databases.

(2) Data Guard broker does not support cascaded destinations.

Configure Cascaded Destination

(1) Select a physical standby database as the cascading standby database.

(2) set the FAL_SERVER parameter in cascading standby database to primary database or other standby databases that directly receive redo data from primary database.

(3) set the LOG_ARCHIVE_DEST_n parameter in cascading standby database to specify cascaded destination and other valid parameters.

(4) set the FAL_SERVER parameter in the cascaded destination database to the cascading standby database or other standby databases that directly receive redo from the primary database.

-- Some initialization parameters when Cascaded Redo Transport is used:

-- Primary Database:

DB_UNIQUE_NAME = boston

FAL_SERVER = boston2

LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (boston, boston2, denver )'

LOG_ARCHIVE_DEST_1 = 'location = USE_DB_RECOVERY_FILE_DEST

VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = boston'

LOG_ARCHIVE_DEST_2 = 'service = boston2 SYNC

VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = boston2'

-- Cascading Physical Standby Database:

DB_UNIQUE_NAME = boston2

FAL_SERVER = boston

LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (boston, boston2, denver )'

LOG_ARCHIVE_DEST_1 = 'location = USE_DB_RECOVERY_FILE_DEST

VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = boston2'

LOG_ARCHIVE_DEST_2 = 'service = denver

VALID_FOR = (STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME = denver'

-- Cascaded Physical Standby Database:

DB_UNIQUE_NAME = denver

FAL_SERVER = boston2

LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (boston, boston2, denver )'

LOG_ARCHIVE_DEST_1 = 'location = USE_DB_RECOVERY_FILE_DEST

VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = denver'

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.