ba6.us - Dave's Database Related Stuff

On Oracle-L there was a recent discussion about detecting block corruption.

One suggestion was to do an Export to /dev/null. While this may get you 95% of the way there it is mainly relying on side effects of data access to detect any issues. If blocks are cached then it might not root out physical corruption. Read more »

So I've got a backup script that runs a BACKUP DATABASE followed by a BACKUP ARCHIVELOG command. The BACKUP ARCHIVELOG FROM TIME command runs to collect all the archived logs created since the beginning of the Level 0. Read more »

So I've mentioned before about the replication product that we use that is based on Archived Redo Logs. Well sometimes the replication process abends before the RMAN backup. Since there is no communication between the two processes, RMAN happily removes archived logs that the replication process might need the next time it starts up.

Because of this we usually like to keep a few hours worth of archived logs hanging around.

Does this suck up disk space? Yes.
Is it worth it sacrifice some disk space in order to save us some DBA time? Absolutely. Read more »

So I took my first hands-on class from Oracle this month.

I'm usually of the 'sit down with a book and computer' camp when I need to learn something new, but where I work we needed RMAN proficiency quickly. I thought it might be better to get out of the office for a few days and buckle down on the topic. Read more »