ORACLE DATABASE PROBLEM AND SOLUTIONS

Wednesday, May 26, 2021

Convert a Snapshot Standby Back to a Physical Standby using DGMGRL

Converting a Snapshot Standby Back to a Physical Standby using DGMGRL

DGMGRL> convert database india_stby to physical standby;

Converting database "india_stby" to a Physical Standby database, please wait...

Operation requires shut down of instance "india_stby" on database "india_stby"

Shutting down instance "india_stby"...

Connected to "india_stby"

Database closed.

Database dismounted.

ORACLE instance shut down.

Operation requires start up of instance "india_stby" on database "india_stby"

Starting instance "india_stby"...

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Database mounted.

Connected to "india_stby"

Continuing to convert database "india_stby" ...

Database "india_stby" converted successfully

DGMGRL>

DGMGRL> sql 'alter system switch logfile';

Succeeded.

DGMGRL> show configuration

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Warning: ORA-16854: apply lag could not be determined

Fast-Start Failover: DISABLED

Configuration Status:

WARNING (status updated 45 seconds ago)

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 21 seconds ago)

DGMGRL>

on standby database table hr.abc_snap table does not exist which we created when database role was snapshot standby

===================================================================

[oracle@ip-10-0-1-37 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Wed May 26 11:19:33 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select * from hr.abc_snap;

select * from hr.abc_snap

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select name ,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

INDIA READ ONLY WITH APPLY PHYSICAL STANDBY

SQL>

Convert a Physical Standby to a Snapshot Standby using DGMGRL

Convert a Physical Standby to a Snapshot Standby using DGMGRL

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed May 26 11:07:46 2021

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 43 seconds ago)

DGMGRL>

DGMGRL> validate database india;

Database Role: Primary database

Ready for Switchover: Yes

Flashback Database Status:

india: Off

Managed by Clusterware:

india: 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 india_stby;

Database Role: Physical standby database

Primary Database: india

Ready for Switchover: Yes

Ready for Failover: Yes (Primary Running)

Flashback Database Status:

india : Off

india_stby: On

Managed by Clusterware:

india : NO

india_stby: NO

Warning: Ensure primary database's StaticConnectIdentifier property

is configured properly so that the primary database can be restarted

by DGMGRL after switchover

Current Log File Groups Configuration:

Thread # Online Redo Log Groups Standby Redo Log Groups Status

(india) (india_stby)

1 3 3 Insufficient SRLs

Future Log File Groups Configuration:

Thread # Online Redo Log Groups Standby Redo Log Groups Status

(india_stby) (india)

1 3 2 Insufficient SRLs

DGMGRL>

DGMGRL> convert database india_stby to snapshot standby;

Converting database "india_stby" to a Snapshot Standby database, please wait...

Database "india_stby" converted successfully

DGMGRL>

On Standby database

====================

SQL> select name ,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

INDIA READ ONLY WITH APPLY PHYSICAL STANDBY

SQL> /

select name ,open_mode,database_role from v$database

ERROR at line 1:

ORA-03135: connection lost contact

Process ID: 5938

Session ID: 272 Serial number: 59433

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@ip-10-0-1-37 ~]$

[oracle@ip-10-0-1-37 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Wed May 26 11:11:02 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name ,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

INDIA READ WRITE SNAPSHOT STANDBY

SQL>

SQL> create table hr.abc_snap as select * from hr.abc;

Table created.

SQL>

SQL> select * from hr.abc_snap;

ID NAME

---------- --------------------------------------------------

2 From standby after primary

1 A

3 from primary after convert

SQL>

Tuesday, May 25, 2021

Validate oracle database using dgmgrl utility before and after switchover

Validate primary/standby database using dgmgrl utility before and after switchover

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:34:37 2021

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 47 seconds ago)

DGMGRL>

DGMGRL> validate database verbose india;

Database Role: Primary database

Ready for Switchover: Yes

Flashback Database Status:

india: Off

Capacity Information:

Database Instances Threads

india 1 1

Managed by Clusterware:

india: NO

Warning: Ensure primary database's StaticConnectIdentifier property

is configured properly so that the primary database can be restarted

by DGMGRL after switchover

Temporary Tablespace File Information:

india TEMP Files: 1

Data file Online Move in Progress:

india: No

Transport-Related Information:

Transport On: Yes

Log Files Cleared:

india Standby Redo Log Files: Cleared

Automatic Diagnostic Repository Errors:

Error india

No logging operation NO

Control file corruptions NO

System data file missing NO

System data file corrupted NO

System data file offline NO

User data file missing NO

User data file corrupted NO

User data file offline NO

Block Corruptions found NO

DGMGRL>

