- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- How long the DB server should be in hot backup sta...
-
- Forums
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- OEM Solutions
- Servers: The Right Compute
- Shifting to Software-Defined
- Telecom IQ
- Transforming IT
- Infrastructure Solutions German
- L’Avenir de l’IT
- IT e Trasformazione Digitale
- Enterprise Topics
- ИТ для нового стиля бизнеса
- Blogs
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Forums
-
Blogs
-
InformationEnglish
- 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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-18-2009 04:51 AM
02-18-2009 04:51 AM
I have Informix, DP 5.5 and EVA5000. I want to implement ZDB and IR. I will use ZDB on raw disk (Informix DB). Informix will be in hot backup. I will use “onmode –c block” to start hot backup state and “onmode –c unblock” to stop hot backup.
I have question.
How long the Informix should be in hot backup state - for the whole period of creation of the snapclone or only for the time of snapclone starting up
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-18-2009 05:14 AM
02-18-2009 05:14 AM
SolutionIn other words for as long as the raw informix disks are being read to make the clone, the database must be in hot backup state.
The snapclone is a full copy of your LUNs and takes long time.
A snapshot, gets created much quicker and will minimize the amount the database has to be in hot backup mode.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-18-2009 06:47 AM
02-18-2009 06:47 AM
Re: How long the DB server should be in hot backup state?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-18-2009 08:15 AM
02-18-2009 08:15 AM
Re: How long the DB server should be in hot backup state?
It depends on many factors.
how many disks/trays the EVA has
how many disks are in use by the LUN(s)
if the the source disks and the destination disks are the same set of disks
other i/o traffic in the same LUNs at the same time
other i/o trafffic in the array overall
array caching
etc.
It can be anybody's guess, I would guess 30 minutes.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-18-2009 09:30 AM
02-18-2009 09:30 AM
Re: How long the DB server should be in hot backup state?
- put DB in backup mode
- start the SnapClone
- take the DB out of backup mode
Any changes to the original volume will be take care of by the SnapClone similar to the SnapShot - except that it will additionally make a full copy. The downside, of course, is that the SnapClone will put an additional I/O burden on the source disks, because it is reading ALL blocks.
I've once read that a SnapClone can be as fast as about 100 GigaBytes per hour. Of course this depends on the total load of th EVA, because the copy I/O is competing with the normal 'user' I/O.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-19-2009 01:35 AM
02-19-2009 01:35 AM
Re: How long the DB server should be in hot backup state?
How long the Informix should be in hot backup state - for the whole period of creation of the snap clone (more than 2 minutes) or only for the time of snap clone starting up (smaller than 2 minutes)?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-19-2009 05:56 AM
02-19-2009 05:56 AM
Re: How long the DB server should be in hot backup state?
Take a look at this document, it is for oracle but the idea is the same.
http://h20000.www2.hp.com/bc/docs/support/SupportManual/c00386935/c00386935.pdf
As always, after you set this up, you need to test your method and recover informix in a test environemnt from the snapclone.
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2019 Hewlett Packard Enterprise Development LP