dg19c_test

Your Data Guard environment has one physical standby database using Real-Time Query. Two sentences have been created by these SQL statements: SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL; Then session 2 connects to the physical standby database instance and issues the same SQL statements. What output will be seen for session 2? A) Sequence a output - 21 Sequence b output - 1 B) Sequence a output - 21 Sequence b output - 21 C) Sequence a output - 1 Sequence b output - 1 D) Sequence a output - 1 Sequence b output - 21. option D. option A. option C. option B.

Which THREE statements are TRUE about Global Temporary Tables, when connected to a physical st database instance operating in Real-Time Query mode?. DDL operations on global temporary tables such as the CREATE or DROP Commands can be run. DML statements on them generate undo. DML statements are permitted on them by default. Their content is always kept in the SGA of the physical standby database. SELECT statements on them will return data inserted into them on the primary database. DML statements are permitted on them only if TEMP_UNDO ENABLED is explicitly set to TRUE.

Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases?. The DML operations on a standby can be transparently redirected to and run on the primary database. You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard. The DDL operations on private temporary tables are transparently redirected to the primary database. Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded. PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.

You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN. Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host. The DG BROKER START parameter must be set to TRUE for both database instances. The standby database must have supplemental logging enabled. The primary database must have FORCE LOGGING enabled. The LOG_ARCHIVE_DEST_n parameters with the SERVICE attribute set must be cleared. The primary database must have supplemental logging enabled.

Examine the command used to create a database service: srvctl add service -db erp -service erponline role PRIMARY -fallovertype TRANSACTION commit_outcome TRUE -replay init time 1800 -retention 86400 What is the significance of the COMMIT_OUTCOME attribute in this command?. It ensures that all committed transactions are written to the primary database before a switchover can complete. It ensures that there is no lag while performing a switchover or a failover. It ensures that all committed transactions affected during a switchover are rolled back. It ensures that commit state for a transaction is retained after a recoverable outage.

You must configure an Oracle Data Guard environment consisting of: 1. A primary database 2. A physical standby database 3. A snapshot standby database You must meet these requirements: 1. Primary database availability should not be compromised by the availability of the standby databases. 2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database. Which redo transport mode and which protection mode would you configure to meet these requirements?. SYNC AFFIRM and Maximum Protection. ASYNC and Maximum Performance. SYNC NOAFFIRM and Maximum Availability. SYNC AFFIRM and Maximum Availability. SYNC NOAFFIRM and Maximum Protection.

Which THREE statements are true about the states of a physical standby database that is open in real- time query mode, which becomes a new primary database during role transition?. All sessions are disconnected, and all buffers are flushed by default. Sessions that are using database links can be retained. All current buffers can be retained. Sessions that have long running queries can be retained. User sessions and Current Buffers are maintained by default. User sessions can be retained.

Examine the Data Guard configuration: DGMGRL > show configuration: Configuration -Animals Protection Mode: MaxAvailability Databases: cats- Primary database dogs-Physical standby database sheep-Logical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS Which statement will be true after a switchover to Dogs?. Cats will be a disabled physical standby database. Dogs will need to be reinstated. Sheep will need to be reinstated. Sheep will be an enabled logical standby database.

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?. Ensure that supplemental logging is enabled on the primary database. Ensure that flashback is enabled on the primary database. Do not perform any nologging operations on the primary. Ensure that no BFILE LOB data types are contained in the primary database. Ensure that no ROWID data types are contained in the primary database.

Which two are true about the creation of a Data Guard Broker configuration?. A standby database profile may be added to the configuration prior to creating that standby database. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created. In a broker configuration, the primary database name must match the DB UNIQUE NAME value in the database initialization parameter file. A primary database profile may be added to the configuration prior to creating the primary database. A newly created broker configuration is in the disabled state.

Which two are true about rolling release upgrades in a Data Guard environment?. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database. A physical standby database can be converted to a logical standby database temporarily.

Examine the Data Guard configuration: DGMGRL> show configuration: Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database sheep-Logical standby database cats- Logical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS Which three will be true after a switchover to Sheep?. Cats will be an enabled logical standby database. Sheep will be the primary database. Cats will be a disabled logical standby database. Dogs will be a logical standby database. Dogs will be a physical standby database.

Which TWO statements are true about block media recovery in a Data Guard environment?. When using RMAN, the RECOVER CORRUPTION LIST Command can automatically use blocks from flashback logs. DB LOST WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery. When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from block change tracking files. DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery. A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has Real-Time Query enabled.

Examine the Data Guard configuration: DGMGRL> show configuration; Configuration -Animals Protection Mode MaxAvaiIabiIity Databases dogs- Primary database cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover DISABLED Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1 DGM- 17017 unable to determine configuration status You wish to perform a failover to Sheep. Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?. DGMGRL> convert database sheep to physical standby;. DGMGRL> convert database cats to physical standby,. DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;. DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;. None, because you can directly failover to a Snapshot Standby Database.

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting. 1. Switchovers or failovers are possible due to testing or in case of a disaster. 2. Clients use local TNSNAMES.ORA files to define connection strings to the database instances. Which THREE will prevent clients from connecting to the wrong database instances?. Client TNS entries for the databases use the correct service names for the intended service. A service name is registered with the local listener of each database instance. Oracle Net connectivity to the primary database instance must be established on all the standby database instances. The LOCAL_LISTENER parameter on the primary database instance must always be set. The standby database services must be defined statically with the Listeners running on the standby database hosts. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment. The client applications must use the correct TNS entries when requesting connections to the database instances.

