#productiondatabase

Production and standby database- Real time Queries and Scripts:

Below are basic SQL commands and scripts to check whether database is production or standby and whether production & standby database are in sync.

1.Query to check database is production or standby:

SQL> select database_role from v$database;

DATABASE_ROLE

PRIMARY

2.Scripts to check archivelog gap in production and standby:

Execute the below query on the Primary database

SQL>…