- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Restoration using frecover
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 04:21 PM
тАО11-16-2005 04:21 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 07:20 PM
тАО11-16-2005 07:20 PM
Re: Restoration using frecover
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 08:41 PM
тАО11-16-2005 08:41 PM
Re: Restoration using frecover
Applying archive log after restoration of online backup is the known thing to me.
Pl. help me in this regard
Rgds,
Mehul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 10:11 PM
тАО11-16-2005 10:11 PM
Re: Restoration using frecover
" 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 10:12 PM
тАО11-16-2005 10:12 PM
Re: Restoration using frecover
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 10:31 PM
тАО11-16-2005 10:31 PM
Re: Restoration using frecover
Rgds
Mehul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 11:06 PM
тАО11-16-2005 11:06 PM
Re: Restoration using frecover
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-16-2005 11:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 08:03 PM
тАО11-17-2005 08:03 PM
Re: Restoration using frecover
# 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2005 08:37 PM
тАО11-17-2005 08:37 PM
Re: Restoration using frecover
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