Recovery problem

[Marcel Kooyman_1]

System: rp3440-4
Tape: Ulrium 2

IOV_INDEX.DBF (+/- 18Gb), using SAM, unrecoverable. See notes below.
Does somebody have info about max.filesize to recover or how to recovery this fletype?
Thanks,
Marcel.

/var/tmp/index:
18815655936 1 /u02/oradata/IBS/IOV_INDEX.DBF

Starting recovery:
-rw-r--r-- 1 root sys 17454748672 Jul 22 10:17 AAAa06005

frecover(1059): File /u02/oradata/IBS/IOV_INDEX.DBF found, but active/unrecoverable during this retry
-rw-rw-rw- oracle dba /u02/oradata/IBS/IOV_INDEX.DBF

[Joseph Loo]

hi,

it seems the file may be corrupted in the tape or u may be overwriting the file when it may be in use.

may i know what options u use to frecover? u may also like to use -N to verify the backup media contents.

regards.

[Gavin Clarke]

I'm going to suggest some really basic things here, which you've probably already tried, it will get things started I hope.

Is the database running? If it is then that file may well be active, in which case I would try restoring to somewhere else if you have space, just to check whether the database is stoppping the restore.

SAM is using frecover so it's probably worth doing man fbackup, man frecover and searching the forum for frecover type stuff.

[Gavin Clarke]

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=194250&admit=-682735245+1122286289016+28353475

This thread mentions a patch and a 4GB limit, perhaps that might help?