How to check the connectivity between primary and standby database
From DR/STANDBY:
C:\Users\Administrator>sqlplus sys@PRODORA1 as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 09:22:14 2022
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select database_role from v$database;
DATABASE_ROLE
-----------------
PRIMARY
SQL>
From MAIN/PRIMARY:
C:\Users\Administrator>sqlplus sys@PRODDR1 as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 09:22:14 2022
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select database_role from v$database;
DATABASE_ROLE
-----------------------------
PHYSICAL STANDBY
SQL>
No comments:
Post a Comment