🔶 Oracle (2 posts)

Oracle database administration tips, queries, and troubleshooting notes.

How to map ASM disks to physical disks in Oracle

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 →

How to solve block corruption in Oracle

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 →