Operating System - HP-UX
1748032 Members
4429 Online
108757 Solutions
New Discussion юеВ

Re: Restoration using frecover

 
SOLVED
Go to solution
mehul_3
Regular Advisor

Restoration using frecover

Hi
I takes daily online backup from disk to disk and then to tape.
The oracle database files segregated across logical volumes u01,u02 and u03 and all backup files say datafiles including control file copies into logical volume u05 as a part of daily online backup and then copies back again to tape using fbackup.
Now, the question is that suppose I want to restore all datafiles and controlfile from DAT directly to respective location under u01,u02 and u03 using frecover in case of database crash
E.g say I copies all datafiles and control file in DAT under u05 using fbackup -v -f /dev/rmt/0m -i /u05 and want to copy back again to respective location from DAT under u01, u02 and u03 volumes in which oracle database resides.
In summary, which switch should I use in frecover

Waiting for reply
Mehul
9 REPLIES 9
Indira Aramandla
Honored Contributor

Re: Restoration using frecover

Hi Mehul,

You can use -r option of frecover. Refer to man pages of frecover for more details.

As you had mentioned that you do a didk-didk forst and then to tape backup, then in case of database crach, you can restore form the disk, provided you known which datafiles are in which path u01, u02.....

And if your bacup is on-line backup, then you will require to aplly the archive logs to recover data to a consistent point in time.


Indira A
Never give up, Keep Trying
mehul_3
Regular Advisor

Re: Restoration using frecover

Take the point in another way.Suppose oracle datafile say user01.dbf and system.dbf copies under uo5 directory and copies back to DAT.I want to restore user01.dbf under u01 and system.dbf under u02 directories from DAT.
Applying archive log after restoration of online backup is the known thing to me.

Pl. help me in this regard

Rgds,
Mehul
Eric Antunes
Honored Contributor

Re: Restoration using frecover

Hi mehul,

" want to restore user01.dbf under u01 and system.dbf under u02 directories from DAT."

With the database down, do:

$cd /u01
$mv system.dbf system.dbf.BAK
$tar xvf /dev/rmt/0m
$mv system.dbf /u02
$mv system.dbf.BAK system.dbf

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Restoration using frecover

Instead of tar, use frecover...
Each and every day is a good day to learn.
mehul_3
Regular Advisor

Re: Restoration using frecover

I want to restore it under u01 and u02 using frecover directly from TAPE.

Rgds
Mehul
Eric Antunes
Honored Contributor

Re: Restoration using frecover

Hi mehul,

It depends of the fbackup command you used to do the backup but "frecover -r ..." should do this.

From the manual about -r:

"This option should only be used to recover a complete backup onto a clear directory or to recover an incremental backup after a full level-zero recovery."

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
James R. Ferguson
Acclaimed Contributor
Solution

Re: Restoration using frecover

Hi Mehul:

To recover files using 'frecover' into your current working directory do, for example:

# frecover -mov -f /dev/rmt/0m -Xxi /

Thus, it is the '-X' switch that arms this behavior. See the man pages for 'frecover'.

Regards!

...JRF...
mehul_3
Regular Advisor

Re: Restoration using frecover

i.e Should I give following command to recover files into u01 and u02 volume
# frecover -mov -f /dev/rmt/0m -Xx -i /u01/user01.dbf ├в i /u02/system.dbf.
Sorry for trouble once again but help me as it is very important task for me.

Rgds,
Mehul
Eric Antunes
Honored Contributor

Re: Restoration using frecover

Hi mehul,

I think it will be:

#frecover -mov -f /dev/rmt/0m -Xx -i /u01/user01.dbf -i /u02/system.dbf

BUT, to be sure things doesn't get worse (before recovery with archivelog you should ALWAYS backup the database files as they are with the database down), backup those directories to another tape:

#cd /
#tar cvf /dev/rmt/0m u01 u02 -- make sure both directories are backed up

Best Regards,

Eric Antunes
Each and every day is a good day to learn.