PowerPoint Presentation: W E L C O ME T O D B A T E C H N O L O GI E S O R A C LE D A T A B A SE A R C HI T E C T U RE 1 B y M r . P R A S A D MYNUM P A T I 18 Y e a r s R e a l T ime in I ND I A - U S A ww w . db a t e c hn olo g i e s. n e t ww w .db a t e c hno l o g i es .n e t B u il d i n g C a r ee r With P assi o n
PowerPoint Presentation: A r ch i t ec t u r e Main c o mp o n e n ts o f A r chi t e ctu r e 1. OR A C LE I N S T A N C E SGA (Memo r y ) & Back g r ound P r ocess 2. OR A C LE D A T A B A SE S t o r a g e L e v el
PowerPoint Presentation: O R A C LE In s t a nce A r ch i t ec t u r e - SGA W h a t i s OR A C LE IN S T ANCE ? • – – P h y s i c a l Memo r y (SGA) & P r o c esses SGA s h o ul d b e a bl e t o o p en i n p h y s i c a l memo r y – – Wh a t i s S W A P ? S w a p a l so a t yp e of f il e s y s t em on H D D , i t i s u sed b y O S w h en R e a l memo r y u s a g e i s a t hi g h S w a p m u s t b e a v a il a bl e b e f o r e in st a llin g O r ac l e Soft w a r e –
PowerPoint Presentation: O r acle In s t a n ce A r c h i t ec t u r e – P R O C E SS E S • E ach c o nn ec ti on t o UNI X o p e r a tin g p r oce s s W hil e st ar tin g u p in st a n ce – SGA (Memo r y Str u c t u r es) – Bac k g r o un d P r o c ess ($ p s) s y st em i s a • • Bac k g r o un d p r oce s s a r e r e qui r ed t o m a n a g e m e m o r y s t r u c tu r es a n d d a t a b a s e fil e s . S o m e of th e imp or t a n t b ac k g r o un d p r oce s s a r e: D B W n , L G W R, S M O N , P M O N , A R CH , R E C O •
PowerPoint Presentation: In s t a nce A r ch i t ec t u r e • S G A - M a nd a t e a n d O p t i o n a l memo r y s tr u c t u r es a n d b ac k g r o un d p r o c esses St r eams P ool La r g e D B W n L GW R SM O N P M O N CK P T R E C O
PowerPoint Presentation: Wh a t i s O R A C LE D AT A B AS E ? OR A CLE D A T A B A S E is a c o mbin a ti o n o f 3 di f f e r e n t typ e s o f fil e s • • Di f f e r e n t typ e s o f fil e s ( C , R , D) – – – C o n t r o l F il e s R e do l o g fil e s D a t a fil e s
PowerPoint Presentation: DB A r ch i t ec t u r e - Co n t r o l F il es Co n t r ol Files – Hol d s d a t a a b o u t d a t a b a s e s t ru c t u r e ( p h y s i c al d a t a b a s e s t ru c t u r al i n f o rm a t io n ) Imp o r t a n ce of c o n t r ol f ile • • – D a t a b a s e c an n ot b e s t a r t ed w i t h o u t c o n t r ol f ile – Mu l t i p l e xi n g t o s upp o r t f r om f ail u r es – S upp o r t s u p t o 8 f ile c o p ies
PowerPoint Presentation: DB A r ch i t ec t u r e - Co n t r o l C o n t e n t s of C o n t r ol fil e F il es • – – – – D a t a b a se N a me a n d d a t a b a se i d D a t a b a se c r e a t i on d a t e a n d t i me A l l d a t a b a se f il e n a mes ( d a t a f il es) Lo ca t i on of e ac h d a t a f il e – – – – A g e of e ac h f il e ( Ch e c k p o i n t I n f orm a t i o n ) Cu r r e n t o nlin e l og se qu e n c e nu m b er Ch e c k p o i n t nu m b er Bac k u p i n f orm a t i on
PowerPoint Presentation: D B A r c hi t ec tu r e - D a t a F il es D a t a F ile s S t o r e s a ct u al d a t a pe r m a ne n t l y i n OR A C LE p r o p r i e t a r y file s c a lle d d a t a file s. D a t a file s a r e g o in g t o b e on fil e s y s t e m li k e • • • – – U N I X E XT 2 – – E XT 3 N T F S (in c ase o f wind o w s) • M ini m u m 3 d a t a b ase file s a r e r equi r e d f r om 10 g – – – S y st em U ndo S y saux
PowerPoint Presentation: DB A r ch i t ec t u r e - R edo l o g f il es S t o r es a l l c h a n g es i n th e f orm of c h a n g e v ec t o r s f or r e c o v e r y • • Ch a n g es a r e s a v ed t o D a t a F il es F il es – w h a t i s th e di f f e r e n ce? Ch a n g es t o R ED O L OG F I L E S a r e c h a n g e v ec t o r s a n d R e d o Log • i n th e f orm of – B l ock i d – F il e i d – Ch a n g e d e t a il s Ch a n g es t o D a t a fil es a r e i n th e f orm of r o w s a n d bl oc k s •
PowerPoint Presentation: DB A r ch i t ec t u r e Co n t r o l files : minimum 1. S t o r es D a t aba s e s tru c tu r al i n f o rm a ti o n. R e c o mmended 3 file s . • D i s k1 Co n t r ol D i s k2 Co n t r ol D i s k3 Co n t r ol • D a t a files : M inimum 3 f r o m 10g. S t o r es r e tri e v al purp os e. d a t a permane n tly f o r S y s t e m Undo S y s aux • R edo l o g file s : M inimum -2 h o lds all c han g es in the f o rm o f c han g es v e c t o r s f o r r e c o v e r y R e g o1a . l og R e do2a . l og
PowerPoint Presentation: O r a c l e Se r v er O r ac l e Se r v er i s t h e c om bin a t i on of O r ac l e I n st a n c e & • O r ac l e d a t a b a se. D a t a b a se acc ess i s o nl y vi a I n st a n c e SGA D a t a b a se > S e l e c t D BBC SP F r o m Em p ; User P r o c ess Co n t r ol R e do D a t a F il e s L C DD C RE D O L OG B U FF E R S Back g r oun d P r o c e ss e s
PowerPoint Presentation: Lo g i c al a n d P h y si c al a sp ect of O r ac l e d a t a b a s e D A T A B ASE PH Y SICAL L O G ICAL Co n t r ol F il e s T ab l e s V ie w s D a t a F il e s P r o c e du r e s R e do Log F il e s T r i g g e r s
PowerPoint Presentation: I S PH Y SICAL IN S T ANC E P H Y S ICA L OR L O GICA L ? L O G ICAL IN S T ANCE ? NEIT H ER IT IS V OL A TI L E
PowerPoint Presentation: O R A C LE D a t a b a se T S A r ch i t ec t u r e S Y S TEM T AB L E S P A C E IN D EX T AB L E S P A C E D A T A T AB L E S P A C E TEMP OR A R Y T AB L E S AP C E UN D O T AB L E S P A C E S YS A UX T AB L E S P A C E
PowerPoint Presentation: D a t a b a se A r ch i t ec t u r e – SY S T E M T S U se r s s h o u ld n ot k eep a pp li c a tion d a t a • on S Y S T EM t a b les p ace. It is o n ly t o s upp o r t b ase T AB $ t a b les li k e • • • • C O L$ I N D$ …… . B as e t ab les a r e c r e at ed dur i n g t h e c r e a tion of d at abas e t o supp o r t m e t ad at a
PowerPoint Presentation: D a t a b a se A r ch i t ec t u r e – SY S A U X T S S Y S A U X t a b le s p ace i n t r o du ced in v e r s ion 10g S upp o r t s w o r k load r e p o s i t o r y R e p o r t s s u ch as A WR a n d ADD M w ill • • • m a k e u s e of S Y S A U X t o g e n e r a t e r e p o r t s Hel p s in und e r s t a nd i n g t h e p e r f o rm a n ce a t S E R V E R l e v el •
PowerPoint Presentation: D a t a b a se A r ch i t ec t u r e – U NDO T S • U ND O t a b le s p ace is t o s upp o r t i m a g e dur i n g DM L o p e r a t io n s S upp o r t s R ead c o n s i st e n cy Fla s hb ack o p e r a t io n s b e f o r e • • • • R oll b ack t r a n s ac t io n s Co n t e n t s of U ND O T S t y p e is U ND O it is n ot p e rm a n e n t a n d
PowerPoint Presentation: B uilding c a r ee r with pa ss i o n D S NR : 94 4 1 1 7 2 718 / 0 4 0 -6 5 555 6 8 9 ww w . db a t ec hno l og i e s . n e t QU E S T ION A N D A N S W E R S E SSION