Re: Datafile not available.

Yuji Shimono wrote:
>
> I had to recover a database from a backup. After recovery I had to do a
> resetlogs in order to open the database. Apparently, one of the
> datafiles was offline at the time the resetlogs was done. When I try to
> bring that database online, I get the error that the datafile is from
> before the last resetlogs and to restore a current copy of the
> datafile. I don't have a more recent copy since it never got reset.
> This datafile is in a temporary tablespace which contains another
> datafile which is okay. Is there a way to recover the datafile or can I
> drop the tablespace and recreate it again using the same names?

Since it is only a temp tablespace and you are sure that there isn't anything on it but only used for temp segments then why bother to recover it ? ... I guess drop and recreate would be the quickest option...

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================