frecover problems

[Declan Heerey]

I am using a DLT7000 to backup 35Gb of data on a HP-UX K750 running UX11. When i try to recover from the tapes the latter half of the data will not restore. If i index the tape the media shows that everything has been backed up but the data will not restore. The problem seems to occur when trying to recover data backed up after the following error message appears in the fbackup log - fbackup(1102): WARNING: unable to stat file has anyone else had this (or a similar problem)??? Any help greatful...

[Stefan Farrelly]

It sounds like some of the files you are backing up are still in use by some process or other when you actually do the backup, and as a result their checksums are not correct on tape and you cant restore them.

Are you absolutely sure no-one/no process is accessing these files when the backup runs ?

[Declan Heerey]

Stefan,

I see what you mean but I am trying to recover database files which are not in use at the time of backup because the databases are offline! For instance i can restore:-

/DB_04/oracle/PPIP/index201_PPIP.dbf

But none of:-

/DB_05
/DB_05/lost+found
/DB_05/oracle
/DB_05/oracle/DBUP
/DB_05/oracle/DBUP/ctrl03_DBUP.dbf
/DB_05/oracle/DBUP/temp01_DBUP.dbf
/DB_05/oracle/DBUP/tools01_DBUP.dbf
/DB_05/oracle/DBUP/users01_DBUP.dbf

[T G Manikandan]

Hello,

I assume that these files were present when the list of files were prepared for backup and
when the backup really started it could not find the files they were gone.
That is the reason it tells unable to stat.

Thanks
G Manikandan

[Declan Heerey]

I'd be happy if that were the case, unfortunately these files exist at time of backup listing at time of backup and post backup. There is no stat message for the files I am trying to recover!

[harry d brown jr]

If you got the message that about not being able to "stat" the file, then the file must have been open by some process.

Is the database down when you attempt the restore? Try doing a frecover displaying the file sizes.

frecover -r -Nv


live free or die
harry

[Declan Heerey]

I am going to run an frecover -r -Nv overnight and investigate whether the checksums are okay. Thanks for all the help!

[Ray Carlson]

I think your missing his point. During his backup he gets an message about a missing file and then the backup continues and finishes. During a recovery, files before the message are able to be recovered, but files after the message are not. I had a pro blem where I couldn't recover files that should have been near the end of the tape, but I attributed it to a bad DLT tape. I have also seen where I would get an error that was caused by a timeout by having a disk on the same channel as the DLT drive.i

[Steve Steel]

Hi

The disc where the files will not recover.

Is it NFS


Also. Note this.You parameters are important

frecover

1 What is written on my `fbackup' tape?

To read your tape you must always use the `frecover' command.

/etc/frecover -I - (break or control-c will pause the list)

This command will display the contents to the standard output.If the list is long, it may be better to save the index in a file.

/etc/frecover -I /tmp/index

The advantage of `fbackup' is that the index is written in the beginning of the tape. `frecover' does not scan the whole tape.

THUS . The index being there does not mean the files are

2 Restore a complete directory

/etc/frecover -xi/directory
/etc/frecover -x -i/directory1 -i/directory2

REMEMBER THIS

When restoring a directory, `frecover' will not overwrite an existing file, except if the -o option is used.


It may be nice to recover relative somewhere in a directory like /tmp/local.
To restore relative, you must go first to the directory with cd, and then use the X or F option.

cd /tmp/local; /etc/frecover -xvXi /directory
(with directory tree path )
cd /tmp/local; /etc/frecover -xvFi /directory
(without path, only files names)

3 Restore of a few files from archive.

cd /tmp/local;/etc/frecover -xvF -i/path1/filename1 -i/path2/filename2
The files will be restored under the local directory.

4 Restore of backup over network.

Restore from a remote DAT/DDS drive

/etc/frecover -xi/directory -f remote_name:/dev/rmt/0m

Remote restore with local DAT/DDS drive

remsh remote_name " /etc/frecover -xi/directory -f local_name:/dev/rmt/0m"


Steve Steel

[Declan Heerey]

Steve, frecover is fine, i know how to use the tool and the options associated with it - Ray has hit the nail on the head with his comments!!! I can't recover anything AFTER the stat error messages in my fbackup error log.

The discs are not NFS mounted!

[Michael Tully]

Hi,

About the only item that has not been looked at is patches. Have a look for the latest patches for 'fbackup/frecover', you just could find something there, that fixes your problem.

Cheers
~Michael~

[Gnananandhan]

When you do an fbackup, Ensure you have sufficient rights and ownership to access the file -whichever give "STAT FILE " error.
Ex: If you are backing up Oracle data, It will have the group as dba. So you have to ensure the particular user-id is added in the dba group too.

I am not sure abt this - You can try recovering files step by step( I mean one directory followed by the other). I beleive this will work.


Regards,
Gnana A.

[Steve Steel]

Hi


1)get
Patch Name: PHCO_25424

Patch Description: s700_800 11.00 cumulative fbackup(1M)/frecover(1M) patch

Handles some DLT7000 problems.


2)Extract the index and then attempt to reload a file from the end of the tape.


3)retry your recover.


Steve steel