Shulou(Shulou.com)06/01 Report--

I. description

Oracle 12c

RHEL 7.3

2. Configure DataGuard Broker

1. Source end

Sqlplus / as sysdba

Alter system set dg_broker_config_file1='/oracle/oradata/orcl/dr1.dat'

Alter system set dg_broker_config_file2='/oracle/oradata/orcl/dr2.dat'

Alter system set dg_broker_start=true

two。 Destination end

Sqlplus / as sysdba

Alter system set dg_broker_config_file1='/oracle/oradata/orcl/dr1.dat'

Alter system set dg_broker_config_file2='/oracle/oradata/orcl/dr2.dat'

Alter system set dg_broker_start=true

3. View dmon processes

$ps-ef | grep dmon

Oracle 5768 1 0 20:28? 00:00:00 ora_dmon_orcl

Oracle 5773 4404 0 20:28 pts/1 00:00:00 grep-color=auto dmon

4. Configure DG

The source side uses the oracle user to execute

$dgmgrl /

DGMGRL for Linux: Version 12.1.0.2.0-64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected as SYSDG.

DGMGRL > create configuration 'dg_config' as primary database is' orcl' connect identifier is orcl

Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Failed.

DGMGRL >

5. Check the error report

$oerr ora 16698

16698, 0000, "LOG_ARCHIVE_DEST_n parameter set for object to be added"

/ / * Cause: One or more LOG_ARCHIVE_DEST_n initialization parameters that

/ / contain a SERVICE attribute but not the NOREGISTER attribute were

/ / set when attempting to create a configuration or add a standby or

/ / far sync instance to the configuration.

/ / * Action: If creating a configuration, clear all LOG_ARCHIVE_DEST_n

/ / initialization parameters that contain a SERVICE attribute but not

/ / the NOREGISTER attribute. If adding a standby database or far sync

/ / instance, clear the LOG_ARCHIVE_DEST_n initialization parameter

/ / that specifies the database or far sync instance to be added.

$

6. Error reporting processing

The main library and backup database need to be executed!

This error can be resolved by canceling the log_archive_dest_n parameter on Primary and Standby

In fact, the parameters of this block should be managed by DG broker, and no longer need to be set by human intervention.

SQL > alter system reset log_archive_dest_2

System altered.

SQL > alter system reset log_archive_dest_1

System altered.

SQL > startup force

ORACLE instance started.

Total System Global Area 1560281088 bytes

Fixed Size 2924784 bytes

Variable Size 1006636816 bytes

Database Buffers 536870912 bytes

Redo Buffers 13848576 bytes

Database mounted.

Database opened.

SQL >

7. Configure, enable, view DG

$dgmgrl /

DGMGRL for Linux: Version 12.1.0.2.0-64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected as SYSDG.

DGMGRL >

DGMGRL > create configuration 'dg_config' as primary database is' orcl' connect identifier is orcl

Configuration "dg_config" created with primary database "orcl"

DGMGRL > add database 'orcldg' as connect identifier is orcldg

Database "orcldg" added

DGMGRL >

DGMGRL > enable configuration

Enabled.

DGMGRL > show configuration

Configuration-dg_config

Protection Mode: MaxPerformance

Members:

Orcl-Primary database

Orcldg-Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 6 seconds ago)

DGMGRL >

III. Summary

Originally, the test environment DG does not use broker, but the customer's environment is managed by broker

I had to change my environment to broker management.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.