topic Re: restore specific file from DAT. in Operating System - HP-UX

restore specific file from DAT.

mehul_3 — Tue, 09 Nov 2004 00:25:57 GMT

Hi,
My oracle database was crashed sometimes ago and I wanted to restore only corrupted datafile from my full database backup rather than full database backup.
I generally used the following backup methodology for full database backup:
fbackup -v -f /dev/rmt/0m -i /u01/gdbs -i /u02/gdbs -i /u03/gdbs.
and I used the following command to restore:
frecover -f /dev/rmt/0m -r -o
but I wanted to restore only single datafile from that backup namely u01/gdbs/systemfiles/user101.dbf.

Mehul

Re: restore specific file from DAT.

jam_1 — Tue, 09 Nov 2004 00:50:52 GMT

Hi Mehul,
Normally all datafiles of Oracle DB will be syncronised and hence restoring single datafile will not be useful and it will not work.Use Oracle Rman to enble you that way.
-Bonny

Re: restore specific file from DAT.

Sunil Sharma_1 — Tue, 09 Nov 2004 01:09:48 GMT

Hi Mehul,

You can restore single file from fbackuped data using -i option with frecover. -i stand for interactive mode. But as per my understanding about oracle is that after restoration single data file from Full backup will not work if you used/mounted your dataabse after full backup.

Sunil

Re: restore specific file from DAT.

mehul_3 — Tue, 09 Nov 2004 02:00:23 GMT

Hi bony,
Whatever you have explained is undoubtly correrct but my single datafile was corrupted and I wanted to recover this datafile by restoring it only and recovering that datafile from archive redologfile.

million thanks in advacne.
Mehul

Re: restore specific file from DAT.

Sunil Sharma_1 — Tue, 09 Nov 2004 03:26:56 GMT

Hi Mehul,

use

frecover -Xxomv -f /dev/rmt/0m -i /u01/gdbs/systemfiles/user101.dbf

Sunil