Operating System - HP-UX
1824976 Members
3769 Online
109678 Solutions
New Discussion юеВ

How can i restore backup taken by fbackup utility?

 
YOGI_3
Frequent Advisor

How can i restore backup taken by fbackup utility?

hello all,
How can i restore backup taken by fbackup utility?
pl read below..
i m taking oracle database bkup..
1) original oracle files are on say /dbbkp
2) i m taking 1st on one mntpoint say /dbone
3) after that i am zipping it
4) after zipping am taking backup on tape.
5) now query is-- if i want to restore this backup directly on /dbbkp ..what is the exact steps i have to follow...
Backup commnad use---
fbackup -v -I /var/tmp/index -g gfile -f /dev/rmt/0mn

thanks,
yogesh
There is never a wrong time to do the right things
5 REPLIES 5
harry d brown jr
Honored Contributor

Re: How can i restore backup taken by fbackup utility?

man frestore

QUESTIONS:

(1) is your Oracle DataBase OFFLINE when you back it up?

(2) what does this mean: """2) i m taking 1st on one mntpoint say /dbone"""

(3) How are you zipping it?

(4) Does /dbbkp have enough space on it to:
--a- restore a zipped file ?
--b- unzip it ?


live free or die
harry d brown jr
Live Free or Die
Steven E. Protter
Exalted Contributor

Re: How can i restore backup taken by fbackup utility?

Just use frecover to recover all of the files.

Or use sam to read the tape under backup and recovery, restore the files anywhere you want. You can directly restore to the backup directory, depending on how you took the backup.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Paul_481
Respected Contributor

Re: How can i restore backup taken by fbackup utility?

Hi YOGI,

#cd /dbbkup
#frecover -f /dev/rmt/0mn -vFx -g gfile

The -F option indicates that you will restore it without the leading directories on /dbbkup.

Regards,
Paul
Binu_2
Advisor

Re: How can i restore backup taken by fbackup utility?

Hi
Since you are Zipping the files and backing it up, you will have to do the reverse way around like
Extract--->Unzip-->Move

Extract using the -x option

frecover -xrv -I /var/tmp/index -g gfile -f /dev/rmt/0mn


-r The backup media is read and the contents are loaded into
the directories from which they were backed up. 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

-x The files identified by the -i, -e, and -g options (see
below) are extracted or not extracted from the backup
media. If a file to be extracted matches a directory
whose contents have been written to the backup media, and
the -h option is not specified, the directory is
recursively extracted. The owner, modification time, and
access control list (including optional entries, unless
the -A option is specified) are recovered. If no file
argument is given (including an empty graph file), all
files on the backup media are extracted, unless the -h
option is specified.

Thanks
Binu
harry d brown jr
Honored Contributor

Re: How can i restore backup taken by fbackup utility?

Just a note: If your Database is NOT offline or in HOT BACKUP mode then your backups are garbage/useless/unusable/trash/%@#*.

live free or die
harry d brown jr
Live Free or Die