understand oracle database
TRANSCRIPT
![Page 1: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/1.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 1/47
Architecture
Memory Area 1
2
3
Writing of Modied DataFigure
![Page 2: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/2.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 2/47
DBWR Concepts
Logging of ModicationsFigure
![Page 3: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/3.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 3/47
Redo ntries
!ndo ntries
![Page 4: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/4.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 4/47
Log "#itch
$mportant info%
Contro& Fi&es%
![Page 5: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/5.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 5/47
Chec'points
Data(ase Reco)ery
![Page 6: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/6.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 6/47
Archi)ing
![Page 7: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/7.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 7/47
*ther B+D ,rocess
*rac&e Directories and Fi&es on "A, "ystemsFigure
![Page 8: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/8.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 8/47
![Page 9: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/9.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 9/47
#or'process connection to *rac&e
-ote
![Page 10: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/10.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 10/47
-et "er)ices
![Page 11: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/11.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 11/47
Data(ase Administration .oo&s
![Page 12: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/12.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 12/47
Administrating *rac&e $nstances
![Page 13: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/13.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 13/47
.he fo&&o#ing shutdo#n modes are possi(&e%
![Page 14: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/14.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 14/47
!nit 2%
Bac'up/ Restore/ and Reco)ery
![Page 15: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/15.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 15/47
![Page 16: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/16.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 16/47
*rac&e $nstance0 B+D ,rocess Memory Area
"+A Data(ase (uer cache
"hared ,oo&
"hared "L Area
Ro# Cache
Redo Log Buer
Command% "ho# sga
![Page 17: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/17.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 17/47
![Page 18: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/18.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 18/47
![Page 19: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/19.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 19/47
![Page 20: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/20.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 20/47
![Page 21: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/21.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 21/47
![Page 22: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/22.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 22/47
![Page 23: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/23.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 23/47
![Page 24: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/24.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 24/47
![Page 25: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/25.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 25/47
![Page 26: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/26.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 26/47
![Page 27: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/27.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 27/47
![Page 28: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/28.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 28/47
![Page 29: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/29.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 29/47
![Page 30: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/30.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 30/47
![Page 31: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/31.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 31/47
![Page 32: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/32.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 32/47
![Page 33: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/33.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 33/47
![Page 34: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/34.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 34/47
![Page 35: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/35.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 35/47
![Page 36: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/36.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 36/47
![Page 37: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/37.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 37/47
![Page 38: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/38.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 38/47
![Page 39: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/39.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 39/47
![Page 40: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/40.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 40/47
![Page 41: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/41.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 41/47
![Page 42: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/42.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 42/47
![Page 43: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/43.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 43/47
![Page 44: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/44.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 44/47
![Page 45: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/45.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 45/47
![Page 46: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/46.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 46/47
![Page 47: Understand Oracle Database](https://reader034.vdocuments.us/reader034/viewer/2022051303/56d6bfb81a28ab30169766c5/html5/thumbnails/47.jpg)
7/25/2019 Understand Oracle Database
http://slidepdf.com/reader/full/understand-oracle-database 47/47