Production and standby database- Real time Queries and Scripts:
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>…
View On WordPress















