🔶 Oracle
(2 posts)
Oracle database administration tips, queries, and troubleshooting notes.
📅 2022-01-06
✍️ Bart Schelstraete
Mapping Oracle ASM disks to physical disks can be done using the /etc/init.d/oracleasm command: # /etc/init.d/oracleasm querydisk -p ASMDISK1 This will result in something like this: Disk "ASMDISK1"…
Read more →
📅 2019-04-29
✍️ Bart Schelstraete
Step 1: If block corruption was found, first find the corrupted blocks: SQL> select * from V$DATABASE_BLOCK_CORRUPTION; FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO CON_ID ---------- ----------…
Read more →