| alter database create datafile [message #60783] |
Thu, 04 March 2004 23:19  |
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
|
|
|
|
| Re: alter database create datafile [message #60792 is a reply to message #60783] |
Sat, 06 March 2004 02:49  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You will be mounting using the restored(backup) controlfile, Creating the datafile , recover database using backup controlfile ( at this point ,the required online/archived redolog files will be applied) and after the Media recovery is complete(at this point your archivelogs will not be needed anymore) , open the database resetlogs.
You will then need to take a cold or hot backup of all the files asap.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