Examine the Data Guard configuration: DGMGRL >show configuration; Configuration-Animals Protection Mode MaxAvailability Databases dogs-Primary database sheep-Snapshot standby database cats-Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS You receive an error while attempting to raise the protection mode to Maximum Protection: DGMGDRL> edit configuration set protection mode as maxprotection; Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed. Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection. DGMGRL> edit database dogs set property LogXptMode= sync;. DGMGRL> edit database cats set property LogXptMode= sync;. DGMGRL> edit database sheep set property LogXptMode= sync;. DGMGRL> edit database dogs set property LogXptMode= sync; DGMGRL> edit database cats set property LogXptMode= sync; DGMGRL> edit database sheep set property LogXptMode= sync;. DGMGRL> edit database dogs set property LogXptMode= sync; DGMGRL> edit database cats set property LogXptMode= sync;. DGMGRL> edit database dogs set property LogXptMode= sync; DGMGRL> edit database sheep set property LogXptMode= sync;.

You must configure an Oracle dataguard environment consisting of: * A primary Database * Two physical standby database Examine these requirements 1. Data loss is not permitted 2. It should be possible to convert either of the physical standby to a snapshot standby database. 3. Under normal operations, transactions should not commit before redo is written to disk on both the primary database and atleast on one standby database 4. The availability of the primary database should not be compromised by the availability of standby databases. 5. It should be possible to enable fast-start failover. 6. It should be possible to deploy Real Application clusters on all databases. You configure FASTSYNC redo transport mode on both the standby databases in combination with Maximum Availability mode. Which requirements will you meet?. 1,2,4,5 and 6. 2,4,5 and 6. 2,3,4,5, and 6. 2,4, and 5. 1,2,3,4,5, and 6.

You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby forward in time without applying a large number of archive log files using this command RMAN> recover standby database from service-<primary database name>; When running this command, which of the steps are performed automatically 1. Remember all datafile names on the standby 2. Restart standby in nomount 3. Restore controlfile from primary 4. Mount standby database 5. Rename datafiles from stored standby names. 6. Restore new data files to new names 7. Recover standby. 1,2,5,6,7. 2,3,5,6,7. 2,3,6,7. 1,2,3,4,5,6,7. 1,2,3,4,6,7.

Which TWO observations are true about the Far Sync Instance?. Includes a standby controlfile, password files, datafiles, standby redo logs and archive logs. Can be created using the RMAN DUPLICATe command. Applies redo recieved. Can only be created using a series of SQL commands. Recieves redo synchronously from the primary database.

Which FOUR database parameters might be affected by or influence the creation of standby database?. DB_NAME. ARCHIVE_LAG_TARGET. COMPATIBLE. DB_FILE_NAME_CONVERT. DB_UNIQUE_NAME. FAL_SERVER. STANDBY_ARCHIVE_DEST.

You must configure an Oracle Data guard environment, consisting of 1. A primary database 2. A physical standby database Examine these requirements 1. Data loss is not permitted 2. It should be possible to convert the physical standby database to a snapshot standby database 3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance. 4. The availability of the primary database not be should compromised by the availability of the standby database. 5. It should be possible to convert the physical standby database to a logical standby database. 6. It should be possible to deploy the Real Application clusters on the primary database. 7, It should be possible to deploy the Real Application clusters on the physical standby database. You configure SYNC redo transport mode in combination with Maximum Protection Mode Which requirement will you meet?. 1,2,3,4,5,6, and 7. 1,2, and 5. 1,2,6,and 7. 1,6, and 7. 1,2,3,6, and 7.

You must configure an Oracle Data Guard environment consisting of: 1. A primary database 2. Three Physical Standby Databases You must meet these requirements: 1. A designated physical standby database should become the primary database automatically whenever the primary database falls. 2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement. Which redo transport mode and protection mode would you configure to meet these requirements?. SYNC NOAFFRIM and Maximum Protection. SYNC NOAFFIRM and Maximum Availability. ASYNC and Maximum Performance. SYNC AFFIRM and Maximum Availability. SYNC AFFIRM and Maximum Protection.

You are planning to perform block comparison using the DBMS_COMP package: SQL> exec sys.dbms_dbcomp.dbcomp ('1', 'BlockCompare', :retval) Which TWO statements are true?. Logical standby databases can be the target database for the DBMS_DBCOMP.DBCOMP procedure. The databases should be at least mounted before block comparison. It requires that the DB_LOST_WRITE_PROTECT initialization parameter be enabled. You can monitor the progress of an ongoing block comparison operation by querying VSSESSION_LONGOPS. It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.

You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements: 1. Data loss is not permitted, 2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time: 1. It should be possible to apply designated patches with a minimum amount of downtime. 2. Upgrading to a new database release should be performed with the least possible amount of downtime. 3. New application software releases should be tested against an exact and up-to-date replica of the prima database. Which configuration meets these requirements with the fewest databases?. A primary database with three physical standby databases. A primary database with one logical standby database. A primary database with one logical and one physical standby database. A primary database with one logical and two physical standby database. A primary database with two physical standby database. A primary database with one physical standby database.

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements: 1. Data loss is not permitted. 2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time: 3. It should be possible to apply and test designated patches with a minimum amount of downtime. 4. Upgrading to a new database release should be performed with the least possible amount of downtime. 5. New application software releases should be tested against an exact up-to-date replica of the production database. Your propose a primary database with one physical standby database configured in Maximum Protection mode. Which requirements do you meet?. 1, 2, 3, 4, and 5. 2, 3, 4, and 5. only requirement 5. only requirement 1. 1 and 2.

Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?. A static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations. Enterprise Manager does not require static service registration to restart instances during the course of broker operations. Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines. Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net. It is necessary to use the FAILOVER clause for an ADDRESS_LIST with multiple address lists in the tnsnames.ora file.

Which THREE are benefits of using the Data Guard Broker to manage standby databases?. It provides an easy switchover capability using a single command. It simplifies logical standby database creation. It coordinates database state transitions and updates database properties dynamically. It simplifies physical standby database creation. It automatically changes database properties after the protection mode for a configuration is changed. It load balances connections between the primary and all the standby database instances that are open as read-only for reporting. It provides an easy failover capability using a single command.