DGMGRL> validate database verbose india_stby;

Database Role: Physical standby database

Primary Database: india

Ready for Switchover: Yes

Ready for Failover: Yes (Primary Running)

Flashback Database Status:

india : Off

india_stby: On

Capacity Information:

Database Instances Threads

india 1 1

india_stby 1 1

Managed by Clusterware:

india : NO

india_stby: NO

Warning: Ensure primary database's StaticConnectIdentifier property

is configured properly so that the primary database can be restarted

by DGMGRL after switchover

Temporary Tablespace File Information:

india TEMP Files: 1

india_stby TEMP Files: 1

Data file Online Move in Progress:

india: No

india_stby: No

Standby Apply-Related Information:

Apply State: Running

Apply Lag: 0 seconds (computed 1 second ago)

Apply Delay: 0 minutes

Transport-Related Information:

Transport On: Yes

Gap Status: No Gap

Transport Lag: 0 seconds (computed 1 second ago)

Transport Status: Success

Log Files Cleared:

india Standby Redo Log Files: Cleared

india_stby Online Redo Log Files: Cleared

india_stby Standby Redo Log Files: Available

Current Log File Groups Configuration:

Thread # Online Redo Log Groups Standby Redo Log Groups Status

(india) (india_stby)

1 3 3 Insufficient SRLs

Future Log File Groups Configuration:

Thread # Online Redo Log Groups Standby Redo Log Groups Status

(india_stby) (india)

1 3 2 Insufficient SRLs

Current Configuration Log File Sizes:

Thread # Smallest Online Redo Smallest Standby Redo

Log File Size Log File Size

(india) (india_stby)

1 200 MBytes 200 MBytes

Future Configuration Log File Sizes:

Thread # Smallest Online Redo Smallest Standby Redo

Log File Size Log File Size

(india_stby) (india)

1 200 MBytes 200 MBytes

Apply-Related Property Settings:

Property india Value india_stby Value

DelayMins 0 0

ApplyParallel AUTO AUTO

ApplyInstances 0 0

Transport-Related Property Settings:

Property india Value india_stby Value

LogXptMode ASYNC ASYNC

Dependency <empty> <empty>

DelayMins 0 0

Binding optional optional

MaxFailure 0 0

MaxConnections 1 1

ReopenSecs 300 300

NetTimeout 30 30

RedoCompression DISABLE DISABLE

LogShipping ON ON

Automatic Diagnostic Repository Errors:

Error india india_stby

No logging operation NO NO

Control file corruptions NO NO

SRL Group Unavailable NO NO

System data file missing NO NO

System data file corrupted NO NO

System data file offline NO NO

User data file missing NO NO

User data file corrupted NO NO

User data file offline NO NO

Block Corruptions found NO NO

DGMGRL>

Oracle Dataguard Switchover using DGMGRL - Error : ORA-01017: invalid username/password; logon denied

DGMGRL Error : ORA-01017: invalid username/password; logon denied

DGMGRL> switchover to india_stby;

Performing switchover NOW, please wait...

Operation requires a connection to database "india_stby"

Connecting ...

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

connect to instance "india_stby" of database "india_stby"

we have to provide sys user credentials (username/password pair) to connect to database in DGMGRL also check sec_case_sensitive_logon database parameter .

In order to resolve ORA-01017 this error , we have to connect to dgmgrl utility using below method :

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:02:07 2021

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 48 seconds ago)

DGMGRL>

DGMGRL> switchover to india_stby

Performing switchover NOW, please wait...

Operation requires a connection to database "india_stby"

Connecting ...

Connected to "india_stby"

Connected as SYSDBA.

New primary database "india_stby" is opening...

Operation requires start up of instance "india" on database "india"

Starting instance "india"...

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Database mounted.

Database opened.

Connected to "india"

Switchover succeeded, new primary is "india_stby"

DGMGRL>

Oracle 12c- Perform Dataguard Switchover Using DGMGRL Utility

Oracle 12c- Perform Dataguard Switchover Using DGMGRL Utility

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:02:07 2021

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL

DGMGRL> edit database india set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.12)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=india)(INSTANCE_NAME=india)(SERVER=DEDICATED)))';

DGMGRL> edit database india_stby set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.37)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=india_stby)(INSTANCE_NAME=india_stby)(SERVER=DEDICATED)))';

[oracle@ip-10-0-1-12 ~]$ dgmgrl

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 25 14:02:07 2021

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys@india

Password:

Connected to "india"

Connected as SYSDBA.

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 48 seconds ago)

DGMGRL>

DGMGRL> switchover to india_stby

Performing switchover NOW, please wait...

Operation requires a connection to database "india_stby"

Connecting ...

