rman

RMAN to /dev/null?

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.

More stupid RMAN tricks: ORA-01843 From RMAN

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.
Tags: 

Stupid RMAN tricks...

So I have mentioned before about the replication product that we use that is based on Archived Redo Logs (Golden Gate). 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.
Tags: 

Oracle9i Database: Advanced Backup and Recovery Using RMAN

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.

Subscribe to rman