-
Hai everybody
In my database,a datafile is corrupted.I have no
backup for that,So i made offline drop that datafile.
I added a new datafile to that tablespace now.When i create
the tables in the tablespace an error comes 'file 6 cannot be read at this time' .That it is indicating the dropped datafile.How to remove the entry from the controlfile
permanently.Not possible to shutdown the db and recreate the
controlfile.
Thanks in advance.
-
you cannot do that
you have to drop entire tablespace
you will lose data
but that's only way
-
IF database is in archivelog, and you have all the archivelog since the ddatafile is created, you can recover it.Though it seems hard to keep all the archivelog since the datafile creation.
www.cnoug.org
-
another solution to try to save as much data as possible:
find out the segments that have extents in that datafile.
export other tables that does not have extents in the datafile first.
and then use rowid to extract records from the tables that have extents in the datafile.
www.cnoug.org
-
1 shutdown the datebase
2 startup mount
3 alter database datafile '/disk2/data/db2.dbf' offline
4 alter database open
Because you did have the backup of the datafile corrupted.I can not ensure you can recovery the data loss.
-
Originally posted by wengyan
1 shutdown the datebase
2 startup mount
3 alter database datafile '/disk2/data/db2.dbf' offline
4 alter database open
Because you did have the backup of the datafile corrupted.I can not ensure you can recovery the data loss.
you can do that if you are in archive log otherwise not
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|