Tag Archive: RMAN

OTN Appreciation Day: Oracle RMAN

My favorite feature to date has to be Oracle RMAN (Recovery Manager).  Why?  Well I really believe that at the end of the day the most important job of the DBA (and there are many!) is to ensure that the data is protected.  If you lose an organization’s data not only will you most likely lose your job but you could potentially cause some serious financial issues (not to mention bad reputation) for that organization. I may have a different appreciation for RMAN than those who may have not had an opportunity to work with the Oracle database prior to…
Read more

RMAN Duplicate Error with ASM and 4k Sector Size Disk

The Problem I recently ran into an issue when performing a RMAN duplicate on a server with a fresh installation of OEL 6.4 x86-64 using a brand new SAN (NetApp Data ONTAP 8.2).  The database version is Enterprise Edition 11.2.0.3. The datafiles restored without an issue but when we got to those archived redo logs I hit an ORA-00600.  Specifically it was this error. At first I chalked it up as a fluke, so I tried the RMAN duplicate again.  Well the datafiles restored just fine but once again when I got to the archived redo logs I hit the ORA-00600…
Read more