Common questions

What are new features in 11g Data Guard?

author 0

What are new features in 11g Data Guard?

In 11gR2, two additional features were added as part of Active Data Guard – doing incremental backups on the physical standby with block change tracking enabled and automatic corrupt block detection and recovery.

What is Data Guard in Oracle 11g?

In 11g, Oracle introduced the Active Data Guard feature. This allows the standby database to be open in read-only mode, but still apply redo information. This means a standby can be available for querying, yet still be up to date.

What are the different services available in Oracle Data Guard?

Redo Transport Services
Following are the different Services available in Oracle Data Guard of Oracle database: Redo Transport Services….Ans:

  • High Availability.
  • Data Protection.
  • Off loading Backup operation to standby database.
  • Automatic Gap detection and Resolution in standby database.
  • Automatic Role Transition using Data Guard Broker.

How enable Data Guard in Oracle?

Step by Step to configure Oracle 12c Data Guard Physical Standby

  1. Step1:-Change Archivelog mode.
  2. Step2:-Change force logging mode.
  3. Step3:-Adding Redologfile for standby database.
  4. Step4:-Adding the network entry in primary and standby side(Both servers)
  5. step5:-Changing parameters in primary database.

How do you implement Data Guard?

Use the following configuration best practices for Data Guard:

  1. Use Oracle Data Guard Broker with Oracle Data Guard.
  2. Use Recovery Manager to Create Standby Databases.
  3. Use Flashback Database for Reinstatement After Failover.
  4. Use FORCE LOGGING Mode.
  5. Use a Simple, Robust Archiving Strategy and Configuration.

What is Db_unique_name in Oracle 11g?

DB_UNIQUE_NAME specifies a globally unique name for the database. Databases with the same DB_NAME within the same DB_DOMAIN (for example, copies of a database created for reporting or a physical standby) must have a unique DB_UNIQUE_NAME .

What is FAL server in Oracle?

FAL_SERVER specifies the FAL (fetch archive log) server for a standby database. The value is an Oracle Net service name, which is assumed to be configured properly on the standby database system to point to the desired FAL server.

What is DataGuard in Oracle?

The software which Oracle Corporation markets as Oracle Data Guard forms an extension to the Oracle relational database management system ( RDBMS ). It aids in establishing and maintaining secondary standby databases as alternative/supplementary repositories to production primary databases.

What is Oracle Active Data Guard?

Active Data Guard. Oracle Active Data Guard is a new option with Oracle 11g. Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, Web-based access, and so on, while continuously applying changes received from the production database.

What is Oracle Data Guard broker?

Data Guard Broker. The broker is part of Oracle’s Database Enterprise Manager and an integral part of Data Guard, it is the management framework. You can of course use SQL*Plus to manage Data Guard but the broker when used with the Enterprise Manager becomes a powerful tool offering the following.

What is active data guard?

Active Data Guard – Answers to Frequently Asked Questions. The Active Data Guard Option is an evolution of Data Guard technology that incorporates significant innovation (multiple patents pending) designed for a specific purpose – to improve production database performance for critical transactions.

author

Back to Top