frecover and oracle tempfile

[accent]

Hi
I have one rp3440 with HP-UX 11iv1. I have one Ultrium 2-SCSI tape. I made one of oracle using fbackup. My database was stoped. The backup finished without problems but when I tried to restore, all my tempfiles (temporary tablespaces) had different size (around 300 Mb more).
Any knows why the restore file has bigger than the original???
Where are the problem, in the DLT (Ultrium), in the fbackup command,…?

[Steven E. Protter]

The database must be stopped at restore time as well.

You should run a test.

Shut the database.

backup with fbackup.

list the files on the tape and make sure the size on tape matches the size on the filesystem, prior to restarting the database.

SEP

[Hein van den Heuvel]

1) You did not indicate the exact Oracle version.
2) How did you detemine the size? ls -l or du?

More recent Oracle versions use SPARSE files for TEMP.

Backup tools will 'instantiate' the non-allocated blocks. Check 'man fbackup' it actually warns for that:

" If sparse files are backed up without using data compression, a very
large amount of media can be consumed."


hth,
Hein.

[Sยภเl Kย๓คг]

Shutdown the database
take backup using fbackup,see to that the driver which u are using is with no compression.Shutdown the database before u restore.
regards
SK