- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Hot backups with fbackup
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
тАО07-22-2002 08:48 AM
тАО07-22-2002 08:48 AM
I found on Oracle Metallink that you cannot do a hot backup with fbackup because it loses inodes changes that occur during a backup.
Why do some of you tell me that fbackup is working for them while the Oracle datafiles are in backup mode?
Are your datafiles being accessed while your backup is running?
Thanks,
Dewy
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2002 08:57 AM
тАО07-22-2002 08:57 AM
Re: Hot backups with fbackup
HTH
Marty
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2002 09:06 AM
тАО07-22-2002 09:06 AM
Re: Hot backups with fbackup
AFAIK once the datafiles are in backup mode you can do the backup of these files with whatever tool: cp, dd, fbackup, ...
Could you write down the link within Metalink?
Best regards,
Juan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2002 09:10 AM
тАО07-22-2002 09:10 AM
Re: Hot backups with fbackup
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2002 04:00 AM
тАО07-23-2002 04:00 AM
Re: Hot backups with fbackup
I have been using fbackup for about 5 years from Oracle 7.3.x to 8.1.6. I have also successfully recovered databases using fbackup tapes.
We do things alittle differently in that I put the tablespace into hotbackup and copy and compress the datafiles to another volumne. That volume is copied with fbackup.
When a tablespace is placed into hot backup mode, it is basically frozen and all updates that dbwr would send to the datafiles are sent to the redo log files instead. This keeps the datafile from changing. Should you try to backup a file without it being in hot backup mode, then you are correct you will get a corrupt backup. (I've done it).
The reason we do ours during low activity is that you are filling your redo logs more quickly in hot backup mode because more information go into to them.
From my notes on the backup and recovery workshop (which I highly recommend. It's one of the best oracle classes ever) Pages 4-16 and 17....
1. Put tablespace into backup mode
alter tablespace yourspacehere begin backup;
2. In unix,
cp /users/disk1/users01.dbf /users/backup/user01.dbf
3. alter tablespace yourspacehere end backup;
4. force a checkpoint to synchronize all of the headers with
alter system switch logfile;
I like the disk to disk copy because it's faster than disc to tape and I don't want the tablespaces in hot backup mode any longer than necessary. I also like to compress the file so I don't have to change tapes.
I'd like to see the metalink doc id too.
Oracle has made some improvements to RMAN under 9i and I plan to look into that more and possibly give up my fbackup scheme.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2002 04:29 AM
тАО07-23-2002 04:29 AM
Re: Hot backups with fbackup
The best way is to use Oracle Recovery Manager (RMAN). Do your backups to disk then use fbackup if you wish to sent the files to tape.
RMAN has lots of parameters that you may wish to customise for your own environment.
RMAN is the future in Oracle Backup.
We do only hot backups using RMAN.
Hope this helps!
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2002 04:38 AM
тАО07-23-2002 04:38 AM
Re: Hot backups with fbackup
I've done some research and I find in Metalink what Dewy said:
Literally from Metalink:
**Can't HOT backup - fbackup loses inodes changes that occur during a backup
frecover -s causes sparse files causes paging for >1GB files
I understand the problem with frecover -s. Oracle datafiles can't be sparse files. Speaking quickly, a sparse file is a file where unused blocks doesn't use space on the filesystem, just a mark on the inode.
And from fbackup(1M):
Due to present file-system limitations, files whose inode data, but not their contents, are modified while a backup is in progress might be omitted from the next incremental backup of the same graph. Also, fbackup does not reset the inode change times of files to their original values.
I am not sure how this can affect the fbackup of the datafiles. When a datafile is turned on backup mode, Oracle still access the datafile, I supossed that only to read, so the inode has to be changed to reflect the change in the access time field. I don't know whether other field in the inode is changed.
fbackup first read the inode information and then the file's content, but i don't why is this a problem with a hot backup...
Indeed, I find more information about fbackup of datafiles, mostly from forums, and some of them afirm that they have no problems with fbackup.
Fortunately I use rman :-)
Best regards,
Juan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2002 04:43 AM
тАО07-23-2002 04:43 AM
Re: Hot backups with fbackup
It is the freezing of the file headers that is the key to the hot backup mechanism. When restoring, the archive logs are applied from the start of the backup, leaving the restored file in a consistent state.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2002 05:57 AM
тАО07-23-2002 05:57 AM
Re: Hot backups with fbackup
Best regards
Juan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-23-2002 07:28 AM
тАО07-23-2002 07:28 AM
Re: Hot backups with fbackup
Regards
SMF