- Community Home
- >
- Services
- >
- Legacy
- >
- Business Recovery Planning
- >
- online backup
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
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
тАО01-29-2003 12:53 AM
тАО01-29-2003 12:53 AM
online backup
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 09:19 AM
тАО01-30-2003 09:19 AM
Re: online backup
The backup performs with normal speed in my experience, tape being so much slower than disk IO.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2003 09:39 PM
тАО02-04-2003 09:39 PM
Re: online backup
Daily backup of the whole database/logs to tape using OmniBack.
We also have a procedure where we have a number of transactions logs each 10 MB. Once one fills it goes straight to tape and providing the backup is successful, the log is removed. This gives us the ability to restore an entire backup and roll forward or back.
During the next year we will be utilising a different method whereby we will use a disk split between two different sites using an EMC symmetrix.
Live data to disk which is mirrored. This is then copied via SRDF to another EMC symmetrix to another site where the BCV copy will be split off and a backup to tape performed.
I agree tape is slow, but this will also depend on the type of data and volume usage.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2003 01:28 PM
тАО02-06-2003 01:28 PM
Re: online backup
One point is that it is necessary to 'flush' the system, so that all oracle data kept in system buffers (etc) get written to disk, but this only takes a few seconds (often sub-second).
The disk image/split technique that Michael mentions has several variations. Lots of arrays these days can take a 'snapshot' of the data, using a technique quite similar to that described above for Oracle's on-line backups. The "snap" image is then available to be mounted to a backup server, and backed up without impacting the database.
Using this technique, you quiess Oracle, and put it in backup mode. Then you take a snapshot of the volumes used by Oracle (which takes about a second), then you take Oracle out of backup mode. This all takes, like, 5-10 seconds, users are up the whole time, and backups happen at your liesure.
Obviously, you have to coordinate backups of log files as well, it isn't as simple as backing up a file system.
One of the other advantages of doing the snapshot backup thing is that, even after the backup is done, the 'snap' copy, for a certain point in time, remains on the array. Since you can keep several/many snaps of one disk volume, you keep a rotating set of snapshots (like, a week's worth). Then, recovery is a snap. Bring down Oracle, restore the snap (takes a second or so), bring Oracle back up and use logs to sync everything up, and you're back in a good state (from data corruption or a mistake or whatever).
Plus, you can use snapshots to do dev/testing on live data, or do batch/reports/whatever from live data, but without impact to production. Maybe some impact, since you are hitting the same spindles, but you can throttle processes as you need to, the point is they are hitting seperate 'instances', giving you control over much more than you used to have.
Sorry, this is a big topic, I'll shut up now.
Later... --bmr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2003 08:13 AM
тАО02-11-2003 08:13 AM
Re: online backup
You didn't specify which type of database or back-up tool your using so we are all speakin in generic terms. In doing an on-line back-up, as everyone has said, the database iis in a read only mode and the amount of transaction processing you do impacts have fast the back-up will get done. Another factor is your back-up tool and how it interfaces with your database. Bottom line is yes, you can access data and continue processing, however, the caveat, IMHO, is keeping logical consistency of you data for disaster recovery if you have more than one system and they are have data that is 'shared' between them.
My $.04 for inflation,
Chuck Ciesinski
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2003 10:47 PM
тАО02-11-2003 10:47 PM
Re: online backup
Thanks for the answers. to clarify, we haven't chosen a tool for the backup and may consider any tool from Veritas, HP, Tivoli, Legato etc. the database can be Oracle, SQL Server, DB2.