Logical logs backup to Disk
Was looking to eliminate the use of magnetic tape for DB archive and Logical Log backup and the need for human intervention. Back in May 2012, we had the opportunity to store information an an Avamar Backup system with terabytes of available space. It was easy to perform the nightly DB archive (level 0) to disk and then have the Avamar backup the archive to the off-site system. We have a 15 day retention policy of DB archives on the local system and a 60 day retention policy on the remote Avamar system. The logical logs to disk proved to be problematic and work on this was sporadic until late September. After successfully backing up the logs to disk on our test server, I did several tests of the DB logical restore and every time the logs restored without an issue. Also tried several table level restores and applied the logs with no issues. After another round of testing, the method was applied to our production server. Locally, I keep 10 days of logical logs and on the remotes Avamar system, I keep 60 days. One great feature of the Avamar system is I can do a month end, or year end level 0 archive and set the retention policy on the Avamar to NODELETE on those archives. We are in the second month of this process with no hiccups.
Thanks for sharing (seriously), but was there a question missing in there somewhere? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Nov 26, 2012 at 10:38 AM, LARRY KOTUR <larry.kotur@heritage-wti.com>wrote: > Was looking to eliminate the use of magnetic tape for DB archive and > Logical > Log backup and the need for human intervention. Back in May 2012, we had > the > opportunity to store information an an Avamar Backup system with terabytes > of > available space. It was easy to perform the nightly DB archive (level 0) to > disk and then have the Avamar backup the archive to the off-site system. We > have a 15 day retention policy of DB archives on the local system and a 60 > day > retention policy on the remote Avamar system. > > The logical logs to disk proved to be problematic and work on this was > sporadic until late September. After successfully backing up the logs to > disk > on our test server, I did several tests of the DB logical restore and every > time the logs restored without an issue. Also tried several table level > restores and applied the logs with no issues. After another round of > testing, > the method was applied to our production server. Locally, I keep 10 days of > logical logs and on the remotes Avamar system, I keep 60 days. One great > feature of the Avamar system is I can do a month end, or year end level 0 > archive and set the retention policy on the Avamar to NODELETE on those > archives. We are in the second month of this process with no hiccups. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9399c711f1cfe04cf68180c
Art, Actually, I am interested in hearing from others that have been successful with disk backup of DB archive and logical logs and I'd be willing to assist anyone with their questions if they are trying to do the same. Larry
Larry, How big is your database? How long does it need to do a level 0 backup? We are backing up both db and logs to disk and recycle it daily, seems happy so far.... Thanks, Frank On Mon, Nov 26, 2012 at 3:02 PM, LARRY KOTUR <larry.kotur@heritage-wti.com>wrote: > Art, > > Actually, I am interested in hearing from others that have been successful > with disk backup of DB archive and logical logs and I'd be willing to > assist > anyone with their questions if they are trying to do the same. > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf3074b1fee1d56204cfbbcc5f