RMAN Gotcha (Got me anyway)

From: Taylor, Chris David <Chris.Taylor_at_ingrambarge.com>
Date: Tue, 16 Sep 2008 10:50:41 -0500
Message-ID: <17E4CDE8F84DC44A992E8C00767402E086176E@spobmexc02.adprod.directory>

We have a Production database and an online Auxiliary copy database.  

I recently changed the UNDO tablespace in our production database, without renaming the UNDO tablespace in the auxiliary database. Suddenly our RMAN duplicate commands starting failing with "Incorrect Function" errors.  

Checking the Logfile of the auxiliary database yielded the answer about being unable to find the "UNDOTBS1" - instance terminated.  

It makes sense when I found it, but I didn't think about it ahead of time. Of course our auxiliary database is used for daily reporting purposes so we had several end-users yelling about not being able to generate reports till we determined the problem.  

So just thought I'd pass that along if you ever run into this.      

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com  

Received on Tue Sep 16 2008 - 10:50:41 CDT

Original text of this message