- Community Home
- >
- Storage
- >
- HPE Nimble Storage
- >
- Array Performance and Data Protection
- >
- Re: Nimble snapshots on IBM Power AIX running Orac...
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
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
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-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
- 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
- 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
- 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!