Download Oracle Database 12c: Data Guard Administration.1z0-066.PrepAway.2018-12-03.53q.vcex

A: DB_NAMEOn a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. C: Ensure the COMPATIBLE initialization parameter is set to the same value on both the primary and standby databases. If the values differ, redo transportservices may be unable to transmit redo data from the primary database to the standby databases. D: DB_FILE_NAME_CONVERTSpecify the path name and filename location of the primary database data files followed by the standby location. This parameter converts the path names of the primary database data files to the standby data file path names. E: DB_UNIQUE_NAMESpecify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles. F: FAL_SERVERSpecify the Oracle Net service name of the FAL server (typically this is the database running in the primary role). References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4720

Maximum Protection mode ensures that zero data loss occurs if a primary database fails. Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down. Incorrect Answers:A, D: Maximum Protection mode ensures that zero data loss occurs if a primary database fails.References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm

Note: Oracle Error: ORA-16625Error Description:Cannot reach the database Error Cause:The broker rejected an operation requested by the client when the database required to execute that operation was not reachable from the database where the request was made. If the request modifies the configuration, the request must be processed by the copy of the broker running on an instance of the primary database. Action:Check your network connections between all of the databases in the configuration. Alternatively, you can connect your client to a different database in the Data Guard broker configuration and try your request again. If you are simply attempting to determine the status of a particular database in the configuration, you may connect your client to that database and get the current value of the StatusReport property for that database. References: http://psoug.org/oraerror/ORA-16625.htm

Error code: DGM-16954Description: Unable to open and lock the Observer configuration fileCause: The Observer configuration file cannot be opened or cannot be locked for exclusive access.Action: Make sure the Observer has the correct operating system privileges to write the file and there is no other Observer that is using the same file. Try the command again. References: https://www.oraexcel.com/oracle-12cR1-DGM-16954

Incorrect Answers:E: NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.

B: A snapshot standby database can be converted back into a physical standby database at any time.E: You create a logical standby database by first creating a physical standby database and then transitioning it to a logical standby database.Incorrect Answers:A: Oracle Database supports the installation of database software upgrades, and the application of patch sets, in a rolling fashion—with near zero database downtime—by using Data Guard SQL Apply and logical standby databases. C: A cascaded redo transport destination (also known as a terminal destination) receives primary database redo indirectly from a standby database rather than directly from a primary database. Only physical standby databases can cascade redo. D: A snapshot standby cannot be the target of a switchover or fast-start failover operation.References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ls.htm#SBYDB4732https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB00580

There are three parameters that can be modified to control the number of processes allocated to SQL Apply: MAX_SERVERS, APPLY_SERVERS, andPREPARE_SERVERS. The following relationships must always hold true:APPLY_SERVERS + PREPARE_SERVERS = MAX_SERVERS - 3 This is because SQL Apply always allocates one process for the READER, BUILDER, and ANALYZER roles. References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm

C: Flashback Database is similar to conventional point-in-time recovery in its effects. It enables you to return a database to its state at a time in the recent past.Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. Flashback Database is used to convert a snapshot standby database back into a physical standby database. E: When we convert the physical standby database to snapshot standby database a guaranteed restore point is created. This guaranteed restore point is used to flashback a snapshot standby database to its original state. Incorrect Answers:A: Oracle Database supports the installation of database software upgrades, and the application of patch sets, in a rolling fashion—with near zero database downtime—by using Data Guard SQL Apply and logical standby databases. References:https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB4803http://satya-dba.blogspot.se/2012/06/snapshot-standby-databases-oracle.html

B: the terminal standby should have a LOG_ARCHIVE_DEST_n parameter defined that points back to the primary.D: Because the standby's requests for a range of sequences involve a round-trip to the primary, be sure to specify a large enough value for the CACHE keyword when you create a sequence that will be used on an Oracle Active Data Guard standby. Otherwise, performance could suffer. E: In an Oracle Active Data Guard environment, sequences created by the primary database with the default CACHE and NOORDER options can be accessed from standby databases as well. References: https://docs.oracle.com/database/121/SBYDB/manage_ps.htm#SBYDB5164