- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle raw disk image backup and restore!!
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
тАО09-06-2009 11:32 PM
тАО09-06-2009 11:32 PM
Oracle raw disk image backup and restore!!
I have a shared volume group for Oracle RAC datafiles. I need to create a document which describes how to recover if the share volume group vg_rac disk is crashed.
How can we take the backup of Oracle rac raw disk image and restore it as a recovery process.?
Please suggest.
Thanks in advance.
Regards,
Amit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2009 03:46 AM
тАО09-07-2009 03:46 AM
Re: Oracle raw disk image backup and restore!!
To be safe, use rman to back up data oracle data on raw disk areas.
I've successfully ignited and restored idle oracle databases in raw disk areas, also software ag adabas databases in such files, but its tricky and unreliable and not supported.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2009 06:13 AM
тАО09-07-2009 06:13 AM
Re: Oracle raw disk image backup and restore!!
But I presume that the fact that you are running RAC means that you cannot bring down the database frequently.
So then RMAN is indeed the best solution. You can create online backups of your database, and fully restore them from scratch. Explaining the exact procedure is lengthy, but when you read the RMAN guide, and preferably create an RMAN backup script, you can schedule daily backups that allow you a point-in-time restore without too much effort.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2009 11:06 AM
тАО09-07-2009 11:06 AM
Re: Oracle raw disk image backup and restore!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2009 06:29 PM
тАО09-07-2009 06:29 PM
Re: Oracle raw disk image backup and restore!!
Thanks for your valuable suggestions.
Our customer is reluctant to use the Data protector. Also, i think we can't use RMAN if archivelog mode is off. We are taking care of this thing separately.
With due respect i would like to ask that "Can we still use RMAN for backing and restoring raw disk image and how?"
Please look at the steps what i am planning to do in case of failure: -
DOWNTIME scenario
=================
- Get a new disk
- Create VG,LV
- Export it to other RAC nodes
- Set desired permissions
- Restore the Oracle OCR/vote from the backup taken using dd.???
- Create database from scratch using dbca.
- restore the database using the backup dump.
Please clarify and suggest if anything i am missing.
If my vg_rac disk is crashed then i think my database will stop functioining and the downtime is evitable..right? Please clarify.
Thanks
Amit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2009 06:31 PM
тАО09-07-2009 06:31 PM
Re: Oracle raw disk image backup and restore!!
I mean "inevitable" :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-08-2009 04:35 AM
тАО09-08-2009 04:35 AM
Re: Oracle raw disk image backup and restore!!
If you do not have archive log mode enabled, you will not be able to do a point in time recovery.
Using dd to create a backup will ONLY be able to create a consistent image if the database is DOWN.
You need to use rman with some tool such as DP to create your consistent backup image with a DB that has archive logging enabled.
Regards,
Norm
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-08-2009 06:03 AM
тАО09-08-2009 06:03 AM
Re: Oracle raw disk image backup and restore!!
> How can we take the backup of Oracle rac raw disk image and restore it as a recovery process.?
Are you "puting the carriage before the horse" here? How do you run backups right now? If your current backup method can not recover a crashed raw disk then it is useless. It seems to me that any consistent offline or online backup method (RMAN is not necessary but it can definitely be used as well), can be used to recover the database. Of course the crashed disk needs to be recreated first using OS and oracle procedures.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2009 03:03 AM
тАО09-09-2009 03:03 AM