ORACLE database disasters and security strategies

Boštjan Harnik (2010) ORACLE database disasters and security strategies. EngD thesis.

PDF Download (1466Kb)

Abstract

This diploma work focuses on data, their introduction and it describes what data really is. At the same time it also defines their role in gaining new information. It thoroughly represents the process, which helps us get the relevant, high-quality, accurate and secure information. It also defines the purpose and benefits of storing data. We also mention the history of media storage devices from stone to paper up to the present data discs, which caused real data revolution. It briefly stops at the databases, which allow us structured computer-based data storage, and management system for databases, which are very helpful in terms of data storage and administration of database. All this brings us to the safety of the database itself, the central theme of graduate work. We make a standard review of expected database disasters which should be covered by our security strategy and estimate cost for couple of these disasters. What can we do to make our database, or data whitin, more secure? Much emphasis is put on detailed review of the types and methods for backup, such as cumulative, differential, incremental, weekly, monthly etc. Diploma work although includes the study of frequency for making backup copies, which is of course dependent on activity within the database itself. The main goal of the thesis is to acquaint the reader with three basic tools, which Oracle provides for ensuring the safety of database: - export/import utility, - flashback functionality, - recovery manager. Thesis is onward focused on extensive research for usability of these three tools in our security strategy. After theory we finally move on to some practical work and describe a specific study for allocation of Oracle physical database files between two data disks, on the primary location, and one on the remote, secondary location. Systematic review of what could be done in the event of an accident or failure of one, two or even all data disks, to lose the least information possible. This connects the first theoretical and second practical part of the diploma work. Systemizing accidents of data discs and solving problems caused by accidents gives a coherent set of relatively inexpensive and very stably structured Oracle database itself. This structure is compliant with ISO 17799 standard.

Actions (login required)