Milton, We recently introduced disaster recovery, and I pondered this for a while. The outcome is that we store the DBSNAPSHOT off site, as one can recover to a point in time. In our case VIA a SAN to another robot.
We keep the full backup + any incremental within the local robot to avoid time delay. Prior to introducing DR, I remember one evening when we had to recover the database and it took two hours before we got the tape into the robot. One soon learns. Kind Regards Mike Wiggan, TCS/14 IT Infrastructure Integration Specialist Petroleum Devlopment Oman LLC ([EMAIL PROTECTED]) -----Original Message----- From: Johnson, Milton [IT] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 20:06 To: [EMAIL PROTECTED] Subject: Question on Restoration from DBSNAPSHOT All, TSM: Storage Management Server for AIX-RS/6000 - Version 4, Release 2, Level 1.7 OS: AIX 4.3.3 ML 9 Log Mode: RollForward (Upgrade project planned in near future, but that's another story) Everyday I do a full backup of the database to 3590E tape, immediately followed by a DBSNAPSHOT to a file on disk. The 3590E tape promptly goes offsite. My question is if I experience a loss of the database can I then restore from the DBSNAPSHOT and recover to the point of failure using the RECOVERY LOG? I would like to avoid the time delay of returning the 3590E tape, containing the database backup, from the vault. Anyone done this? Thanks, H. Milton Johnson UNIX Systems Administrator - USCC San Antonio, TX Email: [EMAIL PROTECTED]