Connected to "india_stby"

Connected as SYSDBA.

New primary database "india_stby" is opening...

Operation requires start up of instance "india" on database "india"

Starting instance "india"...

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Database mounted.

Database opened.

Connected to "india"

Switchover succeeded, new primary is "india_stby"

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india_stby - Primary database

india - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 28 seconds ago)

DGMGRL>

[oracle@ip-10-0-1-37 ~]$ !sq

sqlplus sys/sys@india_stby as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 25 14:05:53 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name ,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

INDIA READ WRITE

SQL>

SQL> insert into hr.abc values(2,'From standby after primary');

1 row created.

SQL> commit;

Commit complete.

SQL>

On new standby

=================

[oracle@ip-10-0-1-12 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 25 14:06:28 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name ,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

INDIA READ ONLY WITH APPLY

SQL>

SQL> select * from hr.abc;

ID NAME

---------- --------------------------------------------------

1 A

SQL> /

ID NAME

---------- --------------------------------------------------

2 From standby after primary

1 A

SQL>

alert log

=================

Initiating a healthcheck...

05/25/2021 14:02:50

Forwarding CTL_SWITCH operation to member india for processing

Updated broker configuration file available, loading from "/u01/app/oracle/product/12.2.0/dbhome_1/dbs/dr2india_stby.dat"

05/25/2021 14:02:51

Switchover processing to this database has started

Notifying Oracle Clusterware to prepare target standby database for switchover

05/25/2021 14:03:01

Updated broker configuration file available, loading from "/u01/app/oracle/product/12.2.0/dbhome_1/dbs/dr1india_stby.dat"

New primary database after switchover

Informing client: OPENING instance 'india_stby' of database 'india_stby'

Informing client: STARTUP instance 'india' of database 'india'

Switchover completed, notifying client

Proceeding with buildup after switchover...

Notifying Oracle Clusterware to buildup the primary database after switchover

Opening database after Switchover

05/25/2021 14:03:04

Evaluating archivelog destinations for switchover

SWITCHOVER TO india_stby completed successfully, new primary database is india_stby

Tuesday, May 18, 2021

Oracle Trace File Analyzer (TFA)

Oracle Trace File Analyzer (TFA)

Oracle Trace File Analyzer helps you perform real-time health monitoring, fault detection & diagnosis via a single interface. It will securely consolidate all distributed diagnostic data.

[oracle@ip-10.1.1.1.1 bin]$ ps -ef|grep tfa

root 687 1 0 05:50 ? 00:00:00 /bin/sh /etc/init.d/init.tfa run >/dev/null 2>&1 </dev/null

root 837 1 0 05:50 ? 00:00:16 /u01/app/oracle/tfa/ip-10.1.1.1.1/tfa_home/jre/bin/java -Xms128m -Xmx512m oracle.rat.tfa.TFAMain /u01/app/oracle/tfa/ip-10.1.1.1.1/tfa_home

oracle 22559 8133 0 07:05 pts/2 00:00:00 grep --color=auto tfa

[oracle@ip-10.1.1.1.1 bin]$ cd /u01/app/oracle/tfa

[root@ip-10.1.1.1.1 bin]#

[root@ip-10.1.1.1.1 bin]# ./tfactl status

.---------------------------------------------------------------------------------------------------.

+--------------+---------------+-----+-------+------------+----------------------+------------------+

| ip-10.1.1.1.1 | RUNNING | 837 | 31183 | 12.2.1.0.0 | 12210020161122170355 | COMPLETE |

'--------------+---------------+-----+-------+------------+----------------------+------------------'

[root@ip-10.1.1.1.1 bin]#

[root@ip-10.1.1.1.1 bin]# ./tfactl toolstatus

.----------------------------------------.

| External Support Tools |

+--------------+--------------+----------+

| Host | Tool | Status |

+--------------+--------------+----------+

| ip-10.1.1.1.1 | events | DEPLOYED |

| ip-10.1.1.1.1 | orachk | DEPLOYED |

| ip-10.1.1.1.1 | vi | DEPLOYED |

| ip-10.1.1.1.1 | dbglevel | DEPLOYED |

| ip-10.1.1.1.1 | exachk | DEPLOYED |

| ip-10.1.1.1.1 | managelogs | DEPLOYED |

| ip-10.1.1.1.1 | menu | DEPLOYED |

| ip-10.1.1.1.1 | changes | DEPLOYED |

| ip-10.1.1.1.1 | param | DEPLOYED |

| ip-10.1.1.1.1 | history | DEPLOYED |

| ip-10.1.1.1.1 | triage | DEPLOYED |

| ip-10.1.1.1.1 | calog | DEPLOYED |

| ip-10.1.1.1.1 | grep | DEPLOYED |

| ip-10.1.1.1.1 | summary | DEPLOYED |

| ip-10.1.1.1.1 | ls | DEPLOYED |

| ip-10.1.1.1.1 | srdc | DEPLOYED |

| ip-10.1.1.1.1 | pstack | DEPLOYED |

| ip-10.1.1.1.1 | tail | DEPLOYED |

| ip-10.1.1.1.1 | alertsummary | DEPLOYED |

| ip-10.1.1.1.1 | ps | DEPLOYED |

'--------------+--------------+----------'

[root@ip-10.1.1.1.1 bin]#

[root@ip-10.1.1.1.1 bin]# pwd

/u01/app/oracle/tfa/bin

[root@ip-10.1.1.1.1 bin]#

Saturday, May 8, 2021

Setup Data Guard Broker Configuration in Oracle Database

How to setup Data Guard Broker Configuration

=================================================

Primary database : india

Standby database : india_stby

Add static entry for the DGMGRL in the listener.ora on both the primary and standby servers

Standby listener.ora

================================

oracle@ip-10-0-1-37 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = india_stby)

