Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?

A.

The standby database must be registered in an RMAN catalog after the primary database has been registered.

B.

The standby database can not be registered in an RMAN catalog if the primary database has not been registered.

C.

Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

D.

The standby database must be registered in an RMAN catalog before the primary database has been registered.

Your Data Guard environment consists of these components and settings:

1. A primary database

2. Two remote physical standby databases

3. The redo transport mode is set to sync

4. Real-time query is enabled for both standby databases

5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases

You notice an increase in redo apply lag time on both standby databases.

Which two would you recommend to reduce the redo apply lag on the standby databases?

A.

Increase the size of standby redo log files on the standby databases.

B.

Decrease the redo log file size on the primary database.

C.

Increase the number of standby redo log files on the standby databases.

D.

Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

E.

Increase the size of the buffer cache on the physical standby database instances.

Examine the Data Guard configuration after an accidental switchover to Sheep:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: MaxAvailability

Databases:

sheep - Primary database

dogs - Logical standby database

cats - Physical standby database (disabled)

ORA-16795: the standby database needs to be re-created

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Which three statements will be true after a switchover to Dogs?

A.

Sheep will be a disabled logical standby database.

B.

Cats will be a disabled physical standby database that can be manually enabled.

C.

Sheep will be an enabled logical standby database.

D.

Dogs will be the primary database.

E.

Cats will be an enabled physical standby database.

Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?

A.

A corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.

B.

A corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.

C.

A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.

D.

A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.

E.

A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A.

To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

B.

To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

C.

A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

D.

A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

E.

The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

Suppose that you manage the following databases in your environment:

• boston: Primary database with a single PDB called DEVI

• london: Physical standby database protecting the PDB called DEVI

• orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source

You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:

Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

A.

Open PDBI (remote clone source) in Read Only.

B.

Open PDBI (remote clone source) in Read Write.

C.

Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to in the london database.

D.

Set standby_pdb_source_file_dblink to clone_link in the london database.

E.

Enable Active Data Guard in the _ondon database.

F.

Set STANDBY_FILE_MANAGEMENT to auto in the london database.

Which THREE are true about using flashback database in a Data Guard environment?

A.

When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.

B.

You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

C.

It may be used to flash back a physical standby that receives redo from a far sync instance.

D.

You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.

E.

It may not be used to flash back a primary database after a failover to a physical standby.

F.

When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

A.

The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

B.

Itbackups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

C.

The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

D.

Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

E.

It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN?

A.

Transfer a copy of the password file from the primary host to the standby host.

B.

Run the nid utility to modify the DBID of the primary database.

C.

Create an SPFILE for the standby database.

D.

Create a standby control file.

E.

Configure Oracle Net connectivity between the primary host and the standby host.

On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

A.

It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

B.

It deletes both the SQL Apply filters.

C.

It succeeds but the SQL Apply filters are not deleted.

D.

It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.

E.

It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.