Examine this query and its output: SQL> select fs_failover_status, fs_failover_current_target, fs_failover_observer_present, fs_failover_observer_host from v$database; fs_failover_status, fs_failover_current_target, fs_failover_observer_present, fs_failover_observer_host ---------- ----- ------ ----------------- BYSTANDER cats NO ol7.example.com Which two statements are true?. The master observer is connected to the database on which the query was executed. The master observer is currently running on ol7.example.com. The master observer is not connected to the database on which the query was executed. Cats is a bystander database. The master observer is not running but should run on ol7.example.com.

Which THREE statements are true about snapshot standby databases?. FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled. A snapshot standby database may be opened read-write. A snapshot standby database may be opened read-only. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled. A snapshot standby database can have Real-Time apply enabled.

Which three are always benefits of using a logical standby database?. it can be used for database rolling release upgrades. it can be used to replicate a single pluggable database (PDB) in a multitenant container database. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates. It can be used for reporting workloads requiring additional indexes or materialized views or both. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database. it can be used for testing patches without affecting the primary database.

Which three are true concerning database states after a successful switchover?. If the former primary database became a logical standby database, it will be open read-write. The new primary database will be open read-write. If the former primary database became a physical standby database, it will be in the same state as the former physical standby database. The former primary database will always be open. If the former primary database became a logical standby database, it will be in mount state. If the former primary database became a physical standby database, it will always be open read-only.

Examine the following parameter settings of the physical standby database: * STANDBY_FILE_MANAGEMENT=AUTO * ENABLED_PDBS_ON_STANDBY=<null> During which TWO tasks are files automatically created in the physical standby database after structural changes on the primary database?. Adding or dropping a redo file group. Creating a PDB from the existing PDB within the same CDB. Renaming a data file in the primary database. Performing transportable tablespaces. Adding a datafile or creating a tablespace.

Suppose that you manage the following databases in your environment: * Boston: Primary database with a single PDB called DEV1. * London: Physical standby database protecting the PDB called DEV1 * ORCL: Standalone 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 PDB1 in ORCL SQL> CREATE PLUGGABLE DATABASE new_pdb1 FROM pdb1@clone_link; Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (London)?. Open PDB (remote clone source) in Read Only. Open PDB1 (remote clone source) in Read Write. Set STANDBY PDB SOURCE FILE DIRECTORY to <location of the PDB> in the london database. Enable Active Data Guard in the london database. Set STANDBY PDB_SOURCE_FILE_DBLINK to clone_link in the London database. Set STANDBY FILE MANAGEMENT to AUTO in the london database.

A customer asks you to propose the most appropriate solution for this set of requirements: 1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss. 2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes. 3. Developers may need to test occasionally on a copy of the live database. You have already confirmed that there are no unsupported data types on the primary database. Which two solutions would you recommend?. A logical standby database. A read mostly implementation of a physical standby database. A physical standby database with real-time query enabled. A remote physical standby database with RedoRoutes via a far sync instance. A snapshot standby database with synchronous redo transport.

Your Data Guard environment consists of these components and settings: 1. A primary database 2. A remote physical standby database 3. Real-time query is enabled. 4. The redo transport mode is set to SYNC. 5. The protection mode is set to Maximum Availability. You notice that queries executed on the physical standby database receive errors: ORA-03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?. Increase the network bandwidth between the primary and standby databases. Change the protection mode to Maximum Protection. Reduce I/O latency for the storage used by the primary database. Increase the size of the buffer cache on the standby database instance.

Which two statements are true for Data Guard environments with multi-tenant databases?. Each pluggable database within a multi-tenant physical standby database has one MRP background process running during redo apply. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name. A pluggable database within a multitenant standby database can have a different database role than the container database. A pluggable database within a multi-tenant standby database can have a different open mode than the container database.

Which two statements are true regarding asynchronous redo transport in a Data Guard environment?. The performance of SQL apply on a logical standby database always improves when using this transport mode. A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration. This transport mode satisfies the minimum requirements for Maximum Availability data protection mode. Real-time query performance on a physical standby database improves for current read requests when using this transport mode. This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.

You are licensed to use Oracle Active Data Guard. Which TWO statements are true after enabling block change tracking on a physical standby database?. It allows fast incremental backups to be taken on the primary database. It starts the CTWR process on the physical standby database instance. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted. It starts the RVWR process on the physical standby database instance. It starts the CTWR process on the primary database instance. It allows fast incremental backups to be offloaded to the physical standby database.

Examine the Data Guard configuration; DGMGRL> show configuration; Configuration Animals Protection Mode: MaxPerformance Databases: dogs- Primary database sheep- Physical standby database cats- Snapshot standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS You receive an error while attempting to raise the protection mode to Maximum Protection: DGMGRL> edit configuration set protection mode as maxprotection: Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed. What can you conclude based on this error?. The redo transport mode is set to ASYNC for both standby databases. The redo transport mode is set to ASYNC for the standby database Cats. Cats is a snapshot standby database. The redo transport mode is set to ASYNC for the standby database Sheep.

Your Data Guard environment contains a primary database and three standby databases with these attributes: Which TWO can be used to prevent clients from connecting to the wrong database instance?. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services. Establish Oracle Net connectivity to the primary database instance from all the standby database instances. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role. Create role-based services with the srvctl utility when using cluster ware for Oracle RAC.

Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered. 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. The standby database must be registered in an RMAN catalog after the primary database has been registered. The standby database must be registered in an RMAN catalog before the primary database has been registered.

