OraFAQ Forum: General » alter database create datafile

Home » Other » General » alter database create datafile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter database create datafile [message #103750]

Thu, 04 March 2004 23:22

barwas
Messages: 19
Registered: October 2003

Junior Member

Hi.......

it is writen in documentation like this:
--------------------------------------------

If a datafile is damaged and no backup of the file is available, then you can still recover the datafile by ALTER DATABASE CTREAT DATAFILE statment if:

1- All archived log files written after the creation of the original datafile are available
2- The control file contains the name of the damaged file (that is, the control file is current, or is a backup taken after the damaged datafile was added to the database)
--------------------------------------------

the second condition socend part (or is a backup taken after the damaged datafile was added to the database) ok when you recovered a controlfile by a backup controlfile taken after a damaged datafile was added to database it will contain the damaged datafile name but how???? because when u recover a controlfile by a backup controlfile then u have to open DATABASE by RESETLOG option only so you will lose all old archived log information which are necessary to recreate a datafile then depend to documentation hos second condition second part will work?

thank you

Report message to a moderator

Previous Topic:	How to apply outer join condition for 'IN' operator
Next Topic:	About Partition an already created table with mass data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 28 06:02:40 CST 2025