topic Recovery problem in Operating System - HP-UX

Recovery problem

Marcel Kooyman_1 — Mon, 25 Jul 2005 04:20:14 GMT

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

Re: Recovery problem

Joseph Loo — Mon, 25 Jul 2005 05:00:17 GMT

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.

Re: Recovery problem

Gavin Clarke — Mon, 25 Jul 2005 05:04:23 GMT

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.

Re: Recovery problem

Gavin Clarke — Mon, 25 Jul 2005 05:13:53 GMT

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?