Jeff_Jeske
ADSM.ORG Senior Member
We have an Oracle database running on linux that is 3.8TB in size. Our current approach to protect this server is to stop the DB, perform a Clariion snapshot, start the DB, the present the snapshot to another server and then backed up from the snapshot host. Note: the snapshot is taken from the secondary copy at the DR site.
Functionally this works well but due to resource limitations we only give the backup job one mount point and thus an incr job runs for 28 hours.
This week a Linux admin accidently deleted one of this server's filesystems. By design, the mirrored Clariion disk immediately scrammed the DR site copy as well. In addition you can't rollback a Clariion snap to a secondary and immediately use it at the primary. So... we were left rolling tape. As it turns out you can't simply restore just a piece of database and expect it to be happy. We were forced to do a full 3.8TB restore from tape.
This took us about 36 hours from launch to completion. The restore worked as designed but our clients and managers where not happy that it took us 36 hours to recover. (EVEN THOUGH THEY WERE TOLD THIS TIME AND TIME AGAIN)
None-the-less we are now looking for a better way to protect this database via TSM. I'm looking to hear from those experienced in large database backups. Do you use the Oracle TDP? Do you stream the backup to multiple drives? Any and all information welcomed.
Functionally this works well but due to resource limitations we only give the backup job one mount point and thus an incr job runs for 28 hours.
This week a Linux admin accidently deleted one of this server's filesystems. By design, the mirrored Clariion disk immediately scrammed the DR site copy as well. In addition you can't rollback a Clariion snap to a secondary and immediately use it at the primary. So... we were left rolling tape. As it turns out you can't simply restore just a piece of database and expect it to be happy. We were forced to do a full 3.8TB restore from tape.
This took us about 36 hours from launch to completion. The restore worked as designed but our clients and managers where not happy that it took us 36 hours to recover. (EVEN THOUGH THEY WERE TOLD THIS TIME AND TIME AGAIN)
None-the-less we are now looking for a better way to protect this database via TSM. I'm looking to hear from those experienced in large database backups. Do you use the Oracle TDP? Do you stream the backup to multiple drives? Any and all information welcomed.
Last edited: