Browse > Article
http://dx.doi.org/10.13089/JKIISC.2013.23.5.947

The method of recovery for deleted record in Oracle Database  

Choi, Jong-Hyun (Center for Information Security Technologies(CIST), Korea University)
Jeong, Doo Won (Center for Information Security Technologies(CIST), Korea University)
Lee, Sangjin (Center for Information Security Technologies(CIST), Korea University)
Publication Information
Journal of the Korea Institute of Information Security & Cryptology / v.23, no.5, 2013 , pp. 947-955 More about this Journal
Abstract
Most of the enterprise information is stored in the database. Therefore, in order to investigate the company's criminal behavior, forensic analysis is important for the database and delete record is a need to develop recovery techniques. This paper is explained structure of the oracle database tablespace file and analyzed system tables that stored table information. Further, we suggests a method of recovery for deleted record in oracle tablespace.
Keywords
Oracle; Database; Deleted record; recovery; forensic;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Oracle 전 세계 점유율, "http://apacm ediacentre.oracle.com/content/detail.a spx?ReleaseID=6129&NewsAreaId=2", Apr. 2013.
2 Oracle 국내 점유율, "http://www. dt.co.kr/ contents.html?article_no=20130123020 11060746002", 2013년 1월.
3 SANS Computer Forensics, "Oracle Database Forensics using LogMine r,", Jan. 2005.
4 Heloise Pieterse and Martin Olivier, "Data Hiding Techniques for Database Environments," Advances in Digital Forensics VIII, Vol. 383, pp. 289-301, Jan. 2012.   DOI
5 Oluwasola Mary Fasan and Matin Olivier, "Reconstruction in database forensics," Advances in Digital Forensics VIII, Vol. 383, pp. 273-287, Jan. 2012.   DOI
6 Oracle 트랜잭션 로그 저장 모드, "http:// docs.oracle.com/cd/B19306_01/server.1 02/b14231/archredo.htm"
7 데이터 블록 Format, "http://docs.oracle.com/cd/B28359_01/server.111/b28318/lo gical.htm"
8 OBJ$ 스키마 정보, "http://docs.oracle.com /cd/B1 4117_01/server.101/b10755/statviews_ 1102.htm#i1583352"
9 Oracle Data Types, "http://docs.oracle. com/cd/B28359_01/server.111/b28318/datatype.htm"
10 Oracle, Oracle 9i Database: Data Types and Storage Internals, May. 2002.