Examine the procedure that you plan to execute on your logical standby. SQL> execute dbms_logstdby.skip(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE'); What is a prerequisite for execution of this procedure?. Stop SQL apply on the logical standby database. Stop redo transport to the logical standby database. Change the redo transport mode if necessary to ASYNC. Execute the DBMS_LOGSTDBY.APPLY SET procedure to record errors that might cause SQL Apply to stop.

Examine the Data Guard configuration: DGMGRL> show configuration: Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover: DISABLED Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs" DGM-17017: unable to determine configuration status Which three will be true after a successful failover to Cats?. Sheep will be in the disabled state. The configuration will be in Maximum Availability mode. The configuration will be in Maximum Performance mode. Dogs will being the disabled state and has to be manually reinstated. Sheep will be in the enabled state.

Which three types of backups offloaded to a physical standby database, are fully interchangeable with the primary database in a Data Guard configuration?. Online logs. Data files. Password files. Archive logs. Broker configuration files. Control files.

A customer has these requirements for their potential Data Guard implementation: 1. Zero data loss must still be guaranteed through the loss of any one configuration component. 2. The primary database must be protected against a regional disaster. 3. Performance overheads on the primary should be minimized as much as possible given these requirements. 4. Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are: prima|the primary database fs1|the Far Sync instance in the primary region physt|a physical standby database in a remote region physt1|a physical standby database in the primary physt2|a physical standby database in a remote region Which Data Guard broker commands are needed to implement these requirements?. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1,SYNC); EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=" (prima: physt ASYNC)'; | EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1,FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL:fs1 SYNC)’; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=" (prima:physt2 SYNC)’; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL:physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=" (LOCAL: fs1, FASTSYNC)'; EDIT FAR_SYNC fs1SET PROPERTY REDORUOTES=" (prima: physt2 ASYNC)’; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1ASYNC); EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES="' (prima: physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION.

You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment Which of the following steps are required to restore the lost file over the network? 1. Connect to the physical standby database as the TARGET 2. Connect to the physical standby database as the AUXILLARY 3. Back up the data file as copy on the standby host to a location only available on the standby host 4. Back up the data file as copy on the standby host to a location that is available on the primary host 5. Catalog the data file copy for RMAN to use on the primary database for restore. 6. Connect to the primary database as the AUXILIARY. 7. Connect to the primary database as the TARGET. 8. Restore the lost data file from the physical standby database using the FROM SERVICE clause. 2,4,7. 1, 3, 5, 6. 1, 4, 5, 6. 7,8.

Which three statements are true about snapshot standby databases?. Tablespaces can be dropped. Tables can be dropped. Tablespaces can be created. The switchover to command allows a switchover operation to a snapshot standby database. A logical standby database can be converted into a snapshot standby database. The failover to command results in a transition of a snapshot standby database to the primary role.

Which THREE statements are true about Far Sync instances?. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary. They use as spfile, a standby controlfile, and standby redo logs. The Data Guard Broker must be used to deploy and manage Far Sync instances. A primary database can ship redo directly to multiple Far Sync instances. They work with any protection level.

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 corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled. A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database. 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. A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.

Which THREE are true about using flashback database in a Data Guard environment?. When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically. It may not be used to flash back a primary database after a failover to a physical standby. When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically. You can use it when real-time apply is enabled in case the physical may not be used to flashback a primary database after a failover to a logical standby. You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption. It may be used to flash back a physical standby that receives redo from a far sync instance.

Examine this Validate command: DGMGRL> VALIDATE DATABASE VERBOSE '<database name>'; Which THREE statements are TRUE?. The command performs network connectivity checks between members of a broker configuration. The command performs a comparison of SPFILE entries between the primary database and a specified standby database. The command can be used for a logical standby database. The command uses information available in various Oracle Data Guard views as well as the Automatic Diagnostic Repository. The command performs a comprehensive set of database checks prior to a role change.

Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning. Which tool is used to tune SQL workloads running on an ADG database?. Standby Statspack. Automatic Workload Repository (AWR). SQL Tuning Advisor. In-Memory Active Session History (ASH). Automatic Diagnostic Database Monitor (ADDM).

Examine the Data Guard configuration: DGMGRL> show configuration; Configuration Animals - Protection Mode: MaxAvailability Databases: dogs- Primary database sheep- (*) Physical standby database cats- Physical standby database Fast-Start Failover: ENABLED - Configuration Status: SUCCESS - What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?. The switchover succeeds but Dogs needs to be reinstated. The switchover succeeds and Cats becomes the new failover target. The switchover succeeds and Fast-Start Failover is suspended. It results in an error indicating that a switchover is not allowed. The switchover succeeds and Dogs becomes the new failover target.

Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?. You can check if redo apply needs to be tuned. You can check the potential data loss in the event of a disaster. You can set a warning threshold on the redo generation rate metric for a physical standby database. You can monitor the redo apply rate on a logical standby database. You can set a critical threshold on the redo generation rate metric for a primary database. You can monitor the redo apply rate on a snapshot standby database.

Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?. building a LogMiner dictionary on the primary database instance. switching the primary database to the logical standby role. creating a guaranteed restore point on the primary database. creating a guaranteed restore point on the standby databases. converting the designated physical standby database into a logical standby database. starting media recovery on all the Leading Group Standby databases.

Examine this list of possible steps: 1 Raise the compatibility level on both databases. 2 Restart SQL Apply on the upgraded logical standby database. 3 Start SQL Apply on the old primary database. 4 Perform a Switchover to the logical standby database. 5 Upgrade the logical standby database. 6 Upgrade the old primary database. Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?. 4,6,5,2,3,1. 5,2,4,6,3,1. 1,5,2,4,6,3. 5,2,4,1. 5,2,4,3,6,1.

Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or GoldenGate configured?. The LGWR process writes to them on a standby database. They are required only for synchronous redo transport. They are required on a logical standby for real-time apply. Only standby databases can write redo to them. It is recommended to have them on the primary database. They are required on a physical standby for real-time apply.

Which four factors can influence the rate of SQL apply on a logical standby database?. the number of full table scans performed by SQL apply. the number of APPLIER processes. the number of PREPARER processes. the size of the undo tablespace on the logical standby database. the size of the shared pool. the number of coordinator processes on the standby database instance.

Which THREE are required in order to use Real-Time Query without lagging behind the primary?. Real-Time apply must be enabled on the standby. The primary must ship redo asynchronously. There must be standby redo logs on the standby database. COMPATIBLE must be set to 11.1.0 or higher. There must be standby redo logs on the primary database.

