file..

[navin]

Hello,
I have to restore a file for a oracle db..but found that file is not backed up...is there any reason from OS system side ..that i can retrive the file for a particular date.I know it is impossible ....but if you can please help
Thanks

[James R. Ferguson]

Hi Navin:

You are SOL [stuck-out-of-luck]. If you don't have a backup of the file, how can you retrieve it? Unix doesn't provide a recycle bin. Unix does exactly (and only) what it is told! At best, you can create an empty file.

Regards!

...JRF...

[A. Clay Stephenson]

This says it all:

I know it is impossible .

You are correct.

This is often the case with how backups are structured. The best backups are those which backup everything except what I specifically exclude. The worst backups are those in which I explicitly list the files to be backed up because it is so easy to miss something when someone such as the DBA makes a change.

[J. Bravo]

Hello:

It's not possible.

Regards;

J. Bravo.

[Tim Nelson]

I concur will everone above.

HPUX has no file archiving feature ( there are probably ways to acheive this via 3rd party app)

Built in features like this are available on other OSs, VMS for example has versioning control, But if all the version of a file are deleted then there is still no recycle bin.

[Geoff Wild]

That depends - do you ignite this server?

If yes, then what vg's do you take ignite backups of?

If the file is in the vg(s) that ignite does, then you might be able to retrieve it.

Otherwise...the file is gone forever...unless you have a lot of money and no changes have been made to the system since the file was deleted (if that's what happened to it).

When a file is deleted, the pointer to where it is on disk is removed - but the file is still there on the disk - until the next time another file is written...there are company's out there that can restore files that were deleted...but if the space on the disk has been used again - then it is truly gone....

Rgds...Geoff