- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Real World Oracle Database Backup and Recovery
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
тАО05-15-2007 10:44 AM
тАО05-15-2007 10:44 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2007 11:01 AM
тАО05-15-2007 11:01 AM
Solution1) Shutdown the database.
2) Using OnlineJFS snapof= mounts, create snapshots of your Oracle filesystems. (This takes only seconds regardless of the the size of the filesyetm.)
3) Restart the database.
4) Backup the snapshot mounts.
5) Umount the snapshots.
Total downtime ~ 2 minutes.
You get almost all the uptime of a hot backup combined with the safety of a cold backup.
In Windows, this same technique can be done using the Open File Manager or Volume Shadow Services.
Finally, you should never have to use Ignite to bring you back up from a disk failure because all your OS disks should be mirrored. Disk replacements are then done "on the fly". I have not shutdown a box to replace a disk in something like 10 years although I have replaced many tens of disks during that period. Of course, you should still make your Ignite images because Ignite protects you from your own stupidity (e.g. rm -r *).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2007 11:18 AM
тАО05-15-2007 11:18 AM
Re: Real World Oracle Database Backup and Recovery
Getting back to Oracle DBs, where can I get more information on the OnlineJFS steps? I am not familiar with OnlineJFS other than it allows you to extend your file systems without having to do a umount. Is there a cheat sheet on the snapof=?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2007 11:39 AM
тАО05-15-2007 11:39 AM
Re: Real World Oracle Database Backup and Recovery
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1019274
Typically, you choose a snapshot buffer device something like .15 the size of the original filesystem. That should suffice for all but the most active database applications. "Active" in this context means many inserts, updates, and deletes. Selects don't matter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2007 08:35 PM
тАО05-15-2007 08:35 PM
Re: Real World Oracle Database Backup and Recovery
I recommend using 2 strategies simultaneously:
- Cold backups (Oracle DB shutdown immediate)
- Hot backups with rman (requires DB in archivelog mode)
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2007 08:45 PM
тАО05-15-2007 08:45 PM
Re: Real World Oracle Database Backup and Recovery
Concerning your Oracle database DATA, I would recommend doing HOT RMAN disk backup. (level 0 then level 1 with Incremental Merge option). The disk backup files you can afterwards move to secondary media.
With Oracle 10g, it is much easier and it has more options that you can use to verify that the backup is OK.
If you need any further clarifications, please let us know.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 06:24 AM
тАО05-16-2007 06:24 AM