Oracle DBA Training - DBA Technologies

Views:
 
Category: Entertainment
     
 

Presentation Description

DBA Technologies is an Exclusive Quality training hub on ORACLE Database Administration, ORACLE Apps DBA and ORACLE RAC DBA which is aligned to present corporate requirements. We facilitate in-depth conceptual discussions coupled with real time scenarios. see more at: http://www.dbatechnologies.net/

Comments

Presentation Transcript

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

authorStream Live Help