#oraclescripts

Resolving Tablespace alerts- with real time example

An Oracle database consists of one or more logical storage units called Tablespaces, which collectively store all of the database’s data.Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.

For example, the simplest Oracle database would have one tablespace and one…

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>…