A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows. As a result of this, you decide that an upgrade may not use logical standby databases. Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary?. With manual upgrade, catupard.agt can be executed on the primary and standby databases simultaneously. Redo Apply on the standby database must be stopped while the primary database is upgraded. The broker must be disabled during the upgrade. Fast-Start Failover can be used to protect the primary database during the upgrade. The upgrade requires downtime until the upgrade of the primary is completed. The upgrade requires downtime until the upgrade of the standby is completed. The new release of the Oracle software must be installed on both the primary and standby database hosts.

You must configure flashback database for your Oracle 19c databases that will be part of a dataguard broker configuration The databases are all in Archivelog Mode You will execute the SQL statement ALTER DATABASE FLASHBACK ON; Which three are true concering this command?. It will execute successfully on an Oracle 19c physical standby database while Real Time query is active. If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standy databases that are part of the configuration. It will execute successfully while an Oracle 19c primary database is open. It will execute successfully while an Oracle 19c primary database is mounted. It executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration. It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.

Which two are prerequisites for configuring flashback database for Oracle 19c databases, in a Data Guard environment?. A far sync instance must be configured to flash back a standby when the primary has been flashed back. The Data Guard real-time apply feature must be enabled. The data guard broker must be used. A fast recovery area must be configured. The database must be in ARCHIVELOG mode.

Which TWO statements are true about database parameters for databases in a Data Guard environment?. LOG FILE NAME CONVERT applies to online redo logs and archived logs. COMPATIBLE must have identical values for primary and standby databases. If DB RECOVERY FILE_DEST is specified, then LOG ARCHIVE_DEST n is not required for local archive logs. The databases that are part of a Data Guard configuration must have different DB UNIQUE NAME initialization parameters. DB FILE NAME CONVERT is only required if the standby database is on the same host as the primary database.

Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?. If the primary database is a container database, then a logical standby may be a non-container database. All broker actions execute at the root container for container databases. If the primary database is a container database, then a physical standby may be a non- container database. If the primary database is not a container database, then a standby may be a container database. After a role change, the broker opens all Pluggable databases (PDBS) on the new primary.

Which four are true about the DGMGRL SHOW command?. It can be used to show properties of a pluggable primary database. It can be used to show properties of a far sync instance. It can be used to show Fast Start Failover properties. It can be used to show instance-specific properties for a RAC database. It can be used to show properties of a primary container database. It can be used to show properties of a pluggable standby database.

Which TWO are benefits of using Transaction Guard in a Data Guard environment?. It protects against user errors being replicated to standby databases. It provides application continuity by replaying transactions interrupted by a failover or a switchover. It protects against recoverable errors during a planned or an unplanned outage of a primary database. It protects against logical corruptions being replicated to standby databases. It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.

Your Data Guard environment has two remote physical standby databases. Client applications use the local naming method to connect to the primary database instance. You want applications to automatically connect to the new primary database instance in case of a switchover or a failover. Which set of actions will fulfill this requirement?. Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name. Set DB NAME and DB UNIQUE NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name. Set the LOCAL LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose SID is PROD_SBY. Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the primary database role: srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150 Consider this list of tasks 1. On a node of the standby database cluster execute srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150 2. On the primary database, create the OLTPWORKLOAD database service using the DBMS_SERVICE.CREATE_SERVICE procedure 3. Configure the TAF clients in the tnsnames.ora files 4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances 5. On the standby database, create the OLTPWORKLOAD database service using the DBMS_SERVICE.CREATE_SERVICE procedure Identify the required steps to configure and use Transparent Application Failover (TAF). 3,4. 5. 1,4. 1,3,4. 4. 2,3,4.

In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE...SET PARAMETER Command: DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace =1: Which THREE statements are TRUE about the command?. The value set using this command is directly stored in the broker configuration file. The value set using this command is directly applied to the boston database. The database must be available when the above command is run. The EDIT DATABASE PARAMETER command can only be used to modify the value of a dynamic parameter in a database. The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.

After converting your physical standby database to a logical database, you get an error: DGMGRL> show configuration Configuration- proddg Protection Mode: MaxPerformance Databases: prod-Primary datatabse 1 prodsby-Physical standby database Error: ORA-16810 multiple errors or warnings detected for database Fast-Start Failover: DISABLED Configuration Status: 1 ERROR How can you rectify the error?. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it. Add logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is 2 logical standby updates to the metadata. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

Which three are prerequisites for enabling Fast-Start Failover?. Flashback Database must be enabled only on the Fast-Start Failover target standby database. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database. The Data Guard environment must be managed by the Data Guard Broker. The configuration must be operating in either Maximum Performance or Maximum Protection mode. The maximum protection mode can be used, but with two or more standby databases. You can specify only one standby database as the fast-start failover target.

Examine the Data Guard configuration: DGMGRL > show configuration; Configuration-Animals Protection Mode: MaxAvailability Databases: dogs- Primary database sheep- Physical standby database cats - Physical Standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS An attempt to enable fast-start failover raises an eror: DGMGRL> enable fast_start failover; Error: ORA-16693: requirements not met for enabling fast-start failover Failed. Identify three possible reasons for this error: THe LogXptMOde property is set to ASYNC on Dogs. The LogXptMode property is set to FASTASYNC on Cats while Sheep is the target standby database. The LogXptMode property is set to FASTASYNC on Dogs. THe LogXptMode property is set to ASYNC on sheep while Sheep is the target standby database. The FastStartFailoverTarget property is not set on Dogs.

Which TWO statements are true regarding Data Guard Broker?. It can be used to monitor rede transport and log apply services. It can be used to create and manage standby databases. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby. It can be used to perform failovers and switchovers. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements: 1. The performance impact on the primary database should be kept to a minimum. 2. Creating and maintaining materialized views should not impact the performance of the primary database. Additionally, there are these requirements, only the one of which is ever done at any one time: 3. It should be possible to apply designated patches with a minimum amount of downtime. 4. Upgrading to a new database release should be performed with the least possible amount of downtime. 5. New application software releases should be tested against an exact up-to-date replica of the production database. You propose a configuration operating in Maximum Performance mode with a primary database and one logical standby database. Which requirements do you meet?. 1, 2, and 3. 2 and 5. 1 and 5. 1, 2, 3, 4, and 5. 1, 2, and 4. 2, 3, and 5.

