20.500.12556/DKUM-60671 PREIZKUŠANJE ORACLOVEGA ORODJA DATA GUARD ZA DOSEGANJE VISOKE RAZPOLOŽLJIVOSTI IN VAROVANJE PODATKOV TESTING OF ORACLE’S DATA GUARD TO ENSURE HIGH AVAILABILITY AND DATA PROTECTION Diplomska naloga predstavlja teoretično in do neke mere tudi praktično podlago za urejanje rezervne računalniške lokacije na Agenciji Republike Slovenije za javnopravne evidence in storitve (AJPES). Glavni namen diplomske naloge je priprava vsega potrebnega za postavitev rezervne kopije podatkovne zbirke. S tem bomo zadostili dvema osnovnima zahtevama: neprekinjeno delovanje podatkovne zbirke in varovanje podatkov. Ker uporabljamo podatkovno zbirko Oracle®, bomo za to uporabili orodje Data Guard. Uporabili bomo še orodje RMAN, ki nam bo omogočilo kvalitetno izvedbo varnostne kopije in prvi prenos podatkovne zbirke na rezervno lokacijo. V prvem delu je predstavljen AJPES in njegova organiziranost ter razloženi ključni pojmi, ki se pojavljajo skozi celotno nalogo. V drugem delu smo pojasnili delovanje orodij Data Guard in RMAN. V nadaljevanju smo opisali postavitev okolja za podatkovno zbirko na rezervni lokaciji, povezava obeh zbirk (primarne in rezervne) ter zagotovitev ustreznega prenosa in varovanja podatkov. Opisan je tudi preklop med obema zbirkama, če pride do težav. Na koncu smo rezultate testa povzeli z analizo SWOT in navedli ključne dejavnike za to, da takšna lokacija zaživi tudi v praksi. This degree thesis represents theoretical and to some point also practical grounding in establishing secondary location for IT department in the Agency of the Republic of Slovenia for Public Legal Records and Related Services (Slovenian abbreviation for the Agency is AJPES and as such is used in the further text). Main purpose of this degree thesis is to prepare all that is needed for the reserve copy of the database. By doing this, we meet two basic requirements: uninterrupted operations and data safeguard. Since we use Oracle® database, we are going to use Oracle's tool called Data Guard. Also, we are going to use a tool called RMAN which enables implementation of quality backup and first transfer of the database to the secondary location. First part presents the Agency (AJPES) and its organizational structure. It also defines key concepts that are used throughout the thesis. Second part explains database tools Data Guard and RMAN. Thesis then resumes with a description of the setting for the database on the secondary location, way of connecting both databases (primary and secondary) and way of assuring proper transfer and proper backup of the data. Switchover between both databases in case of problems is also described. At the end of the thesis we summarized testing results in the form of SWOT analysis, and we adduced key factors that have to be considered if this secondary location is about to live. podatkovna zbirka Oracle Data Guard RMAN neprekinjeno delovanje varovanje podatkov Oracle database Data Guard RMAN uninterrupted operations data safeguard true true false Slovenski jezik Angleški jezik Diplomsko delo/naloga 2016-06-29 09:21:37 2016-10-11 16:15:49 2022-06-24 03:14:29 2019-07-11 11:54:38 2016 0 Kranj 0 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 7769875 URN:SI:UM:DK:OBC1QDJZ UN_Milic_Marcel_2016.pdf UN_Milic_Marcel_2016.pdf 1 72D06F53CD773036BD2742A26E5C1F12 82431bf37d273fd7efdcad8766484054d0d8af6d58d33aa1e432d39e0f4ef62a cf33ce1d-7c0c-11eb-bb7a-00155d0001ca https://dk.um.si/Dokument.php?lang=slv&id=95737 Fakulteta za organizacijske vede 0 0 0