Realizacija rješenja za oporavak baze podataka u slučaju katastrofe

master's thesis

• Title (english): Realization of database recovery solutions in the event of a disaster
• Author: Silvija Tovernić
• Mentor: Mirta Baranović (mentor)
• Committee member: Mirta Baranović (predsjednik povjerenstva)
• Committee member: Zoran Skočir (član povjerenstva)
• Committee member: Slaven Zakošek (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2018-07-05, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Electrical Engineering

Abstract

U ovom radu dan je primjer realizacije rješenja za oporavak Oracle baze podataka od katastrofe. Za navedenu bazu podataka realizirana je sekundarna lokacija na kojoj se nalazi baza podataka na čekanju koja predstavlja transakcijski konzistentnu kopiju primarne baze podataka i koja je namijenjena posluživanju korisnika u slučaju ispada primarne baze podataka. Na bazi podataka na čekanju konfiguriran je i postupak redovitog sigurnosnog kopiranja kojim se dodatno rasterećuje primarna baza podataka. Za ilustraciju rada sustava korišten je nadzorni alat kojim su simulirane klijentske konekcije na bazu i kojim su se pratili osnovni parametri važni za normalan rad sustava. U posljednjem poglavlju demonstrirano je i ponašanje sustava u slučajevima planiranih i neplaniranih ispada primarne baze podataka.

Abstract (english)

This paper describes the realization of a disaster recovery solution for Oracle database. In addition to the primary database, the standby database is created and it represents transactional consistent copy of the primary database and it is intended for serving the users in the event of a primary database failure. Backup and recovery procedures are also implemeted on the standby database to remove the additional load from the primary. A monitoring application is also configured to simulate client connections to the primary database and to monitor the most important parameters required for normal database operations. The last chapter describes the behavior of the entire solution in cases of planned and unplanned database downtime.

• Keywords: Oracle baza podataka; oporavak od katastrofe; visoka dostupnost
• Keywords (english): Oracle database; disaster recovery; high availability
• Language: croatian
• URN:NBN: urn:nbn:hr:168:408285
• Study programme: Title: Information and Communication Technology; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka informacijske i komunikacijske tehnologije (magistar/magistra inženjer/inženjerka informacijske i komunikacijske tehnologije)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2019-03-14 01:40:43