Newbie: Want to get an export(or equivalant) or copy done on a broken oracle datafile
Posted on 2011-09-26
I have a problem with a datafile in my oracle database which runs on top of Linux. The problem is that when I try to copy or cat the 'sys01XXXX.dbf' file i get this error:
"cp: reading `/home2/sys01XXXX.dbf': Input/output error"
"cat: /home2/sys01XXXX.dbf: Input/output error"
The other 5 datfiles are ok; the system has been functioning ok for over a year with this underlying problem; I can do a full system export of the database. If possible, I don't want to have to drop everything and Import everything in again.
What I would like to achieve:
(i) Do some operation that would produce a good copy of the '/sys01XXXX.dbf' or a file that can be imported back into the database.
(ii) Transfer the other datafiles; log files; control files to a new system.
(iii) Import or copy the fixed 'sys01XXXX.dbf' into the database on the new system.
(iv) Start the database on the new system.
Any solutions that fit close to the above would be appreciated?
Rem: I am a newbie.