rman

RMAN to /dev/null?

Submitted by dave on Tue, 08/11/2009 - 12:46

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.

Tags: 
rman
corruption

More stupid RMAN tricks: ORA-01843 From RMAN

Submitted by dave on Mon, 06/09/2008 - 14:40

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: 
oracle
rman

Stupid RMAN tricks...

Submitted by dave on Wed, 11/14/2007 - 18:03

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: 
oracle
rman

Oracle9i Database: Advanced Backup and Recovery Using RMAN

Submitted by dave on Fri, 07/20/2007 - 16:01

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.

Tags: 
oracle
rman
university
Subscribe to rman