Last login: Mon May 21 18:42:35 2018
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgrl sys@cdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Mon May 21 23:58:41 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Password:
Connected to "cdb12c"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> create configuration cdb as primary database is cdb12c connect identifier is cdb12c;
Configuration "cdb" created with primary database "cdb12c"
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> add database cdr12c as connect identifier is cdr12c maintained as physical;
Database "cdr12c" added
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member
Fast-Start Failover: DISABLED
Configuration Status:
WARNING (status updated 38 seconds ago)
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 3 minutes (computed 26 seconds ago)
Apply Lag: 3 minutes (computed 26 seconds ago)
Average Apply Rate: 6.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16789: standby redo logs configured incorrectly
Database Status:
WARNING
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 4 minutes (computed 21 seconds ago)
Apply Lag: 4 minutes (computed 21 seconds ago)
Average Apply Rate: 6.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16789: standby redo logs configured incorrectly
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 minutes 59 seconds (computed 52 seconds ago)
Apply Lag: 10 minutes 59 seconds (computed 52 seconds ago)
Average Apply Rate: 6.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16857: member disconnected from redo source for longer than specified threshold
ORA-16789: standby redo logs configured incorrectly
Database Status:
WARNING
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 16 minutes 4 seconds (computed 47 seconds ago)
Apply Lag: 10 hours 16 minutes 4 seconds (computed 47 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16857: member disconnected from redo source for longer than specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 17 minutes 4 seconds (computed 5 seconds ago)
Apply Lag: 10 hours 17 minutes 4 seconds (computed 5 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 17 minutes 4 seconds (computed 14 seconds ago)
Apply Lag: 10 hours 17 minutes 4 seconds (computed 14 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 17 minutes 4 seconds (computed 20 seconds ago)
Apply Lag: 10 hours 17 minutes 4 seconds (computed 20 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 20 minutes 5 seconds (computed 20 seconds ago)
Apply Lag: 10 hours 20 minutes 5 seconds (computed 20 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c StandbyFileManagement;
StandbyFileManagement = 'AUTO'
DGMGRL>
DGMGRL> show database cdb12c StandbyFileManagement;
StandbyFileManagement = 'AUTO'
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgrl sys@cdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 22 21:49:27 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Password:
Connected to "cdb12c"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 31 minutes 5 seconds (computed 51 seconds ago)
Apply Lag: 10 hours 31 minutes 5 seconds (computed 51 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16857: member disconnected from redo source for longer than specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 37 minutes 6 seconds (computed 19 seconds ago)
Apply Lag: 10 hours 37 minutes 6 seconds (computed 19 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL> help TransportDisconnectedThreshold
Unrecognized command "transportdisconnectedthreshold", try "help"
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
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: 39.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
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: 38.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
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: 38.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 37.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 10.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 31 seconds ago)
DGMGRL>
DGMGRL> show database secondary;
Object "secondary" was not found
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show instance cdb12c
Instance 'cdb12c' of database 'cdb12c'
Instance Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> help
The following commands are available:
@ Execute DGMGRL script file
! Host operating system command
/ Repeat the last command
-- Comment to be ignored by DGMGRL
add Adds a member to the broker configuration
connect Connects to an Oracle database instance
convert Converts a database from one type to another
create Creates a broker configuration
disable Disables a configuration, a member, or fast-start failover
edit Edits a configuration or a member
enable Enables a configuration, a member, or fast-start failover
exit Exits the program
failover Changes a standby database to be the primary database
help Displays description and syntax for a command
host Host operating system command
migrate Migrate a pluggable database from one configuration to another.
quit Exits the program
reinstate Changes a database marked for reinstatement into a viable standby
rem Comment to be ignored by DGMGRL
remove Removes a configuration or a member
set Set a property to a specified value
show Displays information about a configuration or a member
shutdown Shuts down a currently running Oracle database instance
spool store input and output of DGMGRL CLI in a file
sql Executes a SQL statement
start Starts the fast-start failover observer
startup Starts an Oracle database instance
stop Stops the fast-start failover observer
switchover Switches roles between a primary and standby database
validate Performs an exhaustive set of validations for a database
Use "help <command>" to see syntax for individual commands
DGMGRL>
DGMGRL>
DGMGRL> validate database cdb12c
Database Role: Primary database
Ready for Switchover: Yes
Flashback Database Status:
cdb12c: Off
Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Flashback Database Status:
cdb12c: Off
cdr12c: Off
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL> validate database cdb12c
Database Role: Primary database
Ready for Switchover: Yes
Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Flashback Database Status:
cdb12c: On
cdr12c: Off
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgl
bash: dgmgl: command not found...
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgrl
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed May 23 00:42:36 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$ dgmgrl sys/Nblcdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed May 23 00:43:11 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "cdb12c"
Connected as SYSDG.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database database cdr12c
Object "database" was not found
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c
Database Status:
SHUTDOWN
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
Database Status:
WARNING
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
Database Status:
WARNING
DGMGRL> show database cdr12c
Database - cdr12c
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: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
Database Status:
WARNING
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with member setting
Fast-Start Failover: DISABLED
Configuration Status:
WARNING (status updated 29 seconds ago)
DGMGRL> show database ‘PRIMARY’ InconsistentProperties
Object "???primary???" was not found
DGMGRL>
DGMGRL> show database 'cdb12c' InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
DGMGRL>
DGMGRL>
DGMGRL> SHOW CONFIGURATION VERBOSE;
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with member setting
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'cdb12c_CFG'
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL> show database primary statusreport;
Object "primary" was not found
DGMGRL>
DGMGRL>
DGMGRL> show databsae cdb12c statusreport;
show databsae cdb12c statusreport;
^
Syntax error before or at "databsae"
DGMGRL>
DGMGRL> show database cdb12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
DGMGRL>
DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
cdr12c WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
cdr12c WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
cdr12c WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
cdr12c WARNING ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member
Fast-Start Failover: DISABLED
Configuration Status:
WARNING (status updated 34 seconds ago)
DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold
cdr12c WARNING ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold
DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold
DGMGRL>
DGMGRL>
DGMGRL> /
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 2 minutes 46 seconds (computed 12 seconds ago)
Apply Lag: 2 minutes 46 seconds (computed 12 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
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: 3.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 47 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 9 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 30 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - cdb
Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 38 seconds ago)
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 10.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdb12c
Database Role: Primary database
Ready for Switchover: Yes
Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL>
DGMGRL> validate database cdb12c
Database Role: Primary database
Ready for Switchover: Yes
Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdr12c
Database Role: Physical standby database
Primary Database: cdb12c
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL> show database
show database
^
Syntax error before or at "end-of-line"
DGMGRL>
DGMGRL> show database cdb12c
Database - cdb12c
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL> show database cdr12c
Database - cdr12c
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 9.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Database Status:
SUCCESS
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$
No comments:
Post a Comment