Oracle Madhu Sir

Open navigation menu

Upload

0% found this document useful (0 votes)

1K views

Oracle Madhu Sir

DBA notes

Uploaded by

mouli bayi

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF or read online on Scribd

0% found this document useful (0 votes)

1K views

Oracle Madhu Sir

DBA notes

Uploaded by

mouli bayi

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF or read online on Scribd

You are on page 1/ 352

Name: ORACLE 11g DBA notes MADHU Sir (WST) SAI XEROX AMEERPET HYD 9885440924Topic: Architecture - 1 pate: @o-dud Boole: Oracle Complete Pederence + Orocke rund Ath ether Dntx, INI SONSOLARIS Sah t Be Tnxtonce* Cradle avchikecturet+ G) senvert contains the untt sho ak Sun sonver, . cr containg SON Sot, eoterté and orate 103 and the datoka 0 Cf the Servert crashes + | oratte 10} sho then ae need to take’ backup sce e eee he ; rryyt . onty the ‘atabase”, To veros Server eltan's pe eee 7 aries rack and thee open pp: This & ea ee cated fnétancesr staxietag am toMense: * document —¥ data antec us pu ateoays coant date. a tes ont 7 eee ny on RRO MY th backup and appiteattoo aston ON “ole gh executed than dota acewid as aed). Databat re etlek HE ory ROEM See Sse fected oracle ols oat siege Redo CR)! ae fe fe9 Le cmade gp no pef (oy > Servers Bora PBS Ls orade ab = a conte? + KB oF tour MB we ae | peo tog ates wo rs By > tows MB OF AB DOF ,Ceahleh conan obs ote) Ix -1 Traneackton ‘e -y Tablespaces Tatdel Inder alata: i2 cant aa gfe ceogted 03: Blok Bu? oot! vio dexed (plcb.coshe panto cen fe sh. pod $ mero pat cts: cache broctadb* Redo eg Batt Mares pot HES oF 4 \ tot dove poot 7 we Peo tearge pool . veoh gat ge o 2 att ae? Shears pot } 07 fre Oot oa : a on ed Saskgronn iia : 3 co og gt eke ground proceas ta an enetance ort oo ota mas perfor common cfuslt ‘that oat needad 0 Serveee oe oy vs eke vgquesta chrom steal cmeuvyone Ao 8 HM [aco ae” oft ee ae aot pst o ao eatthout compromietng che entagrtly arct perforeran oe ae ye oo of the exhels Bystem: Boch orate traterce moy oe ey wot cut goveial batkground processes depensting on S 7 ont i the condiguration wat! rf ce wy Multiple graett tna & nin Muttiple grace ousMont fs dtagle te: ost) ons fae conaputsr: att gi Banke veco( us) a sa seg a tm the about diagram ar obBeve wor Dont pe can ebey ro! than ons Spe NetlMon of cradle Go but cutth En. Se 3 98 Ce @ tee coart tm Ope KC then he beets q. 0g dates: Bee ce tranackona Ble Spor Rubles: St cant be edhe att Li vt xe th of checks sir flog on AAR) herd dF és pevsttewbor arte Apt ime akterattons Bar af ot dake 9b operation go in fete Sipler butte \ Nya ht ‘eae eso @ g wertton the’ 0B ¢s fn the form. sf contents ony trom a orate 19% usually 0 databace weak to, yee ti de” porter” cee eo 8 aaa > novo} Ge AE altoayyt depends on erty the arr Noetus g00 130-100, NOT 25 30 40 to ARE Became abucaby theTopic: Avchttechwe 0 DATE: ai-cful: Grceppable: We con Stoap ther wacremy data hich coo © eo 4p amet drtve Cf we coant to add another user: Gt thew ome 4 aget afd thy ow Pa] eoorning as, S, he vw v3 vy (e) EE) pe Ss gwee lg. Lawye pero || wy § varay “ue then ¢f ws tank to Login then there £3 no. wacamy Ein dtcoreting tO bar of LARD uy tf dioapped Ento Seronday [Nertuo) memod & tts enters - cleent Atarting @ trstance’ toheneva a uta asint 60 Hatence Gerd on seguett (> Seve then vrepsoue oP Tal cana Starts a eeton ard thin Save we ofl x process etalk on enktonce: wlth the but helpof wx cages sntnton eltent, Sewer persion!” performed tm the prac database: SE 0 chtert coat to eS ereeutt a trot then CE should be executed at — cotta a3 -dbF eLienk Boke dirdt: anat than after Server. Becauce the chint @ on Sriektcgent fltent, t contatag ocon cpo, en memory , too Slo ete | & “8 iTOPIC: ome —— — _— [domple table explaining the cent Gaus architeckne Th Orocle: Ny Select AY eee 5 ThE stint rok gore D Sercer beeaue at client dynton checking goes place» ‘only vss ccos gent t SOWA ye x Ry Sele from emp; tee Glan C3 conrect G Me 6 a vgs than. go to Save then rable wien oo {goa to of ard Tob}. BES don not exists exe dont Hind table theo check Pox tens, 8yr!onyrn5> tocaves. ete: Here mot ound: [5 Gelert, x from erp; Gnaatteerent x emp table exonsn 65 Scott ‘ond he created a gynonyrmtpevatey prewtlages “then Me uoat nok gixr pristlogeo: ) giak x fom ores nese Scott glen prtutlages: then poreong starts ont pass the tnt'o tn data atettonay coche CPO) than the epttmiser Coratls trate) get cupteatee ond exeates an execution plank xtoreest Ey best path) tocPtch thy frjermaton/f opsation ¢ dotatatebuter. a the cledautt optimises pom oracle 103 Ch Cote rased ofbtrniisen 3 cleat ¥ fom onp, Here S08 620 dor db not lor use Here gheve agate oAttdare stmt bat ude have ahs $34 Ep avaiable HO? toe Mereky retrine datas G)S Brome F 6TOPIC: pare: be “% ppewing ave of too types: % Soft parking: Means abreowly opttmnéser executes an EP and then the data stored tr Atbrary ancht and Bemply tating the dalags oft parking, m Has parting: dtorting cfrom be parting & breon as hosed possiog: toprkting aft baw table contents Pautable Fab} > Gabe Toble-name, Sreley-Narne et $ Seat 4 from p@A Gndeves pty ohee Gndex-names'..--."3 : SP se axe the usUs, then we go att wosee- user and ef we are a pA, ten we ola At r atth peA-- BA yMaméc. preference Aulans Suppow a user was autthing tp wont ug Sore tronkattton- ée t tncrement Salorts: ce Vg ules; de geuen the tml Ep commnttted dé this vd Sndeves: diene ‘tf ewer eraghesd shat downs abnormally, tn ote. texting op che BYE, the process SmMont mut ook ap the trangackton & charge the mod?tteations in us doom, postteutos intererlisl place ard then gles core an the autores OR ataeis THES ef Enouon a8 ege- a 7 Gee CirKiare cath rempUey) * on atts atth aka ewe got a vew Scanckick: Bak én unge : Sor toe get deck: (file Sysiero cheekup)DATE: Topic: srion wores — ree PY contr Tq not updated gost eat to atbf ott be taken cave ean getty ars set. rom sadoleg: 2 Aey fees ut parttoty cn got updated tn po etl roD ve yatestba cll et becconrd e9 SedO> ne eee pein Trigguing agen én cones 0 bogdastch zz ocurred ek 2) Shutdocon 2, eBAbOe a ot ’ ae 3 rte ath ta tree oS we 4) Reached @ a trehhotd value 6) the chinty blocks becoming e4, - blocks: “4 £20 blocks ae ost Su eet ev cogpoe! 233 ge : 9 qronzackton comple tid 2) afth tn 3 rettasec: Be | > accent vectolog atl Ya délted: cbatfos the ceca ny sty Sy pron 1) GH eltent datz eshen Serva gends @ commond evn athvatly neo Aetdon Aare when ebtert Cruotees [Soult up- Bit PrP 4) Ba cannot do any ONL operattery untt] a) 1 wleatser] committed| reklback-'e orate rakes a Key | Book to O- NOC pron | og 2 tag too tall raleawy the tock to perform operations updo soa to otha ums halps to Atoart ath old GoXton | pie modtted Soren. ioe: eeabure —, Topic: dvcitubure - 0 DATE: da—ciud- Boskeqround progesseSs: Goneicles a Brat operation to update the” employees énlortes: > update emp See dol= sale tly gpanttve* ; (as) Casio Gore) Gefore Srragel BS) ‘urdiol abe To qo alth the update cormmand, Hirst of alt te have to Sele the dato which hos been rrecttfied preutously- 8, that these data ahovld be Kept én the dtxty blows: Meant tchich ove cxvatiable fin’ the jatabase block buffers ard contato Some, old recenthy perforrnedd Enforraaition: esuatty there axe. three types oF HOCK fo the otatobay buffer free Guifers (Butlers cahich oss frec} patabasbloc® T Ptoned gutters Bal fos cokirh aaa prerenily Soppt eg] we! am) Dirty] Modtfted Butlers:(Ballor whit bur entiy wierk intr GoM (Systm Mottnrteg): WS process coos, the Some gece iy 406 instance aah Tesco C408). allows too destiny on cooskng afth the databases: | ast aTOPIC: DATE: 9 ) “The data echich was nok upolabed pelo te transadiios © Stored tn the Beforefmage ww) undol-dbf: “this ens mnfnlatnad 2, because after. postialty completing the capa command ef Syston eroshes abnowmatliy then pasttatty upsated data ee gets whit toog troerreck’ This 1S Jap catted “ Rottfoncard mneehontsrn? pavetally got epetated tn the 08° J} Any endoutsted tansaction Tx» bat updated ts Setted to he tottl yous be olledback- Because, ponttally Qkeent then, fe ustll shows a enigreatch + DBWRE Database toriter): the database cortter qets enabled ocben, o keg uotteh & oceted> te chen a redoloe fle! th complesed Filled Up ond gout? the resotogfilea then the fogéatteh trorms the PBWk to write the Modified dale to the eet dot: 4) shutdocon a clatabae gracetally: Le tf toe dbo. adit ghutderon the databace gracetally, then PBWR aftl Cmmeciates gett tevoted anc gyochrontte. the datar BD Wtth en thee Seconds (e, F pot ab att coe haut used any bansackfors then alto the OBHR gett axttvated: ST these & 9° dota to Syeehronite than DBWIR goes 4o Sleep rode: li) Reached to a threshetd value: B bec but the reelsfog Files cue -Petling more and moe. then for that Gthuatton the dba had 4aten o threshold yalue Omit: St the threshold wale yeached, then automatically BIR gee astiated- 6) the dirty Hoxks ave becoming ag L2v block: (2) @ Soroe avaty BieKs ave. dilled up ard OGKIR donrlt Syrthronize the cata Anal att trot Here F a chiont needs a Darga table then ae should | orasts © contéten Emp table Loar accewtrg by too uses, © and Va- nteto, Ug wants to update the << Get and qloemer command, at that tne Us databag| Emp gxbety then 00 meeiigtcattoo rarces place & get Aa as to: Th em tenn to pelt dake’ then unttl uy cornmtlt) rotlback the ty bt ta cont be able & do any DML tx: » optete van set Ce, orods prowtdes a Keyllock chen pron ell releases tothe client entit the cork] tx finishes > perform twansacttons - To isiese ap Loe, sake pre ais 9a fad that Fey and oles other chatsStartup Lethe defautt space ORACLE Home Lalbs: unk mean’ allocateng creating of Skovting arate, we must ~310° by the Skortuph the ¢ 4 UH one dakattle ony exe con ate Detferent: shuteoo? shutelocons enh Shutldoroo Startup and shytdoron rnodes: bockgreunel process be, yr Pefore we go the stavtup gate ora] pararceter ancl an connett: to the aint Ti; Topic: étartup 8 ghubdoctn Mc locles| DB exeator DATE: &3-clull- wrointernce, | ers Uae otaten [eon cennest paeeror® |e db fan route & no: Syreneorsting prep the tobbase commands: Thee ave = normal 0° Qgace Gremedtiate Tran curktonal dort * copy te tats the orale tos on error: ene, wank antabage: Ane after only onctuses Shuskdowr povameters echfch file restdes (8 the SoA and steurting the an (nitance: ott tolth the dakaubose then restore ancl theo rainy 4 types of tt Bhutdoor12 Tore: ne DATE: Nornal @mmecttate ‘Transaction — Abost~ 1) Neo « onneekton x x . x o dewsiton) , J) Currant: “VX > vo elegy rertbok offre Hg ene cuniTr) exit work untitony te 5 completa) Is) Gureni Begeton oe prea emmedcolly % x tw. wee A yntih dove thy. fevw'en) Joqaut) rent the oy Vv v i data inesrory & the aatofetes- Is) peirount [unmeanc db v a v Crew san ts reemen oe ee 4 ‘he a direuly or rele * ss peer to ols terminating alt the barktqround proveties) 8) Graceful Shukelocoo v 3) GR tGratence Ah yy x » ay, ot Retoeey) ego) PNorpal Shutdecon: This tsa time anntuming and Safest Shutdocon. Beeese, hee ef there ave three esers soorking tocrewting a databay, ant es! O19 gho Sends vbe Shuldecon normal option. “Then ¢f eooni WAR the rete user anter to the datakage to access the diakabat . (=| Boel Tee diy Sptero oak; unktt att tte, Mm Lol Ts] iUhbalt echéth ore axceetetng the certabase (3 logged outs That meant - . user echo axe actesateg the database con acess the database time. upto any time. But, once Me dogged cut he doadt ot yet Angin: bangoctfon anc he exetukes WS ncmonge the dataftles: Ard CE ait the elgene hawt been ca) The user can stort a neo cumrent Geeton: Anal the PGR Gy alt olidmeunt the database schenenes, toggedouts tHeree & pes cotth the graceful sfasteloosn- fo, that chere @ ro reguerernent of Gratance crash recocery” fan the temedtake ghutdowon 7° nao & Gromedsate ahutcloceo? eennettton for the User qureent Tx runt be yalledbacks dnd CE drould Immedcately aurrent Seaton: And here OE can Sgehronite the data, mramory & the catectles: Loe car acemmunk the database G we can gence funly phustdocoo attd TER cont not vegutresl nnectton © provdledt: yere also nO neo CP pleted: Ard rent boneackion & com gesston: Byrebront ctf of cle toe can tcernionnt the database. 5 regesoentonal susan! The Bysero ood ynttt tbe aun the cument aatattles t hewppenct roercory to the the gracetel shat dnd aldo coe CAD perfor reed of enttance crash recooen}” teloroo ancl we ewe NO medeatt hutdoton tS an abort nok worked So then generally wee ef a dba gtve abort eckty all be -voleateel nel a dbort shukdowoo! the vey] fen rat atthe of @ rrentton box are abe wall 9p Umreuge ts dhustelocoo Bhutdocon, en tenrnedscotely SGA cu Be tone, not grecefel Abut gph Wecoeny ig nocdert: down 80 that tnatanceTOPIC: Dababase creation DATE: 93-160! Database ereatfon: Oracle Supports Some tedls tp create a datahax Gat, here ee ce manually creating the database oly <— is — >, (bto eget ora sho <—Stpot og Lyatect or exeuiltve or abtttty prowtded by orate Sito: ® © {anna }-70 ® Generally, the howe ateveskory for the Oracle Sto (S ORACLE. Homer Ottferent cracle wer@tons axe stored tn aiff arcttle horce!s: path’s 0-H] beni/$ pate by Thu contatnd att orale executables. PAE oroah Sho certon & et ton ols & loco | ONE attest now a ets {KROES w ” wu qtete- Thorder to ciate a database we haut to create ‘an tratance «the 4 @natance name fostance name canbe ognete-sid= siot- Ue eh se then oe we can create one database: rentenseton 05 tencepplace: ce <2 prc here coe haut to dlefine the parameters: echon we conttdes oracle 109 she cof eed to have wamekes Ave catledt a4 rrention a parameters worrnely these et dleprecatect poramnetirt: user duecp- core- durnp - cheat alagt Sere Of 1068 “These parameters can Support backgrouncl - dump oleate St any bugs avotse tr backgrouinel process at Starting of enatance, hen oracle eoll! create trace ftles and copy then fate the parameter path, baexgrourd— durnp- desk = epath> [-r fome Sort of memory leakages moy happen Sornatines by Oraales|eo S that tho trace-files are Sended bo cove dump-dest = apathy |v simttlon » rv, aser qonerated traceftles contained Cn the aser durnp eski= namely a fextftle U& matatatned by the orate Jr the ‘alert tog le? dbrame, These ile contals the att parameter {eles Crformation » ccheneve an trétance vealed, when t hax been ghutelesoo ele tnformation Att the errors occured mutt be oppercied t the alertlorftle- the alee begttle elt wees these errors ce cov‘esponating 0BA'S: Gratecd of uitng the atnee depecated porometers * oratlett? proved16 TOPIC: DATE: @ Single parameter named aS, atagrestte-clest = parorneter contains the | diag? dlexertory cotthin fe: ther after orasle cfeates 0 roof dtrestories, cotth tn a tellag? devertory: dtogenstte dente Moke: Upto oracle 10% alesttog ttle dupporbs 4 becetile Gut’ from UF qlesblog Ble emt wey alto dor browttng: valves The Uiace ctivertory alto contatng the L olecttogeyte upports tewtftle- Cfnwlance rarne> powosiad Ohualty monttortng dertpts, rrenktoring AU tls axe stored % heabthmonttor Chm). —_povantdb ® Creaking all newessasy directory ooo Sbruckuve pleat ro trace. =~ v 14) Cente databerse dertpts salle Anorcleh to creat a clatabase we reguive only 2 lless cay Gyptem. and yfeure Bats et here we are. tartag 8 giles rarely aystero, Sycoux, control, uneto, temp, redloceler- The System table dpace contatnt the Bawtoble dysoux contents the performance yelubed tables: Bool temporary tablespace a cor cpelater (On operations Atice Costteg » updating dab dor tnerementation etc: i asTOPIC: DATE: Sgterwiens tpt MH once we got a command. of create dba then alt the hatetoblet axe creaked or clumped. trto the SyXter tablespace: once exe weceive an ackrouledgment eke database created, 40 all cfRID flex one Created: nlow, db created & tA etn op reoele+ anitead of the database & fn open mole the dbo cannot \te1o the detatle the 4} gece a-from user conthotolss [= snopeneate this datacdettionany wes ave created neal ab the top of the bacetable go, that We yf 5, Os ty created Sorce constrains | Prot an error £eke, ~ obser dole exter . to omp table: | eouotty, to book the cletotls of the dokabace the dbo hone gottowtng | qpktons ne cae ma dbo. Cat ebba Level) Al. (ob ony level) i Cer— Cok uur tot) | 3 ute the abot debaste , dba chould Aun Ube Grteden fat (Responstble cpr creating doterckiekfonany Ue on creating att pltsge selodiel pexg & precedures) procedure). dotloatng Sertpt oF top of Gl) ent proc Sgl (Response fr papbtd- Got Coreater ugeprotiles and ont dladaute profile]18 TOPIC: ‘ DATE: Bump? cgating a database’ 4 ul +bach— profile fos path = $path: $ Home! bio get0OY hee export pore OF yore? “spe ORECLE. HOME = [oraeng fapp foracte/proctutk] Wt" wt" HY + expat OgACLE- 51D = pavantat export PATH= $ oRActe. HOME! bin: $ PATH: ed +. bith. profile $ echo SoRActe-S£O “ file povantat yo kot ee are cafe nx ua 0° ecko} ORACLE-HOME “ouver oautehan « path) gus B echo APATH CEnven ols porh? ase thengutomat $ cd SonActe voMelabs (here coe hawt created hone cally quale wertek default porome sngor én conete Homeldbs) a prod “sixot canentpoth) $b $ Cp Cnét-ora Entt $ ORACLE. STO O10 $ ue trite $ ORACLE. STD: oree “ab-_name = PEPADLT (changed tD porvantdb) control-ftles = [desir] oradtatal pavart| control: cts. 7 | afagrodtteclex [tak foreuetertat /pavan’ -* 1og TOPIC: DATE: corepattele = (to undo management = cuto undo — tablespace © unedotna (2 table spect name #4 é{ can be optrored) undo rekentton= 900 4 mkdir -p [dieska| oradlata | poocané s ch 4 ped pauskay oradaeal paver B wl crWdes Sql 7 sacpt 1 uesie » culoky create database povoniid daterfite e(atatea | oradata/ pavant | Systereel- dbf "Sine Worm aubpextend on") Gysoux catertle \fettekeaJoracata) parent] Syauyxat-cbh'6l2e 160 autoertend 00 defautt Loblespace userdata olatafite € [cited loradata) poron€ fuserdotc.ol- cbf? gue Som default tereporary tablespace Lemp ternpftle © faexkaforadatal powant| terap: tmp! Sire dorm undo tablespace. andoebs datafile ® fausea) eradata | povant fundotbsol- dbf’ Size 400 dog grup | cs [dist a) oradata pawant /yeetotogta: tog’) dl2e 4my grep rs (coe [aitkn] oractata| pavont | realologaa: Log!) deze 4m; 10g20 ToPIC : DATE: $ ut vun-sgl @forncte. tloMte/ reibena}acletn | catatog Sot @sonncre- Home |adbmSladmin, [entpre-sqt connect Systero/ranager @forncte Home laglplud cotmén{ pubblaS4t- ‘a B dgiplen ‘/as sysabor’ connected to an tdte Enktance Syd >7 tps x (4bowe ow iey rroces#es) Jays >> Startup normount ORACLE ANSTANCE STARTED Sys>7 IPS x Sys >? extt £ ca fozaka] oractatal pewant) 4a otog $ ca cleag) 4 16 dbs, $B acl grihens, guDATE: TOPIC: porter $ cd pavantdb gu bowe, 4 col brace 4 pu pdestca) oradatal pavont {cofagl wabms| pensansat] pavaniat] brace Bas gis dee a Wied oa ap: B eatl -f alent povantat log sor @ exbab-99t Catabase created S877 @resge exit: : Syptero? conn [oe SpAba rd > Acleck eters drom He phen te fogecten our claectory, then ug tutence; dyer Sho parernekes dag, gysr aedine $> aha Alt cehows alt Sat commands)TOPIC: q DATE: Types of databaces: there axe battcally tico types of procesttngs avotlable on uatng colth. the databases They ane 1) OLTP Conktne transacttonal procesiing) ly OLAp Contre anaty teal procetetng ) ps Reprpdatserble —. ongeproduable He On condtolesing the databace admintshalton, ae tae op toe foxt data fe then we can gain by using reproduable, procedure: Bat witng monreprodugable procedure oe carte gun the dost trformaiion: RECO: baskirounct process: conkileh <2 Server’ nernely ora hos pasprotl olatabate, anct. ansther hat anccunténg clatabase- Conatder a. hint hoax balane az 60/000 En hk& account olnot he] Soper client} creates an Enxtarce. to server and Akt the request to uth 4,000 -from hs accounts then, pays database ae Geren create a datalink blo database: tw00 Gerveré ond can access the data ftom gerver? and con I rrTy | tue the check for client» client Nao, fn both the Servers, the Aeaount ef client! pret be upolated: ‘the ‘Reco’ backpona process does the task of epdoct | . j a 1TOPIC: ablatpoce Management: DATE: 24-Cal Re Gmplementationt the clataguard émplementatfon Startup from the oracle af. be) of pgterabact fod one databace dewa and then cp raumbat alto contains one databage Sewers turbot DB the’ cttent uteng the hyelerabacl ‘patabace Gur ard then dauer croshes tha etlotogg eles ett Gynthvontte the eh to the mumbad databow. Server Ths sy te cated as telabaguand tmplementatton! remmbak Sewer &% catledt at tHobstand by’ Kf * Resologftles ‘Tabblaspace Management- uch terblespaice & mnactenip of one or rare datacttles (physical hes) vine orade 1g Syfauye hos become mandatory onde tablespace 01s) & qeom crodedt. from orade Be eghtle creating a teraporary espace coe mentfon the type ox temporary: achen coe create a brant nao tablespace by deforte et alt be lo Read torte 4) loging « $ » ondine 5) pluggedta = No formenant objetS. 6) Leentty managect tablespace: 8 Cat ofs lewt) 15 Cot Oracle (ext) 8 —mount- dismount TS — ontine - offline Pond tort. CRO) ) Readedrite (eso) e Bret tly -Roseortte 1S- Reactonly Reaclamttz weed 10 maruatty meoure: b ontines Grteal Folders, 3) TEL] 4nolex voatap C8Kep) 4) Satkup CBkup) be gmat. 5) Quota.Topic: DATE: 91 »> opto Oracles’ Ge con have only one Heekstze for'enttre databat But, Oratlege cupportt rmattitblok dtred dakebases: usually oracts block Bre gtouas —y ake —<— ak 2 wtnclewss eho ne 1t05: . : ~ uke § Soles upto af minima plocka:2e an ak Sky dtnuye J mingmem blockscre Ke tok Hp OK aad one Ba Aw tkrnounk choos att mounted files: thaf —« Ghoos freespace en att fs) pe Hose sfrogtientty ulkibed weet are dba- tabledpaces dba claka--tles dba -freespace # From craue (03 tt Startacl éapposting béyfle tablespace. (The dataftte can roo upto &)c00B) cnc alan we can eneyipl @ tablespace. & the roof tablespace are require gna databas depends on D Noof applicnbtons coe axe Supporting fn thik database: & ‘the behavfour ef the tables: D Blocksree- -| AM % conttelee the cworking of aba Biup 6 ttenings at On « vmparing auth the puso. — 8AM: _ willy timings coe cba timing c satay aan ceny reush eff ferent Became eM the jc wey tienings gen on top from Soni -to GPR:rn a TOPIC: om NTE: Sratutduol us huge databases: conricler be Seners tahteh ave reeentaining the dokabases ag one as indteedaal Sra dakablocks ancl another a4 one huge databases: or conticerting these S, 7 too databases, Sometimes Server! && more « weft ashen Grotto geevsttetol compared cutth the Sercera. ecorking ith eve tcont fnddaddwal Seat databases yreeh ore comfortable a o eegely couple the dakakases ten te, ef the payrotl sans grentirg & poyprotl database. mest Acakup otth the a named Jarra; bat the Sewer has to chackP gener) <& more comfortable. chet to the Clentt then the accounting aatabas Usually they are in ont dad and beak the datakases: But, onty uting a Senge huge database the dtactwantage at can work at 8 Gould be eanesk: dmctlasly , dust one database payactt qatts, usual Bak ta deine fn peepretl or any © entre ccctabate qk ancl no user, can acee then tematasr ther olatererse Faith , ton the a el Transacetoral echo tours “They one doused fato three cotagories: tranaatktons, they O stake ¢ the values are tdeal) 2 Bamelyremic (gore times fe moy YOY) B) Dyneumie C HL easttt conttnuctly vory) 4a table contains the noOf trarsacttons: + Mt shows toe akoot tmee catagores Conntate! these are Erciorddeal trernsaclston: fo tkeTOPIC: DATE: ne au the abax table AhowS that bansathion 7 da State bemmiacton: tranakion % cos a dynamic Lansaction. p databace ray contata the clolloastng percentage of baniactions Engide ets Seakve —— Go- 107. Eamtdynamte — 20-207. Oynarnce _ 5-104 Hence, one 5-107, of tables axe sunning over the datakase- pre} * tne sernatatng alt ove Supporting tm these tables. nixo, conewizs an example, a tablespace astth contatn the clotabay. the different WockSeees alto exSES fq the clynamntec cablespace, | Gernlayyncw nie talhespace elc: \ Qypaentic a aK areal Berk yntenteTOPIC: $8} diagram ‘for the “mblespase ™ yes | Ie pecfeustt) NO yes tactastt) I NO Yettonor + defostft: wegttle col H Smoltiile ” toga ifauett ueate Aer [Rectory avop Reackowte Coefautt) pea-tasespnces fermenaat fr ontre Coefeuutl) pAA_pATA_ FILES | Temporary Ly offline pan _ FREE-SPACE uneto pen TEMP PLES Gyh77 Startup Sys>> Stastup romeunt Database opened e oracle Chitance created gio? alter dataknee mount; Database Citered: Sys alter databace open; Potaboge alterect pe ve ment ay oe Spor dese v4 clatabase opr Seek naroe, dtd, open.rnace from v4}database; Naree resp” Open- mode pavers Rental te4g TOPIC: DATE: EPr7 dese. vd tritence | Jy th) Eytrr coletk Erstonee_nore, clots from up iratance; Onktance — naree gkatus postanest ope S77 dese xb datattle Gpr7 Seleck name, lett, Status from, vpctatattle; p77 dete ug teropile Syrr Select name, lett, sintus from vd temptiles apr? tee blog file a Sys? Selent: prember, Status from VS logfele; 8pr7 dese 4 controtfile- ApIY Bleck x4rom vy 4controtfile; Gry dese V$ tablespace ie? Maleck ame, test frome vp Lablaspace; Bys?7 ese Aba tablespaces Sp77 crotecks tablespace narne, Status, Contents -from dba—tablespaces ; Jbyrr A&C clba_data. files opr? Slack tablespace-name, félerame , autoexdenstble Fro dia-data-ftles; | 4pr> create tablespace t5| datafile Yoleska| oraciatal gowane/ ésrabt’ ste tom; Sybr> oleae abo. agersTOPIC: DATE: Spr? Gelece aSerename , defautt.eablespace from Aba-uses; \ Bprr acate user asert fdentified by a; aden ms paseo use erected: Sy?? Boleck ubernarne, default rcblespace from dba-users; fe .Syrr atter user uy default tablespace +51; user altered: i Byp? Belek username, aefaute tablespace from dba-uses; BYo>_greank connech, nesource t© wer; Grant Succededt by>y conn usenijuts uy Select afromn tab; No rows Seleckect+ Uy>>@ 7) ggiplas tclerno| clernoblet lud> Select Aforn tabs, ‘Tmame Tablype =. ~~ Bonus rable eer , oummy . emp ; SALE RADE ” >> Engert tnto errp seleck #-from a mp Ops 14 vows! croctteds i | 1TOPIC: DATE: open the new exndow copy: |Sysv7 ater tablespace +S! off Line; ray 77 Ensert ento emp Gdleck * from erep; qablespace offline Exror- [gs ater tablespace ESI onbire; —r uy >>/ ablecpace altered Be rows created: [ayo cuter tablespace 6} readonly; — tr? Seleee count) from erp; count CX) oan tayr ereake table tek (m rumber)} staublespace altered CRA o16yrs Error Oys>r Select tablespace. neme, status Prom clba tablespaces; [S487 alter Lableepace tsi read eorctes —» p> / Tablespace atterect: Table treated. Apr? Belect -fele name, ele tet, tablespace. name from dbaclate-\-ftles;, por alter tablespace 48) acd datatile \ cuakea/ oractatal paver? ktsa-dbf” Stee tom; (Syo> dese otha cata. files Gysr7 virck -fele name, fle_tel, bytes/roae Prom vihn.dota—files echere tablespace-name: TSI’; for rekwiey the datatile, S37 sitter atatabay datertile *{ettsiea/oraclata/powart? tsa-clbf’ reste Bisrah gg ng ToPI ptecel Bae 31 a por alka databay datetile 6 retze 6m; Opr7 beleck file name, -file-td, bytes|roae Prom dba-data-fies here tallespace-naroe = cms Spor oleae dha. tablespaces Byp77 geletk tablespace-name, block st2e from dbo_ tablespaces; ays Sho porcimeter db-ak- db-ak. cache-St2e re) ii Couble doz ak. cae. Stee ca Joraengt apperacte| product /tt+t-ol dbs, bul ente Porecte. $19.00 cltagnentie clea dlo—ak_ eeiche. Ste = 6r0 db - uK- cache- Size = 16rO 6y677 Bho pavameter dak. Narre Type value db-ak_ ache. Se. ° » Spor shut Urnmedtate Here tnttead of lem, we Sys? Stontup are getting 0° Gecause after fe crenging te poromelar coe mage Stortup again:co TOPIC: DATE: | | i | i 5477 sho powcuneter db-ak_cache- ntorne ype nobus btg integer torn Sy77 create xoblespace esate dlatatile ¢ ctiska/oradata) pawant] £S2kIr alot? St2e tom LoeKstte aI; db-ak- cache Stee Bpr> create tobespace teak datafile t deskaloradata} powoné] tstklr dbf? Sere tom Wocnstze 4K; Oyr? Select tablespace-name, bleck-8t2e from dba—tablespaces; Renarntig a olatertle or mautrg a datafile -flom ore ferakion & the another feaation. Gyr? create tablespace tammy datafile tdtdien (madata/pavantl tkmvt-dbf’ tea 5m; apr? detec filed, -Peh—narne from alba—data—fites exhee tablespace —rame= cTsmv?; féle-£p -ftle-name q Jautarcaloraceato/pavant) tarewe abt @ move grav) bo dikes, sce have to Offline tevblespace yor aber tablespace biry off dine; minty -p Jazsksforadatal paverly $ ot fasta foractata [pavart ; $ cp. smurf Jexcates/orcacterta |paven? g et [ctedK9) oraclatafpavont gu tart -ctlof $ cet gebeck le-reme, te td from dba data tiles cohese |” 4 t i 7 tablespam_ name = TSM ;TOPIC: DATE: Here the cftlepath &% cleska dyszr alles. tablespace tamy rename dakerfite . [etcakca] oraata pavanc] ernviclbF , to «peesres] orca} pavont | Lorna YB? Select filename, -ftletd from dba-data files chew falblegpacename = ese’; Fite-name Ate. tet Jetcake2] ovctatay/ pavondt exenvi-abh q Revétng a claterfite, co tent datarile Orr creatz tablespat */acake fovadata/parsant] eestt-bF” Size Bm; p tablespace testy // Deletes tablespaces but not flee ayer bro} gcd towsica] oraclata] pavont ous testa - > 7 apr? erectte tablespace esverte clatafite. ¢ /auAks/ oradatal paveart/ testidbf’ tmelucdcng reuse yor drop tablespace esreeuee contents cand ctatafites; fod pacayee] oracterta/ parson! au “ot not test ele andled, - dyn beteet Unbledpce-name Be om dba. table §pacessTOPIC: Cser|: Rote} profile Management] scherna mot DATE: QS-aul: createng a btefile tablespace, yf? create begaete cablespace bats claterftte * fatsko/ orciclatoy poweant/ begttt-abp? Slte toms a7 Seleck tablespace-name , beg ttle -from etba. tablespaces; Bpor delece Pile. tol filename, autoententible from dba—cata. files; Ayr culker tablespace begs autoextend ony Byor abter tablespace begs rerame to bit; COSER- TAN AGEMENT COKER SeHEMA +L + crecites sabes ¢onncelcl wgcens by HOG pee Byronyas objects » eottertton of ther sbyect! Grates the ase-gchma- Sheer deagpamn or the User meenagernent385 TOPIC: DATE: faucng on the cabagories of usert applin oxotnet must crealé grant privélages: rqrant wat m < tnamer to mgr too Gnttead of gheery, mutteple times, provelages Orerele cleveloyped Rete prewetages oe System preucleges > cbjece prowileger We can creatt a rote wring rgrant $.0,d to mgt; Cy Rote rgrant mgr eo Mt; : Ly Managet OP coe clelete ce privétege from crete, then att the rmnages tobe alveaet ntedt the role atl bose that nusdles 4 oe panty Grant Vo—vemnp Grant Uo —remp 0 can xeucke cotthopont Lox pee ate hay gaeint eornmanct sothgrent 0, thaalrnita etthoelrin o : com aut the other ” vo - ee ; 8 aa cxsers by exteng ‘cuneate’ ey catencles So, J tak GOO wtthactmén 03 tatthypant. 03 seve. U Skéte ek have the perncirton eattherap 4 up rust yeuoke From 0a aswell 03" profile: H Ha cornbiration of rexpurces: WAuclly the vehounces O- oie Hemory Zio anc cpor < Merron ‘od kernal leuel recoences Y Pausecend level resources a ween A pokite (defowtt) hat ereattt at rsnning Tea tacit34 TOPIC: DATE: othe aeracvantage on ueing default prot c& unt has ait preutlege to uke resources + Doo ell'vedhite thee priutleges by creating priettegert vextrteted) to the profile net altocaite £4 to ute duthenttcation the cuthenttcatton & at three levels. abhevdt = dathonHlecteton Ee Nho Leuct- 4H user created at dbleel G legged alevectly Cato db then thet t& cblevel authentioatton- These are enteanal userks lp Tf user erealicel at a/5 Level then tho axe exteznal asec. yorecte ue folenttfred, externally ; we dome uselt may connect at nfia evel {. etba coant autgn op, System: privileges to the mormad unsnamety Uy or Dy Oracle attoces only exken the wa contarin 2 passeoore at Ovaek home levels oRacle. HOME? Cwapeoct Sar ctvagram for authenkrcatton: create Nieq|deathenttcatton, a privileges petautt | | efor mera to prtlges cenrdatined <— ones see a feet, [ee or) (ee poseond.tonitt Requiargeles dba-rcle — Ppaba- tab-privs es. : tS “ Serton. ele fy Secton- prvs [y furer- resourre cents a + SeTOPIC: . DATE: peop tTt et Derno on eet Management! Gyprr Eelece eugername) default tablesace > account Stabs from alba. users; Sys? create eigen etgead éolenttfied! by Ua; apr? conn cteera/uas Exor laytry quant connect, Yesource te eserds sr conn cusa.a/ua}; tugyy celece aefrom Geprton- priv; tarp select from tab; tar? creals table teat (n namber); lego> create table beatin number) tablespace Syxtem; lags? create table tecta(n ntumber) tablespace Ay; lugr7 conn at Byctbas usr? Selee # from. SeHlon_prines~ p77 yevata cantéméted tablespace from ga; Revoter duceccted bps7r_ conn crerafuas ug eats Eable texts Cn nesaber) tablespace &SI; error ore - 01536: Space quot Alege Enger B= Quotes a. exceccled for tablespace "TsV ta>7 gn Selene atrom ager-Us - quotas; wary conn (ai Bysctbo. aga gna quote luntemeted on wnedata; por aber yr UI et HEL ta 4m on cuudata; oa u+ 38 TOPIC: BME Lee. agooo: The cement ¢.tockad.. “ww Tek Tew. : Bp clade “olka-t4 quotas; Gyirr Gel from dba-ts- quotas cohen cauname: ‘useye’s he eter yedowce limit; ~ Qos 8527 Aho pavarneter vesouce mn ] apr boleck from tba profiles; oxigen’ / parnss yray> conn (os dysotbo. aporeeeet whernairoe fro 4 cot ORACLE HOMEe/ahs $B We Rate ZORACLE. SID-OA 5 abo-userc; db-uk. cache. Gites 16m dyr grant Spt BP, redcurte— Limée= true E108: ORA-OFD4; : Byp77 Joe ora ona ded apr7 abo parcels ayer Bhat eenmectiolt Aemote- Logtn- psc for orci enttance Sorted da toeglopptoratl prod ayy sho. pewameter resource -eenté sg orapeat yr? create profile teatprot ernie dorapad. dite = orapwp ORAELE-SO . powucocrel Bs dfatled- login. atterepts 2 We i Ghie_ties 60 <-> rept pawanlal-—- porter. locktime Yaa 5 dot Ayr Seleee from ctba.-profiles; os Appr celett sefom wudpeofe Byrr alter era user prot teatprof; ae Syor grant. Ayla, Syopa tous ayer conn useas/al; eorong by77 conn usaaluss Wrong opr? conn = wsng/us; reat ps7z conn userifut ax Byollas Opry cele st-trom wg pofile uses: uname S08 typ dy4hs tu onal ee dale 'D Byr? conn unealey Eror—————————————— r + . TOPIC: pure: ny || } Syor elect wuuname, acccunt satus fiom dka-users; i gyor oltre sein account unlock; to | aps conn auraluas | Jiuasr com fot ayisbas | Sysz7 creas vole tentrctes | Syirr Selec efron tte echore. table.rame Otte © /ROLET.’; bprr grant croati table, creat uces £0 testrate; | byz7 grant tentrate tD cecud} | apr gore exeodi Frdlen to UsAs} f Ayer evoke erect eceble from testrate; ays >y revoke create enctex eo) URLs |ypior create rete 29; hytor grant texte to va) as Demo to crea an extianol emo DB 1 ON = i | Spor ho pesaenela 0s. Pores stetng: ops 4 | Alot poe trea Userd-at of, levels So ale the value to nul Arte JORACLE. Home| dbs] Intt § OROCLE. SIO Ora, | 08. authent_prefte >"? contrat -ftled = /cltak2/oradatal portant feonbrete [Oysr7 dtcotup pre; | apo Aho porcimeker OS- qunthent. uname gdenttfed excternatlys ojs, texed ume = pomasyn Spr erect usr Ut pry quant connect, yexource ko prumasyiav,TOPIC : Storage Management DATE: g7-Aud- STORAGE MANAGEMENT pace demanding objedt® tn oracle ave Knocon at ‘Segments’. # One Gagrment can only be created fn ont TS* je ont TS coin Suppost ent or Move ontform: AU the extents ase of ands etme domebione « outs > the ete of. the Met diependk becomes bigge clon! the. Deb. of the based on gree F tdidle dynamecatly # Mont ensures no pace iNaxtage as ieven cohen coe drop a fableTOPIC: 9. on the extent? axe noto becoming ‘best-fit? for another Segerenti extents: T) Borer en. tern 18: TPettntevon pata. OME non Byte 78 ae t robes Eero oe > Gnctex RBS| orco Segments * Temp segments clusters dipres tr & Define only objettt ae ayeernt> p> wecews, sauder ete: They stores ad ovacle genet objeus axe. PAYPOMY™S — tr Gyxtern TS « Becoueee wrajosly of #20 type Spae ia they one auynearnte: thee demewcting objects. there TP ore ‘are the dynaeric objets qndtucelucelty cattelas |, pots alitecntions that ave. nob ba. Thes cortatns the . permenant: definttion ancl data. The defin & gtorect én dysterrits. ancl lata tn Gg NontystemnTss [Seer] —gonstaset} rhe abox pletortat representatfon elle tha ont Eeroer roy containg the rmaittqple databases: Ont datebas jmuttiple talblespaaes and one tablespace roy | CoB contaga multtple degments + One tablespac conten databateftted+ Strntltarly ont segment & antain meq made of rnuteple extenté and ont extent (4 madle up of ‘K sorante Hock: contiquow aneestst co a oOTopic: ° DATE: 43 on conatetertag est these extenty mea tually, the data of there Segments are Atoredt Ot, v-at abe lett eu gener 1 EL ALE! ee eee schon the datafile completed ftedup » tna datafile | as.abh drat ao (seqirent” emp ray contain }Sattered (8 oo date. to mutetple datotiles: Bub, = = thew cotateles musk contatned @*% Et the Same tablespace: So that thak ons ridley task 6 we go ett space attecation for the table Seqenent+ Gut ee can define the length on conttdertng, nt. Cdoxrage Reealangth) — 16° cbyted Norof Recarels|pay — ~ I0? ete ao nobes Gnexterts Coys] Month working eee ney onthe bee Reorg - 3-4 month toro be sere amply = piers also ce Hue Lake average weolength & — 1200 bytes are the no-of recor to be F dlewy t& (2,000 secords anol the osorking dort tn fngertect per reorgantenton é ts aa days antl the rnontht, be teen mebS Aba ott altecates the month tak time, DSA COyNamLe Space reemels may presence: 6 that at ent for the Game segqrnent: aktecatton) oxit creates another ext of extents deperclon€ of dia. te ke can extent: the detloning Ayrtax ge aoa a estaba con aeak the extent by the creatton enentton the &f2e of debi cediription tat uitng the Storage povametors:44 TOPIC: DATE. Gf DL and Og, ove department Deferntt storage tables ancl they ove. dropped! then we conte x table & the holes by getng tae tok Cotarbirgettnt) code os * F tok 16K (OK ok DOK tok (Next upeming prey s extent) & OF & & & Storage parceneker * Fncttal extent Yo Nerl extent tl Min epkent A Crust contain , cont ru extent) lw Wo extent tal Cmax ettent aan be any Qe) E v percentage Oy. tthe percenbye ciecte toble x er eet tocreos) toxteant per vel Seat enh extent) SPLIT took on crcl Askignmnené OF the Storage parameter: N took table * tin 2); _ put sok N toe Ren )s the toroge pouameters can ke avtgned by the tablecrentor (2, tablecwator pas the cost preference wo atcign. the Storage poxcunotek. f} Cre tableerecitor eC not atetgnect, then a ge att cede Storage dpace gen by 080 at tablespace loved. or f there & no “tablespace leek then the default Storage Spoce. 4 avetgned by oracle eteelf:ToPIC: deco Management DATE: of ~Tut i St the table require goto” ci —i gextents qask tmage space: then 2) @ create gable x Sp CF took Er et N took @ (or) ee i ee here initial eaten tesco. $01) extent mance FoRranser tattead of 7entent onartng the sextents the perfor! ether: Buty Go en contdelertng cotth this example the cohen yeu conacolek. xt th goo then Cf we chen there oceans very huge memory loi 60, ‘ones That means 6 Hoxks ave enough: forat oa. 0h b constder the fit one woe go aeth the Secone} cohen conddoler Orackiat veraton the DM (Defense) crack et dicktonawry rronagement” becomes ah > LM Coptronal) ent, dtefaate arel cevaly rene ovate af 19-7 2M CDotautt) becomes as eptvonal: SW or coptionat EemAlory from oracle ai-3 the focatly momagement becomes at dlefantt anc dfetfonary management become opttonol: ur (oat wee oN eeAet wee NY OOS cohen “ewe conecelen ve por the felon, wt _ daterles, then at und | + Heche the dobefels woe SN tia GF cortatne Basen mpd | rarer and the ng the Mnformatfon about the extent! of the rexk: 22btt contal can be awatteble ta the emetttple Cegeronts: Prd ao deqprent datalbblecks46 TOPIC: Bare Aocally manage tablespace, te focal rronogement, offers 400 chotees: they ome w) onteode Cuntform) eo duto- Gm toca rraragement the data & stored ta bitmaps: - Gr enienset pecording to unicode, the aa One Segment. extents that are created ax unfform fa Spaces to eben —7 5K = toot am POL SL —r a5 extenls—9 200K —r Sernt pyrarmte > 5 + sook-1MB- > byreunte Gn the akoc representation, conetdes thal a cegrrent contain yoy. F Static colarnns and Sol. ave being actsie emery moment + then che clba cas abteca.ting abextents of St2e Sok- 100k pnd ag artents atth wok and § extent oth Soot- IMG Juntcodle method can be used that exch and eer} extents om raw extent « ‘the untforro extent should have a unique storage value, Itt chopped than ar’ can select the pest hte for the Gudwtor On ausko the tneremanté gost on Sap automatically anol ta occ by rranage- Rerorxe Ky ment lta i stored fn bttrreps. reason tg Sratenst of ogee ef eur 7 sp 5 fam 68 \ uaa 4 -100k ™ N - took mar S mat - 6 pi OhTOPIC: . 7 ATE: Spr7 startup It Demo on sto! management gyrr dese dha tablespaces; ayor select tablespace-rame, extent. rnanagement , status Prom dba-tablespaces ; ayr creoke teblespace dmist doteffle Cfoutaka] orcrclatal pavant/clmtst: dbf’ Sve 1om extent maragement deebtorany; qablespace created: tateepace name, extent- agement, status Bys>7 Select ener fiom dea. cablespaces j Cadtgabentent, Mext. extent, racr- extents mrax-extents, aches tablespace - name = epense’s pyr? grant connett, Tesource to dm fdenttfted by dm; mts; ay Bys77 conn dma; pM>> @? [eqeplus! derno|denip’d poetry geleck #4tere tab; privy cexke tate test (name agorchar 2C10)5 pm? dese user-tables OM getect Facktal- extent, next extent, min. extents max. extentS gck-fncrease fiorn diene tattespaces USer- tables eshere table-name= ‘651%; oy create “table zestiCn nuenberti)) Storage ! (fatto) BOK next Gok minertents 2 mayextents 20 get trerease 40);48 TOPIC : ; . nae Opry extace enettal-exkent , next extent, min extents, reprn—extentt, pct — (crease from user-tables asbere able narne = STESTI’; DM >> Sone ory ' ANGE: scum car omplonty Gysr> ‘weabe tatlespace damis> datafile /aesks Jorectotey pavantairnisa tbh’ Se lom i pitent management ditcetorory clefaute storage ental took, next took pet [eerease 60); Fable ince createdt: eel Bysr7 vokeck ence oe extenls, pet -frerease form clba-tables paces shere tavblegpace- name = ¢ pettsa’; By esc. aba extentt; Bry orteck Gog ment-nare, extent.fd , Péte- fol , Mock ed, or? itestioat leeks from dba-extents eahere owner ce. teaablespace-name, extent. management , givens gppee. rronogement ror ctlbo.-talolespaces; Megratng the IM t DM & uccevetas Sper Bys7e eke dems gpace-acienia; Bgre exe lens. pace adtentn . tablespace-mégeati-to, local ¢‘prarsi PLE procaine guccerttalty ceveplete Sypr? getece teablespace -naree, extent. rmancgernent, daqmnant Space— tT managemene foro dea tablespaces;TOPIC: 49 DATE: ® cohile ratte 3 méyrating a tecatly rranaged tablespace to cécttoreary managed tablespace the Segment dpace rnust be ‘rnanual! By2r exec. alms. Space -actentn, tablespace. méqrate. from. toca} ¢*oNrs!; PUI SQL procedure Successfully completed: S487 Gated tallespace-namne, extent-management , Segrnent— Space rrainagernene fOM. ctoa_ tablespaces; tee_cactrnta: tablespace - megrete ~ from decal 181); ayer ete allot Sf Sy1ort ORA -10616 Byer ert ore tals Spr? crete tablespace Arms datafile ¢ fakcaka/ oradatal povani{amesto: Geqreent. Space management morals qreublespace created Byir7 create: tablespace Ornan€ ¢[cteaisaforaciatay, poreerntf Bere aablespace creabedt- Sysre_ cereale tablespace amts3 datafile canilents3-albF! Sree Am extent dbf? S@e ero datafile inf etlf? Sie 8m uniform Bre 2ok; € (etek aloradatal pare’ amnev nt deckfonard ; gyre otter tablespace dents3 temporary ents pererdoents 877 alter tablespare ot50} ToPIC: Onde Management DATE: 2&-—tud FoUkacs/oRdo? Pefore af oracke cses the voll back taldespace to unio the OML bancosetons arelo.. tablespace arnclo ~ morneuerrent: = auto/rrenual - js Manual resembles that ce are manually roilloaening ord auto t2llé thak auto rellback- Palllooek: Oreielr curtomatccdly erealis a tablespace for the seileoek -roarnely Syrtero + Defouttly the Sister status ¢s* online” and oracle rot Auppoats non Systero users te <> enter dais tntp the System: Here tn example graek. ccont “apport uj, uastg b> enter daa A Yoke the Syste: ey Budys coe yrinet howe atleast ont rollbocKSegment Eee pas» Kase, RBSS,-+~ are these are Stored ak RoitborkSeqg mente tartegace (RBSTS): By default these RAS! cave Soffiea’. 9 Pepensléng upon the Site of bansackon arcl conturrenk PML operations we deftna the Stte of RBS amet het many Ree's ae created on conelertag eth yotlbaek Segment we abo spetily the storage pownrnebers: ee arn exten — 2 Cat Least 2 ragexes) pe rerease — X (not applicable) vod ge neetoly tntroctucect for RBI'S:c 51 TOPIC: DATE: Rast Rese RBsa are the Ubree rollback Segment toe contécler from RBSES: Here ent (3 the First conndelek, nransackion Send to RBS! ard required RESTS —r 10RD extent (nereae upto 60M and \ ended and tx2 entered then ora. extent meuy contata mony the Bystern Genel be tka for locks: ore. Hout pasr for ‘head balenetng’. os" foo ~& o ne, ‘g Se x Hers only 0: RBS -RBS2 RBS on ad TREE ROSS trankottton Gut, = = a multiple frontal ™ en TRB ey en SOS wcres equa QUES con be Mecte, TRY TKS TK OM ‘sont 40 — en ont extent _ ay corrept doadt go uth gxte of tran acctton: TE vei completes bangatk’on tom for 1x3- But, tere dood balonetng only go ust n0+OF ok GoM and TH OM f brankacetons* th zom then thee @& oMy as vequeres 40m 40 the trangacttod 1X3 yaust be completed yettbatk and LfaKs letes successtutly ord ef TRY ceturs then boted on te to QBS! ond ther compl Joel balanecag Tee go exth RBS: xtoble én BSI before THY and bat there 3 som space OM ce, ated. paa rant allocate ehat free space to other Rass weeny + optimal Srre’te another he mortmum ettentton of the Ras atlac: Sretak RBI by h tonter Mosk Gees Means tI 16 reffered to a4 Kégh eoater madi Bre: Gn the abo example, any of three Ress oy reach fo, dba olucays Keep an eye O° rottbock Segenent5" oseign a brangaunon geile Geqrnent” hegheoata mask gee a4 (OOM: high coales mask Bre of the eae con, tat 4. Seki trangaetton’ command peottoalat: geftbock: Syments- eensTOPIC: DATE: fa tansaskfon, regutres torn then We Can arreekty -go cuith RES the Res's have cotlowtng status — ondine CMake ot onkin meneeatty) — off tre (Dofeute) — Prcleng offline (echen tury bx (4 executing, andl oe ED offttne then ¢& cook upto Curr tx done ak Uk tyme Status o pensting offline TF cure bx ect completed then market 1S opfatneS, > St Ofre, we are cratid a Segment and Engerted rorecoxels & eadthout commet] yotloack, f we make the tablespace offline ancl tomnowoto cf we made online then the gata are maintained iq that Aegment Because Oracle Enternalty acolis a Deferred| Rottkack Seginent’ to done these T!s- Onclo: Avactable deature from qt: undo- terblespace. tundo~ mana: &= auto ephenave. cae creat an tundotbs’ chan Oradks tnkernally creates to undo Sagmenkt af rolthacke Saqenentt: Once ore have creat uretotbs there oundo deginents ave En conden oss ysto annigt bs. Gm reithacte Segments the transactfon alteration tatees octet balancing . mE én undo mack éeself allocates the tx to any of thee 6 he esto te ando sequen’ .. we OF 7 ik s+ dcr “oceate , then th con be -tattiabeses)) any of those 10 undoSegments:53 TOPIC: DATE: Of tankactton 1x2 attlorated to undosegment q ond that Epxe eeok not enough for Te: then oral qutomattentty / ayrerntcally allocate the dont feaniastion Sxymente Space to + not current: ancloaegmnent q. Thed coos the betta qeature fa uncloths and endo degmentt do, completely éxs HE ecercomep finesh thule brangaatton [BREEAM 51 VIO oso eee andotbs EN eS undo- Kekentton= qoo See Thea (4 the me Enevhtch + atte, ct brangnetfon hax beenclore: Undoblockg have afferent status, 7 febive piece L—> froekve onexptred pred: L,the active status 4afd thak those blocks ave perforeneng Serpe barvoction curently enceente. needle a4 nor ja Grockice Status means the BAnsckTOn GER caropietect and} thy ce rrexintareg the ‘tetentfon time: “guarantee! the retenttontime: text the retentiontimne, the commited & From orack to exe have 00 optton to Buk upto at there tt poguenantes? &o meetin’ Gn thts canexptred skatas ee eww can rottback banaattfon = knocon O4 edtac hboete”. $ After the retentfon bie the expeed status oat Onur’ Gt 0 ech ceuuns eben Oretle go edth Exptred datablort 7 Eoaucktve datallorks54 se Topic: FB-Qry8 PB-Tableg FR-Verston @y parE: AB -FuL ora. (6655 Snapshort —r tocratd- we asi eUnY thts error coe oe conker A fromm exp a clatabace (4) oxth 2 users Uy and Or OF 4 eae tor going on treinsarcefon on ancl On & th gnothe wser. asks O vequest Gt that time we have yok epelated the ) ak Borne etd tee’ shan the © Eranawhbn emp yetentton noguewan! in wen though amp Us become ot usp Snapshot so that we tte -toage So ‘trok the sheet enor’ we con cuucome the ero Py orginat data coat not: Yekentfon guarantee: dound at S&A nor unelo- THE Flash Back: Oded to retlbaci the committed Bongaction- Query) lasbloacks Merargon query een ate Trangeevon | 102 + va ge noone 200 ie eg eof Ee Orop table ea gee eo Canines hon ON ME ata, cachine (#3) Peg OF te ‘me conditions that Support flashback wensattton: 9 endo yranagernent @ Retention time DS User fetion muse be active ete MAlosh husk quent tbe Gey ehith how been dene and cormrnited con be soltincked exth the help of Roanbork query: £4: Geleak. & from emp; debt emp, Comraitc; setore & err +05 TOPIC: DATE: ~ Alodh book veraton query extag dlashbaek verwton quey we Ge the tod updetid dato and thts help en the flashbauk trans Posh baste borgastont fh dlosh back vation wey the data epolatia Emutransously by the uur ancl then we can gee the required dangackton rettbacking using the “trangautton td? every bomeathen taftt have a urigee brantoutton td: fash back deep table: Droplng a. table can he of & type” 9 Dvop table test; 3) DIOP table test! purge; Th the dit cau the gable may be droppect bub ge ext 0 the reryele bea: ore coin robe tk by weeng the veeyeluben ta. Aftes, powxaloss ako the table be th yeuytiabln- Bab using purgt the star atagraro for Ue undo regnagement: oes perearasntly Flashback Rotthace Defoute React cons borey: Keep Mhatance Reccxxry » Recycle create ros a pte alla tablespaces Prop olba-roll bexck segs. Glock Slabs sapurdostart | Ly eonuserd endo. Management aprotistat fx Ackve ese Lr Exptved undo_-tablespace undo —vekenton- L, urexptred.56 DATE: onda Management? 3 ayer Biro poromneber sptte aca Joraenglopp] evasts! prosuee [1 -0/ dbs S rm Spftleponantarore Byer su tenmedtale gpor otort up: Byp>7 oho parameter endo— undo~ ranagernent crepange 1° Bpr7 shat trarmedtole $ cel jorcengfappl oradsfproauee [tt rol ahs Bh tees ORACLE -SID-O1O alo. management = rranual sang eye? Stostap per Aro orameber ando- wmvlo. snanagetnent string Spr dese ‘iba. yolLback. 098 A pr Seleat ceqreenk— race, eablespace-naine » aint fore dbo. rollbciet. 2e955 mania pare 3100.00.90ayer galect usernaree from dba-uses; Gprr conn usere/ua; Uary elec from tab} 77 @ Yoqy Jes [derno| cermobsd ret completes: Soycranes ardo- sap ugrr Engert —nto emp geteck #frore ernp; Brvor ORD -01552 tay conn (as bysetba By? create rollback Segment abst; by? Seleck degmenk —narne, Spry alka. reltbae Segment 2b6I ontene; gyrr conn userlua; unye tngert Cato emp elect a from emp), 27 rdiiback; x77 conn [ad Bysdba- yor ed voll sgt geleck arnarme , bs Kacks , b: extents) bestabs from vs yottnarne ayvt Quan: b-U49} Anatier extedowo ut>r elec ¥ froro emp; vier fosert ento dept Select (97 rell backs; status from dba- retlback - segs; beworaps , b- r6st2e, br opt inie,, roistat b eobere38 TG ToPIC: DATE: Bpp>7 ‘altes. rottback Segrnent rbst Storage (optimal took); Byr> get rott Bprr @ voll Spor dese ug vollstat Bprr Geleck stabas, optstze, hwomscee from v$ rotlatets Status opefiae, HmsiZe onkine 10496 51344 yor alker rottback Segment abi shrink to: (ook; Anghercotggeo: cz ent ck fysor alter rollback Segment 2681 often, wo as Select: gror cept Poitlenck’ deqment attered: a7] yr Al from vdrclktat; uz? | Stabe: a o/ pENDIn: oF exgneTOPIC: Orme Gyrx alter rettbaa geqment rbSt ontint; Syor selete states from vgratl4tat; Sys rr CER tablespace TH of flier JSy>7 Selec Segment rome, Segment type fromm ba._.segrnents cobere Segment Pe ike *7, DEFT’; ay?? cot segment — name for ag 8,77 / Seqrant— Name Segrrent— by pe {20219 PEFERRED ROLLBACK60 Toric: Nebeorking aft orcebe Ug DATE: 30 och Nlekcortting sotth omele: » vpn vg ce supported. ondy host basil computing (Ufing clamp terminals) CBoth application and 0B retideS on the Same Suver) \ le From vteratone ct Atartecl Supporting ebfent [Server computing - Coclint & Sewer are connected ua Ant) RB From oroekal tk supported browser bosed technology Cyan 6 Supported at orashe “kernel Level) Jove foot & asleted to Saf: Grom version® through gt CE Auppor ting qoltoeng protocat Teplop 2» SpxISPX Crowes protoeet) Jd) Welaved Cmteroso}t protocst) & From orackat tt only Supports srepisp as grandiard protocot: & Ak the time of oracle bo potreot aclipte for erep itp protect ie Woe reed to define ce abies Leatner En 40-41 nekcork/actrniry We became endlushes, katlatfon, we need to choose orack rio Beatners ora. ( ASEE -fete)- w hth daftntng the laine coe need to mentfon ) Bétner nome D Kok of SIDS 3 protocet Creplip) YQ Fort number (1581 69 the defautt post number) A Gated on the requirement, tee, con howe mutttple Listners, Buk, vnunt use “unique ‘pork nawnbers: Gnd Lestnes con atppont muttiple: tastarces:e kixeney ond tnatarte need not I follow any portteulor dequerne- etther tk Atartup or Stoppenge le We need to rronually bart the Lictner weeng dotlowtng cre} 4 fanreth Store Cstoxts att Asters defense tn the Lestner- ora) B tanretl stort S61 C stonts Lstne mared L641 only) & ssnreel ASNRCTL? help skort stop Serueces debug - - - processes that Reload = satus ~~ - ave ruantng in Deserers Wortstng otth dgtnerts Neptune (saxxanar)62 TOPIC: DATE: conatdler a client Caccount detabax) requesting hee, account Prom the accountng database: Then the cliente veust go through the titres to conresk aftr the Seust neptune: es\ peng pteptune x Error: Neptune t4 ondettned--A) Ci coer \hosts|- - epoca cil ping Neptune * Erort hleptune & unreachable xl Ping Aeptune Gompartog Luter ith telephone department how corxcle © po =f +S ; Reeratons 484 eats coming up more than add & meus eperator) Repatme ben oa Manager 7 . Water raking Sebtings the phone 9 Ring Peng Hagip & peng activates: 2) apes Aekcenery Ja) GF the ‘operator & not thee & ee Sotebas taeensr esos not avatlakle.. eee Speirs) aiteniee fs) Torn gone to kunth G databate &) Tom-Rejeatd e no SH. tor thak RND- aie Catt cation toiled ey Torn. ayers call G the aor & 5) Mgr nol Ltrerer. etparot howe nok outhenttcalad « Erctereah | seyvien honaller for 5) tor nok entrant @ Lextner hose RNIDTOPIC: Severtde contiguration Nn cet 4 0-4 (rehwork/adenin. Ja) cp Ltatner- ora. ~ 2) NE sbash- profile export TNS. ADMINS $ HOME + bash profile: ue Ustnerora ¢) Lestner name Host name of Server fr) 1P dddvess (it) port number wy Sto 5) Lanrckl Stost r dese dbo tablespaces; |oyso7 select: tablespace-rame, retention From dba tablespaces; lapz7 eat toblespace-name 035) Bpr2 Byrr cent iables pace andetbst dataftle © [desk foradatas ponent ( erdlotiosi-dbf? Stte Am, Spr aller catobase lags dacp © espace ureloues tretucting content and datakles , S77 ceo undo tablespace tandoths ctatafile ee i ; [dso 2 Joreaterta ppovant{ undotbsl+ lbp? Sexe-Am;, Lo —netdemrnaenemmaceear OreTOPIC: DATE: Bp>7 eeleck Seq) gpr7 cot tablespace. nome for a3) frome diba-rotlback- Seq; Byer create nde tablespoce yekentton quorantes; 877 syrr alter tablespace alte, tables pase andoths! is Ber? vp Bprr Select from table 5 conn sett [ary Baer OCAI?7 eeletk cl eowrr? togere tn awry J avai >?/ user? grant eelete oP emp to 086125 wggetr? coon asesatuas usera7y edetk 2 from ubemp; anni pISS5: ‘Snapshot too ee fh 1 ge Ampshat ener gc! mim Oe of “eaeateaforadata] pewont| andotbsr-dbt’ galeck Lablespace-narne, pokenttoo fi Jaen joble rusk contain thousand’ of | By7r alter Systern Set undo-tablespace= undlotbs!; ment. name, Status from dioa.rotlbartt-Segs, Sysr? Selec Segrnent— name, Status, tablespace _narne undothsa datafile sie 2r0 corn allen. tables pones ; undotbs! sxetentfon quarantees vekentton noguavantees cunts) rom KakSEmP; to emp plese # from emp pngther ternsrol Bys77_c00° asers]ur; ugeraz> conn vseriUt userioy ed top beget leop cohen, update emp sek Sal =60° enama = '$cort’s connate; enol Loop; erels | | I | |66 TOPIC: DATE: ES weer 77 get loop usert 92 / fem (3 Flashback. Techostogy 0 Flos bau Query: userayr edlett b-froem emp} wserar7 delete emp; on Po use2rr commsty ten L GB —2|14405 sear? select % from emp as of tmeatamp dysctal pe usetayy tnéert ento emp Select + from emp oy as of timestamp. Sysdatt 314d UsU2>? commit, waar? geleck count) from emp; 2) flashback verston query userar? creati table CC Curr ‘worchora(20), volue number); userayz ersert into c values (* coro’, 45)5 wuserary commit; : : userazy updati c eet ualue= 44; | ugesa7? cormmte} asaazy updos ¢ Sek value= 6; usear77 commit; useIa77 Golece + from C; wena ack oratorsTopic: usera?7 4) Flaahback drop table: use277 geletk ¥ from tob; usesa>> elyop Lable testi; userar7 deop table teskay purges lusera>7 seteck # from tab; usera>7 Aho recyotibtn juserary floshbock table test! to before atop tenorne to tertrest, ugerar7 Select $form tab, etenedtamp miénvalue andl rroxwalue oF 3) Floxbbat 6? DATE: uuserarr gotec vesktorg- Storebrme, verétonkencttime, areritons- xed, versfons operation, wolue -foro userave ‘veravons bekuxeD rclerby wersons-staxtttmes preingarkton- ‘pnother cindo@ madd gysor qee veatoo apr? eet/ Byrr celedk undo-Sqb from Hosbkork — tranxockton..cpaery exhere, lez "1500060055000000’; trancackron Co cod J pnt von ne ayawe"s l4g? eobee Romp: *. 5 SAP commtt; 463 Topic: Bare: Berto op omc vehoorking. wahs3zain $ ed Loraeng! app ora} produce (1-0 nebsoowkctadmta) . adrnin$ 15 aarin$ cp aeather-orar” (een bdo corktgusation) admin $ cd 4 ME both. profile export “TRIS ADMIN = 4 HOKE export PATHE - $ . . bash-profile gd echo gorncte-sid 4 ut destener- ora. Notet To copy and paste the Lines Ldistorct) renome as copy “ie yy! or ey? or SN" apeiy” po range pavat= (oa 65000 oe i Cost = albnuai) (poRT = 4895) SID. Les. flow = (10 tame + gowns!)TOPIC: DATE: 69 4S dsnacet AsurcTLy help kgnigerly extt $ dsnrckh Stove poval Cetasteng, of a. Listener) she command cormpletedt Succesotutty $ cd toenglapplerack|prosturct: evo} nebsoork | actente) adming op esnames-ora, Chextener. Hele cordiequeatton) acd UC sbosh- profile deport ponte = expore TNS ADMIN 4 HOME 3.» bash- profile 4 ul erarames-o1 ALIAS yenorned o% t-paval = cnosr= dbaci) PORT = 1695) (sid = pawontar) § enspeng to-poval’ Ccheuis echethes the btxtenes 14 Pay or rob) 4 oplplus Giger Jul @ to-pova i use?70 TOPIC: DATE: dient /Server enytronment: with tn. ‘bash proxte onside payretl ol sp scottreger L Hoste ase) Lirecotey. » 4 o-sip ale 7 To FD D4 ep sie @ 10 meer amor, ci — cents re Atte oo Nept D % OPsir@ FN nee Logs — EN seplae way » Nekwork related bAuet ane ORA- aw EH w cleents feformation axe ak (/o.4/ netaork/ adminiiog- prom eotncloros cheent cchite evetng oracts frontend cient applications Cheee Fourns |sepor's) then ue Gon diredly use that defined allies: fp eshen eveteq non ovatk chient product, Gri dytplaw Bl crytal Weports otc we alt Neect configure ODBe deesatte atte Copen dota. cnnnedtrutty) data gource Name COSN) Start» kbing conteof pannel -» 32 btk oPBe admin —> cwate new BSN—x mention alfas Crrenttoned tA TNS neumevoin) — bere comesttutty Civans pind eAblasnayne> Coster g* the dommmandt ear cain tert)TOPIG: DATE: , [: mcagh S- Excel ewe can conneck through databas bit of read only " out nag- Excel—> Orkernaldate —r MS- Query -» OBBC —» Listner —y “AY payldle elazabase* ch tf we art mMg-access ue con modéfy db» ay best Support: the growth of a Seqrnent gatth the storage mgt M cae of om yecoramendé ot tO recornmencl Sp orth Arts of the ucrement t& takeD core by cracks USelt ane Space eg pe lo Gocoude of bactecare compatabéltty (ae) caus exer etth UM to? Hered SUL omepts the Storage porearnelin — to tbe exten ot 1) Pp CErtktal Oermand): cane}, then £0 would be wittal extent. Otherwise To -o oe cateudated - nok cone MoH extenkt dnd 51, hale Supporting, the 2D crate elem ; | nite offerteg the £0 the dastne growth © not ask for | ube Supplied 8p tnatendl | “taken bj orochs (leet72| Topic: potabase Links DATE: 3t-areah Using pakabase Lake tn. neboorkérg: sort 410 PF lg tenes Sour éapul ag a fs) jsewtor est tral TTT why e dient pay? ceatt 66 sine pap agrees, yeseate ablink Gelect From poysoll »/ pury ~ ow Bante x o por 8 « Bank@p2A v e Geleck from bal @ neape* tough cmap fb-100 | 100 Because conides the user had updated. auby -t00 got — groped dome information on. 50% — created the objackt then. thase upelaliat wr - ottered date. mukt be foken backup by the Sewers beg ‘tough work ~for the. dha: Pecasise, the ust updated: the dake fn the veraton 022+ Now, the dba. & coorting up wlth &3 veiton atth the neco ard the modified data & no dongek cworkirg yeraton: do, thak the tedious takk can be pvacomed by weeerg he copematte procedure:3 | oo east gunvters Soscngles cn the brorches ioere axound 80 Topic: Makertaussed weens(edth wv-togs) — pare: a -Tul ef Matentolesect Vevas conntles an example of us Heatth Cece projetts centers tag the O@LEnK & neboorteing eat Tepiap Seve-cao connect oft the cbfen cohfch ave ocalid at Afterent Centre. 30) yo PNY; , a Cee PNY 5 Head Quortes ae - g Los healer aw _-< ee et s "abe ae rereate pei 9s “pote --—Riyentuoyarn) os paket poo @LALNYS TTUTTT =~ tinke Sng spestattat oP 7 Select A Horo O-NY-SS; 7 e + paktent:— (0,000 4 100 ele Grorder to acces’ the data, dba must 58-t0q 7 100 _ te che names ett T wea he Creeks es outa ° ee Refrenh — compute nye m not a ta LS 7 the &jnor ge Gat Syrony ost a 2 ee hone Rh oma potater te the dtent Conatder the Sefrshs> ews at newyork This dower contains the dfaby epcotes, fo wiwo the dolly upalater at dos angles Save ‘dbo’ creates the inatextabtged tess. Noto foacang teh Sava coos acking of ebiont te qe the data from ny saver: This wrodetalited wituo gto the wien of the data at Saver Jo gee the detail: of the Sava (Nly) letangles Saver the clata shoula be refroghod the yerdreshment ove of type: complet refresh. tefiexhes ihe updolid dais and ot wellar previous clita: But, [feast rete! ony refresher ‘the updalliol data 4 plastng the oll f fr mexte: falter 09: ll Irath Nfpaebxen DBA DATE: OBLenks Grate dotabae kink Drop databate Atak peewelages TY create DB beak Ly create publte 98 tink Creat Motertaltied veuss, Pa AtkeL Maketalited wes? t rep Materabised veers dob - quence. processes privllegos Refresh options dba_muens <7 arate < uberernicdenss acl Complete Fast Force Refresh, Le Atter Le prop76 TOPIC: DATE: farce on Networking: jor giant Sypstertup Opr7 Geleck vSeroasme from clbo-usas; B77 grant ‘conneck; resource tp teak Cdenttfied by test; Spor conn teat( best best>r conn far Sysdbo. &pr7 grant ueate database Jeni wD tect; | Eys77 extt 2 5 gaps scotbl tiger@ to-porals Seok Sy exit: Syser conn est bese + connect wo Scotk tdenttfted by tiger ewrtng -t0-pavent”; eaky delet -F from enp@ toScott; ener 42SE 7 Geleck sehdon count (a) from arp@Lowott; for fn tests 7 create database kink tscotts b danwetl start paval, (Ttarttng Lesener ak Server B Endptrg . eotdleaeee to. pavers (1 Atavting ab chant 7 ager Qyszr startup Spor Selesk username. From alba users; gys7? grant connect, * yegounee “to Scot tclenttficd by SES Bprr conn Seotl beyers Scott? 2 / sqiplus [deroolaarro, Seotk77 Gelert *-from tabs LTOPIC: b ATE: Syhor exte 3 GAA (oroenglapplorouy/ product dbs 5 dsp we enitkg onacté-S10.08%° gietol-romes = False Saat 3s >7 Atartup lapzz Abo parameter global-names BB77 conn, teAt/ bee Lextsr geleck counts) 410 emp@sitott, eat? Gelect: from emp@ toscote> Sper gene treat. synonym tO test; Syr7 conn bese [bese test ry veal &ynonyro © for empOsote; teatrr elect Count Cx) tom es j teAtr7 drop table erp@tosett; | Eror: oRA-o2081+ PPL eperatfions ave nat atlewedt on « sernelt cobs | ore not poretbleon a vermte clettabn st Bypr? erate public databate teak pubsenk connect bo écott fclent third} by eeger wang & to -poval’s Syp>r7 conn eeae tests | pater Gale count(x) from emp@publTOPIC: DATE: —— Demo on Matertaleted \icewsi Gys>% gront creak matetalized yew to test; Bpr7 conn tedt[tedst, Sysete teat re create rrotertalzred ute empv wetresh complet with rootd Start uilth sydate nent Spdale + i204 60460) a elect # from emp@ trscott 84697 Sho poremeter Job-quere provesses§ conterme clefautt processes: We howe to rroncal dey chong, processes Supporting for refresh - 4 od (ormeng! apploratfproctect (rit-o/ Abs go ut ented oRActe- S10-071 globol-nomes = fore job. quene- processed 25 . 40g Bpr7 Sterbap force Spr? Aho paramebs Job- queue- processe ss; Ogre pe» ay cmiys bask bests 2 i | QDTOPIC: tesky Select # from emp; pk thes bere ompy ell w#resh alt the vecords tr. the dakoloare Seqrnent emp: taster eraate matertaized “Ce depty yedresb fast cxtth primary key kart extth SAdate newt sysstate+l(Caaseor 60 os aelect x from depe@eoxor 4 dort eortaio & Ertor: ORA — t20 primary Key test >?) Seok? ater tale dtp odd pkmany exror ora 23413 poattnce hawt a reatotaled keyt deptno) men otk 7 creole teste] enoitertabiged \ue1o log on dept; Matertaltsed weed creatao gotty select ¥-fror tabs, weak : mauocd.pepr TARE Sott7 (ngert tnto dept mabueds (60,'occdua She), Sent ensert Ento dep yatues( Go, ‘pay’, “erg)} geotk7 Select %-4rOr mLoab— DEPT 5 &obky commit;80 e} TOPIC: Contect fe and Redo-tog ragrat DATE: Aug! Cc ‘ teskrr geletk 4 foro cepts = origénal feefore commit o test v7 | pata moeltfied afta commrtt 7 SOLE? Select HHO OD wllLOad Pe no roea4 Selecfad- Gate et Redotoy ‘He engnequnert x fontrof ffle contatng the cruttal tntormatton of the db- bel ereakion timestarnp gk controtfila oa bendy HE @ db rome eghteh cannot be modified. 3 dbf -fianames § Locattont ne ¥ atthout a epnbobdt ee Reatot Locatcont: Lace fog ftnames G femtto con onty mount the database: 5: temp -ftlenames & Locations. E 4 conttrunsty Serverprccess 1 update se contrat fla: mautttplueteg of conte files! mle con matatatn at mex @ control “Ales ta our geroerpecess: Multtpluxtng deal ett rnakerg yeduvdont fete for contol -fle: a chee creating the db, ee con more yeckinclant aoples by quing paths. Shr modliftcertion of ont contd fele oll of feck ah ea othit redundant coples of control fea tth the help Of we process: a Sayer dataket i + Reatolog ARES cnc. cesllnd 08 grentps and ebeee gr@aps can be t able to tak quups only and faa group ak max 4, 0006: vrembers Con be available & a group: :Toric: a : 61 : DATE: cochtvetog wot oracté— # Suppose Uf we eoant t rename the database then we go © O-td and Enlks ORACLE-SIO-ore then change dotabae name R we startup force then tnstance rok opened) - Becoure contot dgtle wos Supporting the prewcour enxtorce: we toe cannok modtthy the conbet fete: But, =e) ge wthe beace, tk contatat Gyntox New 7 Atertap Gyr Belek Inttance-vorme from ng Cnatancds ae ; By>r chu tronnedtate ' Byrr ext $7 Atl, bosth_proftle ! i export ORACLE. SID= portanfneto ea B27. . bash profite 19 cet waengf app] ovat product [trt-ol bs dag Ib inti: povont ator. aps $ op nut ge tntepavantt: Oro enteg ORACLE SID Ora. abs 4 Fah Bybr7 Stortup SPP were tnatance-rame from sf fnslances powonireed § cd ~aengloppl oracke/ product it oldbs des $ trek patoncar ore. abs ed . 4 cad (dst) oradota] povans] atag] ra.bms /pavantetbTOPIC: DATE: $ ea latsea) evadlata) powant/etag) wclloms) pavoncae] prvanicus! 4 cd atsks)oredatey povont/ tag! sabes) paveantalb) poveninaso) act Ble 4) Renaming the agkabase: Br selet name Hom vg database; poventdb R77 Slortup aorounl teotfile tp trace; Bysr7 atter datobase backup cont apr che tmmedtate Byr7 extt $ cd lorena) are! pascuent creeks] produce tt-t-01 AHS ds $ vl Ente $ORACLE-SID OF do-name= need A | pavonialblpaventness/ (oUARD Loractata} pavand atfag| rales: wee abs $ oct poe ding Ban -bve powoninen0 010. 3456 tre} cont: tre Yet oa trace $ cd ' ae dino $14 brane 4 op6 TOPIC: ome g ul contitre fJereice of out contret fle 0Ge, Ceommant tD ctebfi: Lrus above the cuvior, goettton) Startup nomount: eae contetivte r select # from wdleqfite; Aatceng memba oa veclotog tile grep: [syor alter databowe ade logfile member t/atak a) oradate/ pavant! redotb: tog? to group’ 5 loyir7 ater databax add dogftle member “ Jaesna} oractatof powanif saddtb :Ley’ to group 2; Brrr aeleck +4rom vs toy, Bpr7 delete trom vdlogtile; Stabs wolf gmaud ‘Greoled 8p77 alter aptam Sottch dope; Sp7 beet # from vbtog, -- Skotud Aekere currant P77 alter dyttero Gutteh toytts; 8p? Galore HHO dog, sr Chass : ss SnoewveTOPIC : ape Addteg a group Creo) ays>7 olte. databose aad logfite group 3 « jacexajoracate] powant/ redclogae leg’ Size Srms pyor Sdek a4rom vA toy, Stabs unused rewdt be unused or Pneecel i proping the member en redatog fila (Rl arel ef 42 contatrn at Byrr Least woo members atte clatakose dyep -togftle rnamnber “to trop, 0 erernber » peasaea] oradatal pontani | 7ado (b> 0B por 9 yr? alin, dababo rename, Bpr7 alter detaase drop tog tile group 3 tfazaka) avasatalpavent/ Enabling drehtve flog Mode: redotb-boy’ “(aksloatee i eee L pavers] vedet bie} yer cnehtoc hoy Lists pedabor tog anode no onrehioe mode. Spyr shut Pmmodtale aprr ext ¢ aed PORPCLER Home| aby tnet ZORACLE, 91D > aigcpidle (dcsx2| Cradketal peacanil crxth © T1978. ARC” 7 “LTA VEEL S.] 2.ARe” $ sequenced neunber | c el thet coor casket tA loyften fq anchive let + eye enter dorm = : -tinertd curses a, TOPIC: DATE: Bmmdis -p° fatshajoractata] pavant/ awh 1 eys77 startup eee ae opr7 alta datakase archbetey; by}? alter dotakase pens Spor axchcee tog Ley: matabase log node Arehice rood. caveent log aaguerte 4 S27 alter Systero Guitteh loghles By? dece ud archivedl 009; spre Elect vere foro vg anche eal eno gprr atta Systerr Seurten logites epee once 400 <4 orhived- log; B7794 TOPIC: SpFele and OMF databaw DATE: pile: We ave ting a Hl named pltte cohich eat aan aSeit ele and stalte dite: GH we made any modttealtong axtthta thes porametes. qile we murt shut the database anel agen Ateatup Ed. fue to thts we. howe Enbrodutecl Spitle(seury perameter dele) . Both pdtle “and Aptéte adtt resddes en foractE Homeldds FO kreeo the current exeuubing porrameter file, “ung parameter ke can create pitle by uitng a pitle ax, > creatt spittle tem piitte; . Afta. creating the pile alt the etme che database startup otek only the spitle Bat to connt te open eutth pitte aoe ment smrentton the pathop that pile: diy 2 Atartup piles bgp the clatabase have both the pitle and éptile en the SORACCE- Homelabs , then orasle enatance ctortup detautely Storteup cove the dptile only: Hr Spttle tx o-* Guretbtnary ile! the pile can be manually edited bub apitle egak nok. vronuoly eoltted wwe Aeguire a! Seaees. prowess” & edit the dpiile- Ly there ave three saays & change the parameter “Kile: on tng the alin emand oe an cee? SY change the value of a parameter. ile ~ oth yabker Syste set = alter dyntern det cparameten>= create pttle from dpitle, One (Grose Hanaged £UeE): OME t oregenalty Sete tn fooreb- Boag time & Encreaces by teornb, Notet 2& can create a database by uatog ‘tooth: 2B clive Cdatabase contquration asttante): MR ta grapkical tool eohich con be usec) to eate a dotabase th astt Aupports in ate operating aysters ochech: cooxk& atth oracles Orath exork< on cotth 80 platfovres (on ols: Onell upto the om, utee only Spacthy the pathe for the conbo? -fllek and datafile Sek and naméng conventions But on oxtng oracte vmanaged félex, then Orade automaticatiy Spates these voluck: OM, only provitter Soru Convenience But , vat provides any deatures] performance > create ; Here ae inutlly erate Creates the taiblespmae echether wwe are rot mentiesting the path of the tablecpace G fllenameTOPIC: DATE: Gar toga soy pile and ent » gps mMesoyy a oa -_ | seepe [ Defauté Leal Won Narnd i ¥ i $ oRnceé.nomt/abs gptile -0ra 4) Pile: lot rf. %-oU-dbF | per eee «ser [raring Grventton }- —-[Forormeter lee lol- mf 4 O.cd | Contr ftte) ab ceate- file. dere lor_mnf_3q- 300 Contine reddlogs) Benefits All -Hilet St2e C4 (oomB Mininuen) - DBF’ axe autpextend on ee crealt - onibtar. fog 3 a sentog tes p23) Easter oracte Jet rogt: 1% {4 localty managed. Ease 3d Pasty application eategration.TOPIC: Dare: Demo on’ Spftle: (can be uealid af ary arate of- autance C¢e ett ro wr ho tos sottle; ‘or nernounk or mount oH paremet pte ope oe ow) name type tle i een <> Ef the value «ag empty, Spr create sptile from pitte; then enelanee cans pols Gele cereals « [9ysr cheat fereractate- spr Sareap \Sysv7 ho parameter Sptéles sprr shat fenrrediate- syry saxtp pitle = Jorceng| opploracts pro. lop77 saxtup forces sp77_ Sho parameter Spite, $4877 ho parameter, globat-narnex ; aprr Atowtup force: Gxh>7 Aro ponareeter global-narnes; p77 albek Sytem 42 global names = dole scope: spfile; dict [t1-ro/db6 | inte pavoniat-ora, note: Ta rerrove file nm Spite pavontal ora. legr> sho porarnetes, global-nomec; [agv7 Séartup force; yr Aho prrameteh gloknt names; Lior alter Sptem Act global names= hue Scope = kath; las Aho pasameter global names, bgp v7 Startup qorce o> Ano powarneten gebat-names; spr” Sheat emmedsode- . iTOPIC: $ cd oraeng lappforacte] produce (oles gu gs we Engtpaventar ora. rm enkt PoRncté- $1007 po $ me sate} opncté-810-0r0/ ovaeng lappleroete produce eeS $ cd foraeng! cxppl Ovoete| product] t-ro/dbs $ dA inte g ORACLE, SID-080 snetponarial ra Bano on ones g ue sbosh. profile export cRAcce SiO poveniomt $ - bath_profiles $ echo $ ORACLE std prvantorse 4 cd foreenglapploveele/ produce [ut-ol es 4 op enlk-ovo. Enth g CRALE SIO: Ore Bue Grteg ORACIE- SOOT db-raree's pavorntd cS 5 Nae contl_teles'= Atagnonttc ~dleak = foltAk2/ excxcetay. pavaniom? olb- create file dext= [alexks] oraciata) pavorndaP Topic: DATE: db-ueate. onbine-top-dest..¢ . folie 2] oraciata/ pxentomnt cth undo. tablepace = undotbs +009 sed 4 rakelty -p (dsanal ovadatas paventort gs Spr atartup nomount; gy create databate; Syty ewe cd (askka/oradata/ pavanion gu 7 aiag povornt cll 4 cb pesvorridle qu. Bca controttele F CP ol-mp-sorhAaUE_ eek _ /ackKa)oroeinta) pavanteenéfcankel-ltTopic: Zogtcal Backups - Reg 8 Jnc exp DATE: 3~ Aang contents OAT RMAN cnale® (orachs Managed) f 7 Ora 8D # export ta cheutly operation én the reat plogtcal. backup can be toteen by taure ergcronment + ) Toble(s) ln users) b) fut! database(s) (Must hove DBA, previtage) presgeot backup workk of an. ‘alternative backup Sister. by The beau; about £80 kegical kpekcup) ex we can be ‘elecktue? Cocktch mann ce con backup) restore only te reguired pects which cunnot be powtble atth patphysteal bacnup)) f+ 46 alto offer’ Antrernental backup style- fron orale 8f we enn export fusge database to multypl, clump fle: (devon Saystems) ; From orade gi oe can hepoce Emplemant béenttertho brorkportable telole Space errs) urtng exports: lr from oracke 109 eco hot actvanuol vereion of export Knocon a9 cinta patent Srappaterpab)tarpon 9) den’ eps 4 TOPIC : pumngrhle oe pee a ee Ee dvomp areeg FIP 3 Export aan ako be used for copytng objet from ont datalnse to another database: = export: oluimp #le 2 phiforrn tndeperalent g that ee cin export frome one of & frantfuy the dump ttle“ to Curing FTP) to the tarqeb Saute owtth. Aarne or cutferent gf folloccs by CrP Ls echen ce go for orate vergfon updates, tk 6 heghly recommencted tp take a -full dotabax export ag a aetety precaution: ly AL the databose et Fragmented over pertod of ttre hepotite ef trangoution , we suppose to perform database level teorpnzation Cgeore) - Usually behaten 3 + months. For tex veorg process tae qplloto ) Fatt export 3) Drop exttteng database 3) creak brand nuso database 4) Fatt tenport: Ly ihtle export or import, tae con mention actferent options Like )) Table none Bexp helps y itqives att the options. 4) Gnclexes (yer or No) 3) Grants (441 0% No) 4) Rotos CYes or NO) 5) Corepresses yet or NO) 1 Feedback (ye er nto) | x i > The export dump dele ste! aw oxcratty & tototimes less than the databax gre: Peasonk be1) Systern tablespace ~ rot exported( AS the tonget database Smatt cohen compored tthe ab Stte- # LB takes wore tire echen compared to PBL Export has to { read /Aeleck excry roco of alt tables) ahese 08 pa con be 5a whee coe ave gutng tm Eaport alraaaly hat ts oun Sele & of base “table) 7 co # 2 Temporary teibleSpnce— not exportedd o * to SS) Ondo — nok AA te contains 3 nok exported con before. errage) eohere (oe os export only the committed lata: of 3) Srdex = only defincttona ove exported but not the dala KF aw Because, of att the above yeatong the dump file & 50 ow “ae taken by copying the files at ols Leweh- ¥ Import & 6 to & times locere than export a& ) Expo H only Selecting dota. a Mroport hast a) cect’ table by Sngert data tot of undo & redo lo) ©), Grilexea need to be created: a) conatraentA ave to be enabled. Henae rmport & lowe. 3 wher ace migrate fom one platform tp onother Coa: From. einctowds to Onex')-then froxder to bankfur the db we. hace. & ge ath export] pork ( exe carl Semple move €R Aélen of bie qile Bysterns are diferent) CBat dump te &bomfurable a4 tt CK platforrn fndependent - Sun-tre 480 5 cepqles go, Trt cliente 40% eementorep that Orne? racks vudion wopdates: luenp creat & to which the dump hor cfenedl: G) cB Cesta backup) pus S008) ® All expat (103) Cree the dumps 6S exported (> s) ay pga rath So (208M! ; Database 1 Succeaed —x Nothing Spectal Se gat, >) prop database 3D a6 new db eth on! Yequired 18 DB Senport full end)loz P TOPIC: DATE: 4+. Fe0Mq* Ong veory exe can Improve the performance and reduce the gragmentatfon- : mt : 4 an 2M cota boekup ° (ore) 2 Fatt export * 3) prep patabase sere” a@ dtp table omp i q .-. Y ag nwo database - = =n ecturang ; ; a | D Amp - -- oe ) me 8p CAnttfal 6m) I I Sump file i ipo Gngi | comteles ab Stte —r 100GB : . ee Atle ray be 7 608 oe vee oe Z TO tmport the data to ae wt yo other Sever, thek Seer | ole & alse contatns the a ot » 7 deqautt 13 a4 sien eet }" conbet, ternp, urclo, vedetog. Sr dump gel Bratt, conty defs are. patat desing dorcarcked to cinotha ore _trondfowrred new Saute Export t nothing but gelecking the dota udbes as ernport O : 0 Db 5S9TOPIC: es . _ the dotly «working of cba ts only hours: He perform operattons at that time only. dogteat berup ald trken bocoutae OF bockuptee cota baer # y : a ape tabled ~ 5-10 eam teal badup * : . ois one re Dan a) ep ep i tte bo W) pLiesar pocederes ‘eral cK Fro top) Bary © external data toodey eece gent | veneing @ atatrattcs a Ath clenis : aneernental . a wk “ < 7 ae . Sy commutative comutly ube Elms cok yey leo tO OUEOTE + = te. the dbo. jobs togteat bikup & tee conaucring ond So ‘ we go wth tnuernental export onby er akth the updaad by rot dynarnse pangacttonts complet Encexport git comple datas 6 pexup the pial teibler stoves: Tromporting tablespace: Crom 80) : e ° produstton- =o Ss) ) wserdota— Read onby tocremendal 2 Etporte (Metadate-te clef o data ak Syer") oF ee ; 2 Erp BBP belonging © oD Horm ont ProdUceton ty penelope” at ateexports or Srasernantel 9 Retest alroays to lort,compal. ekup tr Commutative — Refers abcoyt to Lort astine'Cumm.orcomp! [pe Ortvels) £] (3 -cheren.<| TF “complete bokup yleekly trevementals th a companys = Gon [pon wes | wed dar | don éwp homies, | cope | ePE | emp | . got | EMP | dept os gras sol bonus mp Soe =—| Se | curero usrarn te. tr whete cozek coe can encugh eth, 20 clump Her Ct ) Hs user terbles qéver the baekedup tables. Star atagiorn for Export vithys ~Gnteracene 4 mtd coped Bhett Sertpt- <4 Executable etle() < nes vol <4 [eat | oolels) <4 nO -DBA eS ae ong exp helps trp hep y can los Coseagec| by offertng FeDIe Menno , So that le flo wit! be performed.TOPIC: Berd on backups: Fd etplun ‘Yon Sysabo! Sr? Btewtup $ ep helpsy $ tmp helps 4 4 exp Res -futldboe dnp log = falar tog fall=4 5 HRall bawkp usernaroe! (ax Sjedba er dere tableapace- rome, gtatus torn dloa.table spaces; Drop Hoe unnecessary tablespaces 1 tD ertown € Gecreasirg ta 7 Gp? cetesk ‘rep tabLespeice’ Il tablespace parry | : tnducking contents ancl daterites;’ from dia. Latblespaces’, Sys>7 Spock dropts oo Jy 77 Spot oF Fs Joys>7 (As BYP eck HOPI TE sautt extenttoo Por Epoet #ele prep only the unuded toblegpiees: But not emul ( precedence] tablespaces tke systern, dysaux, temp, OD ete+ ays? J . ~ b Erapore file = -Raltdbudenp Rattey Grove = ys10 TOPIC: - shed DATE: Spor evleck teiblespace-rome, Baus OM aldo, tablespaneds % Syb>7 Geleck username, cletautt tablespace From aba-uses; —n pr? Conn userafurs connect Eo user haskng tables pact OF aceay? select Afrom tabs neeaeel ugerasz conn los &yadbas Sp77 gront connect, Tescue to test Colentyfeat by test; By? conn test] test; teskry gelect am trom tetb; no tos Selected: lest>7 conn los Sydba Japr7 extt Srnpooteng ws 7 ™ anon to user: test; ee too ucemaree: [or Sysdba- 107 TOPIC: . DATE: 4 Sepen test /test; testy? Gelete # fromm tab; Bones tabu. ¢ table Oept table Ouray table Emp tobe. Lesko? dvop table emp PuTyes tester “drop table dept pugs tmp tle: futtabr-arap . tog = est 19 from users yoo (USA Lest - tables: clept, eroP5 username: [as Sydbo D gniptiz test[ teSt; tester getete afro tab; test delet cept; teste? commit; : estoy exth 4 tmp ‘tle=fattdd\dmp lng= test-log rHom. users Used to usas test tables: cepts Brrors objet alvendy exect- $ tmp -ftle « faltdbrdmp dege teat dog From uware agus to Ure tegt tober = cept goo;10 Topic: Ata pump (exp ab. fmpdp) $ Syepls — test [teks tede? solete countCX) from dept; ceank ch) + Ce a eee ace | porarnebes fete Surrgt date) > Slenttfies Beorttes the blood nog le Enterprtst zogenscn) Ptanaga enter commupe Flles Blows | Executables Acvant - opttons | tens CLink - exp ap & empap Data pump apt DaMs_ penapomp Meta data ppt DaMs_ rMeTADATA * &pap nepsy —» Epdp refers to export antapamp fimpap help=y —> Sropap rofere to tpt “catapump Grorder (© outcome the drasckncks wwing reguloa expitep cuttin expab and cpap ore fntvoducedt »TOPIC: DATE: + lp Dntapump Jobs ove Served ok SaveSéde and thesé Jobs all oemupy Goroe Space. th SGA: “Streams. poct-atte’ & the Stoo to knoto the cceupte! pace. SAA * Hk exth on exp Cregulor) me carlt rnentfoo ony panne: But weing expdb toe can mentfon the unfue tq tor each anc) every job: & Ta Yb takes shes to complete and tL tineched | hour and wet then ctoppect vatny tadcttona) exp woe cont go utth the conttnutton of the Job bak ustag exp db cae cao rar tbe job from the parttoulea. potat by suing unique gob td “Job- tds - le Ke con ereati a atr named dtrectory Keep the datapump fobs ancl bog fetes and dump tes ttorma.tton. ie con create the dump ftles fn this directory by geuceg, or mantton’ng the foth: : l¢ potapump Jobs can be foraltely exeeuted Advantages: D nlorks 04 an altexnatie kaekup dotubfon- la) gateskore dextopump exports or fmpots are powrtele: 5) Can copy objects 2 trom one Aer to another uset- 4 from one databace to another database: 2 From ont dato another ofg a8 export filer ane platdoro Sodlependen’- | # Flom ont Voritoo of orate to another veredon. ly peach acter thon cemnpaved t> your qulot émplexp- p. apt on azeonnast 0 a BBtepimp jb Sing of waning fn theliq bouxground edhite you get on cotth otter coors a) yotcan monitor a clatapump {pb fror votthtn. tbe database tale [yy Cate. pump jobk ore yesumable ard pricalgion 8) feta pump dees. fk coork enbrrdy and only, este teat fro can change some pavarneterh when the Job & gatting : : * Dame 00 % tenplerp vetlit'es: t en oD egies tmp Sa re ~ oie, Fo ap tte -"wardmp tog = userd-loq fromusere used tousers bY; usanamer userfur $ gptplus wsersfuas 7 dump fele=duttadda-drop esera>> Adlerk t from tabs tq = dutldba-tog ugea77 oop table emp purge; Promugere use’ touser sdenntd grates 45 userag7 delete #from tob; osfuserarz, @Lee g tmp files sence doye useratmp: log username? O6es3]Ua exp “en uaeroscott-dleap tog = wseaccolb-tog exoner= agers, scotks > tmp tle = csera scott deep log =ctven sy ee eae eel Bom. asian wo, scokk uSer> 3 exp Mex fullaba- arrp tog futetba log dutley genta B top fil yserascott amp P 2 Byatern, : tog = sera seot-toy, fulley usemome = 6y6t2r0] manager gre Arerk=y — bitfers (000.TOPIC: $ ul porrsgl Eypor qraitk execute on abs. Plasto to Sot; Atle = Fuildb3-arop eysor cut loge tutldbs:log $ exp file = Scott_ernp: deny falls Y ae putters leq «scoth empaleg. tebles= emp dtvetk = y username = scott |Ttger u 4477 conn Bote! teger a geolty? select aountC#) fo dep; le paragl scotty Eek time On 4 oP ae pret 08: 37) 5B geotby detele erp; ugernanne: S44t2ro] rarage’ 984. 371.58 Be0tE™ eommet 4 exp file> Maxh-erp-cimp 4 exp files scott emp.drp Leys gott.emplog —-Hashback-ttme tole acemp query: \' where. aneege 20\, * Sossorjot #, 1oea75e wsesrame: Scott! “ username: scott) tegen. $lmp fite-= gcoté-emp: dr 3 ou peerernon ny ae v 4 Sqiplus Scott] ttgex Dero on tnerermental box erotty gateck counts) Horo Gjk2x conn seobe| ger, / orp cy Sbisy entese cagrnent.nome, extentaca, 4 fp ftle= Hach-empanp Pele td , block td , bytestoat, blows ror tables: emp ¢gnore= 4 dbo-extenth ashere oconers ‘écort!, tesermame= oot [teger Sytrr select GORRENT- yh? Kove densyt veplaces Lived cdrecrcly excl 048 En From v4 databa; epider option . euvrent_2ep he ep le ftle.oimp , tHlea-arnpy goers) Sy r7 ete dbs. flachbatte’ Hileardenp -Rtextte = 106K full 45 aq -opto 1s nurnber usernames &)kten] manager dualsReport eles expriat: aenp> Flea selenp Gsport file: expdatsdmp > Fle S:ctrnp gu bap Fes pun-com. drnp _feetype = complete Gyrr dese dbo exp-verfon Nome. null? type Eep-uurton Notnut| papery Aetek x frome dbaceip- arin; Pe “ 1 Jay77 Aeleck x from clba.-exp- -feters o> et Rle-norme fOr ass”, , 4 Exp-version Exp-type filaname — ober-Poree ‘treuatcarop t complete Sun-camdnp Stoo G. aug-0F Bp> conn scott tiger Scokt>y oset Into dept geletk # from dene, 3 Kote >? } BOE L comme : 7 HOEY? gett +p from Salgrods;5 7 ee le = Se Meeps TOPIC: 5 DATE: Scott dese user. tables, Scotty Selec table-name , backed-up trom user_tables; $ ep ttles moo-tocrdmp —tretype= tneremental \oyor geleck @ tory dba-exp-tiles JBxer conn scott| ttqer Scotter engert eto emp Gelert #-fromm ernp} Batty? commtt exott yr eoaert ento salgade select # from salgrasde; Brotkry comme: eeorkyr aeleck table-name, bacred-up from user tables; & exp tle: Tue loerclmp — tnetype = gocrernentads 4 spplas scott/tiger ecokbi eneert nto dept cdetk # from cept; Scotter? commet: sooty tnert tnto emp Gstect-# from emp; Hote ry comme, Gentes? nee ento Aolgrads Seleck from salgrade, Kotte? commit; droter7 delete table-nare, batked-up from usertabls; d exp tle= weal Bae denp fockype = eumutatrue urdnome: dyétero) mane:Sprr deteck from ctba-exp-ttless —y continue oxtth vemacaing doyt, 3 expdb helps y $f tenpet helps y Dene gp aatapurp! SY77 sho pororneter Sears. pod- JSypr7 exck gue gorActe HOME labs] enut$ ORACLE-SIO.OrO. os-authent prefix: Streams poot.stre = 100 10g” Qys77 atortaip dorce Bprr Bro parameter Streams poot- Spry Elek s-from dba-clivertories; Syerr esoate .dérettory —dpomp as & fae9k) oradata) pavast dpunp expap durnpfite= shoe toptle= choy a fatty dlerectory > pimp job-nome= -fulljob; sername: [as Sysabo Speer 4 squplux emote toy / othe. crop table emp page; i $ roxdiy =p taéska] orciclata) pavant} dpurep 5 I Aw r no Ov 2)TOPIC: . DATE: SP 4 tenpdp dumpdiles futlb-cimp dtreetory = ctpumnp username: la Syéaba ' Srrort objec alveady extalt $ teepdp dumpfite= futtclo-drnp derectory= adparap tables Scotb-emp Scokk 77 schema tevd export? gen opp durapfile = scotkusera-dinp directory = ctpurnp + gthemas= users, SOEt ; username: Syktero] manager EY7? grant eoonect»Fesounce {2 test! glenttfied by bestts or? e900 test] test! desttor select # from tab; Sroportirg objects ror one Schema to Cc cilias 4B apap dumpttte: fatldbdenp désertor > pump 7 yernap schema < Seobe 423! tog fete ~ Beate beSL «109 4 Schemas = gcebt ueamnarne [ek Bysctba $ sqapls Lest [test testlo> aakert From baby46 ‘TOPIC: DATE: Perpdp dumpiiles scottdmp loyftle~ srottslog dtrectorys a 4 er. udserncene: scott] Hg er cor: Syrr grant read, wortte on cveckory dpump +o Scotts | a 4 expdp dumpftle= sxobtedenp tegfites Soke og rectory = apap: usernare ceoke| Leger Syirr grant vad eoAte 07 dtreckoy pump to used; | p> conn users[us 5 Spry eclece & from tabs expdp dumnpiile= useraidenp devectory « apimp tables= emp, cept { username: asera|uas | Sypr7 qrank erent te “eo users; | aor conn useraluas userarr create dew emnpwied ar Geleck % from ernps & have only def QB expdp dumptile= usersexc-dinp — divenkory= Aptiinp exchucle = wlend wWeanarne: wrerdfua es] !TOPIC: Trontpostable tablespaces: DATE: 5-day TIS( Transportable tablespace): 15 eax Entrodlacee! Prom cracks 8t Thorcer to brancport a tablespace fiom. one Sewer td cirother Gower Firat We w howe 40 whet whether the Lablecpace esto chgtele or roe: ie, fn VED ‘Alri ets! conttole, too Generk havéng Somme eo plakfosrn UNvt anc * transform tha ree eblespace ferxt th ghould be mode AN icon) ts-arep 08 RoC Rendonty) ard only opr a ) eo ao) he tha metadata st anil = peantattes (0%! oe ducep fe oe Form crosle at 08 Fy db “trough pas Dust { os yowe rnuttiple Hor 93 tsa08 8" transport the table bomautr {os spore: the datauitt boneportcrtton + we rronaporing & a tablespace across plattoxms wexpecbne Uses ~ cchile emporting. tafvere plattorens): Were check plugged-er Co) eed cena and target eandleat — tm din. tablespaces coe YE Bares, he geuxe transport the tablespaces ge ona us nts mot locods #e the dec hace exe ne the Expdp t export coat tmportect- tablexeoee-dg ToPIC: DATE: oases Forget a! [ a DMake the bé! Yea onby 1 eweae al ison end: c a « ( fake bxpCbackup) of & a from. the file. . bxp ) Sport clump Pte i (austin exp) - / 3) Make the tablespace Keadlartc C >) FTP the datterttles acsocinte, (etree cons, on veadtonty)- ak cuth the th & dumpile . i wy Stort- programs — cracte- Configuration § megration ioety - ‘Pp ert dbca databace ypgraick axtsiant. C21y netea Cneliaork. configuration f asrextant) Gereote a databace Next>> OGenerol purpose : Next>> > Qluseanw. confeguratton next> Global abnearce: SE © Add Sy stern Colenttfier (S1O)+ cast next next yy, next>> > Doseraant the Same odminuxtaty| dsttoner + Leatenes noms pomuord for Al ace poeand sys nent >> next 77 Aelect protects rcp nent? © 4tle Sptero nent: ‘ rom i Done of standard port purrker'of Aj NeXt © ot db foe + osempe ONO rare 6 Leste Condquaten! Ftnsshe>..@ specthy.2 next>?Aen ed ee | _| Topic: “| Brporty stop ajob= tenned-cole sample Sherat next» @ ryptcal — newter, next y>, Ne by »MeKt>r, I® create database. nectrr , #eniah7?, OF tape 09 dotapunp (starting cand stoppeng a Job) aysr7 oxeup: datapursp-j0b8; per elect y from dba- logftle = falsds: leg B expdp dumpfile = allel S- olnip job-naree = tent jobe asreckony © Opure > fatley userrames | an Sysdbo cbdee fre you auve you. orah tO stop thes gob ( tyestln0) #428 27 exert 2rorm alba. datapump-ob 3 expap attach= testfob ugernarne: [aS Gysdtbo. ed continue clean _;Startt rom the prewtounly aber export aor delece & from alta. dlatapump—Pes; ye dom a 3 epap aurepiite= test: cree futtey dtreckoys dpursp; ” username: [ar Bysclbo pote:& expdp dumpftle testdmp dult=y cea olpuenp are Job-namne = beset Syh>7 delete # fromm dllbo— datapump- johs cchee job-name= test! gure on wangpotante taecrae (acess Same ples: Orr eeleck teblespace rome, pluggedl- éo Promo cibo.--tabbleapaces ; eee fuggeNa. then those TS are locals - le, ‘they one rot transported byor eat tablespace tts ciatafile From onyecbere «== - =~ tfeteatca]orcidata/ pareantRts|-ctbf? Ste Sr; Byirr gront connect, rexcrnce tO be identtfied by 3 ayer altea user th default tablespace tes, ye77 conn tt] EES a7? @2 1 sqbplus/derno| demobld ster seleck ttrom tab; st>> conn far dytetba Qyr7 ekee dios. L&6- trandpor pel sat. procetus guccessfat ty completed tronapont - gek -chedtt CtonpoT BS"); Lgek- cheer Cet) Jayi>7 exec dbrns- Ets. ta. brankport~ Sek cheer ('systen'); [Sys7? exec dbms- Gf we have any onttnr xalllak Gq tp the prattoudas Jtalengace than thos tablespaces aanrat be horepostedt. 20 0.9.0 yA ~A29Topic: . pate Gyh77 Sede ® FO bonsport - See Atcotaktons;, ry alter tables kes, yooh 0 4 exp Kes eegamp loge 9:16} ten eo tablespace: tesblespaces = tts username: / 08 S4fdloo Bren thS-oleep [aesea] oractatal pawane 4 cal (ataka| oradatalpavant: gu . Jorge Serer - Cdbo12), § pep -¢ abate bee eeo gah ee spot BAP?! steby eo AH pepr ropa Las-amp estate : Pea spe be : gyur erat 410m us contol; prontd od . ceed Bys7z ext, \4 4u | B inv eEsebh Latesicgloraciata } pavant(uaa) 4 cA -[aects) oradatalporvers ora) 44 | acd | # a4u>7 grant. conmeck, resource i \ tm te Wentified by tts oda ded 2 tmp Hle= WSs amp tensport_tabletp ace =y datattles: Yaeaksorscate|prst AL lof! 4DATE: wsemame: / a8 Syeba Byirr eelet tablespace-narne ) Sketis : te ugyed~in. from dba teiblenpncess ngnome aby plug 1 n : ; : me teod only yes. pratker tablespace >7 atter tablexpace ets read wees tks vocteart; a pace gerne on brandportablé tablecpace Caeross plottorms)* Sys crecta — toblespoce esac datotle tfaeeica] orcidata) powone| Eexantrolbf? Sete 5m, Spor grant connetk, resource t ailen folenttfied by alten; Jagr atta use. alten dedautt tablespace ce; a7 conn alten}atlen AUen>7 @2 / 6qtplus [elarnd| derroblel Jdulenr7 selett ¥ from fob; $ copay : : . Gprr exec albmng-2k5- transport Seb check rrgac’); p>? Ketek & from Lrornpot-Se- wéckattone; (8 ques that ¢f there axe violations to tr ‘the ponttouloa. table spot) aprr etter tablespace tier reaal ony agrr cele: # from ep bomenntable- plat form; Boevpip’ cumpitle= ebsa-denp _evactony sipuenp tronkport — tablexpaces = (esac ueernaroe: | / 8 Spdbas p00 0 POORAADDOToric: DATE: > gu $ mv wsoerdmp ++ bw $ cds au > ed Bed Jatska}oracate | pean dpump) Gale FED -b 192-188 0015 Fepr tpeod Pep> ed [dtska] orcvelaka|povent Pep> mget Etaac-amp ebsacr-dbf Rpr bye ely en\y dir ttsacrdenp - + tehoctralbh - - erly aqtplus (0s acaba eaty volett 410M aba-dtreckotA, Saly erect dtveckory 4p 5 Verlde's Bat? ett cilag wxder dp ea . (ily wove Ledacedlmp dp tly der ene cl ap clap oer gas [os Syste, gat grant conrech ¥eSOUNER *D atten tdenttted by alten; " erldp> tnpap dumpfites Locac:elep dtractory sdp fansport- catadeleg = "etl absact abe 5 ATOPIC: Baeltup /Reesoxry —cold-) username (03 Spetba- cx\ap7 ed + erly gqlpls fot Syotba, Sadr Aeleck tablespace—naroe, Ababa, plugged-tn. chor» dln. tablexpnees, Sly attr tablespace Ebsoe rex wi; bya maps: Bd koskupt 1) oe take the cole tnckup boy shutting doton the dictalea.se fottowzed bj backup of ecphegnes c/RtD ilesy at ofp level- 1). S$ the databax t& ta NAME No enchive to9 mode) ancl tn cat of dotabae cowh tae can only go for mmanamye veatore (90) Gt the databaw 1% th ALM axchive log mode) we host a choter of # Semple wetoe CSR) ® Rectore + Recovery CRTR) ley) Recoverles ave of tod types’ | # Complete Aeqouy 60%) » Smeomplele recovery caer) 4) SR can even be pertorired boy Qystero adminsstrator whereas wecoverte® con only be dore by penta @ We ene athe. top dtlet dor stan reroute. CR would be posible only # Present centect file Pepe, z sas Both must be auertleuble- % Curent onbine Aerloteg fle * SSTopic: q one 9 any of Oe cha co ale % mang then ox endlup performing ger la “Ger? can be done tr qolistrg coays & wondtl Coneed CdpHy abt oxcattoble axchtex top) # Mox poutble yecovey unktt cancth Capply ot oot lable fp unit sme onttt ¢gen nummberl Apply Yee mut RESETLOGS ard car then only OfFP wake ona conststent- cold backups at cvactable archivelogé 10) Ae the end of TER the datobase’ Aw 0) Amnmoectiect ley v) CR gun be done th 2 Wayt 4 online (PAF'E belonging Eo Syxtan and undots mut be awattable) ¥ offiitna Conn be done shen dbf measetng) Qader a Sova cintolnk three 4 8} ee enbire clextsa treahes, then 8 90 dotohass rextating 1 * eel watth the rectore ond then betoe crash coe tone a copy of orehtee tog attet fg: fr dome other d¢6k: from thot te ae can veomver thes ch Uncomplelt St Finance calle, then reroaing “00 on works ot uduol ancl ove can dio reccoty the Roawnce clerkerbare ag “cornplete Yecouny - onkine”. Becauc, the contrat & redo deter cae avallable 4 -_YTwwwwDATE: TS Shine Doo bu powtble onty 12 presente ctrtfelatat Lents co oon ey ° x v Locos -ttte Ryatero eee : ery Neo atenyptero Tepe drtuea—y office +o NOCO toe hawsehgo chy ww Lé:30 Aotknight — Ce we a) senso today orchietey A 4 atk aS Ly ser 7 Ly 0¢ Cunttl ann ~127 ToPIC: a ome: & The cotdl : the coldbackup of a clatcbas t% taken only tf the clotabox & a ahat trnmedtali or. dhutnosmad mode: Because no user conneck to the ch and mo tnklonta trash vecover needed» drat the database “ encheve log rece: ye ‘the restore can be takenep by using the cotlbackup ancl ee con EE the ve: tnatonee SENS. by nee coy ges recog 4 methods Cunttleancel, unttl ttenextomp, une sen number): -then often deabing tncomple crash vecoy aoe mul Weset redelens dnct then Open the dota base aarhe recouoy aon be of a types: they os 7 yoadine # the complet recony “a powtble only when Ene a) offtes zaent Chit Cobleett Loopy) ERLE and the Current ‘ Pe Fi online redo qr Codleadt | member) must be owatleble: Reeling uitth backupss conceler on mondoy Bpm the vecot Sg as 5a), 592 4523 eshich was en ati atated: toher beginat ctuetday, em theq ane Gn dase Alatuds Ab 8:20 the Le cat teh occured) ant Sal become of 524 — finackix te ~ Cumrent ancl att! aerating axe dome At 8:30 bogustch ocurred ond Say ~ Curr —debive fo~ 70 anc 625—Fractter to - Current and $33 & dame ar GA: dit 10:56 g37-fA , 538-9A ond 589— Curentstate onal database yodhee! loco, coe hace the fafln an redolog &« At¢tI upto the af ttr00 AM cunrent tx took vollineked 536 - Snacktves Becese 534- dé, the deta cuatloble tr the ancheoctoy dexttnation (& upto 528-19 reaotog aquence only hen to restore eve 90 ath Dewsk rage eotd bkup and thon todo orchtocleg recone ancl then tncomplelt creth veroeg until ceareels AY iDemo on backup and scenarto Aecooays Sor See toblespocs-rame, dats from dbo—tablespoces; Oper deop tablespace 24 Aneiuating contents ond doteftles; arep atl unceceessary tablespaces. - - except Byftern, Sygarot, ternp, ortobbs, 0-D “Jeoyiz7 elect userrorce, defositt tablespace 4rom dba-useS; Jspr7 drop user ur cascades e= aeep atl unneceessory Users: *~ Lapirr geteck from ud controt les I emultipex contd tHleloy shut do $ ed gorneré- HoME|dbs oy delete from ug Logfiles 4 mctgornctEswora hyp atta dotabat . drop tog file —— retnove sltska path: { fataxs Joractata) peveesrt yedoab-log’s Spor Slactup Jap dole from v4 contet fete; fopr7 Aclece tle td, dete-narne From tba deta tles; _ oe dll filet ruse bet ataea only > - Ppr archive tog Ont,i29 0 Lets of cletn atless $ dt /dlse{ oradato/ portant/ $B mKder mon 3 cp % 00 g ed eon; vooo $ Ls ood bu opr? Startup por alter dystero dutten logtte; opr] Sper] SPP? avcrboe. (0g UAE; cuenta Eaquence Sry altel Syptero butch tog sp | pee eet een ee eeeeenees TOPIC : ~ DATE: ue aes Ndanchived.— Oprr shetk Ueomedtate ay vent aes Pe oe ro cersove deny He pnother vendor p77 cor grottl tiger SEE, engert Unto amp saleth * fom ores spot” om) geottr? | geotkr? commit} Grottz? casert tnto dope get # trom depti seott>? / Scott>7 |130 ” en - DATE: Spee} spr? Spr / p77 axntve log bets eurantley diguence a yor ext gcd [dfActoradata) pawant au pum * a “gcokt 77 gehen count) trom exp; ae 2, BObEDr conn Scobey Reger aed Scotter Insert tat emp Seth & cls ' “# From ernps au * Scott-7# conn fon Bpstbe + gyter aut tonrnedtout * Se? shat aborts dyer cake Sper dtaxtup mount p77 abtea databay. recouer automatte wrth backup conteckfle. canttL concels Syp77 YecHOU. ccwncel; wnedic. ecouy completo-oo ee DATE: ~ Bprratta database qpon resetleys, Bprr conn scott (ger geott Bpre Selene counttt) from emp; “geotese dealer countG#) from dept; 4} cd sasont) oradata} paver’ Bys77 Bb tmmedtots; A 4S 4 mor cutdo 4 ep & catdo obj panel poent_en_time serous): jen fofenl—7 ope OMAP gioo aro 7 7 - pryiteal —r_ e181 ee ee apt ge ee apoopee—y drop FP PATE ep dolgrade A;o0pro —y Abu nit —raprrbkp Here the user perfor dome tx at gr00am on tucclay and tater. att as0opm he cticped the emp table permenontly £0 thet fe ceult Aoltbackedt» ont performed tx opto 4:copm ancl : Hole fe vecener he the neo thot eoont broppedt fable eather: ‘60 that fe can decoor & weatore a bby eoldbkup.132 o TOPIC: DATE: e =~ G 4 cd | ataka} orndata} prvant o' ‘ & as Sy>7 Aelete username #itte defautl. tablespace from cli HEROES dbouserd; 77 conn acott| teger scott? fhsert @nto emp selec & trom emp; “ otk >7 / Scott r7 Avec count ch) from emp5 oot 77 tnsert fnto clept Seleck aetrom dept ; ote 7? | = - oe aaer System Salleh logs | eye? / gat | atssajeracatalp ary © ygerciataot-albF- scott 77 conn bs Bysslba- 4 ro uaerdataot-dbF Sysr7 conn scott tg Scokk77 See ceunt Ce) from toons; aston! unalde to ofp datectile+ Syio7 xnut aborts ,TOPIC: _— gal [atsia] ractata} powont 4 cd. eotdd) gu 4 cp userctataot. dbt ++ exper stexbup reount ; ry getec -b-froro ug vecouy oe actotile 4 offline; Hey japr> One data bat Lager ober. database ofr; Sys77 alter datalbae adingte (ses Lecoun orutomnertte deatile. t facer2} oradata) posal] userdataot dbF"; Sper alta databae dotattle 4 onbines ays?” coon gote| Eger Ore? = Galerk count) fron emp; Sone? goles counts) from dept) rgbvespert_ Raeat }) stoxtasp rrount lay Mak, the datacile offline a Oper the database uw Make tae pableseat offitne: 5). Reco. teablexpac? ¢ tablespace norne> 4) Make the tablespace online. .gotoloan recouery » Take the dotabas to runt (startup trount) Reove chitabace- t Open toe database: ro on HOR ot en, ante 4 cd fate raforadata} pavers 4 kar ‘etl & cp # coldt/ & am vf FOP} Spr? Stowrtap JSybr? deote] bey Scott >> | Soke > cormmntte; gortr? | rotk>y eosert nto amp select from erp; Gootk7> treet Into cept seletk F-from clept; aysr7 alte dystero Ste tog tty, py? | abr? /. bys 77 nedion log Maes | YUUVIOToPIC: DATE: porants te poxantg rm Gytiervot-dbF Byp>r Saece username from dba users error to opening dababore Feu: Oper éhuk abort gaa tacskatoradatal porscrtfectty cp. Byterot dt 4 abe bw $ ed Sp7z alortup mounts Byprr. Recove clatabates opeckty tg: fartrraggertatt etrasst ao oO joutoleaned oq oppued mecca. geccveny complet Gpsrr alter database ope 84877 ott (tga geokt7 deleck ccunk ct) HO" ernp; Gokkr7 select count) from cpt ;TOPIC: DATE: Deno on_tow of an object _potnt_th time vecovery: Gpr7 shut tmedinte ogre exit gcd (acakayoreatata! pawant/ porort $ 26 gmk dtr cotda) $ ep cole} apr? Atarbup a7? coPO seoktl tiger gectk ry dele from toh; « Groth? teeerk tote emp gleck A grote rr corrntt,, geott 77 eneent tnto dept elect From emp; Fromm ape, Qott77 commit; - Seokk> Sake thee 00 ost ats8 Gorter drop tate erap PNG? of agit Etter engere ento dept Selec BF fron dept os aq au scott>7/ 081a9+a6 cote? Commit og: 291.88 Gokty com (08 haba os BANG CYP? Shot tenrvectiole $ ce: Jatska] orawtata] pavantTOPIC: DATE: & caked aprebp 2 cp + Aprabkp/ powant ¢ 2s ponart$ cf cotta paworts cp Fs. pawane $s cd Bs Spr? Startup mount, eco? oubormatic uctag weaekup Spyz olka dotabae time #3009 | 08/07 OFS AT* 565 controtfile unttl Bpr7 reeoor comely Spr alter aekabae oper ‘yesek logs; Bye? OM ook tye geoktyy foletk count (t) from ainp; grocer goles count©s) from dept’, Gn the 4pmabhep ee cont get orop table, becerute C6 OF ed at APO % exp tiles emp drop tog= ugemamet scotel tegen: emp-tog -tablek= eénp Spr? Aut tenmedeate; a ca Jacskalordlata) powers] gu 4 cd ApapDATE: au amp *.. B ocd 46 seed Syprr Atorbsp pr Cro geotl| tgs Lacotk yy detect & from tab; unot have emp table: 4 mp ‘fle erep-dimp loge emp-tog tables = erp username ;, scottl tqer as S87 coon scott] yer Gotr7 select 4 from tab; Demo cn “ot of conte fete? SO Ops77 shat temediale 3 ed fatAKc2) oradota) pavent 4 14 i 4 mkdiv og $ ep * wed $1 rt coils 877 Alostup a)i rere 41k TOPIC: - DATE: Gyre aatter ctaketbase tackp conkotGfla. bo brace, |syser co0e Soke teger; geoterr Encert miko emp acleck Aron emp; aott? / SOLE Commtty BeotEYy toeert Ento clept detect from clept; Stott 2? | Sxpr7 otter Sytero Suttth logtle; sys / Sper i Syper exck bcd aeeataleradata/ pawant powari gs ven contre: cel $ ct, Byer ott, Agee foteck qhile-narce Prom tbe qpecttter! control cla dba. dota. 145 Beror: cont Open S77 Abel aborts 4° cd fatskaloradtata] peweunt g ww b cd wed as : 4 ep contrat ctel > 4 ctw a mh140] TOPIC : DATE: TRA cook the pravfouk conteoldtts Bt cloanot anccd the after trie between the monday to aad Spr startup racunt Bpr7 vecour clutabak wating backup contorctfite antl creel; auto Jayt>y Aetete mnernber -frorn Nebhog hte; ISysrx Acca database uAtog backup contedttta unt) carl specthy tog: et [osAk2/ orodata) pavers | welolop aa +40q- Fag Sys77 alte clotabart open exertion; “ese S007 anchare log Lae; Gysrr shut fmmedttot?; 4 ed [odeeka) oradaia [ponent] pavont 4 mkdir fir & cp ot fers 4 am ert colels yO i DTOPIC: 3 DATE: [rw Demo on to% of umardhived onbene bog tle Credotog ditten): ee re ESS Opry storbip gyser conn. eokk| beget / Grotery (nsert fnto emp select #from emp; ett >? | Beote >? corométy aeokk sy eneert Into dept sctect aetrorn dept, Bcokt77 | apr CL Byptero Susteh loptly Sp77 | 672 / Bprr ext Bed [At9ko] oractata/pavrant as § ro xedologiarlog sedtefegsa:to4 gh Sis ensert trio galgrade select a fom aalgrace 5 geet? commit; i A a : abet Spre able aostth beg file; fo keok the prceems mal Op Byrn cratten ey abe unas ayer } Bec asaglrdbmslrscty : powoninete] face B77 shat abot: 100 =F let pein egaK $ od. fer} Bu Bop t.dbf i. aed Spor Stoatup runt; Ayer atter aataba recover automatic unttt cancels Apr? aecoog carcils Bys>7 alter dlatabae open wouettogss S77 conn Acotl [etger Soke 77 seleck count (8) drora emp; count CH) corn dap OE? Aelett Spr début femodtate. & cet — [aerra] oradiata}povart gk SB mnkdtr sak 4 cp 4 sat aj weds d os suTOPIC: Backup /Reeve4- 3 ~ Hot: DATE: sar Hot bacteupas Hotkectup alloot acted omy tot = tr ats t the ob 6, ALM» bee ocptabate ogee 7 Cab ae [aac cel haukesps ——r Hoblettasp —¥ (4) ° é Gn pebbarkup the Cletp qntale oS tea piles one taleen lnckup- cone OME, ah] . wok Loeked) pntadéler ox teatien battup ofS tatty ap aith *Bagén bacteup ereds’ optton Becaure the ebispat ations, en? morof clatadtles: fonbel cites baoknp ox not powtble at ay net. D ghouls be Jaten at db Bevel ancl veclotog dete backup ¢ not powtble, drt tn orlbkp cz am Acctoe the dala butnot &r the hOLbKP: Become potbkp coenot contain rhe redlolog gtlen: paler tablespace -eterdata leg bacxup; > ep userdatoovrdlbt > yep userctatana, cbF > aber tablespace wadata end backup; From 109 Graets tntioctuced the cobalt data tnto- agin havkeyp, patter alatabate begin backup; Hottooeups: yn awn companies oe rrayrot hast the Luvory to Ahutdoo the database. fnorclex tp perform edt bacteup cohéch leads ak te Eemplernent hOLbKUP- }) The beacty of hot bockap & echéh the ath U6 up anet sunning ond eve eters connected to the dbChansaction ax getng on) ax can dtl! take the bnekup" 9 the pre -seguinter © mplerrent the hotbep & th db mui be tn were not Qfate axoat tetas Usue hel beap_ contin), ay ontere. én edd backup (oP dent | bap ott the three atest cielo) hot bkup Rnatead ove beep only contol giles ond dotadiles.CRecto’s axe Cqnorect) ince, they ase aontinuoay getting rradkified, oe backup databace offtes by tablespace By Bing each tabbapacs, Ento ] begin hockup mode. : : vatter “toblespase yxadata begin backup: yep" wserdataor abe peeeatne ewe dfntsh cpr att the Kablueponcs- BD controldte 4% bocradup at @datahas level vstng the Sat Stme- vettter db beret contretdtte to dlestteatton: J) the tony we perform the hobbrup Aeghtly ictferent woken. ree & asi bet. the Aecooay chenerfox ox 100% same except “Gimple Aeatore’ % apt a pooitbtitbyy a1 ae hawt only 400 type & diles t be wxtoredl contac G dertoritles but not redologspte)- I Both complete & encomplete Aecouery procecliaes are Same cohen compared tft coldbkp Soabucting dyatox- a) Omete genemtex excetttoe Aectolog eohen a tablecpace &% putter toko agen backup mode ard Weck ove cemking en the same tabiecgatt: qo mnfntméa . thes axcente sedate rtfon) coe bry t> tome eoch tablepaee thin beat’ bkup meets gee shorten pated oy tee. @ This con be dove incom tf we can bkup the diter to a deste dirtve firsts ater cee coun atttl perdoren tape barekerp- ie) Stoce, reccony mreenctatony axtth hotbackup coe ewe bo howe. atteadt: ent anethtulog cite. nd) Gratacnct of peatteng 44tt oral {> procter one arehetve fog He, & kp _igcommmence | ora Worual doittch. Fn core Uf the cb crihgher Lame Bes, the manually Stich oachtoe (og dele att D_a_9 00TOPIC: pare Jes of porerecteile Couce on clabatp) Sprr hath, tenenedtate ABS IA Ertl g ORACLE. SID-Ore inétipavaninera-ore. abe my entt$ ORActE-SID- Ora cat 43 | Sp77 Horeup Brror’ dott nok open Ue parameter tte. 4 cd [desta lorodeta/ pované peat 4 te eco $ ed dfag|rdbrns/ phuodbt ponanéness] trace] troce f ul alert- powantnecs log 4 cd [oraenglapp/ orciete/ prockuct/tt so] dbs dbsg wed Pnde FORACLE-SIO-OFO. paste aur the poramebes copted én the bandfle: dbs 4 cd $s Sysrr Atovtup: iSye77 Ghee fenrmecttal- $ my eneeponrantnerd orct [oreeng lop! oracke} proctuct | wt bolabs G eurcent tnétorce: afd sorep2] topic: parE: Derno on creating dotactless (hos of unbackedup clateaqites)- = Oysv7 elect uAtanoime, otedareté tablespace Pron ABA-USEK lager creat tablermce test datagtle * /atska Joradatay pawand] testol-olbf? dhe am; te Geant connect, Aesounce to ,fobn Udentéfted. by febrs wr alka ude John oledaslt tablecpace teat; [ipy7 conn ebo|febo; Lichn>7 @? ( 2qeplte felarno] dernobha ihn 77 as dysolbo. BP7 Ahuk Crmecteate- bcd (asexa/oradatalpavant B tb 4 cp Faatl a $ cl gat bu & a \Syor Atarup Kyprz conn. foro] dob [Johnor fnsext tnto emp detect + from erp; ob >> | . goon >> / |Achn >> / [fob >> / [sobn 2z / ror! anatle t extend table empTOPIC > rOPIC DATE: 3 AObr? eater. (rtert ento dept select * from cpt; gobo>> / gobo>z | gobn>7 / fobn 22/ lacha zz] Ergor sprratia eabiecpace test ad datatie tfacsieal oradatal pawort| tattondbt) Bae Sm; base? C007 cho|.aobrs acho Select caunt(#) from emp; |gobor7 / obo >z | |fobn>7 fnxert toto dept selerk from dept; |dobn>z / fobn 77 coro, [job conn las ysolbo. Sper alter Sptem Ente togitle; Sgr7 Sysr7 / Spore toip WHY owckive tog Lat; 4c [sana lorodata] pawant, 4% ! es gotott ‘ gm Se 7 nb eehTOPIC: DATE: yer” cere Joho) jebrs fobn>? detect anantl#) from emp; Pron @ror én. opening olttakae die: 3: Aebner conn [a6 Syhabo B27 Shut abort” ; ts oyrr Atarbsp erounts oy Hath . ) pre alter database orolt datettte 6; oof the Gt laprr alter database Open; (zrror) ys77 Becoek datafile 65 auto apse atts database opens [sgier Actes dtl—fol , dtle-rame hom ako cata,-félec; Sy ahuk temmedt tele cal [atakal orcieerter] parent ax 3 cp aASak® 4 ot sate bis : Doreo on hess of non Sydtern cledafile att sollbouy Segenen St thd gg a a ple gL Nene Gprr sho porarnetes undo. Spee exte 4 ut doracte tomelsbs{ En£eg ORACLE SID- cra. j ke ‘yrdo- rnanagernent'=rranuab:TOPIC: DATE: 5 Og8?? Atasbep force; 84877 Sho posameter undo bye> ureate ables pace wosts cleta-tile “(ateaisa} overctorta/ parcané/ bats (vatbot? Bae Army exten’ rnonagernent: Spor recite olla segment yb3} cteekfonomy tatblecpor? sbgts, b TF alvencty xk, Spredrop rottback Segment vost; apr atte. gollback saqenent au ’ rbst onblnes Sper het tmmecifate, fous. cotdbrap eutth rotlboct Segonenté- 4 ntl SORACLE_ HOrte/clba) tnét 4 ORACLE-8ID- Ora. aS- authent&— prefix= '? Acttloack — degmnents = Aba) 108g 4 cd tatdkaoradate|pavant als Sep ¥ sats $ od cats b de 5 a és ay? dlaxtap 4 PeTOPIC: DATE: Ey conn jobn/.jobo joer Conert tnto aalgroste delect + from Aalgracte; Jjohn>> / yobn >> / john >> [John >> comrntt: Jebn>> conn lox Syédba; Syrr alter Syste Gutleh togfetes op] appr! Spr7 rte } cd lasevaloradata] povart A aro sostsl-olbP 43 Syr7 cnr Scott] Hgers Gottr7 @osert énto emp alter rottbackt degreent sb} ondine; Sys7?_co00 scotk| tegers seottey tréere ento emp geocky | Seok > carnmee gato dept Gee -#-FromM Aepl > aelent afiorn ernps grote 7 fosert $ col Lacska] ovaclatal pavant & bom * gu 4 cd $3 S77 cone rote! teger goktr” treet ento emp Gdete from amp; brow: ‘praia. to open datectele « Qrotles> conn [0s Syxdbo. Syso2 sheet abort10 TOPIC : pate: ca Leake} oraciata] powant & cd hokbkp/ ee mo & & bop *,, ood Gyr Atoxtup mount; Syr7 cbte databace reco automate wing becrup conbrotee unttl cancers Bn 77 pecoor ccuooehs Spr amber datebax open reaettogss Sper albes databut begin backups $ od yates a oraclata/pvant $ mkettr hotbKp) 4 op #.dbF hotbkpl ga >y abber databace bacltey controf-féle to op P : Ufeuuckca) oxcrcloctcr) powant pot bkpi(eontrat: ct”; Byprz attea dotabace end backup; .TOPIC: Rrran. - DATE: (0- to dug 11 4 Both cctd ond Hot are onby mirror tenage bacning. G4 wos rrore Line conumings ty hot beup etcertereddtog Lover the perormang “ener Manegemect ena! * Y Rrean Aterbed from” verxtone: By Rman bhup t tater bi greats other, dba Babretts &, a6 a jeb- 9 Pron bee doanot pap bj ple Qe or minor tmaga bps) Fran wackup t% ‘content fnckup”: le) Ran bkeups those ened blocks Crot by anttre qile) 6) Pinan offers tu90 type? of batkups- ¥ Regutlon beap Cosed blocks) & Gerrernental beep C boloeris) * a) Bran tates lexstime dra Leas bnckup fpace: He need not depend on oln “Schuatulowrs db “ern” fn onix as tt hod ths cron Achectulor: ls) We nead: mot deperct en éoriting boieh giles eke “helt Sepia” fa uncer 0b Fran hod ete ocon duripting Panguage heh % protien Sndepenctent:- f) man th capable of earup of ep obtoluls cachtee dogs ob the ancl of a Guccemgul bowkup- 9) Grom Brasle tog tt Atavied obfertng cormprerieel bacieyp Conn tax te! Space) It) ron. con perform bkup on rauttiple desttnaitans poraittely12 TOPIC: DATE: ge? 3 oe emuattyy enclerders art eatethe connectisl to the target dkxtabages: anal te Sf we perform ‘backup DB commane ©) A the end of Bucestful Pran boekup coe con ask Fran to heck dor che “senteltty” Of the bkup: 13) Ran can qren® seporté for BS R CBRup ancl Recarroy) opoations. trlorking ct Renan Bawteg en Renan. concept: se tare ore catalog ab a ri o and. wary darned aroreteas (Berwers) eth. défferent ofs: oe aa databases’ centralize: dared ypeonte gare Lantos enon qDB- tasget DB Gre Needs di to Eek bRLUp Amant x3 pay ,ace,ttn) bo Y enn pede oe 0 ; we ee ot "ye ny es crea wag catalog cantatas the TOBEntormatie then the phigeteot files echich one wm te eatll ice the backup to tapes/Atsa. onsatty for long, procexing ] dealing oftth doage Serves we whe Roan Scripts» . 1 k oTDATE: TOPIC cel as. at oh oh oe pee et mon- At wero 022, #) ®> ve and. 01 = yorenen eaont* bkup-4b LL sh tor gab fasldatdp feel cotng meme) beup eerie souget eeortup tar put ltev/amt]O > Spee tog, rp ony oe ae oheck. ced a be at etek taew(vmele cot Py yi gt amon ye Noge * ey ; atobase storage promdure: Pi oy J PoP hg % wsopm ge ' Ce ve (a) 7) Wiel \ as 3] te J pe ra cobst |puk ’ . a f mae eet 0 ecerBegen ga interactive oe ee net end procedure, ) RU7 Some Kea SQL> @ x-890 <— Bath procedane. 4 Sexseng in the clatabaw So that each and every eben eon wx % DB xtorage proceohne7 14 TOPIC: DATE: F osuortly tn the SQL prompt user wirtles the prccectuse ¢ exeeuteg = — thot procedure: thes anocte & ¢fretercuttue moele?. fe Jt dret then coe aA dave the precede Cénttead of cortting the tong gutpt): Thea enode % * Bech procedure”. THA coos cet" uses level Lp Getter to atore the Sertpt th the clb AD that the eash anol. every User can cicreds % exerts that procectuse This & Coutlect Paterberce sorege proenclesse: Gr orerete veto 4 ONS the thtre} gqenerentton language ase used anol the serpl & creuulist at tater «Buk tn 4th pe ege the exeustion taines place at ctrentonly. From +9 te «stores én databau fo that each & enetgy exe Coun exeunt the Sertpe- e Gn. bot eateh @ hot bKup the mirror £ careose) t of dtles wteiken nck both ne a & peop dt & se r that echether the cornpletely | _______— a ¢— oman e i Meteterror) @ftlederp or NOE* But, coheheever Er £ | contenc ing a bine - | man. tAL conttantbkup of eucect bloctts eet) sng 1 [awe teen at beupat ovarkelevct: — : crane ort | |G @wran tre ed Bowes ax -taben oe hoe =| Level Bes at btu cd orcaels lout cohen ee cleal eutth Compiered Rrnan bsp then. at lamamldeiban Bas bamoxcvied amTOPIC: DATE: 15 + Ran qubormatie weleasex the absolute archtuelog ¢ Cte after. teuking the backup) to free up the. dere Space. we Prran v& a centalezed proceduve and et can powaltely gerue the Aauverks Foran Conefequrerbtont Aoargat catalog ) condegqure ct Lectener [egtetbi] @ cordiqure on altasnams (to-tgtdbi] 2) > reate. ¢ablespoce 18) ols] $ orapeac files ae GroproporacteS!0 abe user boot taentttied boy oot; prrssoones 5) ralter user. blot dadoslt 44 Amants; ar gront cmnneck AeAOUTCe, Recovery catalog. crores. (2 beat, 2 ¢ mean catalog beod | beot R ate - MAN > cres catatog, Wt Erapty cota 9) gran entallog beos/ beot. tongee Sys /egti@ to -tgtdbt- RMAN> Regtates databast',TOPIC : Derne Ga Reman dong fue Lektenef ora Sigrab = S10- LST -regtalbt © SIO-NAME = ! Spr carp Arrantals, DATE: ration’ ton cgtalog® Cabbata) © $ treptng to-fhgtelbt. on taxget Cetbarsk (dbaat) alas CHost= abars) ° et giao pawarknewo “A $ Lhnvckl stort pigtdlbor drstexting decteres Peat gut -insnames-ora. to -gegedbt = 2562 Costs abars)Cport=6787)) (510 = powarkinerd) + ay y erente terblecpace gmants) ctatectile ee eee arocintapl-dbf? S22 loom; din [orodate} yeeno Sarr creat usa boty tadenttfrect by bent edowtt [asgace ie box port 256m BADNI Topic: ne: DATE: 1 Spor grant connect, resource, veroerry~ artaley-otner to bcos Spor conn beads] bcos \ Bcod> selene g from. tab; >Bebett: countl#) drome tab; count Ce) ° Beoi> Ontt $ vmon catalog beoiy beoss gp best qteo Ie drop catalogs deletes dhe cota Resend > creat. cattatog; recovery cotala; ve Seana HH awop catalog rg to RMeny Extl 4 aqtplus beosfbeost Beoj> select countGe) from tab; coure) "ga auttornabfontty Gwerted Bros? Actect ap from tab; tues the Ghflo abt the -ongets and controttiles abt borg! etc: ashen a. catalog got created tfeles go wot 4 cot foraengtapp forty prostuce( vol abe dbs 4 orapsod ele = oropeopOrncte SIO pawcoud sige! Pore=y ; v des4 cd wa? vu 5 ae a 2 Spr? ctortup ee : 92 @latog: 4 anan catalog boot tee: toxget Sib leges@ t-veqealbss - RMAND ‘reqgtaten, dotabar; +18 TOPIC: pee & fF ong neat the apts) | DATE: Rraan> host * clea”; RMAN > Leak etb-urtpe-name all; H&L of patobasestechich axe coonected '> coteuleg): RMAN? oxtk Sqdplas —becsil boos Boos select from re-devabase; Boos Gelett tablespace-naroe, file: Beorte bxkt $ rman aptaley beoa|beoal terger syste @ €0 -AQLAE] Retany shot atl; at from tc- dotaftle; AMaAny host "clear", grient> spook log Shot -log RMANZ Shot ally gMeaN > spool off) Reton2 extt & ul phoes-togs ees condequre vetentton poltey & wedundlourey 4; Wotefaatt CAL any goknt of ime yron & qed to maintain only treo lakest buckup Le eronge to 2 \ ects. KR corteqare Eoerup opeiméeation off 2 © 00" & fh readonly rode tn target and once the Eup of tS 8 ‘fn the beKup Gk ofr thin of that ts oF non. d going w @growe to take ENUO} abi) seapet_poncontrws-F? 5 eedatartle.corehiguve dlefaule cleutce type to ctiak; tf defante Ls 4} exe want bape then place a2 Sobek’. conde, Antrotffle autobockup offs — Li change os‘ 00! CBoey tee cor eoth & ey backup the Pan aft! automatieatty creakes the copy of contect¢tte) coewttqutve controtftle quipbackup format -for deuutce type deck tm * (deaka tovaitay govant| sao! ePeckh? a tgedeute wo tog eet 2 cont 4 est [aeaks] crodate. | povart & be 4 enkalte ran 6 td rman 4 pod Jacéea| cradata] pavant| rman + ernan > conttgure dettce type AeA porailelearo t backup type e> backup set 5 (0 poraltely van the novof behange a 2 angel Geaweré) conttguce: ehernel dleuton aye atch format sack foradata] pavent|"novdt congue channel 2 dewee type ake formratr weoy tfdeaka} oradata] pavont/ ze-dbf wy) Cthe degree of porcatlebcstn Cotefeule degree!) denotes the paraitel + channels umnt Aman con openup oluvtng a. bkup or seanoey «The theeTOPIC: ones taken & complete the bu & recouny operation asfll oleereax as york toorense the degree of paratielsam) (pactigntng channels? channeld ave the means by eahech Arman concluctt és berckesp g Yecouny operations onol they represent a Btogle Atseam of data to @ poretentan deuice: For ot If a howe contigured 4 channels then 4 connectfons eufll be mole to the forget *D pen up the 4 ceperale ewer Sareions- conegure doteftle bueeup copes for deutce condégure encheveteg beekup copees cor atewtee type ack tly congtguie moncetatte to undimeteds conjegue eneypt2or for clatabast oft, comttyare ahheryptton algin ‘Acsioe’ 5 * cormpresefor. sf B08" 5 type oleate wis cont tqeave Snapshot conbrotdik name td yi eucxka/eracate/pavars] riman}gnapef — partontneno4?; + 04 ep these granr @ sheto- low ss oe RMON backup daberloercesTOPIC: ot tag bnrckh start Latenes 4 egtplus® "as Sysco. Ays> Atoxtup DATE: 24 4. eraptng, to-tigtatbt $18 4 skorbup 4 von. cataleg btot [b003 tongek| 5y6/ Ege @ t-tgtabi many Lest db- unique name ally RMANZ host “Clear”, RMAN? 4st backups Roan? report need cae Sn. corttquration, toe 2 eotunclant boerups: Bak, 12 m+ taking only ona bkup 2, neeol another one. RmAn> backup database plus archivelog; RMANY yeport needl backup; i con to bCOd 1 F Sgtples beos[b0ot yro—claterbare y ore tablespaces ' 1 beod> gelect & from e-datobeses; | prose select # ror re— backup. get; | boo? acest: fromm ye- backup. plete; { beoy> deleck # from exp; RMAN? Let backup Summarry ; RMANE Crogsebeck backups oquaddy beup 4 én target But fa a ‘alin te can cots check the 2 baskup of the Larget Seuss «22 | Toric: DATE: jo dengee Ged acsica]orostato] pewant{sman € iS 48 rman ® wn -f ogkrnde tp-t-t: lb rreang sre. -f ogkmnae ae-t-t-abf RMMAN> oO cheek boakup; tere cece gok Crom checker Aobjeus Beceme Ortenvgel we. detelicl @ bkup pleces Ard & shows tho acexpt prtani> delete exptred backeeps po you toank to delete te abou objets (yes or no): yes eMant> delete roprompt backup ob peletes ott the brup pect cath cut on prempttag by RMANI? boekup database plus archevelog ; ROMAN packup catalase; RANT poste neect bkup;Senertors foes of cfRlp fess on. targett : Syp77 deletk udernorne > cletault._tablespace dzom alba-tuses; Spx7 conn Acott| Eger Eeotkz ensert tnto erp Aleck + from emp; scott > | Sot 2/ Scott 2 commtts Gott > trisert gato dept select from dept; eat 2 / ott >/ gate y.c0n [os by sale: B67 alter. Gystero dutch lopftles op7 7 op> / Isp? / Sypr Gate mang ed ss pavantp arn + powernt.s 4s 4 ce &}s oy tom gee! beger geokty Engert tanto dept select # from clepts Enor! Qror to opening datafile -On RMAN'y Ahutdewo abort; cpieing RMAN> ‘veatore control ttle; <-; on sexget Spr shut abort dys startup nomounts RMAN 7 alter. dotabace wount RMAN> TeAtore databerses RIAN? yeroxr dakabase; Rrapni> alter cotabose open wegenings: Spry conn Scote| Eegee geotk gelert countce) from emp; entanty backup database; Repnt> backup datakase plus archevelog; Geenanton! Jats of monsters aadadtle on depts Sysr7 conn aeott| tegen inert Ento emp delett #-4rom emp; to dept selerk %® from depts cotkez goott> ensert tn Gort? coramit; Sy ater dyitem geattch, hog tes ope / oy extt pavant $ ar powantg wre paeadataoralbeTOPIC: DATE: a 25 S&ys7r_ cone Sooke keer lecoursy tneert ento salgrade detect # Hore salgroste Zerort Sunaible to open the qile: on caisleg eMany alter databa datetle 4 offilcne; error: gmeniy sgt ‘atte dotabase cletattte. 4 offen’; emeny geatore datafile 43 Rmanz recout. dotafite +5 on torget getant> gab t atter olatebort datafile ~ 4 onbine’; Scotk 7 selene count) from emps frorn dept} RMAN? backup database; aman? backup oreharelog ad; RMAN> report need backup; getenr report obsolete; mr Gites nek vero veguered archated: Rmonir cele te oprorape obsntete; penn bocmip database tag “te bee" oy Mktgning a.teg *° the. hookup of a database: event deletz! Lockep vagetee bKp} > yes Scott's elect count)TOPIC: DATE: REE? clelete noprompt poekup; RMPN> betckup of cornpreasedd buckupsel a clateibose; : RMoent? backup tablespace Sydtern; > TAKA Stage 46 backup: RMAN> backup dotafele 43 Takes Staple dof backup On ange on cataley: Syr7 alte tebleapewe usedatee offline; Reiant > backup database, > Balt take the offline té aldo But at -ftrat time only RMANT backup citabase Bkép off D2ne; Rinne oak oe qexelucle for terbleapace CUSEROATA?S > Toblezpace wSEROATA asttl be excliica} for futurerdcke databace backup: Reeny backup clesterkrce; Nok tales wSERDATA bKup eotant> backup cataba noextlucle; 2 Gt tates ehole clata efthes exelucted tablegpete or datefite i cuge, dake kup { | Reaant> center etcluce for tablespace *usernaTAa’ clear;TOPIC: DATE: 27 Crerermented bicuaps Ut! = =—=— = mary bat ena ups OIG cup tnevmentat lertl 0 databace} Qran> bortexp tneremental Rroan > boekup @rerementad = level | dortabeae ; Welt ~ Leret o database: texto - conmplets xp cunnulattve bEP @rean> backup fncremmanto! lenel & darobase; tepel 2— tncremental EP » Reman eeripes ore types 0 hocal Eerips (five anos anty the posttaslas -tenegets) 2) Global dripks (five avots oll the Lorgebs presen’ tn catalog) Eortpet (no edlete cornmand For Sértp: Stmply reploe the Sertp®). gmiant> create éartpe bKUp! By degault ae 35 delete noprompt backups rad bewekeesp dotabase pls arehevelog 5 ‘et was “lecol Sop? 6 4 crealie dertpe bkurpi quent veatt qoeet fartpe qr ber ~ & aéseatng exe crea ‘globo a ¢ éertpt. ap delete noprorapt borckup; a> backup daeibase; > —_ bowkup archevelog atl, G> crocheete backup; >» 3 crooked. global certpe g-bkP PMANI> Lak deripk newnessTOPIC: DATE: Rran> von as a 3>, execute Sertpt bKPU ¥ a 3 AMAR HU a § ay execute trtpt: g-bkp; uw § wr” . xe Bran Garces: gy Sed father anlutsorkt Generaily the rears contol _ erttieal prety ge > bowo thee prorty. The! Liat folluve? ell WAL the cfatlures ancl thery provtky psec aetna ea ermanet avollale tr afognostie—dest- athe dadoult algorthm # Reman upto 103 wos Bafprciod) beraysipe je che iftatk: algortthen. to Rien apt rom. 9 coor zUtbCu9) | the cornprosied Action axe Mer] geoel on performing eth B&tpa algortthen. shen compared uxth the zieb algprtthra.TOPIC: DATE: 29 Nertual private conalog! conwtdes. there are bv0 4 : i bone cataldge catalog and Cateriog? + Catalog: howe. the, regiatrolton of too tawgets fn & ciney io ancl cataleys esas empty regrstorest: catalogs import ye ase hawe the poeetb tty creole Nerbaol anether uke ax bcos by gtutng the aes catalog privilage as ecoutny catalog 2075S troport? added to Oracle 113 fo beoas Hence boot atl elke howe the . arne prnrebanges ttke bod Léke estat beo2 atl ee the ets (ether | or: (00) oF e& tlt Seenply ctsop the cotolog $0) for thes vwertual proceleing catalogs ove ereoted. And. oe can. grant the Limtttedt targett tO thak nptrtuol users: Suppote we are’ tndererted 2 vegtstes elt the. too tangels ee the cataloga then we have an eptton to uniegéater alt the too toxgets groom coctologt anol te vogrtstek, & catkatleg 2.” Buby OS howe voy best deature prowded er ud as “fonport? the vegutred targets thatene we cae needtects . geaton stee = [oom Gockfon Sezet ‘ecefon Ce : Ip dp} 14 0 : cn! . ay " — span Lhe —— = fecorekérg em rath, duppose exe rnatntatned Bertfon Ste than alt the aataiile c% partitioned Entp ‘the equt section $t2e blocks. f ‘ hloco, the datadtttee are alévéded ac fn unttorm, eetien Sere.TOPIC: DATE: Then, we can Colette the data -fom muttiple datafile extents at a time. then we can Engrease the performance. (02 can masntoin i> nang cChannelé in the porarmetes “lel Ahexo: log): dle diagram pr the RMAne backup nle howe a.cholee to take the backup fn compressed -fostnat ao that ft Cbackup) oceptes lets no-oF bytes ‘Led Databawe name 716 Boskup set nurnber LY 8 choracker unique tp Lt Backup Set time “UP prece murnber én the Ser AIST. Leas the conten’$ of mebactata reporting REPORT performs a moreDATE: TOPIC: 3h em Dernd on real Peg txtereng orother, tonget) on eatalog: Celbals) $ Se Bysrr Stowtup 4 wean catalog beogs| bcos; RMaN > Lee db untque-name alt; on another texrgett (dba) tovaengtapprorastel produce] tts bol netoorts [acento] dixtenes-0T ~ -- Renadla -— yep B ue Lastenes-orer Abgtdbs< 2068, Ceosts ears) (pont=630@) StD- Lest. Atgkdbe & BlO-names STOOL ree? 3 sunrckl start atgidbs $ col SORACLE. HOME /AbS dbs $ oraptod -file = oraprodg ORACLE-SID poricord = 4egtag tones;TOPIC: DATE: on catalog: Colbata) $ ul trsnames-ora t- atgtdba = Host = dats) Cost = 6306) (41D = Srtvoxtra_nesd) 4 tnaping to atgtdba: $ Arran. catalog boots [Lost soagee Syslatgte Amani> Aegtstes clocterbases PHAN? est ob-unggue-mame att; erapni> exét- gro costertog beoss[be0J1 target Syl Atgt! @to- Akgtelb Is Peaceay axltsovss Doren on chattuse catutsoest on catalog! Cetbat2) RHAN? loaakeup databate plus awchevelog ; RAN backup doctelase; on dinst tangett (Abas) Spirr conn. Sent Hye Sot tnsert trio selgroote elec # from aatgradte; O to-Atgtaba on. dst target Cotbast) & hanvetl Mort Abgtdbls _Eypr Bese % from Ng recour-ttle; Scotk> angert Into soulg vecle select trom. aalgracts;TOPIC: DATE: 33 cork? / otk? conn (on Syke SYr ater. System Surttch. Logtites ape | Spr] Sree gu $ am uderdetaot- dbf 4 ed $13 Sys conn Acokt] igen. geoter Endent Ento dalgrade Seletk % From salgredes . RMAN> Dect qattures gutdnly ackucce garluce; Retent> sepatk gattuxe prewlen; RMAN> repair allure, ov y noprompt sepolk qotlere; Po you ewant to exeatte the aboot crepaitr (yet Or M10)! YOR letdnty rrablolate detabax; Ml St afte fectexroilly votty the database blookk ane xtc perfactly or i there (& La waittien Or ory an extn: & oot eyes poet” RMeny waltctali -tablexpace userdodteTOPIC: DATE: RMAnty cordigure compretfon algorithm. “xe18"5 Rrcany backup os competed bocenpstt Atl 4 Jon9 ano overhead RHANZ bowkep eckfon de Sm © compaseat to aster atatakase} On catalog: Cabets) ys sho parameter contra yer? reat eibledpace ancpetae feuecka) ovelatey wena) Aupeest-dbef? S22 wos O77 create UACK Avpel teenttfiedt by avpet defo teolexpace — Aupthss Sis v7 chrarper [Apc 3 create usa ANpt etantthved by netpony- catalog -cxonet to Avpels ctotacttle anpel dheqouitt terblecpace dupes ayer grant connect, Fesounee, Sr Clavel Awper” Op? ett $ yon catalog btos5 |beosd Ren? Legeser qront Aegtaten detabuce tb ANpCL; feetanty grant acglcter dlonerbae to &vpCa; . ReaAne ext g man catalog super (Avpel’ RAM> creati vicrtual oxtalogsTopic: DATE: NAN exe § Fran catalog Avpea/avpe!} emant> creda utrtuol catalog; Far. ehegtble bat, catestay ceonest by beosd PHAN? exte o sqeplas — avpet (ave! Axper? detect coune(2) from tab; cont - tol ANpel? Gee gd aman eusetlog beodd] bead RHA? Lise db-untgue- alg mame ath; RMAN > exte $ ron catalog bros] beoad Boaget Syl Atet @ to-Aegtdel prant? grant catalog dor database Aencolb to Aupcl) RMAND extt 3 Arman catalog Axper [Awpct PMAND LtAt olb-uneque-name all; RMAN? exit 3 aman cutatog beost] beod) saaget extt gg Tman oataliog boss bod RMANL> Lert ol-euneguie— name att, Sraporting the tergel Prore one. base carteilog tea to another. bose cotateg et on catalog: - Bp qrost connest, weKcurce recor - cakertoy-oconer to fbcobes tdenttfredt by broad; App? alter. user beds2 dlefeuutt tablenpace frantsti; : , Gps 7 exe 4 aman catalog beoia/ beot2: ARMAND Creal catalog; RMANZ exe > 4 op lovatng) apport protic o/nenoretadmsa SS 9 § we dedtenea+ ore segetemp fs CHowt= atbara) SO ~ List dbgetemp = S:BN0- NAME = percanineso& Uanrtlh tore pteetenps Boul -tanames ore. Ct jodety en catetog only Boe 9 user ore ( \ antaleg) te aegeinp eHote= dioats) Cport= (sto= pontaneneco) 4 enapeng t0-Bgt cap $ Aman catalog beolalbcla & 09 RMpnt> emport 4 eed | beoss @ to- tkgttenp pman> £6e dlb-untque-name abt; RMN? exte } won catalog bo033] bo74 RUAN? MAE db-untque-name all; No targets awatlable --- RNAN 7 exte 4 veman cntetlog beoss|beo3) RUAN, ernpose catertog pr092|beoI.@ to - Atgtlmp alb-nome= amon Lsb dd-antque nome atl;DATE: oy Gyormetrtcad vent do precesstrgy) ExREM: Error corruptton code RAM a 4a eatery cam SCST{ Srnalt computer oyster ZZ — > Tp oe enterface pr ols Se FO: Ftbver tien Channel ee Network pe eater auenedey report SAE! ertal attached scst The ratn problern etth perfor mane, at gay 1 100 a uuntng & eotts ‘Reports’ only but noe 2 ou, Forres: Geocuske yeporting contornk the PT Sek deleting of thouwanda of recor: 9, eek . tote apteatont oth aff aes étheten ME exter, 71 (6AM ten kero. oe doo >> [eron-ouk fat toe fda de 1S _ BHeesss9 ern Soap -L 7 (Atop! oD OF ae 0 Guest $ froro emp — 1) 2D Seleck ¢ from erap = U8 eshere ename=*’ 2) update ant ercp hat cet dole fale -— 4 wa) Select emp Che - 19S by Aab:, Sinateod of lo roof drhes ff we ae multiple drcves then tha, perlonmarce cuttl eoer@ases- ae# Gt exe Enereage repre dries then the eonkotlers are also Jeio at cor’ sash contrhlea : 6 artes 0% eave oy ny % tnwense the i grees, ose need to have One Sleieiele) trereased: Bach contrctler ean handle up vrove west contollex, ab MOF ; te A diz con appre pls RE er ; Wa conkreflere enatde He - ye away the coortctng of cMtentt | are ak dag time: Gappote, the data % 198 + Linteoral én intédoy.ore- parernetes -tle- pleco, eltent dp cote fra | — & E Coata entry) or bape (éome) wand NGA (purest Cf shaveageot dove.do, they eottt have enough Reporting pce Bs) share ok PAB=%07 & S+P =307, a “4 But on eortetng totth dba, eniéntghe ove. for tnttaightoa, &® pth henge bandon Lire fin the catty 24%7 emeCronment pls age brontacttont, a. dha. must nok hut the db- from at we. ‘repos ele do thak the yeux the deatwe to frerence the BB or p20 = Boy, and SP= 207%. gp Sete or to elecrence axthouk shut: the. database: ae mAvoity the doy te ove very Arnatt «en ner 5a. MOLT! LOCK READ. coor compared to the trance roc &o thab veacteng of 8 bloerk ab Be Cott doy oro—lew = time & Abtdty enough for ° ang og Per inttneght-oa— Hoe she doy Keneduales Ara reaching ne of 80 blocks ce preferable of the ntghke grorkicng Aehechide of DBA- Beanuu ha has to run rruch moe NaNYy tee] :Jn orctek to go elect table-name, cathe from uses tables; Table Mercian abn. cached £1 nt > nol cached 4 — cathed Kory atter table tablename Cernp) cache; cache from user-tables; the batfercachs. Scott? dent table-name, Bot 7 sek teaing ons ott> engert ento emp select p from amps Scot? alter table emp nocathes yar dbo porometer db_wrtter. db-worttare proces eS tnteger| Toric: pate: fo kavote mutttple DBeoriters But. $ opnctE HomE/dbs/ tases ORPCLE-SID: QO epo-count = 4 ch -cortter. processes= 2 Cat max awe go atth 20 dbuntter prewesses) Seams pool - - - — Nete: do-tortter-process cwatting % aleowys bagd on cpu-count @F epu—counE=2 then we can have ont db-rortter processes: T+ Cpuneount=4 then ae but 2 Sysr7 a the jpbs- "Ss socnn aren jy Gq Loader or Sqtelde Ko tot used for are . ord importing the dots St ae ss or ee hen we GED che or teat ftle « Suppose Source conttclek the vegtlor Crp file Yen te cain} fal q tile, on wxtng cotth endures & a dump 124 : a. better toay C& & dvop the Ladle” BC "Ef nan toad the gata and resrantc the fndanes: taster @ drop Hlss Sefautt Stee. fer tre orcule toets * = 2 onsaly [ee ets te pa date colon. trnin 30sec es] CD Ree HUEr ‘Fle the performance 9 foverselyy proportional to the flo fromsstry $0 that coe. need to vorkeuce the to poseTOPIC: Dare: Shay org Ag ban Note: one user dorted dome alate “puey Oe Oe be udsect by any cnothes used: be Gah th chowerble but cot port: rt) ea Caney 9! aw Seppieg ar geste pm, pase 9 et eee a) 6 [dena f & cpr cot pos faces J & J 4 i = tablespace (atitfonay mgmt) SQ. SO oe \ created utth 3 datadites- Aral lectet coniicte a Sql Att provided crealit rmutiple extents ogenents we the “deo then the qury 224 and entertng the extent® and Hie dnttelea) tnto parts anal att & con rented and the cotaftle ddledup —-« > eptton that RL Skme= ond we au. ont data thn Gull is ac by vraesple op be created ak the next oocerttle and 400% ~ plant 2xeuutton plan wos maded by the optieizer G4 wos of a types 0 preezewstton plan anol &) Pose exeurtion plan Execution plan contains, the infin abouk the quey 40 that cchether 2& toants endex dean or chit ostth. tabblescan: ftuppost detect # From CMP t & noe neccessary © qourh ndaw Aco otirectly # through the fall ctoblegcan i = ExecutionsApteation Tuatng: O1, TKPROF Ctroce Kenel profile) & Explacn plan pen 2 : 4) TkpROF t Cpost exeast on plan) 2) we have to have the dource code (SEC stmt). ® Befow the xtaternent K dubmétted , enable AL trove exthes ak exon (on) at Enétande level + © Hong sotth the exeuatton plan exe can also rt the actual timéng Cop ttentng, flo teentng etc) Ghende, ‘timmadk..glabextter’ && Got to bue- jay aAHtes enabling gQl brace one submét our SQL dime then cracls noe erty exerts the Atetement fait cio gerarates a trace-ftte &" the trace cuveckory: (fn caxe of 14) Je) Noco, ee goto the trace dtrectory G férclout the brace-fite wohteh eg not readable, 4o we perform 'TkpROF en ce which procluces an output file the olp -Hle showt the execution plan pilowed by the Oracle. fy analysing thes exeuntfon plan oe ean -findouk cohather the cracls 4 going through djutt tablescan or by the roeold geen by He endex: Jg) TKPROF cx very euch ux@fel whether ce have the fource code or not For etaraple a btnowy coppltcatton cnet Bot of pertormance eases toe can SELL dfind out the execution plan. dotterwed by oracle by enotbleng St brtice at the eritance Level: Ih) The fide pile & nowned after the process td of the Serverprenss. > Explaen ploant Cpre-exeautton plan) @) 9 t% an another MELE prowtcled by oracle, Rech Ue seh for both das and af aoell a9 appltcatton Proproronren b) ® wa prsexecrtton plan: s46 TOPIC: DATE: © ke axe aantally caring oreute bo off dn exeusttfon plan etthouk — — aetually executing the dctrmee id) eco cack a table aatled at © plan-table’ by executing the Serpe @$ ORACLE HOME [rabms] acinin/ ubtxplan- sgt Cracks duraps or exacutton gion ta tnee plan table: later we can west this plan table fo get the exeustion plan: J) Srcowe ef exe hae ony Ynoy exeeutable plan & not tworthable coe Sttll go atth TKPROF Deve op opao Comcle povatter Query Open): codes eicuntable expoin Spor storbp S877 Sho poseirmaten porattel_maw sever} J atl ORACLE HOME) dbA] EneLFoRACLE. SID Ora st poratlel rman doves = 5 ene hth: Syarr Atoatup gorce, eprr bho parameter porollel more Sense apr conn Acotel ego \ Seok? Aeberk #& from tab; Scotky. £etece terble-rame, dlegree from uéer-tables; \Scoue > abker. inble emp povarttet 53 Solty deleck tatble-name, alegree from uger-tables;TOPIC: DATE: Dero on sofhene sitpping: B medér —p fateki]oradata) ponant 4 mea -p fatskal oradatal percent Brokaw -P tassxa}oradatal poscant yr Actenk tablecpoce—neune, ‘Atatux from dlba_tablaspaces ; Sys? cfeate tablespace Str datafile © fasxkt] orelater/ pavoné: lan-cbf? ge arn pesvact | stra-clof? Sle aro, ‘Jacakal orwtota] [atra-dbf? Ste arn + faeaes] orcrctata/ pewant extent management cliettonany; oy grant connect, resource tD Yeest eclerstetied by est) ees dye git ger defeat’ tablespace Atr; oper cone dic bist vent heen test>y @7/sqoplus fdarno] demobtel- teser? detent from tab; Spr Aelect degrrent— name, ettent-Td) fletat, biock—tet 1 bytes [1084.1 blocs from dba- extents cohere. Ocprer = "RrEST’; yor dove dersqt cysrr gpk aeAnothes wladoco: textry Ansert Ent ernp selesk 4 from erp teste? | beck >> / tect >> / Syprr get aes tek v> comrntk: Spertead indexes fn crace (from But upte creth ét we have untque and nonuntque (ncunes: ca wa have, the dpllosing adldzttona) trains W Reverse tee Soolenes @) faretfon based ge — Manual — production D GOT pGnaer org’a tables) atlad — Standley — prockuckton 4) pexcenching Andee een somes! 5) Btermap Ander rod uI- Automate Cong Reser toy Saat) 1003, i conven emp Ged “| ere Geol) Sndteasl of wrtog eotth novenal einclax potter to go tetth reverse tnolex: Because rormat ends. uattl “forme £ke a. one Level tong onaTOPIC: > Lol engea: tooctvantoge on canting af th comprorvten) DATE: 49 Fipuscon bated Gnatar from BE - re fndax xy2 (Sol-tcormn); Betore ec, Sete empno, earme uahwsx tom emp Siretax tor det Sandie ter Coron when (Kal+comr) = 5000; x tor (end,corem) Here, co are creating an tndet cotth the Surn fone oot enough to of both at and comm. Aral hence the opttmiser ensue the guey. Aerextty go through the tnolax and geet the autput Speier adyantages onel deadtvantages: Cempreton avaiable anty sees tencorpreisons theca: trom a) pores 82, GME Bahroutsng ~ data. at t 3 [advontoge) - jo x weet ‘ete procedure SOL tooobytee oes ot Coreen ee Greesbing grattitons of Segengeestect to record: “7 on considera the casey use have the aclvantage Of uktog ett the compression technique. Becourde, the large clate. must be compressed for Tnureattng the. performance. goo bytek Gndax, Dotoenhy <_ pata peubion ers io CSrreatt entrar) ——> opalakton . er Great entries re ett damprewion watt take the much ttme for each 6 evn reatrtl..Bo, Compresscon techrigre. (0k Neccessortly prefernble+ pompoveng ee performance by Gebéteg Tablepate haan (oggirg + NO- te, woren et i ave genmalZl for thetax tablespace wpaating co Shey elf A= anc prodtas rue g more ee archare loge: Pe50 TOPIC: DATE: that ome s0"t of performance cnreases But the ader-cieta ancl or tewaked ard the data (5 dynchronized. Suppose we then. Stenply Tecreal trite Dog —> Automatic Optimiser Automatic cfomge rranagenant* Asam 9 Automatte Segment Mermoy manage. 4 monitor MImon tablespace wage" prstt 5 proaiive Allocating the temporary tablespace. of orostst Conaider. a Sb Sava cl’ Contertrang louge (Hp dfista bose toctusting Appiratias recounting, payrett & france: indo: whan we “ (ot > Aatoroattc: 408 none Cocsableel) Goto enttora. —s stattes- leet (st da) 2, Zs easce Conny efor sab) ao PALL Catt daLen) 1 & ees Because 1,8 eco s © 156 f,.ob ,000 Cpreweans tee . Soren, 02t recor Te S000 Caddie ) dtatte € gooo Cu ” 196 Some one [ ca chyrerrnl : 4s toy. Cntremonte bss gating (Ot eta eto Stvce can Knot the Atokud of stabtetres ydese O tables Be. atatuc (Seqrrant Siaet) Lg naitt Cthe value cs nisl) a 2 conditsond: 0 sable: or tarbte! Ly ay CAvottabl ) ee athe Ly seate-CMeang that Some ato ty 2 oa are takan place bk Setlt noe den = NOME; colostatid the alentcatecs-only pentous statesttes ave cvatlatle). conateler the table contains, 100,000 records Costes wt coe one adciing date, 5000 2002 keg. Move here (6 7D neccessory to cnlentote "the daly siatte| peterable only after aciding (0%, oF tbe ortgenad data, elt reguire glakesttes coldutah’oo + gan sixtng: a y spate O + enttrora Stake a Oe== ) Sernt Stee; daycare. : caxeentc Scope = Both 7 once SS future fretonce 102 Recak of a debs , i ayn Tonge = 468° i Mn (08 chyattkornobealtey ogress grocos @, chrtabs octh the . help of BP Meant Asta pe the Ae gth trent ©54) topic: On working edth S48 Sktng te have related SpeetPtedt components not or at: Regurcaible tablexpocet ak ath be ends the can be changect aa auatteble from 109 ane catted of proactive tablespane 109 ~ proctttise sop tending sgt Att bereuuse hey on a fer rid eOR- worttoacl Repoiethy DATE: etble to grow the Scze i So they owe, 08 BK sp CAhared poot) Tp Cdawa pot) AP Clge pool). RUB (Restclog) ate! Sp Cstveamé poet) 08 — méinval= 6oorMas- ant then exe con ereea th. at 85", mares. “esoUNeeS / IM, ep. wero SO ehen the usage of the TS reaches yey. then cremle Sends % “regular. woarntag? yea. nai] alent] Sms and echen tho Usage 6S corteeal utarntng’ These Ubreshotd ohne ea, cus enveronment: Tik qeature comes Jertttoad saxretrg Regan warning tating) TP Anmchtng Sat sat Stinks vasalty tn pT we get probiam oth time teockirg)DATE: 55 Topic: wen! eel Ceftra — fq — 1 tty Cio men) tr — Retention — qdays, Ctdtay)> T dey i ~» 3s0 Me, 5 Sess coe Sts wmsally, the Snapshots xe magnbunea equentty for tomio ond tolwp setention Erma: te can thank feaventy ‘ ont need more Secon abluspace - a ako: Bat We maériadn abet dou wae! it oe SGA ah 8 2 0! in aes Freg Cr — Gaon) pte or Snapshot of AA 9 Analy ts 2) Roate Come D. Saggestton 4) Rattonale PK the data. or at Aeme geen to ace tS taken ent by tensors fog puscedaey Ott PWR etth the help of bg processor MMoni and ther, corthes Hae Snapshot to the eoorkboac! vepotitory tables exéstad tr the dycoum tablespace and t reads fey the ODM and than evel Le r analyses the dtrnt ard go atth rok couse of che Stmt anal then sstth the duagertton cto aelve the groban) eat: task tb gou Urces> rattoroll, AtOR, (woathel ee tb) Sores serseet) tatormatcen — S™ eed 4 Frageeney, Syouy e6 Retenbiog | Tt Nurabetof oatie ; i 35@ Topic: DATE: Derno en ADR: Syre ortup: Sys rr @ $F ORACLE HOME /retbma/ aolreen/ aeorrpt-sqb; Enta walue for repork-typet text G th beocoser level Eres. wolue for num-dlays 10 fees dnapahots prenctously taken -- - along cath Srapehot t+ Glek value for begin snap: 45 anter. volue for brd-snap: 58 Ente, value for veport-pame> au tte Syprz exc $m Ul arwibext oee, Sjr7" dbros- toorkteaarepesttory -crenrte Snapshoee? Bprr les. bea. ecoukload— ‘repoxttory , x. opr” @s ORACLE HOME] rAbOS/ colin} adidenepk- Sy Bante walue for begco- Snap: 45 ontee value for end-snap + $8 \ cavcan uce hime Foal eel to rranua) Sop‘TOPIC : DATE: Enter watue for yepost-name = add exe spor ed addene txt ck nore SPO ) bene Tt Generally um cleal utth the diff fetes on workeng eotth the dotabases the qéles excts En databae are, ASM ¢ chstornatte Storage Man ib Regular ftles Cotter bette. contrat} performance) Gitte, om (at) Coreche rranaged fileA) (offers aonvencers) Rano Dev Cotte performance) "OF perforroance) asm convendends)* Coen pest + es . ‘The Alandord regular -les, eager Gctnadeucat 42h Spheres eRoemease. the RF> ceates toblespace ye datetie napeca tespees FJ...) seve 5 tay! [a dy lay [AS RE gy od ura endo exp orate managed les, sored) qeaqet Croan OME> crectke ablexpace xyes SB . ome / la a tay a etal toplist only * Byers) B RaIo~ Bbrping qeect better convenience, Gecacice att the d&shS are condtolertng ab a Bangle volume (Legtcal uttumes Gn desta. & stetpeng 2% gota on bebueen the muttiple drives and atlaat the dota & tserted into a Kn Here ome artue Am that Convenience rontetnd, Because ste RF. we need not howe to rrentiop all the legatons.of files. Hae only one fee 80. that better convenience taloes piace: ‘ee ae OT ge co soe TOPIC: Bares aa Ca¥? Rowd-dewtces- oe Te 6 OE = 7 on gasses Oy omy” oe oe He ens 7 ie oe Roun ebeetes on cworkang ath ce! _fgeanseatie ce abe 5 tanaged 2 Hl Recorptb : by orate ools ou yt abe; toleuf ra.aky 2 partranicg Chtodisg he O16 helps the oracte sleo only tm prowCating the address of the rae0 cisucoe- p> Paso davéee & not a clerectoy St & File contains no ftter fn te and ee con't perform Atendard uncr eperatfon® @reltuucting back ssp Ctar | optol pax] wfAdemp) Roxodnseces: Aawontages % Stone oracle dealing devectty eth the artve by poveing toe can Kee 10- Isifs Eoereast of Blo perforrance Atsnarverntages! eames the aivtve U% Meated a5 a rato cteretoe,(nol a4 a gle Systero) wont be able t ude dtandord unit bkup commands Uke tosfepto|pox) pfadurap The cforceses to goerth mirror Ernage brup (DD- déskaucrg) ashen & wery dfocoC bkup takes sorges) J* Sn a Aegubea qa 1 ee can creat ax rary cites ag ee exishy hese ak th thiA foww dawtcce, we are Lémitted to the no-of Slices) portittons Pe example, fr SOLARIS we in have. at the rant 4, Slice — which mean we can create ma’ ceguire the entire Ste of the ere 1S YE ASM architeskuves = & + O0r- PCCTS fe our uteg eed deca geves that we are = ~yMeané the mérror fmage of age: the : yor Note: Atl the desk groups conto a Le: etic fe “ ce op Comal grt COR ost fe of AI ak sq? a ne OTT «ou at these 14-0 S sent 4 osees ASM. atéont . DB apy ast we ot eee of 8 oe tegh- Sp en 1 8 3Fals aun orders CPT ‘quer or coo Puce)TOPIC: DATE: REMAN TSPITR (mon toblecpace potnting time ey) e 7 bbe tenoes that, Jers of an objerk ok aprn @ Wwe need c& ok 4pm than qo ont entire databatt recn ‘ a oe con avtotel & by Ban TSPITR: prod he" FTE apr — bi 9 PmmbEAP Oj suutlay -Frnstance: Rertore— Last bkup apr Recowr- unttl time. when ee eyeoti on Vouretlary fostonce’ togteat beup— obj - cxe Caeqouattly net contain cfetp flea) then Reatore — +PrO Gitte creates the ‘ebons of the emp ~obj- ort databow’ from the procautton fn the porttentar path we rrenttoned th the poremetarciile: Guppot ef coe crane an curtiiary nstonce the dotabate and some by provesses* Mrxrend af dttorbing the. production dotabae exe recov the ebjers én tect by cecblaspace Cevel de Stenply ated Aereve oP cat erport the tables pace 4 fom teat ret ern pont te Into the procixctton 60 thot used cain corrpletehy gees on ath GhetA ofen stables paces” Deagadwantages: ap Stree, ace cleat the object at apm @ realises at aprn anct the toblerpom coos conbenwscusly fr ondeMe: en ee muck al4o Dont the ‘then tt rompunt Apr Ceptn) soot alo So, woe must take an export’ of the 4pm cork fh that tablespor & after Regovtny toe Emport tkTOPIC: DATE: 63 G77 stoxtup- Sysrr coon seotel teger |Sott> sete: count t#) from dept; count C#) scott conn / oS 34sabo. Sarr ext Bod [aeses) orodatal powant/ og! sabeng| reradb| pawarnero| & ea trae tore $ Ag —Lte { ~ copy the today vecebtly Gysr ater Sesston eck Sat- trace: true, Depo on TRPROF CTrate Rercel profele: Syd77 Seleck username, defautt— tablespace from dln users; brother wéndo Sykr7 COD Seott| tiger gcotty> geletk counts) dromemp; Scott >? Singert tnto erp Seles ae from ern; Scott»? corral} geobk yy Lagent nto Salgrecle eck # from Salqrade; sotte | Scott? | comme; grotty selett # trom Salgreste; gensoliae broenfttes - - :trove $ bore $ veprof —parrernfrew- Or8- 3669" OE shoco-out Sy no output tele: exprof trace $ ut shoeo-out count = troce $ cd uso oP Sylon plon: Syrr @$ ORACLE rome] Sqeples] acenin] pluxtrce sq -- creates pluctroe vote for Spauiser «~~ - oper qrrt pluxtrace to Scoths yt? conn. Acotel tiger; Gott»? Select from Sevtton- privs ; rabms] garnin [attyplan- ¢ aS qyeates Tobi. creed. > cele countt#) frome emp; count) glan eithout qeuveng - the yecoras Copa: Preartton plant (And aio can be Seen 6 ve 994) Sootty gelest ¥ from emp obese ename =‘ geott); ] Mt goes cost entire table Seon becom tneax have not create -- | TLL MOLD + 2048 yok Zelentecl Listutton plan! plan hed vole? ---* Broke create Cndax grdend 09 Aalgrade( qracte)s gcott> Aclece # frome Salgrodie, where grade=!) =~ Ge gotng wath entire tableacan because thet & no analyzation of StabtAEtCS = ~~ 6 =~ gottr analy re tobe dolgrace comput Atakesttcs; Brot? Aekeck w trom. Aolgroate echede grade =!3 were abso aorsetimer go atth tableacan: Beaaur fndeves ate vow word applecable cy lage swecord tables -~--|-- +TOPIC: DATE: Seotky gek autotrace of} eo’ for forty explain plan ok gtaternent— td= Gelert # from emp eaheye enarnes Scot? ; Explaéned: Scotty Gaeck #-from erp eshere ercirme = 'S0077"5 pee Oroue chumps the arecchy woaleal Exec plan *nto Scotty setenk to-0nSt» cpa cose , optemirer , cbyer nome 4rom plan-table eshere skaterent— a= too! qo sror cost enoos eptiren? —"g she porometes opted. re @ aysr dba properties >Ginsert the Htnux potable ca & restart Generally the Enstattatton go cotth 00 methods: boot: tert for graphieal rod book + press enter * egeleorse fo red hat creeps Heat Saee * v Engleab Cel which wepdel egjoned ge ave MENG: Caaoam.Aeesten vous r= + St obvecicty Linux extkts tn our pe then tt asks as Y Roingtat gyabero Rect Hat Enterprise Anux £8 4 (sels) ws% — peake patttcontrg getup Platoparetiton v¥ peak Prutd Back: Z d yo’ ong 099 Lo ory exo a ewe oe oe ynot 7 paxtttiontay (dew (sada $da t 121 a7eM ekED _ for delete parton F4+ polert att the ontcttng portttions andl delete th: Gy ‘eres’ pavettton exeats cthen clone delete te Because ct wos wkacoook O|8- for new partition - fa Caeleck (devisdo & press Fa) Adel porttitor: = poo Mount foents / eke exze ti MiB)? 4000 (4 farce to be @ primory posrtteton- \exte ste ema)? 51a (eI Poree to be a primary portttton: ce] press fa Pe) 7 PS 24 oon wtteton 7 ae & “ eee Mount potat: / usr ens Ste (MB) = 15000 pate 08 18009 [1 fore wm bea primary partftton Cniot mandatory here) fe] press Fa (r) ‘TabKey- in eS ie 3 Ade pastthfor: yr ol “ee om ges corte Mountpoint? | Vor oh oe 250 grarepl ’ oe are ee ents eo Ste (MB) = 4000TOPIC: DATE: pass £2 eo oe fad poxtttcon pd 1° ae vs ae sonore” Mount pocat! | oraeng ext ate (MB)= 19000 aa Bap co to fs press fa = yo ase or ere tn oot fell poxetiton Mount potnts | opt pote enka Stee CMB) toooO press fa fad pantzeoon Mount poént! [+P exts Se LB) = 4000 L min 2oo0 (v1) or 268 [ox] iTOPIC: DATE: 71 agent pas pezetor wt stount pont Bp coe have (00 then give 92 Of 42 chon 1208 ¢3 enough Plte System typet aS | more than 1068 go colth the sare correpe pret tet pe SOP w * 122 CMB): 2000 oe 200 yor og. press Ff cag onectson) en oo ol Mount pocat: task! b> 7 on oral om gcve tel) = (00007 gue i Sa ; not? Aga. porttitor go mount point: /dese2 a ents, Sze CMB)= {0000 clTOPIC: nae eSS F: Ald wEttfon, press Fa (add parettio! ee apt te? tount poents Jacek ce ext StzeCMIB); (0000 or] er) fia Note? Sn actors we have able to create 4 qtéces on a single ISK Gn Hour we howe able to create 4 glices on a Sengle disk: which «boot jena coould you vie & use} (8) vee ORB BooT Loader. # Rape legen epottquydtrr CTot a Geom password: Arbo CROC aeuER Noe necessary to gO ett paxcoordTOPIC: DATE: * a = Seunrtty enhancedl Row SH : Boot tewster contiquralton: pefoutk Boot lobel. perecee + Real tak Snterprese Atrux ES [der] odo renal wotn- tInatatled then tt alto desplay --- mentfon that echtch ola ¢3 clefautttyy alestup --- ft alr nto manually we Joker. opening usp the Syste" or we Book looser cortiguratton eshere ao you: count & enstall the boot toaster? na att Ube paew] sco taster Gook Record CMBR) a potable HES of go a's PS we ope” * Fe recoatt (a3 po Ftweenatt &) eoweng ro -ferewalt CHI Acktve ealTOPIC: : DATE: + tonqung’.. Support tel Enguesr Cuse] % Teme zone eelestion Ce) gyotern clock USES OTe Asta} callenteo % Root passenorsl pasrecoret pilahere accord Coonerm): sotlahere — pacicage defaures (#) custornite groove Selettton- tal + pnmage group extesteonMr a TOPIC : DATE: & Anstaltatton to begto e 7 ~~ = docakhogt to TNE Pte ot Satrag Sratattetton of orade U9 on aunSotarts vertton to- a rnkdir -p lorceng lapp] orale | product} 11-1+0 greupadd -g 1900 ofnstatt qroupadd —q goo dbo. userada —9 ofnstall -G dba -d loroenglapploracte/ proauee [tt-t"° ro orale’ pasted = _d oracle chown -R oracles otastatl foroeng chown -R oracle? dba /atska ub [ete syatern Seb test. module? debug = ons noeiec. User. Stack = 1 sersyst sernttofo - gerpront = (00 161 Sorin fo - Sernmns = 1024 sovoyet gemtnfo~ gernnil = a+6 Sermsys! Semtofo~ Sernvrnx = 32767 ERE EE Shrosys* shrotnfo— Shmmar= 4294967295, gab Shrigys: Shminfo— shromto = I 31 Shminto- shrront = 100 shengys + hrotofo— shreseg = 10 ‘HE 8\Sropic: DATE: tt Aeboot at su — oracle — ashi ORACLE. HOME = [oraeng / appl oraxtle [proctuce:| tht: se 96 a> teenth $ both bouh-3.00$ pIspLAY= watsunag 10.0 a rexenaarne tosh-3-00% export OLsplay bosh-3:00$ puod loraeng ae cqnt0n eng PF pash-2-00 ai fopt; omens? re ee bash-3-00$ 18 gonwlts sonwomlth dotaoose foxes toandl bosh-3-00$ Cd dotabase/ bagh-3-00% 46 doc ‘response stage ter Uke txt files, doc tiles Gravett yun dnatatter ygokome: het | Soars howe waaitnatatien, make Inetaiter fetes. (ash-s:00$ {ran natelter) fete. bagh-3-004 vb + profile mage = Jusrfrnactl $$ LOGNAME? rg axpore ORACLE HOME Joraeng | app /oracte(produte (10 ee orncte.omel ben: Jotestusrl bea! (usr [ccs [bn usr] web be Soe f RRL SID edb: AD-ABRORY PATH= § ORACLE— nome /ttb, (usviuebtt,/ ust] openeotaltt expovE AD- LIBRARY. PATH dipss_ peri = 4 RACE HOME / jib expore CLASSPATH ©TOPIC: DATE: DISPLAY= toSESUNAB 0-0 export DISPLAY bash-3-004 . « profile keush-3: 004 prod bash-3-004 ed lope] databsse/ bash-3-00 4 M4 pash-3-00 4 + | sunfnatatier eonttaue (VIN) 24 Orose WF on Aires CIngtattattor) => aren Tebooktng we get ¥ welcome pb next * Ltgcence agreement: > next *® pote & time bp next Je ptsploy > nex gystem eer peck — eoorntng le Gourd card > ment le fadittona) eps Db next lp Gineah setup — Dnext pt ale enterpece Hwee uSername= yoot passcoord ; jelahere- ee 723 ‘ 4 TOPIC: DATE: press wtghteleex —y open terminal. Crook @ localhost ~Hrakdey -p loroeng! applorade! prockace [10-0 a it groupadd —g 1800 otnstat! 4 Le groupname: optton tO mention grouped tt groupadal —q a000 aba: mentions the Jab useractd i we =u tol 9 ofnetath = ; i 7 dba -d [oraeng /app option ig option to proutde the weantton mention Ee, vised Secondary group primary qreupname: — namet: # userodd -u t0l -g otnstatt -Q dba -d foraenglapp oracle} poduckiro -m oracle . ut fetes passtod ey nats te prasleug: ¥ 1e0t: 2000: 1 /orC#r9 [app] ser oratel produet| 1-041 ber ke ab passuod orale Meno one password: wt ehowe =k oracle 1 ofnatatl ( oraeng acho =-R rade’ abotacarr | atskaldcsk> v + option to provide potseetons to We ro poet ton tepof ott PPE anTOPIC: DATE: tk cd fetelrerdf yes-d | saqkenet C file created noco «> store Kernel. proc/ sys| Kernel) shromeax ah owe parameters): echo a47 483648 >? echo 4095 7 (preci Sys! Iprocl S44! [proc] 8441 4} fele-mox kernet) sbroront echo g09152 7 kernel | shroeul echo 65536 7 1024 85000 > i proc aye met (¢pv4 | (P- hocal- Pave TAR eho echo 250 32000 (00 1ag > [proc | ays] ermal Ber 10g ghenrnar — Mawtmum Ste of the shaved rnemory Seqreent: Shremnée — moxemur no-of ghoved ‘memory Segrnents- a te) catia | pages ab a. Hime eb con use Fete-mnox ~ Mowlrum novof #tles we CoP eroate at os level Uprough orate: tp —Loead- port ~ range — Port number ranges from 102 to 65000 sen hore values: at sh Sarkeanels tk chmod 755 sqaKernels at cd at ul fete] gycctte cont Kernel. core. uses ~ pcd=! nek cove. rman + defautt = agalad worner | getemtt = 962144 nox = agate+ = 6ate4d nek-core pabecore + TERI, restorer — ra net:co) 4109TOPIC: DATE: —é6- ‘ i ‘ ‘ rmemi read memory butters Sete- _ tomern cortte memory butlers Sete: these rmern,comern wabues ave usa Er netaoriccing- db inte 6 CReboots the partteular Setvton) Rect Hak Enterprece Atnux username; rook pasteord: #xK* Reghtebser er open tereninal oe ge veount [medéal aaroro} ee at cd (medto} catrorn) whys oe tt ws weqeatg upgeoae patos Heutange tg Ri-aelStONe OP wot a2 AGRI _darabox tip CRY oop or Liou x86 — tight - databa:2P | ope pnother tereéro = = a cg a Pie oe oe oe Le ye a ie a \ ye we & ut .tash-proftle- S <TOPIC: DATE: 81 expose part uunsee USeRNOme export onacte-S10% ott expove orActe-HOMe = loraenglopPp Joraaetatproaucel MO export paTl= & opActe-Homel bens 8 PATH: « 4 1009 Fert: terre § + - bash: proftle: att cad [ope} ar Me unzip peau 286 RI database atp tt eoateb af=b eves the aetanls of the sites att Another cocadow? & ca lope! 4 dotabot = 7 $ cd databace! fyeok Jak xhost + $ ds -- pantnataller . 4. franiinstatier gt opens. ofacts tntialtatton tindoco- © Advanced Snstattatton DrextTOPIC: DATE: # Speetty Sromtory dsretboy & crogentcals prext & Selett tnstaitatcton type © Enterpreet eaetton i Gnétal! locattoo orexe crock: Bae: [oraeng! apploracls) produce [ite Dene woging: yes warntag: 428 ® prodesck — Speckttc Prevequiatte checks ype status store. TD user vort-fted jatomatie EF usa otrtived a cdeK on the values errors, esorning next a Gleck conttquratten eptfon @ Mnktoll Softcore ony: prruttegesl Operating SyRte groupe pnexk nent 2 Gurereany > TnatattTOPIC; DATE: 83 * Evewbe conttgearcation Bureptions CBetore press o& ran Ebe Serspk 04) wit oh orang Lapp [oracle proctucettt-1-0/ orafrwentoy Joracnst Root sb 4 sh lorceng! apploracte| product ie] aa on Gnétallatron utadocs pol beth:44roptc: DATE: bewecce ASM: Keot@ localhost J tt Afacak -b[ rove CAtads aut the togeco! posrteeceons |] my 9 ont togteal parttbton -ttores 7 ony one Hila enAtole Ler peskt dev 1Sdo gp Bxtendast porbstfon can allows o create reuitips togteat partitions: pest dex (Sato a these. gical ttetons Afants oAthS: pesict chev [Sale ee ‘ Becourse the 4 O00 for primary - . partibton + pesxteler( soll (Dont otelekt cy togieot powttlfons) (dev (9ddia 2 - Rene SWAP” eqn 08 oO vet als &° 7 » ea Trt [awessot coat 9" a Bren eq etek FT sas a wr chmod -R fe fatate [dlew[sdo eommanalten for help) + help corarnatnd (ra tor PIP)? command Cen tor bap? d (datetes the partitions) poxevtion number Ct-t5)sT ohech coore alreauby exiktedt f Cprtnte the partttfons) coramand(rn tor help) = p> --- tno parettons) commana rm for hep) = 2 Gowes) ' te fassk taeer sae aTOPIC: pate : 85 comntnand Cm for help): P command Un for help): n Cro aad a parttto0) “ 46 wast pod at command ov:ton wot ae e extended we sod ot) ot ee av s P prcmory pavtttton oe a e 200 © pavettfon number (t-4) + | . tyre we are nok mentfoning epact then cefauttty, te tabes entire cylinders Spone—" cornrnand exatat(rm for toelp) + p> comord Cm for hep: n . a Jogeeat (5 or ow) a4) p pricreigy parr tttion hose? gyindor or +5(2e or +S2eM or + Seek +g Ly Spectty the gtze of the postttton fn Ga's Cinasaiy defaute 2230+ command Cr for belpd= p z ok th Cplinstet: a command (ra tor hep)! of nt" a ott) ok ot meet fade tylinder or + Sizer +Sc2eM oF +Staek : UE 2031, defautt 2280! tag ‘6ToPIC : DATE: command (m tor betp): © te daesk — /aev/ stb Repeat the above procedt a fassk faevisde P atbave procedure for ‘hast woo vacodetees wt PAtsK -L] more (shows He auatloble porttitor) ash of th ebmed -R TIT [devisd# preter cotadoco we oe? -oradle rc A a oe : (ovoate @ toca haat wg cISckL. cheat C85 GSA: huactar Syretwonization Serucces doigecam daernon- ce facture tt - - > te feted the doco lar cq forcengl apploratt/ gate lotangt apglonne proaweette tof to eset s— paalibeharks the port tlfons btn tt Gh toroleonteg adel hich we aan paty creouiot noeo- duster Synepronezation Serutes @ aebne on att the nedies « & exscel cheat c98d = qquater Syreprontzation Ser veces appears Theattthy *TOPIC: DATE: creating an ASM Engtances rade] 4 ue «bash-petle export opt! export ORACLE-SID = tasm DEMO t ug gaserble wa toh! 4» « bash-profitte § echo ORACLE-SIO LE-giD= ORCL $a iovacralapplorosetpretueinr alas dbsg ve cack$ ORACLE- SIO” ora: cnstance- type = a3t0 asm. acakstring = * (devl gdo*" alex} sde®s” taew(sod*?” Mtaex tsab®*} ddagrosttc lest = tpacexs}oracttto] aamderro” i lenge - pod-Site = 41D a shaved posites 160 arn S01 gibt | ant $08 gayr stents Sons; dbs $ ed S mater. -p Jaren) oradtata) asreder>" 4 gatplus 08 sysstba” RL? dtortup, pornount eM anaidnee started a +TOPIC: ———_|— DATE: ety \ps x Céhotas att bgrecand precess) osm-rbol bq & for balereéng the cheskqroups’ Setr desc vb asm. desk CGttes alt the togtead postttcons 4% asaks 3 sac oly desc vag asm olextegroup s&s Opty Adee names path, heaoler- Atatus from vgasm-cfsk’, ee 1380. tee candtdate -» Means fee Fetbfons U panes PE oy tdewtsdos oe eo an ee 4 arog pares Meang & alxeacly gentrepatiog to AcSHGTOP: Not cued tn presnt ebéshgroup forreer v Means UNK gs0-togécal pontttfor & powttttorad preeéouxly en One Go tp rook Akskgroup andl roto aoe can «tt te ak meats -j [dew[sdoe Cohanging the Atatut of the partttton. +e totally formatting that togeee pestitfor at Bode level) Qos yer ‘ owe, Qtr seb nome, pati, header Atetus Lor code phere rom vgasm-clesk} arom vg at (dew sdak uandcdate. ae Y Neco ¢é can be e2%eq for acarigroup §*TOPIC: sary sete #from vbasm-lESKGOUP] poe “89 | salr seleck rome, wtate, type rom vq asm-atskgroup; Ntorne gto musi ptsmmounted — (means the aliskgroup CS ot at atl porttespating. Hence no operations pertormast heat) 60t7 aeake adtskgroup extdg external yeduundancy atc ¢ Joe isdar*,! taer/ sdb9? 5-7 angther anges") ye ort fatlooa + Ce] Koup | BaL> gelect nome, path, SeL7 create dudkqroup nordg normal header-atabus from vs redundanty det’ faltgroup 49! desk © (ler) ste’, Ctdev/sibs’ faltqroup #9? acc © fetewl $09, asm. dtek; getee the Logica? . patton Cree) «~~ nbodoclovs groups: Ctdev|sabs' J it Glaus) nesgroup create ( Dedauiltty the otShgrouP & ta mount SQL create dssicgroup hegheg high redtundarey sfattgroup fgh! asa © few sdore’, loevisdbig’ ferlgroup fyb agsk © [dev/adauta’, § tdeet sada’ tadtqrouP tgh3 aise * fgew) sabia’, © fev (sabia); BQLY Gelect narce, slate, type from nigasmn- ASE GrOUPS nome State Type: Extdg —wrounted ——_pxtern Morag reunted = norma} Oo +egralg mounted — tq ‘— TOPIC: DATE: w creat) rol grat Lerména} pam eleent lb) @ ue -bash—proftte cagating an asm euient cays export ORACLE SID > + ASMDEMD expore onncte-SiD =cltdl 189 3. « bash- pottle 4 exo $ ORACLE-SID 2a foreengjappl oracle} presuck: Mi trolelns dbs} cp entk-ora ence gor dbs $ yt eEntesoRActe SIO‘Or> AChE SIO‘OTA db-name= easindbt contret-4ete =" + pordg/esrrell{ contre cet” dtagrntte—cett=* accealoroaiata/ asm” thle = tile comnperté leo undo —terble apace = ureloths es ate undo — management unalo — retention = geo . wy Ndbg4 mkdir -p Jaeska]oradata.) asrndbTOPIC : oa on On CBr extrdoco 4 osmernd tates to osm command (@) sqlz | aarnemel prompt) psrterp 74d Ces att the cteakgroups croatia) fememD> help Cwies att the commands used. €0 oss) pEMicMtd > col nerdy mememby rakdcr asmdb (10 Atore the asm tngtema. conbrot-fCl2) pamemD> 16 cased) on_deent ob esindero ue ered: 3qL create atotabage dageed ogra dotofile ¢ +rordg/ asredtel gsternot rece the. nodes) 7 luster Setup Here the désadvantont { te a See & autoriattatly Horsup | Meter ath ves. ange, Hegh ovatlabeuty: ween moment - va NOS mA ws et cnet. nee hoe © gh cwcrctabeliey oof 3 Kecaol HOLA onsk Bt tte ppenously ees ase coring % ae pose pectormaner Los ter tne (grarea HoroR hina Bee ony * s No depersls on ard ponty p v aa uctereng eo at casey: To maunkeen. écalakcuey 7 ASE Nebooric attachedTOPIC: DATE: Sh thA Case we can aad any Hoof Servers becawst of NAS onaclabiity. But the perfownone t& getting denon whing SAN ae qt — AS performance & NAS Sodabettty. ye SAN offer gieok performance (ithe tm OAS) G Scalabélity (lege to NES) # SAN K offered to ¢three aleff technologies): 1-1 Fe Cétore channel) very expenesve) (sere 1998 — ttre tested) 8) (SCs CBnexperttet) (March 3008) 3) Shtinl Band yet (> become. prociustton) # pittough FEA wey expenntot © Emnplsmant becot of C6 pert Utogbt ge2) te th the best chotee avaflable of of today « Fe uote ating calling qiens ) Copper Cupto 15 deet) 2) tlre qpttes Cheat wou Cupto halt a Ketones) 8) lore optic bong out Ceipto to Krne) wp Beco of tht long austance upponted by fe ft benomes a ratio! chotee, for carnpus type? OF arntronment+TOPIC: pate: Rata Guare Cduatlable trom 92); Veraton 5: 48) produtkior jesnstby oo 9¢ 10) 20) 3)---50 BAF i HRS Sexy omen FER on 62+ verotenepy parent: Here restore @ resoutteve ont needed g geR of Sr- wesatong i CLA) : St Renoweny only necetect. (eR) “The resoven tome cleperds on tbe Ab-of archivesgrateanoe. &0 bobatetea by tA te pein mode T qwortt cxtth Enis Crdtence Senply reek: Loot & Sorep here after eshin aoe add BEF, & hat to be coped: mueraton gel 0 {u? Crae) Poladuarel: Here eshenewer the vedleleg procewing applying the. tmgSurtieh produtifon Hot ctorallo ne al ees te Be rq 108 Clog applying Sarees) tea) ove transported though the 118 & (Coral) there arehtors are taiten core by Angak Rand by date. than atte exthttk to enstance: tog taepore ushéer 3 mount veonoy the yedotrandesctions eghtch ort rmrattted ore ovexttable: na tf ecte this. raciotoy wee auoitabl hee not committal: Bat oul the ‘ex Co! procuactton Seer qpes dee? then often 1 con oct te enatence- So, Som down tine te -rneoktor? oxatterbttity « )TOPIC: DATE: Dataquarel protertton wrodder’ dota Max protestton protection» wigg cwattabtltty moles \ Max performance Ccloctoute) prod atndbyt Moye stby-B ro T100 TOPIC: DATE: Demo oo datagquard a Neke: pataquard cloesnot support the 2p production: Cabars) ore S{0 sbrtpping: Remove the dbois$ ut Lestener- ovo est shipping files OY prool= quyastee abais) Cport= 2155) eip- ASt- prod= (sip ante) = powaninen } danvetl Atart prod 90 ctorntly Cdkots) (dba!) ora teed dbous efoaharh etal ge ew hee® (as dbaw$ ue tnsname: CHost= dbaus) (pert = 5005) SI0-NAME = powanineso 4 tnaping to-prod: dbaiaB we Uatener-orer stand = ttoge= abata) Cport = 1258 gID- kIST- etena = exon SD produ Cstb- nance = pawanénews) “HH $ damrekl Above staidTOPIC: DATE: 09 prodtutkfon (dbs dbase $ ve -trsnames: ove to _stand = Hosts dbatt) CporT= (eip = Powaninewo) B eping t-étend: gysr7 shut tornedtoue Conky gracetestly Ahutdown the producetor) note: Here eve can LORE potor eatd bKUPS + real = Bal facana/oractettalpawant™ — Goceuiee SOE tmAK prociuscde? g mkdir dg ameronmont doesnt Support for shutting the database: B cp # aq $ cd 4 orncte- Homeldbs dos wl fete $ ORACLE-SID-OPH ie bog - orchtoe dest = (ateka] oradatal powoneloreh + at define tuo contrat fles ty clefoutt log archeve— dest -1 = * goeation= *(acsicaloradestal pavant|arch” tog - exchave ~clese 2 = * Gerutce = to- Stand (gor ape afftrm fo geruer= to-atond reopen < 10" for— ewent= to-At Keap 00 ones oma transfurceg] Syoe dor exry 10 Sec~ srandby - ftte— rnahagerment = outo Bondy - archeve ded = tadska| ordicatal pavarilorch: appellee pat ttectiathath of s_ authent— penne aedbsg ep tnekGORACLE-SID Ora dios4 cp orapiog ORACLE SID aa of peasssor Abas age ftp -i dbata pup > prod Ushows tatb oth Hepr [pod Cehoot ws! par eepr pod Sipe ipod fepy mmpsk # Spr bye dibaing raxder -P power § 26 power rawdir oxch tarska/oradate] paworil dq: dbs} orapiod tite = oyapeg ORACLE-SID password = cA Cacskaforodata| paver? sep > ped tep> } prod Fep> put stand ck fep > bye104 | Topic: DATE: : on stemnolby CsbaI2) 4 ut. tntts ORACLE-SIDOVR contect- files > (asokd|oractata) pavact/standet sea pacont 4 cp orepeopananine? govncee tomes bars ¢ ca (Aesiea] oraclata) paxant] aco] rabies} senpovanicesd 1 4 ea Gace) pavonineso tog trace $ Lad -fFatert- eee stand) Cart on atonaby Cabal) gyrr atartup ppmoune on another Atand by Cdbat2) & brace & coil F atert —-porcarineurlog on. stond by yabals) BY? alte dltbetboast dount atandly dokabat) Sf7 atten, ootabast reco rronaged stanclby databag,TOPIC: DATE: 20 produckton (sx> geleek fela-name, Robaapate nonce, from dbo. data ttled; Spr dep teblespane str fodsckiog content and data tees] Syprr Atop Caster dotabast oper) ! ope ovehine tog 466t1 on Atoray Canothea) les syirr alter gystero Srotteh Og 4 tail -f olak— pot yr | ap Spr Spor archie 10g sts test dg datafle Gyr create tobblespoce aby’ S22 6m) eyacers} oracato} poo] testdg opr? crea use dq edenttfied oy 393 gyrr gront connect, resource *0 Ag opr alter. user dq do-foutte tablespace Aestdg, syp7 coon Aglag 4977 @2! sqiiplur)aerno| dernolld Age Aeleck 3 from tab; Syir alter, Systero atch logit, ee : | asi Sy>/ i en aiond Ff ‘ press ctrhte aan pene rik ab MoM reer)Torigg orn ger mn produsetoo Sys axchtoe tog test 1% - dyoebrenetad ok cea perfestey both text4) Expy citter dyctero Sutteh togttle; op? / opr ape! Sys? aychine log Lest; - Bo- -- ngdotabo t2 Rrow ehech te pret ( sland” DATE: ap Handy Dr ALA Aababat opens Co gypr7 archive tog UBt: oy ot Sr Acie sablespoe-roree, gait trom dba. teiblespacess SK? Aalerk USENAarNe deteutt—tableapace from dloa-vses> Sytr conn ig Log3 dg? selec: # fom. tabs Spr averwe tog desk; rt ere Synchroncteal). oxchitted-toqs L570 now wahathon tha, arto OL Qpanronsted opr aese vb Spr sere vem, appr dro XB orehived tog 5TOPIC: DATE: . up 76 ce Say yes SO thot they ave ott applied: Rematng. ove tn 70 © nee ox breansfuredt OMY me ok applied Because te standby pot th MRM Mmede + 7 dest wa databas Op? Aelece Ccheeathaonm lin rele trom vp dokabese’y databace —| op produercon “Biondiy —pretieal : Ee . controt fete —ty pe» databace - rote from ug database; contrat patabace-rote | garrent Primary: Bysz Ahub Mmmecka® apy abnbup porneune opr alter antebae mount stooatPy | database, yar atten dlatloace Zecorr rranagat | atanclly databat),caset' Giotteh Over Aperatfont (Suitehing the Wenis 1 Slorstiry) 90 production: Cabais) Sys7 alter dataloase commtt to Gxttehour (> prytoot Stanclby 5 sink ermedtale ser on standby Catat2) Ge autormaticalty Comes uk of MRI erode & prompt Sys? alter databas comme —D gattehorr. t(D phyrical primary, Spr shu’ tmmecttat- Spr akoxtup Spy sclece databare rete, convorte type trom vg databast’, pototox-rte contol Sy7 shut Rtenrmecttake op7 Atorbup pormount; apr alee. “database mount standby dokabact ; Spr alter databace Tecowr ‘mranaged standby datebast; co ongehue Sewer. Cabats) quite: Qaet ous epetbtton g re engnames Ora to-fotls : Crests abate) Cpr = oud for ny) \ Crose > commit on production Cdloats) Spr atte. Syptero Sutter logfiles See) > ahut abort pop snsert tnto dept select sé ap -trom dept; 7 Eero: on standby Caltats) prese cbrite Gysr7 alter database commet tp guttth ove. to phyiceal primary; ap? alter, databaw vecoo gys77 atten databow. commit to Gattehoor to physical primay, rronaged Sondby databar. denesh;, gyre Atal tenmedteo opr? atartup ps7 deleek dotabase - role, control fele- type fom vp database;116] Topic: DATE: pol reeenee cae 4 oylplte aglag © to- fart co production tt) & Lenwckh atop Stora 4 seiplue lglg @ to - tal CLierect abe Gegrat ceaps te cteuquars cenfipTaton! pod Steand, <> jretaip fedteora PFOECSIPT Ce) 6 4 9 Hal prod] —x *s- te-prod inb- (to-stond]<— Les—z ston 4) shutdocon prod ('s nlf) TS cp clalD —y dest —y 24549 13 cd o-tldbs tnt: esiD> or. 1$ ep encbesiv7-om rapaesiD 4 7 ceo Atonelby contort ttite..os N © (dtanolett!sTOPIC: ae Rotwes of 9 belonging te cetaguerc! 0 Ackate Atand by Lit 8) snapshot. story - » on before ee Knovo that CF the standby & ta parm reode theo the archives generated at prod t6 bansfurred to the stanelloy ond ten applied: Gut, ¢f the standby % rot to raRtd rrode then. the avenives ave trorsfinved bub not applied: T-opplees erty afte dosing the stordby tm Men reode: But, from U9 AL ory case eohethen the Atandby c& tn men mode or net ek Simply applies & opply the _ onchfors *ch) prtuctton: abas g. Jannett étart Sys zonehiet tog Heats --- 60 Gextshiy sgpne Agr! prod Sypr atten. Systern Sotich log he: Sy7 | aye) 2 end ' Derm on dataguarel: § Cv deatures) ‘open alent log tes tn both preeld standby’ bas — producetoo 5 Abast- prod. standby: on, stony dbaat$ Lonrekt stent Syhr Seorbap nemount gpr ates dababas mount stondby database; SY7 aller databese ‘recour managed starntby doxtabat chesconnect 5 Ge ett TaN en MRM mode fut we get the yk prompt: #€> WI qeotue AF ovchive tog Lest; -+ 2 60 Cpertendty Syreinronteing) extth each other Standby Gyk> Golerte open-toe, protection, mode from wh databace’, opened _ protest Stemtup mount jarsxaoracatal paver] flogyTopic: pr olre. Sptero lpr 7 Isr DATE: YAY alter databose -fasbback on; 5 . Gyk? alter database open; oO. SA7 Select ftovbbactt-07 trom vg dateubae; ) flasbback 00 3 am, ) Syby Aelent rare, dotabex -rate from NS databases . Ntawne pertabace- vote pavontiah — Phyvicol skenalloy Sys ater database conwet to. Snapshot standby; Spr Beeck nore, dorabaa- rote fron v4cetokt Gp? Ahut, Cmmnedieol Spr Slentup Sys7 Gelert comme, - => ~Snapshet standby-~ ~ databar-rete fron vé clatabast, SAr conn sydtern) manager SYSTEMY wreate table test C0) nesmber): Eyton (ogat Ento test walures Cen); Enter vole. or ot 10 opto | an $20TOPIC: DATE: “u syters> | 180 System / 140 eee? 150 By see cocarnit Bp archi tog UAE, axptemy gelect + trem 4896 gys7 archive (0g USE) ee Pee ce Wace applies Beoau.se the db & standby rpdes Test enchteS OM geored at ftacbboett Logs oattable (9 the acreatory ftoxb- Sysr shut Ummecteates Sys7 StOseUP mount yar abter dbatkerbast conmet to phyitead siandby! oy’? alter datebast open, Error oye Seat shut tenmedtaG syky stertUP mount Spy ater dotabae secoo managed standby dotabaee désconneck; Le roto, Seettag ere at the arches yer arch tog Us tog whieh out bonshuved axe gle! Error & because the wonized << Bysy avthiex tog Ute S487 alted tataba sable (& gerasatiet at Aneypthst te retour mronaged stand bf | sd databax canctl $4 conn ote ear, Qutterns arleek & ternn baneChanging protespiee reades: eed alee Sys7 drut loomed Syr stortup yr otter databast aad standby logttle (desk foraclata] povonthradostanstia: tog? Se2e arms Gk aaltex dowtebaw add standby tog ht ¢ [desk ayoredata} pavant! redosteind2a ‘log! Byd7 Shut eeomediaG St2e 4m, 867 Sostup Front Sys alte. dorobase Set Standby databas to mantmize protections B67 Shut fmmnedcate: Sys? Stortup rrount Bykr alter daterbase recov manager! 8987 alten. clatebase cpens Gloralby dattaba dtstonnest 5 Sidr attes Syctern Sutter. logfile; Nobet work ath atandly database to Maxine? axeittabdlity-TOPIC: — we # nemo of Ritpn potcting- Hine enLeTY” asparR ss xo c bor Rorgme catalog - deas$ UG btdtera oro _ a i Abas — gorget tgedb= lest = abais) pert = SID- UST equdd (sto -NAME = partantneo)” 100g § sanveed Atort eghdby abatag are tnd names: ora to. tgedb = Utost = dloats) Cport = Csip= ponentness) + traptng to tgtdb detabax rte, control fel type from xngdatabar, gpsatert potabac-yote contrat . an carrent* Sify eats teiblecpate —Amnbt cetectdte « jatsteal ovadata/ want] Fneehe? gad tcom, 5 Spr grant connect , resource, yecouery- Catalog ema CLONER tp rm Panne +TOPIC: SA7 eo rmlxro RM > Seleck f from cell; RM > extts dbaw$ rman catalog whlxo Rmantiy exte ‘ B mon catalog vra tren darget 5:61 8Y6@ to_tgtdb; eran Acgcaten database; RMANS Shoco atl+ RMang — spot tog to Shovo-log RMANS shxo atl peyanig exte 4 ue shorosteg Rwten> @arowrleg RMtANy backup databaws, dbs $ orapwod +tLe « repo: —- > candtgure as betore---- DATE: 7 otter UA of Us AML default tablespace Ameats; poucnord= a9 forces} $ {8 Sys7 Atovtup on target B cd tdgekal orectata) weran| a . $ mkdir rman $ cat vena 4 ed | nate: before ging OO ae ey asxtin to POM to Ate on torget 3a Soret $ cd $oRecle- tome]ds z w=- Got porametes fete & ernment the 89 pout 8 ORACLE-SIDTOPIC: pate: 9° #90T fU. “tig ae 18 potabing — tlw Recoeony 1A silo ‘Prepowtng an cuntlory tnavance: note! Aenullony tnetance must b creates! ‘ tr target only rot oxtaloy gE BBG co cotalog ets dbaia® export onacte-SiO sauxtest 4 echo HoRACtE-SIO B ed SoRActE tome [dbs 8 ap inck.ora fntkd CARCLE SID-Ore bors gykr Seleck rome Fore xB clettetasy dog wl Ente. ORACLE-SID OFA Lal ab-name> poantaty xmandb! at controt_ttle = za dfagnosttt - dest © [deere Storacater|passanusy AUK test patoksloreatotey db- Fete name conve = [aesk.2 [oradatal peccomer rnc!» auetesk reuatataloureett Op tog tele rare coment = passka/ oraceta) Ament, taecka 1 iia 4 mkdtr -p tatskal oraciatal aurtest is Syhy Startup nomociré: the tages: hos inteo Connection etth catalog bak catalog hak no nto o4th tenngel =~ i ~- Steve, & macte (E120) TOPIC: DATE: catalog atbaig$ ul Lestenes ora dbats,$ orapwd spite. ovaper$ ORALLE SID porradrdl = aux abs abated rman catalog amlare Longer Bykl Sys @ B- tged ausolluy — ay an @ to-0Ux Reanty batkup databases aman> backup database; Spr conn = Uapur Ua > selec % from tab; war Sek time on 10109°.41 277 drop aap table emp PArzss 10109: 52 ua 27 fut Serept seh yun, es ailecaite actions channel ch deuce bpe desie. foreak S+/, ubkp”,TOPIC : DATE: weer tablespace USERDATA until tine 1% to daté(* 2004/ 08128; jor 07 AN, VUTY/ menlld'+ bhhag time « 6895 \ 4 neg alle? pman> @ satpe-3at dbs $6 Lente dos$ rm — 4 LRNEWOR note: 9p ches 1098 excebg thet +o open the db an enor oceutrs et aortt open databare exclrgdve mode:“Regumable timeout! pue to not enough Apac regutcernents if we intent the dake Ento the objens continuously oracle may send error G Go) for that we nied t aolal one move aatahile for Ub But, f cos ttera consuming becasice the es done before t% not cormmitied - Than. wettbarkadl: $0, we hast the qecthire yesumablue timeout © extend Before this rot adele! the extents» Bub the clefemtt time 6 abet Czao0 ee) ren, we howe, t ald another aectagzlnor Space: 2} om atth fa. ahs than the aeorton, teamlnates* } plas the usw tn sesumable anode as air alter Gydfon enable vesumable; : con menbion uy? alli decefon enable qesurnable. trreottt 3600; an “econ These & deteton clepenctent vey tirne coe have t moneatly explectty at the Aeron yexurnable.+ toe dorlt Knoco that ehen the dototile -Httlec ep, by enabling reaurrabl chen the datatile fétledup chan the mode on. The errors OF nottited én aleattog time: aoe get cuerrent Geton Fexumnable bfrne by ngee- Lementt penesut FoKnoco othet seston, a geb—casslon- tenant (Sor Fo ek rexumable terme yesumable bine by 9 eek - Herreout* we can frowns) decwoe the PentS— RESVMABLE- M any be te Aucpended then tnmedstotely a vearrel aotoltal En. ub Seveton- vontt N© eon ye ot TOPIC: DATE: re 123 | eg chatatng @ Row migration: (salty vow chasning occurs ak tohile performing tasert operaee7o A ingle abort macrrenatton ¢ stored ta chateud of boues | rrusttrple Blocks: Dut 0 Sratler Hoot 56225 apr Selete * for OP) toe have to detch muttyple Becks 1 Wed Sine ene veoord + Sif Updae = gp select from erop, a Eton . coht. perforentng upaalk spac’ reo hn revtgrertcon rrany cee: Gor thes epee ome 0 0F 7 ao conidtdan the orale Blok Cth 1oouns roowonts ont - chaning: of tree Apne. aonatdes Eabext each & wy yaoord te tates (ONE Space: ‘Then bienelhy axe eee en | 10 vocords: Bat eth the por pREE tT soz, of the Hoek & Keep to be free for Rakure. ——] purposes: $0, 02 howe. poorebelthy to Engeak 7 Tere } fo} onty 0 upsale. a geoaeel 12 rogite ao uote 4 1 av mip 208 Ma any a PAD ame TY ed prove of per Pree gateoek: fer nuxt apcteton coe go cust another youutd at the bioek: oreote sacl? tater woe waquered: detablock & place the Another desta block ForiteelecteaHoue [espa crt | RRR plo vt aalrcaucty : hail Thee cons seining rach @ rrore there tovthe + migration & performanee elegracting beetsTOPIC : DATE: hele Enaexting the veoorls how coould oracte prows cho dreaspace of the datoblecks? R coas matntatnes én a teubte narmneol “Ml a BF, Space resewed dor the qutesre apdatt of execting taba ‘ & peroseD: The tt of rnin. spas Uva dor Endertfon Of new roto date. of racoyets, Hotes « ior fuanove upacites” on at dates constden ab the erecition of Segment cae nobed aS pr rentionad ag perused — 60 per FREE - 40 Noto, ee Knew that extenk contacntng 4. Fecords én on tnseating “each ery Bok een only Go, of tet diored fn thak block by teautng tote freer Oracle defen fredlege tabla eohtch cmtaing the frtin about -free datablocks > eohanevte oe may ore Ersert comenard then groote erternallty lnsente the date ZF the blouc how fa about thee Hock ound ther donkiquows oreuls bioekd+ jer only : key mnadnkoers dearches dor the qreeboct dtlled up then oracle rernaoer the ind Gf coe dott. the vecordle @, wake free spews then. asstornateosty that Howk intta & octdacl to tak table .TOPIC: DATE: 19 cwatel ous chatetngt Take export of that object” 81 Srop the objec 2) reat eablespace ou'th begyer block see 4) Senport’ 1p cuts ved ropaton: 9 Take log ceat bockup For that ebyet: 2 Drop the object 9 Srmport that abject * on Y Copy the abject atl détferent name. ® Dsop the obyet» 2 copy the abject to original name:1 2 6 TOPIC : DATE: pemo on vecumable eeereouts Sysr Stewtup Spr detect username, detent b eablexpace from dba-users spr creak tablespace ats datatéte ¢ /oLeak2) oracata/ paren} resovabt? Size arny” Spr cole wser arts fdenttfied by urts defautt tablecpace sts; Spy grant connect, Aesource to ctetss Spr Adlon eidername , clepaure— tablespace from dba-9ers; Sysr cone crté]ures vets > @1] satp'us demo] dumobla+ URTS7 Select ¥ from tab; URIS? alted Geaston enable resemable ror: Gneutfeucnt preullage ortsy conn fat sydbo Sy7. grant yesemable to arts; Syk7 conn vats] ents ORFS? Select drOM Sesston pris’, wRTSy altes. Sesston enable Aesumables ueTs 7 dese dbros- Aesumable Brrovrbpy deednot extst oRTsy conn for &sdba ap 7 tee dines -conerasties great exenuté,.on abmns. vesumnable ty uxtd;Sr conn urtsfurte; ORTS? dese dbms- Aedurnable. ORTS7 elect atbeng_ wesumables get. timeout frore duals RTS? alter Sesston enable reSumable; ORTE? gelect dbrns. sesurrable. gee —eemeontt From. oles: ek _ Temeouk 1200 Cabra) GRTS7 alter Sesscon enable vesurmable tKrmeout [g00; RIS? Geletk dlorOs- yasurmabhe- get EXmeGAeE from dual} ORTSY alter Session enable reaummable MAME toyprs BATCH PROceS?, di RTS Ensert Ento emp Geleck # from emp ; another tatactow Co weewallter oRTS > ] URTS > J ley teera) wrace$ tad ers >/ + toll alert paycninero-log --- conteutns evrora éntin--~ | 1S >) E Prather cotndoto2 (to rescre T3 >} = = the aatatey) (G0 td Ssepenet noes) Yk? Select HU-name, tile-td Adbed eating bbe or vestzing from dba-datattles, the datattle- Dt comes SYA7 altel clatabae datatile 6 oul of Suspendt rode ancl then eS glo the prompt" oRTs>TOPIC: DATE: Derno on fou chaning & roo migrations RTS y dese user-tabtes URTe > Beletk bable-name, ANg-FO- Jon, chacn-cnt from user- Lables; Nol weenkag wes 7 dove a wrtsy enseak Entd ernp Seleck yp from emp; wars? / wes } opts >] oRTs x} nT vpomntet oRIS get o URIS > / a Mok Wteenkng wRTs7 analyge adable erop comput, Stattsetes; URIS? gee & urs? / th Noco & Ahowos- ORTS7 glee ¥ from tab; 4b ORACLE ~ HOME] wets) aslrnen) uubtehasr S34 urrs7 @ uprsy gelete a from tabs -- The cboue Sertpt areates a table © ghasnedt-10008’ = ~~" errs y clesc cheuened- wets : ORTS? analyze toble amp LAE chained 10S; RTs 7 Geleck ip from. chatined...voc0, No yecos. | Aeleetist + 2000) > 1 RIS 7 alter table erp actor nore. charl. eo we er TOPIC: Je a DATE: ORTS? upsell emp Se mame = \ gytkagepataibinden joepal”, CRIS cornrate oris7 analyze table emp compute siattsttes RIS? eka oes? | Prcarali J the ehatn. count extll géver the Lepdatea) Enegraael yocords ~ +. Flere wortsy analyte table emp Liat chomnecd yoL0s} woRESy Selete ocuntk) -froro chained rows; cris? extt = evatacng the roto migration) 4 exp file = ernpedmp tables= emp username: tyts(ures $ Sqeplus eayta(ures opts deop table emp pH wRrsy ett # tp file> emp-dmp tables= emp 4 sqipluk ersts lusts ortsy analyze table emp compute statesttes; CRIS act a phe block Stre. ranges from oRtsy / eons) i Lenn owes, _-- NO chain. ent ~~~ Noket Lemur, Sckarts g pperes Wok Sete upto 16bct block Stte+ Tam-Ar& Hp can Suppoxt Hotkre upto Sabet +180 | topic: | DATE: 3 (w2aegeep RAT Cat oppltratton ‘sites = en ae Jaume seco parts (hp > set peerormace ANALYSER pateplay has rrany pases: phases —7 copering Leask ( on procustten) SS fprcessng Peleg the core Ceceneltead Replay eLtent) Anabijtet & Reports for the sat PERFORMANCE PNALHSER , Chere eS O- package, dbrns- sat pa Cperformarce oralyses) thts analyses €& certol tO coats the Enolexeé ete The Auk of SOL AtmEx applying to selpa We Calted a& SeLTol gusting dae strmdd oe haut to note the reports: © Pertomrannce betore ary mmodtftanttos ® Ratorrnance aftes ary mmoctéficattons: cokecctlly the f[p tw the Ripa can be of 3 types ESET: Before, cator cache sor tune debe Air Coonterins Snapchots) Le means ene con amit quer] eheee Snapshots Ep.saiP% vy qiuteg ee snapshot Cd cosuolny these Seapshots ave ot dylan abespaeTOPIC: DATE: Demo on DBREPLAY CDatabae Replay): on prodactton. Cctbars) bas ¢ 19 Syd y stowtup fxs selece & from dba oltvestortes; Spr create dcectory dbeplay 06 ‘Jacks oractata] paword] abreploy! ; racrectory to gine te Keep the caphised tooo’) f micaic =p [acake)oradatal pavant/abreplay- & cal satectea oradatal pawant! abbreplor- $ ut caphoetsqt begin. bmg. ssorkload - capture. Start capture Cname = > Recbenpturt’, dere 5 “DBREPLAY’, durertion= 7 NLL) w dérectoy named ehatere, we hawt creat ends SyS7 get. caphuren agl SS? grant aonneck, Legource to tests folentified by teat 53 lsp7 alter yablespace adseadeta onbine; Bp conn teats tent; 0st 57 @?(.29lplus}durne [etseoble Lesbey deleck-& from tab; teaksy fadert ento emp celeck 3 frome emp, C adoteng dome Local) tesk5y / . | * : tests > )eat 52| Topic: pare: 424ESY Enkent Ento clept celect # from dapt; teaes> / teats? / testS 7 conn fox Gycolbo Sy> exec olbrns— ccomtatoaal Capture » #entsh—copture; + cd folk a/oraclata/pavant} albreploy : pis _ oe dilen named eer (esorteoad ebeenk weplog) axe e creatiat. which expleéns he coorkload ~~ ~ a : ve ChDBREPLAY) ° " geleat olbmé.- ecorktoadl caphire. ge capasre. tafe “ mh * frorn essa / yer Aelenk Cd, nome from ctbacworttoad.. capture , SP? yf ceuphare) coptures Spr Another Sesecon Colboig) leet.) C10 dend | fap Uese ener files) . $8 spr seatup: oye? Select fnttance.name, Stet tus trom nag tnatance - ‘ oe Sys7 Guetk 4rom. dibn-clévestonies; | Sys ueale. dtseckory tert as | © falcata! orelata [pareant| testab,TOPIC: DATE: "pronacy -p /alexeloredatayparani testa: J ea [Atskaloractata) pawant [teste tertdb$ tp ~¢ dbats fier kogin passecorals 4tep> {pod dep prod RP r col fexcors ferostata} paswantlsbepleif ep x ped pep mget dip > bye tert 4 Lk _ contains ewer files = => - ayhr e1ec dbmé- sooektoad - replay. process ap tye cirestps); Fi od dlr esortttoaal- replay. tntttaleze replay Creplay-name= 7 © REpLAN’, ends Greploy- dire 7 © este!) 5 Sysx bagin dims - coork loco! ~ yep ley prepare replay Caynchronizatton = 7 tte); end 5TOPIC : on anothed terminal Cabaig) aa eK Hys7 exer dhnns- cooertoeo|— wplay stave — veploy' DATE: | pceemstea ae 6 quite, goon 9 ware Feore mect=ceusbrate replay abtrs Jacokalorodata | paswani/ ent wore rrede= weplay repleayoter = fataraloraeatey pavant| teste = cones ant the replay procoune wr diftea execubing the stm then, & gto acinoctadgenent a * reply aterrtedt’= = 977 gs Sys? Soeck username from AbA-USeEs 5 teats (User cratic ct precterctaton. | . cave crottable mene) i HS? on teats] deAtS 7 ror; Here the passevord expcves® Sys7 abtes- cused tests, Eotenttfied CF tek) dypr cone teas] tests kexts? Belece & from vob;Topic: DATE: 185 Damo on $9 perforenanes ely ert on. predution Cdbars) Cos dba 4 18 Syd conn dystern) manages C ystem> yea table rey-objecké a6 elect: ¥ from. atl-objecks} atemy exec dbras. stats: gather—table- stats Cusery Cerny MY OBTECTS sy cuscade =ptrue) 5 Systern> bs gee Ex+sgt Corrutng sartune 4 -0b) achere object ~C = 100} CB) tre rey OOH eee eared cotucrn where. object t= (00 5 gbjert—ld £=1000 abject = 10005 gystern7 set to sat perforrranee analiger) t detect count! @ glee obppck-name from my -Objeeks counkts) from my objects where obyetk-nome from my-ob pees coher. byeok-tol between count) from ray objects where. ol two ainct (000); B seteck uy gelette 5 Selete Not! pxuatty there foe Kerbs axe fers bby woe have (P asttgn a none Akred at Lhosect pots Moc, 4p that Ack G ght that Set a4 Elp to SQLpa* Systeroy @ bx Sot tern y conn (os Syddba* R on yAeom t cqucets| Sy? exec albens- gq ttune cron Sq tsek Csqtéeb-rames? gqt-test -S9ttee a Sys> ect deel — exptsete sgt CH to wrilk a Créer) Sabtune ceename DECLARE deeursor emis SQLTONE, SqLhek--CHrsor} BEGIN i | OPEN L- cursor FOR !1 6 TOPIC: DATE: SELECT VALVE) FROM TABLE CPAMS_ S@LTONIE+ Selett— CUYSOT Cache = ra COL Chale. ftttea => ¢ te > Cage test LIKE? * eZ my objeces */.” and poorwting- seherna.-narmé. = “ guste)? Obeebute Lest => (AL) as DAMS _SeLTUNE, Loccl— sqtack (sqhseb—name= >t t ogh- rack spttese’ populate cunsors> seewssor)’ 3 END, ; 34h? @ bood - sqdsets sqt (deo sqeack— atectarnar lf) syr deter Sqt- text from dba gqkcet- staternents coheore gqbkeb—name > (sgt TESI- SOLSET’ ae bindvartable gre eter, CTE gees the “tenis eohatener cae qévEN. to uninatextel coture objeet—€d) aay Spr vartable v-Losk vorchara (64)5 bye eee te tastes = abr sptparcreste. anabytts *gat_tertsqliet') = Wake gqtset- name: ends - / Sys? prents, u-tosk Cet To print the value of Btndvarfable un task) yeTAsSK TASK tot gyb> begen dims Sqtpa+ ce anolyte tase C ‘ toak_name = =7 2 WEAK, exeoubtontype, #7 test | exerte?, execution none = 7 . bate change”)TOPIC: DATE: I egariber fiecatenn y Agathes terengral Cabos only) dbais $ 19 yh? conn. ayétern manages syerern7 creak endak you -obfeeS— Oe haces Cobjeck-€4) 5 7 exee aba stats. gather table: Syptern’ Saks (User eray-oBg ects") =? tue) 5 cascade Syptern> conn las Sydatlben Syh7 Another tegenvteat Chest teménal) wegen ot. qtpavenzcte craigs tank doak name> zi \t-task) executton-type = 7 * cownpone perforant! executton- poramns®yabrns— ase “SOr* awgusel * teyoettornamtl , tpetore- change’, Coxecuttfon- names! 3 £ ofter-cnarge’?) Spbr Seree analy sta task3-Sqt Syp bager ! lle s.sqbpa excels ray ttek C { tercic-name 247 sNr bask, execution type = 7 tteatexecube’ * Gremnteton nouns = > t apter-change’)5DATE: by Sys @ analyte teres: 998 To wed reports Set there paroreetess Sysr Get bong 1900000 Syby Gee pogestae o dys> See binngeze. 200 yb 7 SE longehunkst2e 200 yer SUE tetengppok on Syh7 Spot benp| eneesete- compte aid of Fhe Yepota aoe ge pee # 2 Sysr detect abr. sotpa. veport — anaby a task (2v-task) from dual; Sys7 ed Cemp/ execute - commps Ext once when the dequr eorttes the date into redolog site, tn current once the Logeor Envakes then archives taba. ch tn arehtut log mode the ckrakk G ad cocttar data t do the yee cohen the stats & axe gered chen only the oto archertog destla amtoink the aerouty epencattends Ir genovery coe 7 getting the entere clada- ae Archéve contains open tx tntormatton oko atth the commétted tx 12 carte emagink thot att che archtcs dice. for ong time Archive olextin. alo -Hlted up+ $0, the tx woheeh oan En aettve dourtt berome fhackive and sx cant do MA Exks se that ates one another. achiex dert'n: tiene orerote U1 axe obsdleli» WE Coen corte ae Sina we hace rary archive loge Chote cron. eb tb vernat ent ofcler avehixs: eageistion™ 0 Recoy 2) con matntatn ctdes. cater ptratortcal data)ot dee) Sep unl?" oxen t pot TATE: co conte , Bat aur Spleles a tab & later he realéecs, then thowe tx SHocls ane ak archives: We dat Weis avedterlog: Because ft a btrary TOPIC: de NL toe have rmany poerages trough echich qeaponsthu fer‘ Logmines: depenole attr af afg levels legracnn execu” for logpetrus se need tD orale a. centacne , dorne proeeélures & packager ean to px donk kneco the a yaeatin, cohonerer the bx @ dated Is ur based on the appron t4 Atoreds &0, ee art Keep gevéag om ning Baas Flom vAsye eve can find the entla hol du detacls of lagmmeds insect —> delat debits — Enaect4 140 TOPIC: DATE: Pakabas cloning: fue to performance éveies we evtlt clone theab bo test the database: There axe deveral quections to clone Et olatabacs Jo mnstall packages, Oh pqractes, package cupgradtet or €D Enatatl nasoty poeiages cox atleoceys, dont go kth tt cb. $o ox ost cacrting a clone databatat tece- dé ta data guare) coe howe oacubicl ancl controtfile Neco eae Ont wating the cdont contrat ttle: Here we need & mount a& Ninount devtabaw at clone’ and ‘Glont, hex the conbrot ite type &' clont cantrot fit. woe can elone the databace cufth the three types of backsyps y- cota a) thot D RMON _ panty duplicate target databax duplicate eargee databace for clon 94 use dttse EMA corarnand then the toaget which eet Gotont catli be clonacls The doneng oan be clone én any Le JAcant or (AESKA oF (AlfSES" teat tebasencurne?; conrectial cation ec'ther144 TOPIC: DATE SQLA heaslen: osuatly exp Bah the date from the database @ thar: toads eat & churapttle Stenitloxty trap reaclé corthes to luhfeA anal then @& places én dakebo.se- Prom the “asraphtle & chen butfea & comaalty exp eabtltty & understood by fp only bat not by ary other Sys? Geleck tablespa: + fo0k ab a glans Sys? Ahuk ernmecttae ( Grocful Shutdown) $ edt (ckeSK2Joradata pawane | Pavan 44 \ pované $ mkcler clere pawon’ $ cp # clone pavant¢ cd ¢ oRACLE- Home [dbs dbs 4 ep endl ORACLE. SID vO. [desks | orctelerea] porwernt/ clone i abs 4 cd I Yd> ,SEORtUP pormeunt Sysy alten database backup contrat file |b facoks) aractatay paver cone! lene seus 10 ons - the elcet aI SS on another Seaaten (dleat®) | bata} |S 1 Se Startup | Hott? Gnitest? we clorint regen a el aleacly exttrg yuck Linere Gy arerttesS enough: \ 4s > excl : B ca [aska] oractatalpavaneTOPIC: DATE: pevane$ mmiteler cloneteste t pavenid ed clonetest doretese $ ftp -¢ dbas ' 1 ogee tas | dep > prod - Hepy ! prod ttpy eck [oleakstoractate] pavant] clemtest Ftp y eget * dlonetert $ 16 oo £tled from the productten one oxictlable hey Clonetect $ expere CRACLE-SID= povantnero | E[ Lbs dlonetest ¢ cp Enltportancneto ora 4 oRActE_ Hd donetest~ wel ORACLE- HOME] dbs] tnét } ORACLE; SID-Ore gtones CEL contet-Kles= (acskasoraciata | persone) elonetedt Afagnoatte - lest = taednaloradata] pouan / lores | db-fth-name convat = [leskal onclater/powany/, cacsta) orestata) pavane| dorutesty tog tile — nacre — conwat — [alist 2/oracata)pavary ¢ Jdtars) orerclataf por ure} cloretestTopic { . DATE: 3 a end osncteso aul Syhy Ghawtup rromount S48? alter database mount clone database’, Syér Select centrotfile—type foro ugdatabase’, i contret clone ct -file-name, tle tt, status frome vddatatile; Sysr es axe Cn offline. --+ By clefoutl cle the el ue howe wD mate alt Ales ondtens+ i . ayer aftter claterbace cletodtle may) 4) 8,6/7)8) onkins; Ip ifenor otund ther: Aecreate the cola hte hee Jsys7 citter dlotebbate sper resetlogs, ap'alted the logttle name or venoms rogite tf tog hile error | oceans" | ferbace 5 yar fpetece cpen-mode from vg daUy ‘ TOPIC: DATE: Rerne on leg rnénor’ Sysy Atertup Gyr conn galua Eger Select from Lab; deer Selec count) trom tabs day coon fas Syaelloee Gye Gwchtve leg Lest; Spr extt B ut 4 oRACE- HOME| dhs! EnkSORACLE-SID-OTA OS- cethent— pretixs* ' atte fele tre folecka oradate/ paverne (ued 3 meder -p Jacokaloredata fpencounctats Sys Staxbap force 8y87 batch logte B47 auedtot tog Lect; amarty ty log £9 yer dedete fre conn wale 4 Uar delete from emp; | | i \ Sypr Seteck ucermame, tablespace - name from dpa users: { | | t | i | 5Uae Uae S467 SANZ Sys 2 y Sys? Sy? TOPIC dibras -Llogren start ogra | é Spor test sat) Sport te DATE: foe : nee en for pollo latter Systere Susteh logile; 4 Spr /| i » ea rea atbrs— degen — pray / ectect: Sequence th, bo. char (fersttime, 'yyyyrram/dd, hha init ds butld Chet lide’, [desk aforadata/ ponsonsttutt'>; ga!) from up dog-heatory } \ vor get att crac hie loge Sage’ begtr [dbms. lagmnor. add logfile (' /deskaloractata/ pavant [axch- - avchtue | ends logrtttencirn t | . open angler S288 ¢on. [begs C0 get rchtvelon Kile raere} bree $ Carcetitename = 7 (acs) oxcectata) pay andl evel fuutte ch cee ay endl; / seleck —Sqd-uodo from ablogmor~ contents cohere seqename «1p! and) Seg-exoner= 0245Topic: & DATE: es rs os Sys Spool off i Bys7 ect testelot Here leave only Sul seeks and rernove all the unnecessary Lines -- Bypr Deeaertat SYR? commmnte - a ceesey | Dereon sabe lonetes Pll the -Hiles aus en gquesé dbata & dbais 3 aller a+ Mere woe get al tiles = ~~ contertnacl tn Batter - . | z | by defeuut the novof ervore t& wax {8 60° woe can Cnerease tbe errors Space to Shae more ¢47O%S: g MO cametarctl {| % gadkar contect = cmeeia- ch fogs cacctarlog eagegnare: U2 [ Ua 1 | ace Koadea-6ol! For fnseat option, table mus be. empty. | ys 7 cone alee : | | | tay tuncatr table dept} uy conn (at tyeadba ay ote ‘i i —_—__— TOPIC 4 sqbta controt = cogelacctt logs cautartog fyanceme ¢ n/a obi frm go utth ded! flask back Databoett There are mony floah beer ee ca) Pe] ) PUchbax veaton Query 4 a 5) Flckthback 4x Query feorn 103 wt L? table we Soe 2 fhlaboe 6) ata archtie (119) fan ostacncstee £etin dr painting taarlfause antaban: Suppo a user ines! ¢ att tre tablexCobjeeks) 0 chat to'undo we catdbeup @ exn porting Mme recovery 0140" S/ order to go cotth fachboek databact ee reed toon parameters 60 the parameter tle DATE: 7? bactt coneipte archiver rout be enabled decrnigues -acoslable, tema recog of databast a table & cE COs need tp tloahback oe hawt gorre dow commce, tagere owe pocnt A 6 Recovery - Hla -clest = mite. of e* dotabace Ste pee : soue point B Recony. fla - dest. S202 a ptter|tneecolcetng these povometers, te neat © gave: pount 2 oacrt stootlip database ob mipmount | cond then : 9 Rett oaek-Ceb undo stn nk enttl corneas) 44 P mantton > dhter databace Flashback 07; . as vieuo the datatoace 4 60 floxhbark mods oF NL, pdatabase —r Ptaxhbock a atenaatornp es ee estore pont Rottbeux toe Cedan Ce yottbacka upt> &)ee th i. See © Go to google Search ant got code and execute ze of databat: RVIRC Recovery wontter)! din opttonal byprocess enablas imodéfteattons dona an clatabace Cake blouse) the destination CDG-Recovery- —Hle-dext-Stee= —)- | I Flashback date axchictt St Atores | roalintacnes thy objec at databace let: For thea Foor porevestan } on object tnformatton). the vetintfon ss ete erp, aape eke TOPIC: Dare} | Patabow Size= Sum of att the clio Hles: | Ly ocr hase a quota en top ofa tablacpac dnd we hove a parametes named % Retention’ ee en | hanewe, 022 kepe the databace ag flashback recoury dortaba| phokeve the RVR UAll ~ Atore that tnfosmatton (1 floshback 9 tiles tn ger mentfonen} heatory of a. oe reed.to iTopic DATE: g j 4 wel on “Rashback database: ee name, ftashback-on from v4 database; ttadhback- 00 No pornete HOME fabs) tated ORACLE-SIO“ OF archeve -dest = dp -fecouery- ttle cleat = jacaraloracata | paveant (Hach grander —p 1d@sk2] oractatal pepavors! flash Jacska) oradatal power! Flash sys7 Jehu Cmmedtos a 1 ecorke rohte na Atala —> enabling] aesablieg: IS gar glartup eroune Co Fraenbna tex database -flachback on; ogA7 Gs? pttak databot open; Oy? Betece noms, Flashlenek -o9 From vgdotabat ; S6> Porchtoe ley Lect;TOPIC: DATE: i tod Cp wean Hosea po Hetes 4 ca {aeste8]oractate} phan Hoch Florhs 14 j fovone $ cd pavant gu | Flax hack $ cod Hoxh back gu ol-mf_ sapaamhe-ftb|( Hoshbark toy Plvhk Sesston creatid ekth -ft extenafon eshich Store a the tnformaltton akpult the objects + i SyAr como earl Sh extect uservorme, defautt — tablespace from abo’ ure gelece from tab; ayy fps xi grep yur Cwe can dee at de level by ettménating they uve Alote: To check cahethea the database i tachbobre reeoouy, ary @? |ggepless] daso|darncbled | uy Enteak fnto erap gelece ¥ from onp, i a> up Comte yy tetenk Onto dept Seleck * tron capt uay comme; uyy alter Gyctern Sutteh log tle; a / i . » |TOPIC: DATE: ty? [sede etme on cB ot 00 uy? drop table emp purge? peior4oq uj> encert CnkD dept Gelete « trom dept; ar | uy? Commet, Syh7 [shut aemmedeats ( qracful ahutdowe only) ayty fKtentap rnount ayy Boleck syctermactarep Hloabback database to trestanp fro tena, 846 to-tumetamp ('31-08-d6b7 08: 012 00") sadernm-yyyyi hadi mes $895, Hore} we can open, eb oath 2 opttons 0 Rese toys een noco,| coe are “En prexe€ous posetcon of db to g@ oth toe rut open ab as yeaa only: open Sy puke. databace | read only lgya9 [conn e/a) ayy delete oUNeO*) from erp a7 Selec count C4) from aspts Nobt piter deleting om t tx we need & have a depts soe axe not howing tha { togtcat_béup ov ott eveinsacktons- 2. Eph lenp seg og didle only ona cbjett t& rroaittiedd 30 cee om asoliig with dane ero Ard then open the ob p table ene done Some trangastvons © dl Current postion sth oth then Cbyeck ony12 TOPIC: ByAr%e Gelece Eable-name nwo ae ime from dtet eobere ne table-name ache (y, PLASHBACK. ARCHIVE /'; p05 oo up ene 3 exp files emp amp tables= cat-emp $8~> abut emmnedcate Shr Akortup mount Syd? Fecouwr database; Syh7 alter database cpen; Joye etek counkoe) form ult emps Table mot exfSt6 ~~~ Syar eel 4 tmp les emprdmp fatl=y Syny Select counts) from emp; Gyrr Adler: countcx) trom dept > Dero on qlashbaslt dota ayshivest rom dba- -flaaback.. archtex. tables; NO YOK Aetecticl” od le S147 aeab tablexpace fbdats dortofi [desk] orciciatal powoni[ Fpaatsol db: Gy67 Create flashback archive s object Flaahback averse crecitiot the can seate ‘n' n0-6f awchtcrt yablespate for storing das pf) sire aom; thoy tablespace | bleu Layer select teble-name , ovoner-name, flachioaek- archer —rarne, q i | te riot i A TekeNeoo rn (on a yepr, Syeor (er) tenonph, 2 rranth, [a0 ‘noloToFIC|: R f DATE: 13 Sysr akter -ftaxbbok archive fla! Set defoutk; ret raentfoned any flonhtoek archive name for ony objet: ak at) we 4 tnjarmation stores ak thee flash than aubornabioatty tse cts & back ar toe - pack archéve flaa tablespace +6 quota aro mandate: creaking flashback archFoe otheratee tb throws an error: 6447] ercat fash! gs otter Flasbback archae: floa add tablespace beats quota am) ft antl creates a quota on an another tablespace fbdats -- yxy Gtter Floabeoek are flor rroctefy vebentton 5 FO") : I Gu oft! enqeases the vekenkfon Kms for ehat i posefeutan archtoe = gytr dite ftachoout onchtve flat purge a conn ay fUts i uyy altes table erp flashback archive laa; | : tz arOp table emp, CRinaméng, mocéfyeng cat, not porta) ay monet aa al ORA- $5610: Snvakédl POL statement oa history bpepast table He ce, no POL ave performed on thak table Eecau% the ue 5 ! , tab WEP cK (A Flashbacie archtot rede: Fe ? a matntaints the bxtowy of that postceubar emp cbjeck --- j tyr alter table emp no flashback aycheve 5 j pback archi] $0, Now the table emp has no Flos! lor we can do any bol operations inataa}on =p | | | | 4 that table’ ---- | | i i { |TOPIC): Picea ean ct coeemmanaliay stot: the pavamster eohesh oletenes ree faites: the paremeber ache Giee of san CS echech bontret: a to the or . eo wthe abtloek bat f *sga-seeer” er ggarmnax-Sere- : Ab_cashe- sxe: ; ; 5 doe _ecee: from gt gus tr steoton ofp Seve ot thee retetonting tse bloeka Cnt gaa comperentt oA ONO ales the feria watetia sees. me sae OTs one = ark > ak OV ce ee (nes? 4K getoutt & 8K “ab-nk- cache wy pated isk eine? pete eer leans ep (Excustieo -psharedl poct can te defined by the pavoretet, * shaved pock-stze’. the ea batferstze can be conoled by thd parameter.‘ ' $ on Gaile ef, “dog butter’. pf —arnory S brhe favo. packages execitton neests Sorma rramoy arear Go we éakan the ua poot and fe con be measured] as Lyersca.- poat. sere’ 4 internally gore componente: pue td clakapuenps fob execirtton ovaths wan te enocon by ‘beams pod. she’, this |rrerory area Rman backups ore Ueing 4 eee backups /poenteng etme recov ft ‘the. e pot anh Known by‘ Lorge- post. geze’s coos the coyests Clarge) objets can fa kamen fr keep post: Reoyele po eoith our mandatory aefeaing ce oat Fluchout the data, tnedole te: Porameter 63 renyehe pot’ i the June of rremory clefautety aitccatid t SQA Components (s measured by [Granutes'. tf Sga-stze = +108 9 eeth granutes GAN be of Seve Ambo tf Sga- St2@: > 1G.» each gromules wilt be of Stze [6mb-16 | ToPIc: DATE: ‘oga-target? ret be akoays 1256 than the gal jax sete: Otheratse Ce throws ‘goat’! error: i The automate thereactng & decreareng of 240 ts done pamm CAatomatte shared rremory rranagement) cotth of MMAN (Memory manages): Because ftom wi sga & dynamteatty basecl on the vegutsernents- glatattes..tevel= Typtcal log-butfer twheneve the user Gende a veguest then usa p enter fuer Ceatleck¥on of programms) and Sewer procesé Starkup qn: oRth the help of Gerwerproveas Cnterface Irttance ean be stav dcldp. pr} then ga componenté axe altlecateat ® oracte creates ¢ eget coats) to ole the rgguect caine from the Ute These ee eq taken os \ereaphores? ecoute the Segnabing can be done ore cet cottestton of algortthmns | of these sérnaphores: te, to det want «tale or tocrad| Atal or to euent ele A these Serrephores ave mnottnfafnel by | yntock. amy "fovo level gertalizatton douring rrechonismn” CLATCH) || The datadeettonay , “ited € get use tntorreaton ie | wb gesgton’ ane re fo rreny vB coat: ent | and also eine to Kreco ga taformation “ vesqe » v¢ saa|ates i | fp got the soatbovnth veg Sgo stat: { a otually there one @ types of Suv processes: \ 1) Bower proces [4heneel process | i | i 2) Dedfeatic process:etre puss exec curt can }> sor “ Sort, ror DATE: 17 i fo clecoyys OAKS the ehtent& to do | oxen e ueed by Sorsaby’ a the SP Starts up then PGA iterates on the top of SAA rrereory oven fn RAM: pnd thE paw fre Bharable: Bating on haey raquivements hea pyr get allocated: 1 Cloceal). A reamory componant deallecates exhanews the S28ctor process contains a pao exe con meteor pga. target Se 6S " pga_size = the Gescton dependent varcables & eorttten ta net wortable contacns only one value wables are tL bipeeto* procectuves: 9 be cornporst a can howe eS whor & a sarfable that rauteeps CALLES * ” th rH not mandatory to dow the Cursor t spe augue a: Lamte “for the the pt/sat procure: toe “tea ih to be openedt ¢8 open-consors = Go" PF gate thé Curaore: Ae CUNsOre Cntvement ce the eursins- per tee regquererene ope wAlt legraces the perforant gundtttfon or etc. The Ste oF a Sab awe Wraentcuinad at gork-avecr-Stre= 64K: j Gibh ast clatement qtetn for sorting fo abtuttag dewediac tato jauns* Oe) ewtth. ternp tobespate coniatn ony ce degractes the performance « contaier wow than ow ternp Hles rmporante e pAR gots ‘fited up then (goes lerop tle apto qt for tange Sorting L198 exe have a tablespace group bre performance aIKO depends on the alleratten, of BAN co || spectftcation- f18 | | TOPIC: DATE: | we can qalewtatt the Chit ratto! ~ the san comporeris “the eondttton t% attcoye the hitratCo muct be greater ae. others 3G8'S data block burfer cache wit! talce dave of the Ade yetto: 82 can calutab the hélratyo for PB blow batter , Utbrory ccuche, Spy DPC etc: Pegeate cache: dvattable from U3 fnstead ef Caching ok entre, table (nto the cache taning ony the Aews bacol onl the we eoant tp rantfon a pare ellen os | sere vagutvernentA: cache-gcse'. Te tnereases the perforrnana alo “pecuntt — peautt gaiche modeie™ Manuel Note: Reads arp of 2 types: DD pesaute } N\ 1D physteod vgaots Canal orn Auto Pipreofcles) 41 Logtcad th L fats Putters) + Fa) DB bl “He" getont f =Py if e a ao we 4 = = gy gi ani ‘ole thadae fooc aa Fare cherr loo Sate rr ‘lg A TETTLITUTTTIN 3 oot cage eae r Gs) \ ee are ated ) * Tntetdgert dortaguto: rd prowedes onty the storage mecitsen creatlabettty. ce there &@ SOME etme butnot the datalotSo ches SAnt 0s Grtrockusso! to provécle the [Mgh avattabe tery. 5 thel databax cx atorad at te Enteltigent storage 6 ana the errors according to that olatabnse ave yerdack axth the help of SMP form of SMS tp the userd:TOPIC: Pic DATE: ‘Beacteng data. that alveacts a ag rat Crade Cdatabae bulfer cach) . Eoeng teers orosls A able aaktety tn the lnitfer cache but Some of the lata has been any frettbark degments/ undo Segments to matntacn th contatiney prinetple: these dlata biecks are port of dace catagory * Torroata. to fénc out the db butter cache Mt ratto Sy? Ve doles yk Beleck 1 - Cprvtatue } (el vatne + c+ wate) “htt ratto from wb Sysstat P, 20 \ Rens: there a a types of reaals: 1) phyttca) Poaols | 21 Logica! Reads | ‘ cote! Phy eceed rgaudls: These axe datablocks chat orastt eau, Prom. oa RAK: Peooteng data from ota ¢& merch more expenge’ on tn oracle ramory (SCA) echen. you tre etl alenoups iva ty to velrtend fromm reerrory 2) Logica vegas ft from dip budtfes cache you pe sagtca) dato. oy veaolir pead. the togtcal Aeact inctucles both db bloke a omnetetent ee 2) 28 Blew gets: whan ovack. dinds the requestat act eutth & the butler cache, te checks eahather the data én blocics c& uptn date on not: SF eh late th upto dats, tran |e Us gestng ao fetch the alata rom the butter cache uselt- ep Such fetch (& Known ah ab block ae | bs Conetitint: gata: Sometimes oracle ctinds the necesrany dedatitecks grange! by uses) thon exacts applées the pottback enformation from e| Aen lee conttstent fetbbe” i | ub Gyestat c, nig syaadat dath atetonary he resto to colon the trom ayer |eciece surotptn Kets) [ sarnt Hrom ug Library caches opi] tesa Eo get Sgt memory gysrl satece # from wh Sg% Sys gysace vg aga. teagel- aol Syd AAEAC wd syatnto at: tha Aetratto of datacdetronary rarsseeaes Cw \ DATE: 21 eqeht or gqeemisses- pened) | Sur (gets) 27 tron vgrowocache creo ents. muse aboot greater than 99 60 frst envreatt the shoved poot site EO? PFE rS.0 pone of shaveol poo!) coche hit roktot pins) # Koray cache ME ratvo" datoi ls geleck ¢ from chenpyycsunt. ug oqostot Spridece wh oqa~ dxyramic -cormponents ce22 TOPIC: Bere 20 pga Spat yang! aysr select username) Byer conn ag (2g gy selete ¥ from tab; ‘ By67 conn aglag defautt- tablespace from alba. PGP gelett count Ck) from emp; ingert fnto erp Selec ¥ ftOm emp; DATE: on another Sys Sho gorEH oe howe ae yor Once B vee goRActe-Homelal pop. aggregate banget + 60) Syd Skaxtup. force i ay? sho porate pge-| we wale 23 0 =~ Bykr dese vg Sort usage By Select username, toblespahe atone, Contents .geqtype, Seg bik vg Sore-usege, No rows gelected: fromDATE: 25 TOP! 7 Oye} che alter 519teM Set resull- cache. rnede= force; sys] sho parameter resalt- cache -mrode . gyar{ con aglag Golett: stoto-4ntn) from tab! ‘ > 1 0:00!00-00 - + Beraust the result gets from yeguit cache =" Sloco-4ntrd from kably, par [ac ro -regattcosbe #1 pot. 00; 00: OS ‘Ol No conte pad Regource BUSY ora.00054* optton spectved: op bol eeakt open: name vorccharol 20))), oaylereal table tabat n number, gar fencer tnt fabs vewtuest 1, tabe’? ; pay | coment; par ftnsert entp eaba values (2, Oxy2" on areher user (S48) : ; aia: co0su: resource 4S and eqor A oct axcqucxe eatth NocoAT spectre yee or tering «2g | Tore: = Nod ft toes for Neboort Tuning cmualty to go uct performance coe MPUKE take CORE of nubweortténg alk Usually Gf a usar connerkt © @ Seuxi preces then gach & ery ude all howe a Sauna process: sor can go eth showing 86 ewe proce sek heat Kouers ave catlesl oh Syk7 Sho parameter doll dock. Her YA? alker Gesalon Sek ad Loew. Etery neth the cleclicalict Sawer process the mit ee of eesoueey rapper: Sritead of, culocating one Asus proces to 100 asprocepses = « muteerrreccast Save procession “hens DATE: + oie o Sy67 ates oble dg-tabs aropCraq)) wouee to prypeoerror. OF utth In thes 10Me Cf User tl Committ the tx then tb cll drops the estnam--- | & @ cot!) to ont, apaproanss coweprocess? = ' santa. ; vecttcatsa: tHe — 1 Sect 56 1 Gl tapatentr- rrost Aiealy toat inpestcht pase preced precew—preee Shevad ext proce 70 Killa Gesston the user frformation dan be ceueullaliol from ' w$ Se6s¢on’ cety taze the sehpopily wsuprecesss | |23 ToPid: DATE: Da splect £ from emp order by ename; — -]- now te uses the temp tS for Sovting - -- ‘ gys7 Selec usernarne, Leiblesperee , contents, Seqtyp? » Segbiktt from ud Sore. usage; » SiAy grant puctretet to Ag} ay GyAr conn aglelg -agr Set rreien regutt caches (119 deatures) notes he detente Gere of the resuibcache 1% SY OF the shaved pool & (8 pont of the «haved poots Pt improves performance of Slo ag coekt on Roautt cciche can tale mereérnuen OF rok Leonabtty ef the ghatement> \ fon ime St2e)> SyAr foho parameter tesute- w@Gule- cach? ~ max - sere oak gysx fonn aglag pay feat. table tobitn numbed? te tnto sabi Cratises (20) vay lerter mate fers rm par : fonted vratue for Of 224 TOPIC: DAE Dar / Enter watue for or 5 yar grant exeeul on albeng— tock tags par select from tabi, oc. Sr ue tm qweat or replace furctfon Slow 49 (np table m7. byt yeturm table ny.type cletermintstte as begea alomns- tock slept) 5 return nn; ond; Ly an tnvartable we howe declared: ot. Shy Of .. ~--functton created ---- 447 conn aglag our geet glow fncny from abl; a+ St takes 1 Gog OHA panting each TOD Day Sek trenting on par Beer slow-Fntn) from ‘abl; ‘ elapsed: 00+ 08 105: 01 pay gelete Jat vecult-cache x) stow tnt) rom, Yesule cache & that ff Elapsed: 00:00: 05-05 Here tho sosult (5 stofe Joe query the Game. Atrnt “then po howe no time elapea + | cd gett om redult cone butter I i 8) wayables trvarfable oat variable Twouk v oe teTopic : DATE: 27 —. Z Hen Userprecess send the requests then the drspatener colt! -yeceer, luserprcess: Here only the made Likely fondled dispatcher can take Jucerprocess responstbtitty and then place t% the request queue 1 ee howt dimnitecl norof Serr processes: $0, ap “first chetk eahethar, foo, Gener processes axe frecup or not- so there CS Some delay or the userprocess and after seaving the aseprocess the 0 of thak process tk Gerd tm the game rqquectat ucuyhroce by environment & 1S yecorcl4 ala time ce, the array ste ts neh: For rnere fransfurtng we UC “rove array S¢2e - jrantages ath dedctated Server process: - cuclécalteal eure processes DEP) need fot of (ony dak test to my pmory ori the Aenuer- ce cleclecaacl Server Aperols, rrove tiene tp create & texmminale the Gerke proces Ca tdle-mose of the time: 4] Shared Sewer process CSSP)' tages eatth muttircadacd day tent connecttons . Less wastage F 1) Sijoe cleat SSP ean hanetle mang ete 1S remo . 2? re cpa time’ are not rum mackd for creatyng gy terminating Ses eSS pis are adecl more effiecently vantages coceh : met etthreacted ae (SSP: 1) FHa chhont & yanning a huge batch job, cahich demands attention {Serer process, fn mattithraccled geroas fH eS mt generated. hess tote time:28 Hl i | | TOPIC DATE | wotesses UN and how bu: ore: ° 4 a Derwent 9 Segston Spectite data (S8D)—r onty for that partioutos 8) User global avec (06,A)— % the past of pan | ze Pn eremabe areal sarge poot). Fach neo conneckfon c& given t the rnost Likely dead Atepatches process: fate muttyple used to be Serviced, te aan plan -for rap dexpatehers from the nevof acapatehers echéle the Enctonee W& uport wand 2 Utenté has ( east For submeeetng a Sat Ste unt g shared! server process ¢8 freedeip, whch olepends upon the rode Server ston. Jo th ceuce of dedicated seuxprocess plif-s1 vortables, sq binal voriabiyy honk vartables ave Abpved én the axon memory Space: ) Incase of SSP (Shared Sener process) needs to be mot i anne 5) Gn MTS the etinpatches proorsS communicates woth a el 6) Dtkpntches textes * the request me vss Cualtd $69 stmt) Pp cients B places them in a request quese cohen a ¥eq & ontered LD nee avadtable ssp processes t+ | A) ate vequere at least one aecpatches pec prtzcot as Oractte Supports rmuterple protocols repifp, Named pepes cic: a | - a) we hOLe (© prong up atleast one atspotches Per protoest| Df there, Le. nkkrove ox we Cén also tncrease| yrulttple orDATE: 29 ————. TOPIC: Sn rien to gp eth auatiing eve have ¢o mention the paraimebed parameter file namied fn jJacctee - trou the Uptuer for Hed porametes £3 1) None | a) ols > 2 0B tion for the audce files: ke. Home] velbree|audce —y defautt Loco cise Levels P47 Qnedke of rane — fuclfe cs Nok appltoable toformatten tn dakab neal of DB ~ stores the audlcttry | gr the bac tedbles spans of ola — AtOres at ols Level cahather cur given path) defeult path, | S65 5, Systern privileges veers |, object level 5 Sat Staternen® Success hal unsaccess het access Seseton pap Avoit- TRAIL A083 -AVDIT_OPTS: par. pvON - CBsECTS: ort. STATERIENTS ped_ srr. AvdIT-OPTS | pen. Au pen Lppiy - audit opts pea AvDIT. SESSION30 TOPIC: DATE: ee og eed on Serer Cabo tS) doats $ wi Lectener ora. = contegure and Staxtup the Lesteneré-- = 7 $ dann Alea prot Py4r Stoo tup lajer conn tect (teat Heeae> LPS -* cor) Lps x teat yr exile bysy Select username, defaute— 4 gytplus — ets] text S 3 usr Connecking docatty on fen eC abatta albaia$ we Enénames --- conttyure the 4 & peng $ eniping €0-prey ro ares, benea- o> = tablespace from dba-uses | en anther Sepp thats) Bysr dese vd sesbrpo e- Gyar Selece username, Siilemang i 5 moehtne -from ys gegston bere t usernames © TESS | <-- Hele ene gee one Sespton- ~~ bree Sik Gave ww nowe; jAfettcozl , on cbient Cabats i $ oqtplus test (test @ tb-prod connetiving to user ule remotely ©" * testy vy “4 i |DATE: 31. rene, scaled | Tispetlt dette poccal- deatener = sbaighekaheasctiocn } on another Server ctbois) +) SY? gee neime | path the im | Hoe al ee occ Ct eta akouta &ngleate gonatpakedt HOU Ad Here two get 2 gesstons LORE: - a tq oRneLE. Homelabs| Inte ORACLE-SIO‘OrH acer terminal. See, ce bites peamattd | shoved servers: + ; abouapalavesofuren atcspatchess «*Cprotocot= teprCatespatehers? 4)” “Cactavess = Chest = apats) f cprotocet = tcp) Cport = Amantroned 60 ucteren -- | tea a 1599 Sysy Slortup force; were ape hae one opefon. . pmo butepatenens dna eae & sys sho parameter atepoteher- tof the an gle Ube Ape 2 Lo Bh0S the cteapatehers [nformedtion*~ cuepaspner™ e 4p sho porometer shavedl-S aH ee we phous the Shoxecl Seruers*” ae a wee re pownet See Syr dese vg okcapatcher 40) fort ge ge? “go noes attopatcher cletac!d, 0 datadicktorany weeu2s ete an eleent (bate) abaiad ut tnsnames-ora. enakt 2 od i rer’ Cconneue datas eq Og alg 10= pavaninees Go aah rod aeregy? . Seema Creat te bane he 80 OM ey ! ahan’g insping &D. prod32 TOPIC : DATE: on another Seu Cabos) clbais gqiplus test [best cpfspe} — get ame: ayee / crurame - = machine Tee dais ».Alahiresot t1com seb Teste PEAl a atbais eklhiresoftscom — ~ nore shared) ee | Sys coma «ho pawametex aucltt. Marne. Type vane, 4 Ista] wr-olrtoms uate. file-dect * og fomenglappl © tat olson ult ~ 643 operations povtean fale i Oudl’'t ale Syklog tee sing auualtl — trae sietng lee lone | syA7 exte 4 ul honncre rome fabs) (ntes RAE -SID- OF. | wot lot Based OL em aueleb brats trae: Cprewtously te was tn tome) || ined : oor i) } ay mS] a8 | Sy Slostup force ef Bye Sho porameter audeb—— | W autsl. trol ishing trae \ {Scot4> celeck ¥-from ab; lscotrp- ann fas sysetbo SyS7] eon test rest test tesch audte select on emp; ee Succeeded: okfon* Hout he ipaes Ard dow He of nerf ame actfon ackton-name, Sco ror tagoft Tent 101 togott teste 101 toqett Souk yo logott Scot los, essen Bee Seabue| vor tego oe es Ron ee DATE: grant eeletk on emp f scott; 7 prothe 4esscon O48? ecokty Seleck x from testemps conn scottlttger geotley conn las syedea ayer aaect count() rom oud $s count (4) _? 4x87 conn scott! ger ae seotky conn fas Ssdbo gysy Selec conics) Hom aud’; counece) 6 ~ yer. celeck wserraree , ob} name, aarion, ackfon-name froro dha. audit - boul; < Here there axe Some acrfon codes: acing these actfon Coctes. eve can write tréggers--- $4S7 conn test [test bese? MO, cmckee neapatt Select on emp;34 TOPIC: best > conn ‘ ‘9n other Sesston Soe ous | DATE: testy auctet elect on erp eohenever | ws b8y eghenever Solese operation emp then no audsttng Aask> roauctt gelect™ on emp eshenest mpe Successful | Gosston text aycteting: Syky aucttk creat Gesston; Sy87 Select Username, bo chow Ctirnesial 32 *dd-mon-yy shh: mt: ss”) logtn, to-charClogoffisime , ‘det; mon-yy? HP decodle Crekerncode » 1917, Fact, "sh From clba-audct - traet on 7 te 5 acces} oer eee bestlabe Sus7/ | = quack decode a4 fatl--- \ 487 Seleck retumendes atkfon, aberen-name ee Gro dba aude tratl cobere deernamete7} 1 i] yt | | Sy87 Sulect count(x) from aust. count) au SyA7_ noaudtt FY bya? buncob table auds; oak Sesston,,ek : DATE 35 statbrcenk unk veut SOME — gysr aaidtt table; cathe stmt aghteh conten rams table cotll + pave audlcetng - SyA7 conn test | teSE test > exeat table +600 number) 5 test conn [08 Sysdbo. ) 9437 Selete: countts) From audd36 | Topic: aon Rertintoning and Gndetes: enualty otha coorke eotthy mul wba rede hove to maintain the better performance: Sp, mut be dtutded nko mutetple Ataternents by Query are then these query anawent plasid tn dttferent dt ‘Jo pertorrnance ancl tor performance irereateng - FLA Cor rnceon 06 luo Stripping: And thease ¢& ons audadiwaniage a Heo atetpptng- ay becouse ctog te ” poratlel quey eption’ if oe tre a quey then no qavantes, wp eakth ecktch drtue contain the TeAULe D) need to cheak ait the drteer 9, o fo tnereoted & then for tis cratconbaek past eterfing concept fnbrootuces - as typest ailows cot oe | @ Range paretttons Cntott reange could ot beg, i =) sot [at pasttetonin oratin PFE apne oa ae > of. cored D> acereo ctf NL oc : ra aoe eden O ts ou 7 Ronge Lent ei] e. & ia @ compote 9 — (0.20 30-30 1-H 19 enhance ce vetor 1B Sateaval Perrge— hash | wy Syste Crtok eases} alba reaponetble only orate et jolt takecare) a ot . in partttvontng coe oAtl partttion the tabtet containing rrutltiee ~ 15 coe. con cn oo sn OMGaH er) Sevetal vecoreé) using the about partttiontng *ypes oe trhprove the performance. Condtctek sarge pavtttten wen ge aon gee 00 or “F] portttvon sarge for auptno from 19-20, 20- 30, 0-40 oe 4 for thie pentittontrg ox have tSeotabttity! eco, ce have postitfonad the verorda: Each B cory pep Ehren GS treated o& a table Roto, when ering 2 query, Chen. tresheool of Searcxng through entire table dean coe Can early get bie result from thig partttfona because toe rmanttoraal sofye. i i 1 ut i anTor|t: DATE: 37 ee ch postttfoning meant wing the hash value, generciBial ak thot 1 porfteatan time ponttion tatcesploce: 'Syen a portttfonad teible an lad be Sub- poretttoned. orate Cesett tales tbe partttioniatgof dala to reulkple pontttfons: "p clfmports pontttion t& a combérnton of muttiple pasttefons- fg Ph extension to the range pastttton ¢S tnterual garettvon: Th we ra pontitxons froin (0-30, 20-8 ont toe axe trytng tm cnserk Oe ee ce ree) eee ah error ‘ro dedlirad'. Gor EMA ee hawe mntecvat pon tttien » 4k dymamieatty erent portstton . tores the sec dhe 20- a fluo poneeion @ store x0 range +m 30-46) wnuatty sometimes partitions algo contain dome huge nt of data: So, we Teed to go with énderes: csually endexes O98 ‘Apa ducnaneterg objets? (dafraata): osustty making or creaking pillows) &- tree otuckure: C8. trae bawed Trdkxtnd) tor O©0© 8860 ‘4! 1 pra no, C0 HY ® @@ e portitfonadt table can also he indexed mew record aici théh the at the changes ove algo. effectiat dex and then odd leaf nodes Atte coma tine actdiirg ness wxotd balanced tree: -%prop + Rebutlel Snalaray Rebutt Mralaces- | . 38 | toric: DATE: Jeape to (ndtit, then the bénary tee becomes unbolanead. upto at oe muxt drop the tnd G veereati tha tnolex ror export tog tle on exporting ace have 'dnet#te? Coontazng att be t's )-And from 103 ewe howe qpature to rebufld ender wALL the] transackfors are qq toe have a aoubt how Can we ceatiaue gehile the tx are manning. $0, “ter thx we howe a Eeraporory Epdux tobexpace and ott the ty ave done at that temp tnder t9 G/eh the bx correct added t original fnctex- @) Funekton based Ghdae- Nob: uertual caturand |?) feature trom a ee a) Srwtatite Gnoexe! Ww B) Remase Rey Sndax w LOT CEncloe Organceed teubies)» 3) Dedcencting Inert: i © functton bana Tndsss GF we mentton as, w |% att Sedge oe oe? kenexon ak a qeireefon 8} we ude chiA Sémt muttiple times then at atl the aeotues indares axe vay Uteful: AS per the Search ertterta fatee or tues | ° i Sothawx" ae the B- tse stetactuve: { © Revere Key Tncaxi FR oft! revere the veltes rol wes | maintain Aurting § creates the rod for the pen ttiafone cedeutati the wokued of att records & Sores and then die reautl» For thik ue wall go edith ‘qunctfon bata Tnde*’ contatns [tioe wotue Leg the hunetton: AL creating Cndix qacie caleutate ehh bates G 3). SCE-mapP Andexes: col eohéch give bavteatty bootacn, Corel) tHE fe augids, cftherrom 1 T ‘ope : DATE: 389 — Z uy ‘Gn thE oratle matntacns the indir totormatton (h€, routs) 5) Dkscenetting Snaert ’ Saat ¥ from emp aacending fom Sal descending from corm ng ertterta. pes etth owas values bub PoE pose the Search) souk coturan yale » eoe note Some pecudo Cabrencly deftnad) cotummns ete. virtual cotumns ase the cetumns create! (ixtuod cotamns: Apa, verator, fof tre panttoutea eatarnné ee the modfitcattons perforrn on oftgénal cot etrtuad ectumnns. Arc ako coe cantonal fnotexes? ror this monuotiy creat the virtual cot'O& ct! affected eschumns Grvpatble better Bnderes: From uF ewe can metatain the rable 8 Tables pace Eneryptton? onucitty the cjRtp's are Stored at AS leet Ard ave bfrary text eles tortng QrRINGS? wwe can wid he oats tebe diles’ alg lwo & not ceuursed lene: Go, coe are ueerg to pion (to wasotatn “etuse views of the files) for the th eneryptton eve used ‘enattet Key jmacatotned. “These fey cook corttten| macnioired at Copy the 1 and a deperat dir from 0-H retecorn/adratn —y Syfnel ova. anc then aad a walter key to che copced Spatt: AL Sauer tor howe the coatlel bey. Ab vtlage to See the eqnitet bey TO olaflevet atte no one can haut prt nerypked tablespass dada the clata Cy toatlet Coy) ear renst Kraea, te coatfettbey- So, eaktte banaporttng 6 AKO cer Cn ucodts the lates (uring tiger ccoutet bey.40 | toric: DATE: —~y Dero on Virtual columns J | \ | teat’ Spty create toble tabs(n rumber, stud varchar2(ao) , marks number, grade varchar 93) generated aloays as ¢ case : | tchen mavttS.e60 then tc? | oobi comitsoceer chee chen ynarks> 50 and marks ez60 then when marzkS>60 and masks <=90 then eohen markS +40. and marks <=100 then} ena | cae fen) a ‘ rota 2 os femal) veo gett . {8 eatatos: ete me TOPIG: i | RAG CReat Appiteatfon Clusters) eating extth RAC) coe howe to nottty an bilities ~ ” avattabttity MW Meclean (eq! detaquard) i a) fnd the mekes are & san protestfon (Neede @ min 30048 RAID = 0 errippingy marvorteg 2G protectin eredes cody Hab dh teat eh tore that atoether ee ten ara > gor? the about PLISAL tests the Sewer componente fn the upgradect databace, along eth chery current Uerevon acl Slates: ext Ahutdown Cormedtal., restart for normal operaten, rel then TUN UbtrprSAl bo recrmpele any nwa application objects: . pac> ote deat abeh ange anther deer ttre tht te bok 7 te A> shut tmmedtote 7 Stortup & yy Getete ¥ fron dba objets eohere Stetus= SINWALO); £2 shocos the tnvaléd objeas - ~ sy4p @ foreeng! apploraele/ product lio a-o} adtbms Jadrein] utlyp: Sot co- Ge uAtl convat alt the tnvated objeeks te valid objets «- Ana the upguadation completect From ai to 109 Successhatly « i ito 2401 Hy 191270°3—y (OLD TOPIC: DATE: Opgracation ftom 103 to uF cxeep the dump oF ud aff Kyahut am termediate (109 derteboe) gyperte yoot@ala ~Jzt mkdtr -p forwenglappl eratle/ prodeactt + soot @dba vw] choco -R owmtletocnatestl loraeng oratle@dka aso]. $ ed lopt Coontatnéng u3 dump) Ope TS ts opt $ ca databace) dotabae]b 0 database] $ Sh runinstatter. eeleck engtatiotion method @ chroot aitvanced enctallatton Yo nent O enterprise 2ditton V * Fratall tecatton cradts:Bax: loraerg] apploractet prostate ‘ Noree! ODIHOME 2 path: [oraerg| applavatie| proctuct tl: nett # product agpect Re prevequtatti cheeks = eBeK O9 all cooHntngS =v Next” c# Seletk contiquration option, VF Snaball Seo onby NextTORIC DATE: 59 4 pebetteged ols groups nen v anata gerip tecat . “ an \ | torvengl appl ovat proouet It Weofroot:sh \ root £ @aba ~Jé sh | craenglapplorsele] produce het 0 | x00k Sb courte (YN)! Yee © Hitler exented than ft Gall o | .+ OP aheody G | ren i Loree | Y Sxit opbae@aba q-20]¢ Sqiplus ‘las syseton? 103 database) 7 gtartrp (starting up the ie} product [wo] sds} oarnin} abba tiit +Sqh ab @! oraeng! appl ora a pee tere Like af to 103 mégratton fh shows some pilok need adjustments to restae ther Scraillory here alAo coe need to make gome adjustrrents . -- - 1 : Gnateac of rrenttoning Lab-cache-size! from 19 coe are rnenttoning ub-blowt- batters’ - =. And a nero paremeter CS axtenpates alagrosttc deat ! * k go that te need not to mrenttan the aja dump, | caurnp, burp 26° 7° | c- Here a comatng: sfmrazone “KU CS uring prevlous bert ron: -60 Topic: nae ae ai” bok ge” 8. eb ony Ales alvencly exits then fe ott sysy elect wm fromm vd ttmezone- f#ley eee aoee Keurtrgrdat 2 CTnsteadl of & eve require 4) ys exe soot @ draw] tt cd opt opel opel ct 103 touglupgrated patens / potehs Jar 44 ab ep paggTOlt= tor03- LinvE: ep (-UmP —— | used for enanging the eetdcebrees atl pouicages ; procedures potens 4 cel [trap tor ampJ#_uoXtp pssaror4_ toaas - LIND: Rp prormpk. auacon CYN)E Yo trplat ts Gp to_oraule users: trp] $ ea 919K1/ pekt] gd Be B sfraninatatter * eoeleorne Nex 4 Speetty home aletulls name? ovttiomet path: Joraeng) applovaete [proceust te 2-0 dient latfon,DATE: 7 ora databat 109 yeleaw a potehget 2 19°2:0-3:0 | v Anatol Ge aAll trata) aill eb reco deatures that are roqutred Hor ud upgradation: seeipt location Locaeng| app] oroele! prodtutt: (0-2-0008 Golo rook ‘x00 @adba trp lytt sh loraenglapploraste] proetuct (0- 20 woot’sh Sertpl location vo v extk orate @aba 4:9:01$ Sqtplud "os sysctba? LF plus Releatt 19-2/0'3'0 4 fest fope rT cd togeo1ig\ upgeada pauens | Jat parce ep paezaacu-tosos. zinox2¢p (™P empituntp ps6 222cy-roges. UNDE CP u ge el! oat ctr 5632264 6162 TOPIC : DATE: templar 4 tmnp]a# cd 5632004 660.8264 tt ah KogaasyTe cd Hla flea tar L6 HHles] & cd oracose/ btacwela oracove tt cd 2onecnfo} of orate UL ZonecnfoJ zt ta oracle @arao] fed Cemp|5p32264/ ALLAAL on adore | 2onento Fone Cot & cp-Rtempl 563: 264) +les) oracere| zenecnie, [boracte-HOMe . | aac OTA @abavon cntold 94 S447 Startup upgrade | OyA7 Seleck #-4rom vo Filename ‘ temertrg- dat SyAY CLEC Abrns. stat s- gather. aéetfonasy- Stats; Sys? e1ec clbrnd— tats. gather - Schema Stats (' Svs"), Syh7 Ahut énnmectiacte- orack dba Zoreinto]$ ad crack @aba qo] cd foraenglapplovacte|produst | tbs] ep tet Porncte.Si0-0ra foraénglapploracts /predt ~--f~5-—---— zonecnto ja-olabS # [i roldbsDATE: 63 = + & ed Joraenglapp foraute| proauce|ii-t-ofses adbpl$ wl Mnle ORACLE. S10-OKO- ategnosttc lest | dtskifovadstot task background Cunp aestinattens-- _ comment caduirnp, ecdurrapy , compatible = rh shored. pod-Sete = 230r0 dimromebe cote e alb- block - butters bee or Yas Sysoba! @ave absig saps sha robo. sionted) vtup upgracte (109 at yet geet Batorn vg kemptiley yet alter davbose tampttle (Jacaktloradatal test temprtinp’ reste 6°T5 Ahut Conmedtate- ombie@aha q.0-0] $ ut shash-prokle expore ORACLE- HOMES Joreeng lapp foraths] procluck to |. bosh- protile f sqiplec “Jas Sysdbo” 7 i Aboatup upgrade ENE U3 aatabox opens)TOPIC: DATE: . | i 57 @forcengl app! ovate) product[wro) rabms! admin! cat giarsae i | iproctuce! tt +19] rales] adroin) vty} Ae | jobyetts ~~ Sysx @ lorneng] appl oractal = Ge Atl comme att the invalid objeeks to the vot | sThus the upgradatton £& completed | from 109 to U9 1 |

Wilshire Oracle11g DBA
71% (7)
Wilshire Oracle11g DBA
350 pages
Oracle 12C - (SQL & PL/SQL) : 1.fundamentals of Database
No ratings yet
Oracle 12C - (SQL & PL/SQL) : 1.fundamentals of Database
8 pages
SQL PL SQL Content
No ratings yet
SQL PL SQL Content
4 pages
NareshIT Oracle
100% (1)
NareshIT Oracle
140 pages
SQL PLSQL
No ratings yet
SQL PLSQL
213 pages
Oracle 10g Material Final
No ratings yet
Oracle 10g Material Final
145 pages
PLSQL Introduction
No ratings yet
PLSQL Introduction
17 pages
PL - SQL Useful Examples
No ratings yet
PL - SQL Useful Examples
37 pages
BOOK-Deva-Oracle Material
No ratings yet
BOOK-Deva-Oracle Material
177 pages
Print SQL
No ratings yet
Print SQL
52 pages
NareshIT SQLServer Training Notes02 BangarRaju
No ratings yet
NareshIT SQLServer Training Notes02 BangarRaju
84 pages
SQL Oracle11g Notes
No ratings yet
SQL Oracle11g Notes
125 pages
NEW-Oracle PLSQL Labbook
No ratings yet
NEW-Oracle PLSQL Labbook
40 pages
SQL by Jai Shankar Sir
No ratings yet
SQL by Jai Shankar Sir
158 pages
New Sateesh Yellanki (Oracle 10g)
No ratings yet
New Sateesh Yellanki (Oracle 10g)
398 pages
PL SQL For Advance Learners
No ratings yet
PL SQL For Advance Learners
4 pages
Oracle SQL notes
No ratings yet
Oracle SQL notes
66 pages
Oracle Book
No ratings yet
Oracle Book
169 pages
Madhu - Software - Sparks - SQL - PLSQL Guide
No ratings yet
Madhu - Software - Sparks - SQL - PLSQL Guide
215 pages
Oracle DBA Servival Guide
No ratings yet
Oracle DBA Servival Guide
287 pages
JDBC
No ratings yet
JDBC
190 pages
PHP Naresh Technologies PDF
No ratings yet
PHP Naresh Technologies PDF
258 pages
Introduction To ORACLE
No ratings yet
Introduction To ORACLE
9 pages
SkyEssPythonSyllabus 1
No ratings yet
SkyEssPythonSyllabus 1
10 pages
Oracle PLSQL Examples
No ratings yet
Oracle PLSQL Examples
33 pages
PL/SQL Best Practices: Infosys
No ratings yet
PL/SQL Best Practices: Infosys
8 pages
Skyess Spark Syllabus
No ratings yet
Skyess Spark Syllabus
12 pages
PLSQL
No ratings yet
PLSQL
61 pages
PL SQL Quick Reference
No ratings yet
PL SQL Quick Reference
48 pages
CS322: Database Systems: PL/ SQL
No ratings yet
CS322: Database Systems: PL/ SQL
47 pages
Oracle Syllabus
No ratings yet
Oracle Syllabus
7 pages
Oracle SQL and PLSQL Training Course Syllabus
No ratings yet
Oracle SQL and PLSQL Training Course Syllabus
5 pages
Oracle Notes
No ratings yet
Oracle Notes
64 pages
DBMS - JS in Database Management Systems With Its Operations and Its Functionalities
No ratings yet
DBMS - JS in Database Management Systems With Its Operations and Its Functionalities
71 pages
Java
No ratings yet
Java
233 pages
PLSQL Questions 1
No ratings yet
PLSQL Questions 1
2 pages
Oracle Notes
No ratings yet
Oracle Notes
588 pages
Skyess - Informatica Syllabus.
100% (1)
Skyess - Informatica Syllabus.
4 pages
SQL Difference
No ratings yet
SQL Difference
61 pages
Data Base Concepts
No ratings yet
Data Base Concepts
51 pages
Exceptions in PL/SQL
No ratings yet
Exceptions in PL/SQL
4 pages
Pawan Kumar Khowal SQL Server Tricky Interview Questions Answers Set 1 45 Questions No
No ratings yet
Pawan Kumar Khowal SQL Server Tricky Interview Questions Answers Set 1 45 Questions No
7 pages
PLSQL Program Example
No ratings yet
PLSQL Program Example
9 pages
Scenario: Executive Summary of Class Scheduler System
No ratings yet
Scenario: Executive Summary of Class Scheduler System
8 pages
Web Dev Notes
No ratings yet
Web Dev Notes
270 pages
PLSQL - Cursor Online Session Notes PDF
No ratings yet
PLSQL - Cursor Online Session Notes PDF
35 pages
SQL PLSQL Material Ramanjanayalu
100% (1)
SQL PLSQL Material Ramanjanayalu
323 pages
PL/SQL
No ratings yet
PL/SQL
148 pages
Triggers
No ratings yet
Triggers
4 pages
PLSQL & Relational Algebra
No ratings yet
PLSQL & Relational Algebra
21 pages
Ramchandra - Corejava (Update)
No ratings yet
Ramchandra - Corejava (Update)
603 pages
PLSQL Notes New-1
No ratings yet
PLSQL Notes New-1
86 pages
Unit 3 Advanced SQL
No ratings yet
Unit 3 Advanced SQL
44 pages
PL SQL Triggers
No ratings yet
PL SQL Triggers
5 pages
SQL Interview Questions
No ratings yet
SQL Interview Questions
45 pages
Stored Procedures in PL/SQL
No ratings yet
Stored Procedures in PL/SQL
22 pages
Oracle SQL Syllabus
No ratings yet
Oracle SQL Syllabus
9 pages
Hanumanth Sir Book-1
No ratings yet
Hanumanth Sir Book-1
172 pages
Murali Sir Oracle 11g Notes PDF
100% (1)
Murali Sir Oracle 11g Notes PDF
372 pages
Murali Sir (Oracle 11g Notes)
81% (31)
Murali Sir (Oracle 11g Notes)
372 pages

Uploaded by

Uploaded by

You might also like