Suad, Thanks for your help. Let me see if I understand correctly. 1. When you said putting db in backup mode, I can think of ARCHIVELOG mode for Oracle, which will take a few seconds and execute the flashcopy; Q: I heard flashcopy takes a lot less time to create a snapshot. Any analogy about how fast? How much time would you gain? Let's say mine takes an hour to hot-backup Oracle through TDP.
2. Change to NOARCHIVELOG mode for Oracle and mount pseudo volume and backup that filesystem. Q: Should I create a separate set of disks for fs (pseudu vol)? Can I do LV backup? Q: Can I use, after backing it up, the same fs for testing or report purposes before delete it? Sorry for too many questions. Thanks again. Gus >>> [EMAIL PROTECTED] 03/27/03 03:04PM >>> The FAStT flashcopy is very easy to use. It's the same as most snapshotting features on other storage subsystems. It creates a pseudo volume that utilizes cache area to record any changes in the original volume. You can mount the pseudo volume as you can the original to make a backup copy. For a database, you either shut it down or put it in backup mode before executing the flashcopy feature. Then you restart/return the database online and mount the pseudo volume as you would the normal one. It gives you the ability of doing a filesystem backup as you would the database being stopped (i.e. cold). The only reason you may want to use the TDP is if you mount the pseudo volume on another machine to reduce I/O impact on the main host, otherwise it benefits for cold backups. Cheers, Suad -- ----- Original Message ----- From: "Jin Bae Chi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 6:14 AM Subject: FastT700 with FlashCopy TSMers, We are about to get FastT700 with FlashCopy option. Has anyone had experience on this FlashCopy for backup or/and report purposes? IBM said I can do backups from a separated set of disks for FlashCopy, not from the original disks. We also run Oracle with TDP product. I don't get how db will get flash-copied and being read for backups or reports. Any comment will be appreciated. Thanks. TSM 4.2.3 AIX 4.3.3 TDP of Oracle 2.2 Oracle 8.1.6 Gus
