restore specific file from DAT.

[mehul_3]

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

[jam_1]

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

[Sunil Sharma_1]

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

[mehul_3]

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

[Sunil Sharma_1 · Accepted solution]

Hi Mehul,

use

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

Sunil