迁移表空间在Oracle数据库备份恢复中的应用

电信的计费结算数据库按月处理的特性较强，各月的数据相对独立，由于统计分析等方面的需要．数据库中往往保留距今6-12个月的数据，历史数据每月备份清理，要求保留两年以上，并且可能随时需要恢复。Oracle的全库备份恢复方法不适用，逻辑的exp／imp方法由于时间太长也不适用。所介绍的利用迁移表空间方法实现的数据库备份恢复方案，能够解决该问题。各月的数据存放在不同的表空间上．对单独的表空间进行备份恢复即实现了历史数据的按月备份恢复。

Transportable Tablespace and Its Application in Backup and Restore of Oracle Database

The billing database of telecommunication is usually managed and used monthly. The data for each month is relatively independent. The data is reserved in the database for 6 - 12 months normally to meet the requirement of statistics and analysis. The history data is backed up and removed from the database each month and need to be stored for more than two years. The stored history data may need to be restored to database at any time. The whole database backup and restore of Oracle database cannot meet such requirement. The exp/imp commands need too much time so it is not applicable either. This paper introduces the method of transportable tablespace to backup and restore database and it can solve the above problem. We can save the data for each month in different tablespaces, then we can backup and restore history data by month through backing up and restoring each single tablespace.