rman (4)

Dave

Detecting RMAN block corruption - 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…

Dave

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. The BACKUP ARCHIVELOG FROM TIME command fails…

Dave

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…

Dave

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…