[es] - Backup&Restore baze

dusanmiloradovic
Dusan Miloradovic
Abu Dabi

Član broj: 38080
Poruke: 45
*.ceetel.co.yu.

Profil

^{21.12.2004. u 08:36}

Najbrze i najjednostavnije(ali ne i najsigurnije) ces to uraditi sa exp/imp alatima iz komandne linije.
Znaci iz komandne linije kucaj exp user/password@baza (naravno, stavi svoje vrednosti).
Dobices gomilu pitanja na koje treba da odgovoris, sve je intuitivno. Kada te bude pitao da li zelis
da eksportujes celu bazu ili korisnika, odgovori korisnika, i navedi posle toga koju semu zelis da
eksportujes. Taj fajl sada treba da prebacis na masinu gde ne postoji ta sema. Kreiraj korisnika, dodeli mu odgovarajuce privilegije, i uradi imp user/password@baza sa usernameom i sifrom novog
korisnika, i to ti je to.
Vise o ovome imas u knjizi Utilities iz dokumentacije, a ako te interesuje da vidis kako bi bekap radio za prave sisteme, postji i Backup i Recovery guide. Iz te knjige pogledaj rman utility, mislim
da je to najjednostavniji nacin za pravi bekap.

Dusan Miloradovic

^{21.12.2004. u 08:36}

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL Developer, Erst..
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at.

Sajt: www.baze-podataka.net

Profil

Re: Backup&Restore baze

^{21.12.2004. u 18:23}

Pokusaj sa RMAN-om (Recovery MANager).

Recovery Manager Quick Start Guide

http://otn.oracle.com/pls/db10...&remark=portal+%28Books%29 HTML format
http://otn.oracle.com/pls/db10...&remark=portal+%28Books%29 PDF format

Recovery Manager Reference

http://otn.oracle.com/pls/db10...&remark=portal+%28Books%29 PDF format
http://otn.oracle.com/pls/db10...&remark=portal+%28Books%29

Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA

^{21.12.2004. u 18:23}

_owl_
Centar - BG

Član broj: 318
Poruke: 990
*.vdial.verat.net.

Sajt: home.drenik.net/~owl

Profil

Re: Backup&Restore baze

^{23.12.2004. u 22:07}

Pokusao sam sa exp/imp programima i koliko vidim uglavnom radi. Ipak imam problem kada zelim da eksportovanu semu jednog usera prebacim u semu drugog usera (na drugoj masini se taj user drukcije zove), posto se u definicijama nekih objekata pojavljuje ime usera iz cije se sheme eksportuje.

Owl

^{23.12.2004. u 22:07}

dusanmiloradovic
Dusan Miloradovic
Abu Dabi

Član broj: 38080
Poruke: 45
*.ceetel.co.yu.

Profil

Re: Backup&Restore baze

^{24.12.2004. u 12:27}

Ne bi trebalo da bude problema, ukoliko korisnik koji je eksportovao ima isti nivo privilegija kao
onaj koji importuje(tj. ako je eksportovao DBA, DBA mora da importuje).
Posalji gresku da vidimo

Dusan Miloradovic

^{24.12.2004. u 12:27}

_owl_
Centar - BG

Član broj: 318
Poruke: 990
*.vdial.verat.net.

Sajt: home.drenik.net/~owl

Profil

Re: Backup&Restore baze

^{24.12.2004. u 18:31}

Ma ne problem je sledeci:
Eksportujem semu usera owl
Importujem podatke ali ovog puta koristim drugacije korisnicko ime (ovaj user ima iste privilegije kao user owl)
Prijavljuju mi se greske da import nije uspeo posto u dumpu svi objekti imaju imena tipa owl.ime_objekta (meni je nekako logicnije da se koristi "relativno" ime ako nisu vezani za objekte van seme korisnika koji se eksportuje).

Owl

^{24.12.2004. u 18:31}

Raspucin
Ljubisa Punosevac
Java Programer
Salzburg, Austrija

Moderator
Član broj: 20699
Poruke: 181
*.236.EUnet.yu.

ICQ: 244452581

Profil

Re: Backup&Restore baze

^{26.12.2004. u 01:12}

Ako samo nesto eksperimetises ili hoces da prebacis tako neki mali deo baze onda je koriscenje EXP/IMP ok, ali to nije backup alat. Sada imas RMAN, kao sto je vec neko prethodno napisao.

Elem, vise citaj help. Ako otkucas IMP help=y videces da postoje opcije fromuser i touser pa je i logicno za sta sluze, inace odgovor na tvoje pitanje je npr.:

exp userid=system/manager@baza1 owner=hr

imp userid=system/manager@baza2 fromuser=hr file=expdat.dmp touser=oe

Osim toga evo ti i jos jedan mali primer, od Thomasa Kyta, valjda ces da se snadjes:

ops$tkyte@ORA817DEV> create user u1 identified by u1;

User created.

ops$tkyte@ORA817DEV> create user u2 identified by u2;

User created.

ops$tkyte@ORA817DEV>
ops$tkyte@ORA817DEV> grant dba to u1;

Grant succeeded.

ops$tkyte@ORA817DEV> grant create session to u2;

Grant succeeded.

ops$tkyte@ORA817DEV>
ops$tkyte@ORA817DEV> create table u1.t ( x int );

Table created.

ops$tkyte@ORA817DEV>
ops$tkyte@ORA817DEV> !exp userid=u1/u1 tables=t

Export: Release 8.1.7.4.0 - Production on Wed Jul 21 13:59:51 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table T 0 rows exported
Export terminated successfully without warnings.

ops$tkyte@ORA817DEV> !imp userid=u2/u2 fromuser=u1 touser=u2

Import: Release 8.1.7.4.0 - Production on Wed Jul 21 13:59:52 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

ops$tkyte@ORA817DEV> grant dba to u2;

Grant succeeded.

ops$tkyte@ORA817DEV> !imp userid=u2/u2 fromuser=u1 touser=u2

Import: Release 8.1.7.4.0 - Production on Wed Jul 21 13:59:52 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by U1, not by you

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. . importing table "T" 0 rows imported
Import terminated successfully without warnings.

Toliko.

^{26.12.2004. u 01:12}