I’m looking for best practice advice for TDP for Oracle with regards to # of channels.
If you have a classic TSM environment with a disk pool that migrates to tape, it would seem that using one-channel for TDPO backups makes the most sense to prevent the case where multi-channel files get migrated to the same tape. Our DBAs are quite opposed to using only one channel (particularly large multi-TB databases) but I can’t find any official best practice statement from IBM that I can use as a response. Unfortunately IBM support worded it “you might want to only use one-channel” which didn’t sound strong enough for our DBAs. There is no “reverse-collocation” to ensure the data ends up on different tapes, as far as I know, so what is the best practice for backing up Oracle data in an environment with data migrations? -Thanks Shawn
