Hello, We have a large warehouse in the above environment (over 6 TB). We take weekly (Saturdays) backups of the most critical tablespaces and retain archive logs. We use a native "userexit" to move logs from the active directory to the archive directory. The backup images are going to three 1 TB file systems on disk simultaneously. One of these filesystems also holds the archive logs. We keep two good versions of the backup images on disk until Monday, then the previous version moves to tape and we remain one on disk prior to next backup.
We do not remove the archive logs, and as a result we started experiencing a space problem. I understand that we can implement something where the archive logs will be moved to another filesystem or tape, etc. Given that we do not have full database backup, only isolated tablespaces and the catalog space, and that we can re-build the rest of the tables, my question is: Can we remove archive logs older than a month? What is the archive logs retention, if we have some spaces that have never been backed up? Is that possible that some of the "old" logs may have something that will prevent us from doing successful recovery in case it is needed? What is the impact on the recovery process of not having a backup of the USERSPACE? If we need to recover the database, what would be the best approach in our scenario? Thank you, Ellen Klebaner-Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