Which four requirements can be met by deploying a logical standby database?. Support for workloads requiring additional indexes. It can be used to create additional schemas. It can be used to create additional tables. It must have the same physical structure as the primary database. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers. Support for workloads requiring additional materialized views. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

Which four statements are true regarding SQL Apply filters for a logical standby database?. They can be used to skip execution of DML triggers on a table while allowing the DML to execute. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands. They can be used to stop SQL apply if it encounters an error. They can be used to skip all SQL statements executed on a specific pluggable database {PDB) within a standby multitenant container database {CDB). They can be used to skip ALTER TABLE commands on a specific tables. They can be used to skip CREATE TABLE commands. They can only be used to skip DML statements on a table.

You created two remote physical standby databases using SQL and RMAN. The primary database is a four-instance RAC database and each physical standby database has two instances. Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure. Consider these operational requirements: • The ability to manage multiple standby databases with a single tool. • The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases. • The automation of failovers to a specified target standby database. Which TWO tools can be used to fulfill these requirements? (Choose two.). SRVCTL. Enterprise Manager Cloud Control. SQL* Plus. RMAN. DGMGRL. GDCCTL. CRSCTL.

Which three are among the various tasks performed by the data Guard Monitor (DMON) process?. performing role transitions when switchover requests are made. communicating with DMON processes in other database instances that are part of the broker configuration. activating role-based services appropriately in the various database instances of the configuration, based on the database role. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required. maintaining information about all members of the broker configuration in binary configuration files.

Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered. backups of data files taken on the logical standby database, if not connected to a recovery catalog. backups of control files taken on the logical standby database if not connected to a recovery catalog.

Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?. Backups of data files taken on the primary database may be restored on a physical standby database. Backups of control files taken on the primary database may not be restored and used on a physical standby database. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database. Backups of control files taken on a physical standby database may be restored on the primary database. Backups of data files taken on a physical standby database may be restored on a primary database. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.). Different pluggable databases within a logical standby database may have different guard statuses. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database. A multi-tenant standby database can have fewer pluggable databases than the primary container database.

Which three statements are true about snapshot standby databases?. Snapshot standby databases may be used for rolling release upgrades. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database. Flashback logs are used to convert a snapshot standby database back into a physical standby database. A snapshot standby database can have Real-Time Query enabled. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Which two are true about management of a far sync instance when using the Data Guard Broker? (Choose two.). A far sync instance is in a disabled state in the broker configuration immediately after adding it. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created.

Your Data Guard environment consists of these components and settings: 1. A primary database supporting an OLTP workload 2. A remote physical standby database 3. Real-time query is enabled 4. The redo transport mode is set to SYNC. 5. The protection mode is set to Maximum Availability. Which two are true regarding the DelayMins Database Property for the standby database? (Choose two.). It can only be enabled for a configuration in Maximum Performance mode. It allows user errors on the primary to be recovered by using the physical standby database. It enables you to bypass the default network timeout interval specified for the standby redo transport destination. It can only be enabled for a configuration in Maximum Availability mode. It allows logical corruptions on the primary to be recovered by using the physical standby database. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

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? (Choose two.). Increase the size of the buffer cache on the physical standby database instances. Increase the number of standby redo log files on the standby databases. Decrease the redo log file size on the primary database. Lower DB_BLOCK...CHECKING to MEDIUM or LOW on the standby databases. Increase the size of standby redo log files on the standby databases.

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?. Real Time Query must be enabled on the primary database. Real Time Query must be enabled on the physical standby database. If a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved. If a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.

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 will be true after a switchover to Dogs?. Sheep will be a disabled logical standby database. Sheep will be an enabled logical standby database. Cats will be a disabled physical standby database that can be manually enabled. Cats will be an enabled physical standby database. Dogs will be the primary database.

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.). The primary database instance must be started using an SPFILE. The primary database must have flashback enabled. A backup of the primary database must exist. The primary database must be in archive log mode. The primary host and the proposed standby database host must run the same operating system. The primary database must have FORCE LOGGING enabled.

A Data Guard environment has this configuration and these attributes: 1. A primary database 2. A Physical Standby Database named sbdb 3. The configuration is in maximum availability protection mode. Then sbdb is converted to a snapshot standby database. When two statements are true? (Choose two.). Sdbd can still apply redo. The recovery point objective increases. The protection mode is lowered to maximum performance. The recovery time objective increases. Sbdb can still receive redo.

Examine the Data Guard configuration: DGMGRL> show configuration verbose; Configuration Animals - Protection Mode: MaxPerformance - Databases: cats- Primary database dogs-(*) Physical standby database sheep - Physical standby database (*) Fast-Start Failover target Properties: FastStartFailoverThreshold = 30 - OperationTimeout = 30 - TraceLevel = USER - FastStartFailoverLaglimit = 30 - Communication Timeout= 180 - ObserverReconnect= 10 - FastStartFailoverAutoReinstate= FALSE FastStartFailoverPmyShutdown= TRUE BystanderFollowRoleChange= none - ObserverOverride = FALSE - Fast-Start Failover: ENABLED - Threshold: 30 seconds - Target: dogs - Observer: 015.example.com - Lag Limit: 30 seconds - Shutdown Primary: TRUE - Auto-reinstate: FALSE - Observer Reconnect: 10 seconds - Observer Override: TRUE - Configuration Status: SUCCESS Which TWO are true? (Choose two.). The observer must run on host 0I5.example.com and is currently not running. The observer will reinstate Sheep automatically after a failover, if required. The observer will mark another standby database as the failover target if the original failover target becomes unavailable. The observer will detect if the primary database is unable to accept new connections. The former primary database will not be reinstated automatically after a failover.

Which three factors can influence the rate of redo apply on a physical standby database?. the network latency between the primary and standby databases. the number of archiver processes on the standby database. the number and size of standby redo logs on the primary database. the rate of redo generation on the primary database. the number and size of standby redo logs on the standby database.

