The Oracle DBA wants to run Health Checks command with Health Monitor upon his database. With Oracle 12c/18c, these checks can be done on a regular basis daily/monthly: – DB Structure Integrity Check – CF Block Integrity Check – Data Block Integrity Check – Redo Integrity Check – Transaction Integrity Check – Undo Segment Integrity […]
Category: Troubleshooting
Unable to create audit trail file or Read-only file system
This morning, the Cloud Control and other applications are down. Hard for the customer :( but as an Oracle DBA I love problems in production so it’s a great day today! First, I tried to edit a file with vi but a swap error raised: “E297: Write error in swap file“ Another read-only error with […]
Flash Recovery Area (FRA)
Download Brave : Secure, Fast & Private Browser with Adblocker Sometimes the Flash Recovery Area (FRA) is full and the Oracle DBA wants to know what is it’s usage, size and the list of occupants (archives, RMAN backups pieces or image copies, flashback logs). To Enable or Disable the FRA, it’s in another post here. […]
Flashback table to before / Restore table
How can I restore a table to a before state in a Oracle pluggable database (PDB)? If Flashback is enabled, you will use this amazing feature and flaskback the table. From Oracle 12c you can also restore a table with RMAN Flashback table If the timeframe allows it and flashback enabled. Use the FLASHBACK TABLE statement […]
Resource is in UNKNOWN state and srvctl Cannot Start/Stop the Resource
An Oracle RAC Service is in UNKNOWN state on instance 1 and it is impossible to stop or start it with srvctl. crs_stat -u ora.DBName.My-ServiceName.DBName1.srv NAME=ora.DBName.My-ServiceName.DBName1.srv TYPE=application TARGET=ONLINE STATE=UNKNOWN on Host1 Solution: The UNKNOWN state can often be resolved by bringing the resource offline using crs_stop. If the resource is not in Unknown state: Use […]