Oracle闪回技术在数据恢复中的应用  

Application in data recovery on Oracle flashback technology

作　　者：曾传军[1] 傅秀芬[1] 彭小玲[1] 许金[1] 

机构地区：[1]广东工业大学计算机学院,广东广州510006

出　　处：《微型机与应用》2010年第16期90-92,95,共4页Microcomputer & Its Applications

基　　金：广东省自然科学基金项目(06021484)

摘　　要：在Oracle 9i之前的版本,要恢复用户误操作的数据,必须通过逻辑备份或者物理备份进行恢复以纠正错误,这种方法是极其复杂和低效的。为提高数据库的可用性,从Oracle 9i开始引入了闪回技术,使数据恢复的方式和手段更加丰富,操作更加简易。主要分析介绍Oracle闪回技术的概念、功能,并结合实例介绍闪回技术在数据恢复中的应用。In order to restore the user data,previous versions of Oracle 9i had to use logical or physical backup to recover the data to correct the error. This method was extremely complicated and inefficient. For the purpose of improving the availability of database, Oracle 9i started to introduce flashback technology that provided diverse data recovery ways, and the operation was much more easier. This paper describes the conception and functions of database flashback technology, combining with the development example to illustrate its application.

关 键 词：ORACLE 9i ORACLE 10g 闪回技术 数据恢复 

分 类 号：TP309.3[自动化与计算机技术—计算机系统结构]