- Community Home
- >
- Storage
- >
- HPE Nimble Storage
- >
- Array Performance and Data Protection
- >
- Re: Nimble snapshots on IBM Power AIX running Orac...
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
- 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
- Email to a Friend
- Report Inappropriate Content
09-19-2017 08:41 AM
09-19-2017 08:41 AM
Can you run Consistency Storage snapshots for Oracle on AIX ? If so does anyone have experience doing it and can explain how it is working for them ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-19-2017 09:31 AM
09-19-2017 09:31 AM
SolutionHi David,
The short answer to your question is yes, you can take consistency storage snapshots for Oracle on AIX. There are two methods to doing this...
1. Crash consistent snapshots...this is basically where you create a volume collection with all of your volumes in a volume collection, and take a snapshot without doing anything on the host or database side. As of 11gR2, Oracle supports crash consistent backups, and you should be able to get your database back up and running by reverting your database back to your snapshot and opening the database.
2. Application consistent snapshots...this is when you place the database in hot-backup mode, then take your snapshot using a volume collection snapshot, and then taking the database out of hot-backup mode. This takes some coordination on your part (typically scripted) to place the database in and out of hot-backup mode.
In both cases, you need to create a volume collection that has all of your database volumes in it. You can then create, or manually create volume collection snapshots that snap all of your volumes at the same time. For Oracle databases, I suggest creating a volume collection per database.
Once you have volume collection snapshots, and want to revert your database back to an earlier version of your database, the typical steps are: shut down the database, restore all volumes from the same snapshot back to the original location, and then startup the database. With application consistent snapshots, you should also be able to apply archive logs once the database has been restored in order to get your database back to a certain point in time, SCN etc.
I suggest you look at the Oracle Deployment Consideration Guide on InfoSight for more suggestions.
Also, please let me know if you have any additional questions! I'm more than happy to help!
Thanks!
Freddy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-20-2017 07:01 AM
09-20-2017 07:01 AM
Re: Nimble snapshots on IBM Power AIX running Oracle.
Thank you very much Freddy, this was very useful and spot on what i needed to know
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-20-2017 08:13 AM
09-20-2017 08:13 AM
Re: Nimble snapshots on IBM Power AIX running Oracle.
Hi David, please let me know if you have any other questions! More than happy to discuss further if needed!
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP