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

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

1. Modify database properties

EDIT DATABASE 'South_Sales' SET PROPERTY' LogArchiveFormat'='log_%t_%s_%r_%d.arc'

II. Operation steps

2.1 View DG status

Dgmgrl /

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 55 seconds ago)

2.2 View DG properties

DGMGRL > show database verbose orcldg

Database-orcldg

Role: PHYSICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 0 seconds (computed 1 second ago)

Apply Lag: 0 seconds (computed 1 second ago)

Average Apply Rate: 24.00 KByte/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 = '30'

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 ='% tweets% slots% r.dbf'

TopWaitEvents ='(monitor)'

Database Status:

SUCCESS

2.3 View archive log format

SQL > show parameter log_archive_format

NAME TYPE VALUE

-

Log_archive_format string t_%s_%r.dbf

SQL >

2.4 modify database properties using DGMGRL

DGMGRL > EDIT DATABASE 'orcldg' SET PROPERTY' LogArchiveFormat'='log_%t_%s_%r_%d.arc'

Warning: ORA-16675: database instance restart required for property value modification to take effect

Property "LogArchiveFormat" updated

DGMGRL >

DGMGRL > EDIT DATABASE 'orcl' SET PROPERTY' LogArchiveFormat'='log_%t_%s_%r_%d.arc'

Warning: ORA-16675: database instance restart required for property value modification to take effect

Property "LogArchiveFormat" updated

DGMGRL >

2.5 check whether it is effective

SQL > show parameter log_archive_format

NAME TYPE VALUE

-

Log_archive_format string t_%s_%r.dbf

SQL >

2.6 Database restart

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL >

SQL >

SQL >

SQL > startup

ORACLE instance started.

Total System Global Area 1241513984 bytes

Fixed Size 2923872 bytes

Variable Size 452985504 bytes

Database Buffers 771751936 bytes

Redo Buffers 13852672 bytes

Database mounted.

Database opened.

SQL >

2.7 check whether it is in effect

ASMCMD [+ datadg/arch] > ls

1_12_954623021.dbf

.... Omit.

1_61_954623021.dbf

Log_1_62_954623021_585bafa7.arc-format change

Log_1_63_954623021_585bafa7.arc

Log_1_64_954623021_585bafa7.arc

ASMCMD [+ datadg/arch] >

SQL > show parameter log_archive_format

NAME TYPE VALUE

-

Log_archive_format string log_%t_%s_%r_%d.arc

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.