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

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: 
  INET: Paula_Stankus_at_doh.state.fl.us

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).