- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- How long the DB server should be in hot backup sta...
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
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
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- 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.