Which two statements are true after enabling block chan…

You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database?

You are licensed to use Oracle Active Data Guard.
Which two statements are true after enabling block change tracking on a physical standby database?

A.
It allows fast incremental backups to be offloaded to the physical standby database.

B.
It starts the CTWR process on the physical standby database instance.

C.
It allows fast incremental backups to be taken on the primary database.

D.
It starts the RVWR process on the physical standby database instance.

E.
It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical
standby database in converted.

F.
It starts the CTWR process on the primary database instance.

Explanation:
A: Many of the customers now are opting to perform RMAN backups on standby database to offload the
resources of production database.
B: To enable Active Data Guard on a standby database, set the ENABLE_OPTION_ACTIVE_DATA_GUARD
initialization parameter to TRUE.
Note: Fast Incremental backups is possible with Block change tracking, which is initially introduced from
version 10.2 onwards, by this tool it’s very useful to reduce the RMAN incremental backup duration but it islimited only for Primary database. From 11g Oracle with Active Data Guard feature we can use Block change
tracking even on Physical standby database. T
http://www.morganslibrary.org/reference/block_change_tracking.html



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Chunn

Chunn

A,B

Explanation:
The block change tracking feature for incremental backups improves incremental backup performance by recording changed blocks in each data file in a block change tracking file. This file is a small binary file stored in the database area. RMAN tracks changed blocks as redo is generated.
If block change tracking is enabled, then RMAN uses the change tracking file to identify changed blocks for incremental backups, thus avoiding the need to scan every block in the data file. RMAN only uses block change tracking when the incremental level is greater than 0, because a level 0 incremental backup includes all blocks.

https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV8125