Re: Incomplete recovery question again

Thanks for the reply!

Q> How did you create the new controlfile?

It was from the original database AFTER the files were put into backup with an

ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Q >Which version are you on?

9.2.0.4

Q> I suspect you didn't put temp files into backup mode when you copied

   them - does v$datafile_header show them as fuzzy?

Yup. Fuzzy.
SQL> select tablespace_name, status, fuzzy from v$datafile_header   2 where tablespace_name='TEMP';

TABLESPACE_NAME                STATUS  FUZ
------------------------------ ------- ---
TEMP                           ONLINE  YES
TEMP                           ONLINE  YES
TEMP                           ONLINE  YES
TEMP                           ONLINE  YES
TEMP                           ONLINE  YES
TEMP                           ONLINE  YES

6 rows selected.

Q> I'm wondering if you have created your temp tablespace "correctly." See Note:160426.1

You mean the original ones or the ones on the backup? The cold backup recovery
works fine but then again the database is down...

Q> Is anything in v$tempfile?

SQL> select count(*) from v$tempfile;

  COUNT(*)

         0

Q> Is there an ADD TEMPFILE when you backup controlfile to trace?

No. It has the 'old' datafiles listed.

So.... can I drop the temporary tablespace and recreate it? Will the database then come up?

Again, thanks for your help.
Vince Received on Thu Oct 25 2007 - 13:28:56 CDT