Your expertise is requested for these customer requirements: 1. The Data Guard environment must be in maximum protection mode. 2. Reports must be offloaded to a physical standby database. 3. There must be no lag between the primary and standby databases that affect the reports produced. 4. The primary database must be resilient in case of a single network failure. Which solution is correct for these requirements?. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY MAlLDELAY parameter set to zero, receiving redo from the primary with asynchronous transport. two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY MAlLDATA....DELAY parameter set to zero, receiving redo from the primary with synchronous transport. one physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected the primary. one physical standby database with Real-Time Query enabled and the STANDBY_MAX_DATA....DELAY parameter set to zero, receiving redo from the primary with synchronous transport. two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE__DEST_n attributes SYNC.

Which TWO Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control? (Choose two.). monitoring the redo apply rate on a physical standby. monitoring the redo apply rate on a logical standby. monitoring the undo generation rate on a logical standby. monitoring the redo apply rate on a snapshot standby. monitoring the transport lag. monitoring the undo generation rate on the primary.

Which TWO Data Guard features require the use of flashback database by the broker? (Choose two.). Read-Mostly physical standby implementations. Far Sync Instances. Fast-Start Failover. Real Time Query. Snapshot Standby databases.

You have a Data Guard Broker configuration called Somewhere as show: DGMGRL> show configuration; Configuration Somewhere - Protection Mode: MaxPerformance - Databases: Nearby-Primary database - FS-Far Sync - Farout-Physical standby database Fast-Start Failover: DISABLED - Configuration Status: SUCCESS You then run this command: DGMGRL> SHOW DATABASE Nearby lnconsistentProperties; Which two are true about the output of this DGMGRL command? (Choose two.). A far sync instance cannot have inconsistent properties because it has no database. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby. Any inconsistency reported is on an instance-specific basis.

Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.). A rolling release upgrade can be performed with the Data Guard environment in any protection mode. The transient logical standby database used for the rolling release upgrade can run with a newer version of the Oracle software than the primary database. The transient logical standby database used for the rolling release upgrade must have the same DBID as the primary database. The original primary database can ship redo to any standby database that is part of the Data Guard configuration during the rolling release upgrade process. SELECT GUARD_STATUS FROM V$DATABASE; must return NONE as a prerequisite for the rolling release upgrade with a transient logical standby database.

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.). It backups 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. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered. 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. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog.

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.). Create a standby controlfile. Create an SPFILE for the standby database. Transfer a copy of the passwordfile from the primary host to the standby host. Run the nid utility to modify the DBID of the primary database. Configure Oracle Net connectivity between the primary host and the standby host.

Attempting to start the observer raises an error: DGMGRL> start observer: DGM-16954: Unable to open and lock the Observer configuration file Failed. Identify TWO possible reasons for this error.? (Choose two.). The observer configuration file is marked read-only. There is another observer running for a Data Guard configuration which uses the same observer configuration file. The broker configuration has not yet been created. There is already an observer running for this Data Guard configuration. Fast-Start Failover is not yet enabled for this Data Guard configuration.

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled? (Choose three.). Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary. Their usage may have a performance impact on the physical standby database if the CACHE size is too small. They must have the NOORDER and CACHE options set. If the CACHE option is set then the size of the cache must be atleast 100. Their usage will always have a performance impact on the primary database.

Examine the Data Guard configuration: DGMGRL > show configuration; Configuration-Animals - Protection Mode: MaxPerformance - Databases: dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database Fast-Start Failover: DISABLED· Configuration Status: SUCCESS You receive an error while attempting to raise the protection mode to Maximum Availability: DGMGDRL> edit configuration set protection mode as maxavailability; Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed. Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.? (Choose two.). DGMGRL> convert database sheep to physical standby;. DGMGRL> convert database cats to physical standby;. DGMGRL> edit database dogs set property LogXptMode= fastsync;. DGMGRL> edit database sheep set property LogXptMode= fastsync;. DGMGRL> edit database cats set property LogXptMode= sync;.

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control. Which two are true about this change? (Choose two.). If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database. Fast start failover can be enabled when making the chance. Real time apply will be automatically turned on.

There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.? (Choose two.). Increase the PROCESSES initialization parameter. Increase the value for the MAX_SERVERS SQL apply parameter. Decrease the number of archiver processes on the standby database. Increase the PARALLEL_MAlLSERVER initialization parameter. Decrease the number of PREPARER processes. Increase the RECOVERY PARALLELISM initialization parameter.

Attempting to start the observer raises an error: DGMGRL> start observer: DGM-16954: Unable to open and lock the Observer configuration file Failed. Identify two possible ways to start the observer successfully.? (Choose two.). Set the Observer Override property to TRUE before starting the observer. Create a broker configuration and enable Fast-Start Failover before starting the observer. Start the observer using a different observer configuration file. Start the observer in a different working directory. Enable Fast-Start Failover before starting the observer.

Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database? (Choose two.). FLASHBACK DATABASE must be enabled on the physical standby database. There must be connectivity between the primary and the physical standby database. FLASHBACK DATABASE must be enabled on the primary database. The physical standby database must have Real-Time Apply enabled. The logical standby database must have Real-Time Query enabled.

A Data Guard environment has this configuration and these attributes: 1. The primary database prima is in the local region. 2. A physical standby database phystl is in the local region. 3. A physical standby database physt2 is in a remote region. 4. The primary ships redo to phystl. 5. phystl ships redo physt2. 6. phystl and physt2 have Real-Time Query enabled. A sequence has been created with this SQL statement in the primary database: CREATE SEQUENCE a NOCACHE SESSION: Which two statements are true? (Choose two.). The sequence is usable on phystl and physt2. The sequence is usable on phystl but not usable on physt2. The sequence is usable on physt2 if phystl becomes unavailable, but only if an alternative redo destination has been configured on the primary database. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG..ARCHIVE..DEST_n has the ALTERNATE attribute specified on the primary database. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG..ARCHIVE..DEST_n has the ALTERNATE attribute specified on physt1.

