| ALTER DATABASE CREATE DATAFILE [message #60554] |
Sun, 15 February 2004 06:38 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
