dg19c_test

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.

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.

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 should not be 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: 1. It should be possible to apply and test 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 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. If the former primary database became a physical standby database, it will always be open read- only. 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.

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 POB_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 srvtl 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 bein 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: fs1SYNC); 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 phyIt may not be used to flash back 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. Adda 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. You can specify only one standby database as the fast-start failover target. 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.

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.