Qhov txawv ntawm RMAN thiab export thaub qab yog dab tsi?
Qhov txawv ntawm RMAN thiab export thaub qab yog dab tsi?

Video: Qhov txawv ntawm RMAN thiab export thaub qab yog dab tsi?

Video: Qhov txawv ntawm RMAN thiab export thaub qab yog dab tsi?
Video: Qhov Txawv Ntawm Lus Hmoob Thiab Lus Mab Mawb 2024, Hlis ntuj nqeg
Anonim

Ib RMAN thaub qab yog lub cev thaub qab thiab Data Pump thaub qab yog logical thaub qab . Cov ntaub ntawv pov tseg siv expdp yog 1 zaug xa tawm ntawm ib lossis ntau qhov database schemas. Nws thaub qab DDL (cov qauv rooj, kev pom, cov lus sib txuas, cov txheej txheem khaws cia, pob khoom, thiab lwm yam), ntxiv rau cov ntaub ntawv.

Kuj paub, qhov txawv ntawm thaub qab thiab rov qab yog dab tsi?

Qhov txawv . A thaub qab tsis yog automatic, thaum rov qab los point yog tsim los ntawm koj lub computer. Tsis tas li ntawd, nyob rau hauv ib tug thaub qab , cov ntawv luam ntawm cov ntaub ntawv nyob hauv ib lwm qhov chaw nyob deb ntawm koj lub computer, thaum a rov qab los yog ua nyob rau hauv koj lub computer.

Qhov thib ob, qhov txawv ntawm cov tsoos export thiab Datapump yog dab tsi? Qhov sib txawv ntawm Cov Tso Cai Export thiab Datapump Datapump ua haujlwm ntawm ib pawg ntawm cov ntaub ntawv hu ua dump file sets. Txawm li cas los xij, ib txwm xa tawm ua haujlwm ntawm ib daim ntawv. Datapump nkag mus rau cov ntaub ntawv hauv server (siv cov npe ORACLE). Kev cai export tuaj yeem nkag mus rau cov ntaub ntawv hauv cov neeg siv khoom thiab cov servers ob qho tib si (tsis siv ORACLE cov npe).

Tom qab ntawd, dab tsi yog export thaub qab hauv Oracle?

Oracle thaub qab Hom Kev xa tawm yog logical database thaub qab uas rho cov ntsiab lus logical thiab cov ntaub ntawv los ntawm cov ntaub ntawv mus rau ib cov ntaub ntawv. Export thaub qab yog cross-platform thiab tuaj yeem txav tau yooj yim ntawm ib qho kev khiav hauj lwm mus rau lwm qhov.

Expdp thiab Impdp yog dab tsi?

Datapump expdp / ua impdp khoom siv. ORACLE muab ob qho khoom siv sab nraud los hloov cov khoom siv database los ntawm ib lub database mus rau lwm qhov database. Tom qab ntawd los ntawm 10g, ORACLE qhia datapump ( ua expdp / ua impdp ) raws li kev txhim kho rau cov khoom siv hluav taws xob ib txwm siv.

Pom zoo: