Which two are true about the creation of a Data Guard B…

Which two are true about the creation of a Data Guard Broker configuration?

Which two are true about the creation of a Data Guard Broker configuration?

A.
in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

B.
A primary database profile may be added to the configuration prior to creating the primary database.

C.
A standby database profile may be added to the configuration prior to creating that standby database.

D.
A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

E.
A newly created broker configuration is in the disabled state



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Wim J

Wim J

incorrect.

see: https://docs.oracle.com/database/121/DGBKR/dgmgrl.htm#DGBKR625

D is incorrect

CREATE CONFIGURATION
Creates a new broker configuration that includes the specified primary database.
Format
CREATE CONFIGURATION configuration-name AS
PRIMARY DATABASE IS database-name
CONNECT IDENTIFIER IS connect-identifier;

So in the ‘create configuration’ there is no need (even no possibility??) to add information about standby’s

C is incorrect:
same site as above, ‘add database’ section
If the connection cannot be made, the broker does not add the new database to the configuration.

A is correct:
database-name (part of create configuration)
The name that will be used by the broker to refer to the primary database. It must match (case-insensitive) the value of the primary database DB_UNIQUE_NAME initialization parameter.

B is incorrect:
You must connect to the primary database to issue this command. (about the create configuration command usage notes)

correct answers: A, E

raul

raul

Yes A and E.

thanks

database-name
The name that will be used by the broker to refer to the primary database. It must match (case-insensitive) the value of the primary database DB_UNIQUE_NAME initialization parameter. (A)

https://docs.oracle.com/database/121/DGBKR/dgmgrl.htm#DGBKR625

CREATE CONFIGURATION configuration-name AS

PRIMARY DATABASE IS database-name

CONNECT IDENTIFIER IS connect-identifier;

Only the primary is required on create configuration command (Not D)

PK

PK

creation of dataguard configuration
1) duplicate primary to standby + copy orapw file from primary to standby /dbs
2) setup standby logs on both primary and standby
3) setup oracle network (listener, static registration for dataguard in listeners, name resolving in tnsnames.ora or elsewhere)
4) setup parameters for datafile creation and standby_file_management
alter system set standby_file_management=AUTO;
alter system set db_create_file_dest=+DATA;
5) enable dataguard process on primary and standby
alter system set dg_broker_start=TRUE;
6) create dataguard configuration
dgmgrl sys/
create configuration ‘PROD_OLTP’ as primary database is ‘PROD_OLTP’ connect identifier is prod_oltp.domain.com;
7) enable configuration
enable configuration
8) add standby database to configuration
add database ‘STBY_OLTP’ as connect identifier is stby_oltp.domain.com maintained as physical;
9) enable standby
enable database ‘STBY_OLTP’

Standby can be added before enabling whole configuration and then it is enabled as part of enabling whole configuration without enabling it separately.

incorrect nonsense B and C
incorrect also D
correct A and E