SYSAUX corruption and restore

SYSAUX corruption and restore

On one of my databases, the SYSAUX tablespace has been corrupted. SYSAUX was introduced in 10g to store all auxiliary database metadata related to Oracle options and features. This is a mandatory tablespace and cannot be dropped. Therefore it is important to have all objects in this tablespace accessible at all times. Here is the… Continue Reading SYSAUX corruption and restore

At-risk schema separation

At-risk schema separation

Not long ago, we launched a fairly large operation on one of our oracle databases. It was necessary to logically separate two schemas that were extremely nested. The intervention itself goes well but the next morning (during the ramp-up) we receive many alerts concerning the number of Oracle processes. Indeed, instead of consuming 1000 (approximately),… Continue Reading At-risk schema separation