The below SQL reports on the space usage by table space along with details on each data file. Additionally, it identifies if a physical standby exists. Continue reading “SQL to check space issues”
Category: Databases
Checking the status of RMAN backups
I find the below SQL useful when I want to check when
- the last backup ran
- how long the backup takes
ORA-17629: Cannot connect to the remote database server on resync catalog from a physical standby database
On the standby database we were getting the below error. Both the primary and standby are 4 node RACs.