RE: HELP URGENT RMAN FAILS - FILE?????

Paula - I don't see where anyone replied, so . . . In Oracle 8i, backing up the control file with RMAN and then recovering that control file is a dicey business. I recall that part of the problem is the point in the backup the control file is backed, maybe not after the file backups. Anyway, I gave up on that backup and just issue a separate statement after the RMAN backup. I think in 9i this is much better and maybe RMAN backs the control file up automatically. I think Robert Freeman's book has information about this, but my copy is at work. I know, I know, I should have two copies, right? Sorry this isn't much help, hopefully you've made more progress by now.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, May 30, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L

methinks resync - could I be write? I had taken a tablespace offline and had not resynched with catalog - kind of makes sense.

-----Original Message-----
Sent: Friday, May 30, 2003 5:34 PM
To: 'ORACLE-L_at_fatcity.com'

Guys,

Running Oracle 8.1.7
RMAN with automated backups - no problem Wish to recover
recovered controlfile from backup then issued following:                                              

MAN> run {execute script alloc_all_tapes;
> restore database;
> recover database noredo;
> execute script rel_all_tapes;}
                                             

It failed with:

RMAN-03002: failure during compilation of command                    
RMAN-03013: command type: restore                                    
RMAN-03002: failure during compilation of command                    
RMAN-03013: command type: IRESTORE                                   
RMAN-06026: some targets not found - aborting restore                
RMAN-06023: no backup or copy of datafile 173 found to restore       
                                                                     

Yet, when I query the target database mounted and look for

  1* select file#,ts#,status,name from v$datafile       
SQL> i                                                  
  2  where file#=173;                                   
                                                        
no rows selected                                        
                                                        

MAKES NO SENSE AT ALL!!! WHERE IS IT COMING FROM WITH FILE#173 - IF THE MOUNTED TARGET DATABASE DOESN'T LIST 173 FROM V$DATAFILE OR V$RECOVER_FILE!!!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).