Which two are true about the usage of DBMS_ROLLING? (Choose two.). The leading group contains the original primary database. The trailing group contains the original primary database. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process. At least one logical standby database must be part of the initial Data Guard configuration. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control? (Choose two.). A snapshot standby database is the only standby database in the Data Guard configuration. A logical standby database is the only standby database in the data guard configuration. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration. The primary and standby databases are hosted on different operating systems.

Which TWO statements are TRUE about Temporary Undo when enabled in a Data Guard environment? (Choose two.). It reduces the volume of undo generated on the primary when using Global Temporary Tables on a physical standby database. It reduces the volume of undo generated on the primary when using Global Temporary Tables on a logical standby database. It enables DML to be issued on Global Temporary Tables on a physical standby database. It reduces the volume of redo generated on the primary when using Global Temporary Tables on the primary. It enables DML to be Issued on Global Temporary Tables on a logical standby database.

You are using Data Guard in conjunction with Global Database Services. You have a Data Guard Broker configuration called Sales and a GDS pool called Prod. Which three are true concerning the management of the broker configuration when using GDS?. Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services. DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool. DGMGRL may be used to add the Sales configuration to the Prod pool in GDS. Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration. Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.

Which three statements are true about redo transport? (Choose three.). With synchronous redo transport, LGWR ships redo directly to RFS processes on the standby database instances and waits for an acknowledgment. With asynchronous redo transport, TTnn processes may read redo from the log buffer or from standby redo logs on the primary database. An RFS process on a standby database instance may receive redo from an archiver process on the primary database instance to perform archive gap resolution. Multiple RFS processes may receive redo on one far sync instance. Multiple RFS processes may receive redo on one standby database instance.

You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not. Which four could be reasons for the increase in SQL apply lag? (Choose three.). An increased number of bulk updates on the primary. An increased number of bulk inserts on the primary. An undersized shared pool. The standby redo log files are undersized on the primary. Many SQL apply operations do full table scans. An undersized undo tablespace on the logical standby.

Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.). Flashback database may not be used to undo a physical standby database activation. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby. Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby. Logical standby databases retain their current role when you flash back through to a point in time the switchover occurred which caused this database to become a logical standby.

You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command: DGMGRL> CREATE CONFIGURATION 'DGConflg' AS PRIMARY DATABASE IS 'PROD' CONNECT IDENTIFIER IS PROD; Which three statements are true regarding the execution of the command? (Choose three.). The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host. The command will execute successfully only if the DG_BROKER..START initialization is set to TRUE for the PROD database instance. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER..START IS TRUE for PRODSBY1 . The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER..CONFIG_FILEn initialization parameters on the primary database. The PRODSBY1 standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBY1 database instance is defined on the primary host.

Which two statements are true about Far Sync instances? (Choose two.). They work in Maximum Availability mode. They work in Maximum Performance mode. They work in Maximum Protection mode. They do not work with Logical Standby databases. They do not work with Snapshot Standby databases.

Examine the Data Guard configuration: DGMGRL> show configuration; Configuration - Animals - Protection Mode: MaxAvailability Databases: dogs - Primary database cats - Physical standby database sheep - Logical standby database Fast-Start Failover: DISABLED - Configuration Status: ORA-01034: ORACLE not available - ORA-16625: cannot reach database "dogs" DGM-17017: unable to determine configuration status Which three will be true after a successful failover to Sheep? {Choose three.). Cats will be in the disabled state and must be manually reinstated. Cats will be in the disabled state and must be manually re-created. Dogs will be in the disabled state and must be manually re-created. Dogs will be in the disabled state and must be manually reinstated. The configuration will be in Maximum Performance mode. The configuration will be in Maximum Availability mode.

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?. 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. The LOCAL LISTERNER initialization parameter must be set to the listener used to register the primary database instance. To enable ReaLTime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

On your logical standby database, you specified these rules: SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> DML, - SCHEMA.NAME=> HR, - OBJECT_NAME=> EMP_NEW); SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> DML, - SCHEMA.NAME=> HR, - OBJECT_NAME=> EMP_OLD); After completion of the weekend batch cycle you attempt to delete the SQL Apply filters: SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT => DML, - SCHEMA.NAME=> HR, - OBJECT_NAME=> EMP%); Which is true regarding the execution of the UN SKIP procedure?. It succeeds only if SQL apply is stopped before deleting the SQL Apply filter. It succeeds but the SQL Apply filters are not deleted. It deletes both the SQL Apply filters. 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. It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

Examine the Data Guard configuration: Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' TraceLevel = 'USER' FastStartFailoverLaglimit = '30' CommunicationTimeout = '180' ObserverReconnect = '10' FastStartFailoverAutReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'all' ObserverOverride = 'FALSE' Fast-Start Failover: ENABLED - Threshold: 30 seconds - Target: dogs - Observer: prutser6.example.com - Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE - Auto-reinstate: TRUE - Observer Reconnect: 10 seconds - Observer Override: Configuration Status: SUCCESS What happens if you issue "failover to dogs;· at the DGMGRL prompt while connected to Dogs?. The failover succeeds, Sheep becomes the new target standby database, and Cats is automatically reinstated. The failover succeeds and Cats is automatically reinstated. The failover succeeds and Cats is left running. The failover succeeds and Cats is terminated. It results in an error indicating that a failover is not allowed.

Which feature is available when monitoring a Data Guard configuration using Enterprise Manager Cloud Control, but is not-available using DGMGRL or by using SQL?. Viewing a logical standby database redo apply rate. Creating a broker configuration before creating the databases. Performing a series of validation checks on the Data Guard configuration. Automatic creation of standby redo logs. Analyzing the dmon process trace file.

You have a Data Guard broker configuration consisting of: 1. A primary database 2. One local physical standby database 3. One far sync instance 4. A remote physical standby database The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools. What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?. Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored. Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored. Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored. Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored. Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.