基于Oracle Streams的数据库实时备份技术研究

Research on Real-time Database Backup Technology Based on Oracle Streams

在数据库的故障恢复中,实现无数据丢失的数据库备份与恢复是极为重要的研究内容,运用数据库的实时备份,当有数据库操作时,可以实时地对数据库发生的改变进行备份,从而有效地防止数据丢失。基于Oracle Streams技术,提出了一个数据库的实时备份方案。该方案利用Oracle Streams复制技术,配置捕获进程自动捕获数据库的所有改变,并将这些改变储存在高级队列中,传播至目标数据库,实现数据库的实时备份,恢复时从备份中读取这些改变信息,应用于目标数据库,可以得到一个处于一致性状态的无数据丢失的数据库。在Linux环境下技进行测试实验,结果表明本方案是可行的。

It is important to avoid data lost during database failure recovery.Real-time backup of database can store all the database changes without having to interrupt work,then avoid data lost as far as possible.In this paper, a real-time backup is proposed based on Oracle Streams.The approach configures a capture proceeding to capture changes of database automatically, saves these changes in an advanced queue,and propagates them to the target database.While restoring,these changes are read from backup sets,and applied to target database.The database after restoring is consistent,and the proposed approach has been tested to be workable in linux environment.