Re: Archive logs....do they create data files

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Sun, 12 Apr 1998 21:59:00 GMT
Message-ID: <353138d5.12595961@www.sigov.si>

On Sat, 11 Apr 1998 15:35:01 -0700, ngreene_at_NULL.capgemini.com (Neil Greene) wrote:

>All of the books I am reading from Oracle Press explicitly say the
>datafiles ARE created. However, I have also seen situations that would
>not automatically create the datafile.
>
>Now that we have some different thoughts, can anyone confirm?

Interesting. Which Oracle Press book explicitely says so? In Velpuri's "Backup & Recovery Handbook" one of the case studies covers exactly the same situation and explicitely says you must create the file manualy (Case 12: Creating Data Files - note that this is the first edition of his book, covers Oracle up to 7.2, so the case number might be different in later editions).

I tried your scenario myself. Added new datafile to one of the tablespaces. Dropped the new file. Restored the database from the backup prior to this new datafile creation. Tried to recover the database, recovery process ended with the following error messages:

ORA-00283: Recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to controlfile by media recovery
ORA-01110: data file 7: '<the_name_of_the_newly_added_datafile>'

So the roll-forward process added the file to the controlfile, but the file itself was not created .

>--
>Neil Greene
>Principal Consultant
>Cap Gemini America
>Email:<mailto:ngreene_at_moonlight.wdc.com>

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Apr 12 1998 - 16:59:00 CDT