[U2] tape backups
Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] tape backups
There's a dbpause / dbresume command on unidata that looks like it would make backups safer: dbpause is a UniData system-level command that blocks most updates to the database made in a UniData session. Any updates made from the operating system level are not blocked. You can use this feature to perform some tasks that normally require UniData to be stopped, such as backing up your data. When the dbpause command is issued, all current writes and transactions complete before UniData pauses. Updates are blocked until the system administrator executes the dbresume command. Edward -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 August 2008 17:33 To: u2-users@listserver.u2ug.org Subject: [U2] tape backups Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] tape backups
We used these for years. No problems - except the tape loader itself... They work well especially if you have a fast disk sub-system. It's more the software that you are using and how it handles open files and locking them. It's been too long since I've set one of these up on Aix but in Windows some software won't backup open files (which the database may hold open even if no one is actively using them). The other problem is the backup software locks the file at the OS level so the database can't read the file and the program aborts. Hth Colin Alfke Calgary Canada -Original Message- From: Roger Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] tape backups
quote who='Edward Brown' date='Thursday 14 August 2008' There's a dbpause / dbresume command on unidata that looks like it would make backups safer. If your system supports filesystem snapshots, a really effective means is to: 1) dbpause the database 2) take file system snapshot of database 3) dsresume the database 4) perform tape backup from snapshot 5) release the snapshot once backup completes This typically results in very little downtime (as long as it takes to pefrom a snapshot of the filesystem) often 5-10 seconds or less. Yes, you should wait a few seconds after dbpause to allow any pending writes to complete. dbpause is a UniData system-level command that blocks most updates to the database made in a UniData session. Any updates made from the operating system level are not blocked. You can use this feature to perform some tasks that normally require UniData to be stopped, such as backing up your data. When the dbpause command is issued, all current writes and transactions complete before UniData pauses. Updates are blocked until the system administrator executes the dbresume command. Edward -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Email gives the illusion of progress even when nothing is happening. unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
