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

A LITTLE EFFORT EVERY DAY.YOU WILL MAKE A BIG DIFFERENCE.

How to use DGBroker to close redo applications

I. description

Oracle 12c

Rhel 7

2. Experiment

1. View configuration

DGMGRL > show configuration

Configuration-dg_config

Protection Mode: MaxAvailability

Members:

Orcl-Primary database

Orcldg-Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 27 seconds ago)

DGMGRL >

two。 View database information

DGMGRL > show database verbose orcl

Database-orcl

Role: PRIMARY

Intended State: TRANSPORT-ON-- enable transport

Instance (s):

Orcl

Properties:

DGConnectIdentifier = 'orcl'

ObserverConnectIdentifier =''

LogXptMode = 'sync'

RedoRoutes =''

DelayMins ='0'

Binding = 'optional'

MaxFailure ='0'

MaxConnections ='1'

ReopenSecs = '300'

NetTimeout = '10'

RedoCompression = 'DISABLE'

LogShipping = 'ON'

PreferredApplyInstance =''

ApplyInstanceTimeout ='0'

ApplyLagThreshold ='0'

TransportLagThreshold ='0'

TransportDisconnectedThreshold = '30'

ApplyParallel = 'AUTO'

StandbyFileManagement = 'AUTO'

ArchiveLagTarget ='0'

LogArchiveMaxProcesses ='4'

LogArchiveMinSucceedDest ='1'

DbFileNameConvert =''

LogFileNameConvert =''

FastStartFailoverTarget =''

InconsistentProperties ='(monitor)'

InconsistentLogXptProps ='(monitor)'

SendQEntries ='(monitor)'

LogXptStatus ='(monitor)'

RecvQEntries ='(monitor)'

StaticConnectIdentifier ='(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=roidb01) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=orcl_DGMGRL) (INSTANCE_NAME=orcl) (SERVER=DEDICATED)'

StandbyArchiveLocation ='+ DATADG/arch'

AlternateLocation =''

LogArchiveTrace ='0'

LogArchiveFormat = 'log_%t_%s_%r_%d.arc'

TopWaitEvents ='(monitor)'

Database Status:

SUCCESS

DGMGRL > show database verbose orcldg

Database-orcldg

Role: PHYSICAL STANDBY

Intended State: APPLY-ON-- Application enabled

Transport Lag: 0 seconds (computed 1 second ago)

Apply Lag: 0 seconds (computed 1 second ago)

Average Apply Rate: 0 Byte/s

Active Apply Rate: 0 Byte/s

Maximum Apply Rate: 0 Byte/s

Real Time Query: ON

Instance (s):

Orcldg

Properties:

DGConnectIdentifier = 'orcldg'

ObserverConnectIdentifier =''

LogXptMode = 'sync'

RedoRoutes =''

DelayMins ='0'

Binding = 'optional'

MaxFailure ='0'

MaxConnections ='1'

ReopenSecs = '300'

NetTimeout = '10'

RedoCompression = 'DISABLE'

LogShipping = 'ON'

PreferredApplyInstance =''

ApplyInstanceTimeout ='0'

ApplyLagThreshold ='0'

TransportLagThreshold ='0'

TransportDisconnectedThreshold = '30'

ApplyParallel = 'AUTO'

StandbyFileManagement = 'AUTO'

ArchiveLagTarget ='0'

LogArchiveMaxProcesses ='4'

LogArchiveMinSucceedDest ='1'

DbFileNameConvert =''

LogFileNameConvert =''

FastStartFailoverTarget =''

InconsistentProperties ='(monitor)'

InconsistentLogXptProps ='(monitor)'

SendQEntries ='(monitor)'

LogXptStatus ='(monitor)'

RecvQEntries ='(monitor)'

StaticConnectIdentifier ='(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=roidb02) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=orcldg_DGMGRL) (INSTANCE_NAME=orcldg) (SERVER=DEDICATED)'

StandbyArchiveLocation ='+ DATADG/arch'

AlternateLocation =''

LogArchiveTrace ='0'

LogArchiveFormat = 'log_%t_%s_%r_%d.arc'

TopWaitEvents ='(monitor)'

Database Status:

SUCCESS

DGMGRL > edit database 'orcldg' set state='apply-off'

Succeeded.

DGMGRL >

SQL > select process,status from v$managed_standby

PROCESS STATUS

--

ARCH CLOSING

ARCH CLOSING

ARCH CONNECTED

ARCH CLOSING

RFS IDLE

RFS IDLE

RFS IDLE

RFS IDLE

8 rows selected.

DGMGRL > edit database 'orcldg' set state='apply-on'

Succeeded.

DGMGRL >

SQL > /

PROCESS STATUS

--

ARCH CLOSING

ARCH CLOSING

ARCH CONNECTED

ARCH CLOSING

RFS IDLE

RFS IDLE

RFS IDLE

RFS IDLE

MRP0 APPLYING_LOG

9 rows selected.

Third, knowledge points

1. Use DGBroker to start and stop redo apply

two。 Physical standby database status

The role of 3.MRP0 process

The official website explains as follows:

Physical standby

APPLY-ON

Redo Apply is started on a physical standby database. -- start the redo application

If the standby database is an Oracle RAC database, the broker starts Redo Apply on exactly one standby instance

Called the apply instance. If this instance fails, the broker automatically chooses another instance that is either

Mounted or open read-only. This new instance then becomes the apply instance.

This is the default state for a physical standby database when it is enabled for the first time.

If a license for the Oracle Active Data Guard option has been purchased, a physical standby database

Can be open while Redo Apply is active. This capability is known as real-time query.

See Oracle Data Guard Concepts and Administration for more details.

Physical standby

APPLY-OFF

Redo Apply is stopped. -- close the redo app

If this is an Oracle RAC database, there is no instance running Apply Services until you change the database state to APPLY-ON.

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.