(SID_NAME = india_stby)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

(SID_DESC =

(GLOBAL_DBNAME = india_dgmgrl)

(SID_NAME = india_stby)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

(SID_DESC =

(GLOBAL_DBNAME = india_stby_dgmgrl)

(SID_NAME = india_stby)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

[oracle@ip-10-0-1-37 admin]$

Primary listener.ora

==============================

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = india)

(SID_NAME = india)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

(SID_DESC =

(GLOBAL_DBNAME = india_dgmgrl)

(SID_NAME = india_stby)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

(SID_DESC =

(GLOBAL_DBNAME = india_stby_dgmgrl)

(SID_NAME = india_stby)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

ALTER SYSTEM SET dg_broker_start=true scope=both;

SQL>

SQL> ALTER SYSTEM SET dg_broker_start=true scope=both;

System altered.

SQL>

SQL> show parameter broker

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),

((TYPE=EMON)(BROKERS=1))

dg_broker_config_file1 string /u01/app/oracle/product/12.2.0

/dbhome_1/dbs/dr1india_stby.da

dg_broker_config_file2 string /u01/app/oracle/product/12.2.0

/dbhome_1/dbs/dr2india_stby.da

dg_broker_start boolean TRUE

use_dedicated_broker boolean FALSE

SQL>

on stanndby

==============

SQL> /

Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

1 29 29 0

SQL>

SQL> ALTER SYSTEM SET dg_broker_start=true scope=both;

System altered.

SQL>

SQL> show parameter broker

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),

((TYPE=EMON)(BROKERS=1))

dg_broker_config_file1 string /u01/app/oracle/product/12.2.0

/dbhome_1/dbs/dr1india_stby.da

dg_broker_config_file2 string /u01/app/oracle/product/12.2.0

/dbhome_1/dbs/dr2india_stby.da

dg_broker_start boolean TRUE

use_dedicated_broker boolean FALSE

SQL>

DGMGRL>

DGMGRL> create configuration 'india' as primary database is 'india' connect identifier is india;

Configuration "india" created with primary database "india"

DGMGRL>

DGMGRL> show configuration;

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

DGMGRL>

DGMGRL> add database 'india_stby' as connect identifier is india_stby maintained as physical;

Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

Failed.

DGMGRL>

DGMGRL> add database 'india_stby' as connect identifier is india_stby maintained as physical;

Database "india_stby" added

DGMGRL>

DGMGRL> show configuration

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

DGMGRL>

DGMGRL> enable configuration;

Enabled.

DGMGRL>

DGMGRL> show configuration

Configuration - india

Protection Mode: MaxPerformance

Members:

india - Primary database

india_stby - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 51 seconds ago)

DGMGRL>

DGMGRL> show database india InconsistentProperties

INCONSISTENT PROPERTIES

INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE

DGMGRL>

DGMGRL> show database india_stby InconsistentProperties

INCONSISTENT PROPERTIES

INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE

DGMGRL>

DGMGRL> show database india

Database - india

Role: PRIMARY

Intended State: TRANSPORT-ON

Instance(s):

india

Database Status:

SUCCESS

DGMGRL> show database india_stby

Database - india_stby

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):

india_stby

Database Status:

SUCCESS

DGMGRL>

DGMGRL> show database india_stby statusreport

STATUS REPORT

INSTANCE_NAME SEVERITY ERROR_TEXT

DGMGRL>

DGMGRL> show database india statusreport

STATUS REPORT

INSTANCE_NAME SEVERITY ERROR_TEXT

DGMGRL>