loss of full database & recovery - rman backup.pdf
TRANSCRIPT
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
1/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
DFAAHDU UF UG[@HU EGUGKGTH XTLA@ [OGA
$ hxpfrt F[GDJHVTLE?dros
$ rjroga tgr`ht /
[hdfvhry Ogag`hr= [hjhgsh 77.;.3.7.3 - Srfeudtlfa fa Tgt Mga 47 73=74=82 ;378
Dfpyrl`nt (d) 7;, ;33
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
2/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
DFAAHDULA@ UG[@HU EGUGKGTH
T\T1 shjhdt agoh, ekle brfo v$egtgkgsh9
AGOH EKLE
--------- ----------D[OT 7803570354>;3<
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVgaaaaVJHRHJV3VBXJJVKG
DIXSVkeryzk8tV.kip tg`?JHRHJ-3-BXJJ-KGDIXS dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
dngaahj F[GVELTIV7= ehjhtla` grdnlvhe jf`(s)
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf̀ /;378V37V47/f7VobV7V8;VkeryzV.grd
[HDLE?423 TUGOS?>0354>;3<
Blalsnhe kgdiup gt 47-MGA-78
Ttgrtla` kgdiup gt 47-MGA-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 3 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
3/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
laput egtgbljh bljh auokhr?33334 agoh?/u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
laput egtgbljh bljh auokhr?33337 agoh?/u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
laput egtgbljh bljh auokhr?3333; agoh?/u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
laput egtgbljh bljh auokhr?33335 agoh?/u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
laput egtgbljh bljh auokhr?33338 agoh?/u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
laput egtgbljh bljh auokhr?33332 agoh?/u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
laput egtgbljh bljh auokhr?33330 agoh?/u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae3VUG@;3783747U7;;
447Vkeryzdt7V.kip tg`?UG@;3783747U7;;447 dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=58
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 3 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup shtladjuela` durrhat dfatrfj bljh la kgdiup sht
ladjuela` durrhat TSBLJH la kgdiup sht
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa3VUG@;3783747U7;;
447Vkerz3t3>V.kip tg`?UG@;3783747U7;;447 dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=3;
Blalsnhe kgdiup gt 47-MGA-78
Ttgrtla` kgdiup gt 47-MGA-78
durrhat jf` grdnlvhe
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe grdnlvhe jf` kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` grdnlvhe jf`(s) la kgdiup sht
laput grdnlvhe jf` tnrhge?7 shquhadh?84 [HDLE?427 TUGOS?>0354>;8<
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVgaaaaVJHRHJV3VBXJJVKG
DIXSVkerz3vnqV.kip tg`?JHRHJ-3-BXJJ-KGDIXS dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
dngaahj F[GVELTIV7= ehjhtla` grdnlvhe jf`(s)
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf /̀;378V37V47/f7VobV7V84Vkerz3v>iV.grd
[HDLE?427 TUGOS?>0354>;8<
Blalsnhe kgdiup gt 47-MGA-78
$ js -j /u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/
-rw-r----- 7 frgdjh flastgjj ;823 Mga 47 7;=;4 f7VobVgaaaaVJHRHJV3VBXJJVKGDIXSVkeryzk8tV.kip -rw-r----- 7 frgdjh flastgjj 75>5> Mga 47 7;=;5 f7VobVgaaaaVJHRHJV3VBXJJVKGDIXSVkerz3vnqV.kip
-rw-r----- 7 frgdjh flastgjj 7;V.kip
-rw-r----- 7 frgdjh flastgjj ;054>;>5> Mga 47 7;=;5 f7VobVaaae3VUG@;3783747U7;;447Vkeryzdt7V.kip
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
4/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
Kgdila` up kftn tnh egtgkgsh pjus grdnlvhe jf`s, nfwhvhr, tnh grdnlvhe jf`s wljj kh dfplhe blrst
gae tnh
rhquhsthe tg`
wfuje kh
— ‚JHRHJ-3-BXJJ-KGDIXS‴, tnha tnh grdnlvhe jf`s wljj kh ehjhthe
gs phr ehjhtlfa pfjldy dfabl`urgtlfa.
Pnha tnh egtgkgsh ls kgdihe up, tnh rhquhsthe tg`
ls aft ushe, sf tnh gdtugj egtgkgsh kgdiup `htsga [OGA `hahrgthe tg` (UG@;3783747U7;;447) gae AFU tnh fah wh wgathe.
Unh durrhat rhef jf` ls tnha grdnlvhe & kgdihe up —
`ft tnh rhquhsthe tg` ‚JHRHJ-3-BXJJ-KGDIXS.
Blagjjy tnh dfatrfjbljh & spbljh grh kgdihe up gddfrela` tf tnh gutfkgdiup pfjldy gae g`gla, `ft
ga [OGA `hahrgthe tg`. [hquhsthe tg` ls fajy gppjlhe tf tnh blrst kgdiupsht la tnh kgdiup.
f7VobVgaaaaVJHRHJV3VBXJJVKGDIXSVkeryzk8tV.kip JHRHJ-3-BXJJ-KGDIXS [hquhsthe Ug`
f7VobVgaaaaVJHRHJV3VBXJJVKGDIXSVkerz3vnqV.kip JHRHJ-3-BXJJ-KGDIXS [hquhsthe Ug`
f7VobVadsa3VUG@;3783747U7;;447Vkerz3t3>V.kip UG@;3783747U7;;447 [oga @hahrgthe Ug`
f7VobVaaae3VUG@;3783747U7;;447Vkeryzdt7V.kip UG@;3783747U7;;447 [oga @hahrgthe Ug`
L nfph yfu dga uaehrstgae djhgrjy wnha phrbfrola` rhdfvhry, wny wh elsduss kgdiupshts & tg`agohs nhrh.
L ogih sfoh dnga`hs la tnh tgr`ht egtgkgsh sudn gs drhgtla` ahw ushrs gae drhgtla` ahw tgkjhs.
T\T1 `rgat dfaahdt, rhsfurdh tf ushr7 lehatlblhe ky ushr79
@rgat suddhhehe.
T\T1 gjthr ushr ushr7 ehbgujt tgkjhspgdh nros9
Xshr gjthrhe.
T\T1 dfaa ushr7/ushr79
Dfaahdthe.
XTH[71 drhgth tgkjh tgk7 gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
XTH[71 drhgth tgkjh tgk; gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
L ngvh ogeh sfoh dnga`hs tf tgkjhs la tnh ushr7 sdnhog. Tf oy egtgkgsh ls ngvla` ahwjy dnga`he
kjfdis. Afw lt ls rhgey bfr ladrhohatgj jhvhj 7 kgdiup.
UGIH JHRHJ 7 LAD[HOHAUGJ KGDIXS — 7st ULOH
[OGA1 kgdiup ladrhohatgj jhvhj 7 egtgkgsh tg` "JHRHJ-7-KGDIXS-7"9
Ttgrtla` kgdiup gt 47-MGA-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 7 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
laput egtgbljh bljh auokhr?33334 agoh?/u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
laput egtgbljh bljh auokhr?33337 agoh?/u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
laput egtgbljh bljh auokhr?3333; agoh?/u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
laput egtgbljh bljh auokhr?33335 agoh?/u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
laput egtgbljh bljh auokhr?33338 agoh?/u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
laput egtgbljh bljh auokhr?33332 agoh?/u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
laput egtgbljh bljh auokhr?33330 agoh?/u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
5/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV
7Vkerzd5z5V.kip tg`?JHRHJ-7-KGDIXS-7 dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 7 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
ladjuela` durrhat dfatrfj bljh la kgdiup sht
ladjuela` durrhat TSBLJH la kgdiup sht
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VJHRHJV7VKGDIXSV
7Vkerzd02tV.kip tg`?JHRHJ-7-KGDIXS-7 dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37Blalsnhe kgdiup gt 47-MGA-78
T\T1 drhgth ushr ushr; lehatlblhe ky ushr; ehbgujt tgkjhspgdh nros9
Xshr drhgthe.
T\T1 `rgat dfaahdt, rhsfurdh tf ushr;9
@rgat suddhhehe.
T\T1 dfaa ushr;/ushr;
Dfaahdthe.
XTH[;1 drhgth tgkjh tgk7 gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
XTH[;1 drhgth tgkjh tgk; gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
L ngvh ogeh sfoh dnga`hs tf tgkjhs la tnh ushr; sdnhog. Tf oy egtgkgsh ls ngvla` ahwjy dnga`he
kjfdis. Afw lt ls rhgey bfr ladrhohatgj jhvhj 7 kgdiup.
UGIH JHRHJ 7 LAD[HOHAUGJ KGDIXS — (;ae ULOH)
[OGA1 kgdiup ladrhohatgj jhvhj 7 egtgkgsh tg` "JHRHJ-7-KGDIXS-;"9
Ttgrtla` kgdiup gt 47-MGA-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 7 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
laput egtgbljh bljh auokhr?33334 agoh?/u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
laput egtgbljh bljh auokhr?33337 agoh?/u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
laput egtgbljh bljh auokhr?3333; agoh?/u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
laput egtgbljh bljh auokhr?33335 agoh?/u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
laput egtgbljh bljh auokhr?33338 agoh?/u3;/gpp/frgdjh/frgegtg/dros/dros37.ekblaput egtgbljh bljh auokhr?33332 agoh?/u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
laput egtgbljh bljh auokhr?33330 agoh?/u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
6/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV;
Vkerzt>0;V.kip tg`?JHRHJ-7-KGDIXS-; dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 7 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
ladjuela` durrhat dfatrfj bljh la kgdiup sht
ladjuela` durrhat TSBLJH la kgdiup sht
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VJHRHJV7VKGDIXSV
;VkerztkndV.kip tg`?JHRHJ-7-KGDIXS-; dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
Blalsnhe kgdiup gt 47-MGA-78
G`gla l ogih sfoh dnga`hs la tnh tgr`ht egtgkgsh sudn gs drhgtla` ahw ushr gae drhgtla` ahw tgkjhs
bfr ahxt jhvhj(duoujgtlvh) kgdiup.
T\T1 drhgth ushr ushr4 lehatlblhe ky ushr49
Xshr drhgthe.
T\T1 `rgat dfaahdt, rhsfurdh tf ushr49
@rgat suddhhehe.
T\T1 gjthr ushr ushr4 ehbgujt tgkjhspgdh kpos9
Xshr gjthrhe.
T\T1 dfaa ushr4/ushr4
Dfaahdthe.
XTH[41 drhgth tgkjh tgk7 gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
XTH[41 drhgth tgkjh tgk; gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
T\T1 shjhdt ushragoh, ehbgujtVtgkjhspgdh brfo ekgVushrs wnhrh ushragoh jlih 'XTH[%'9
XTH[AGOH EHBGXJUVUGKJHTSGDH
------------------------------ --------------------
XTH[; N[OT
XTH[7 D[OT
XTH[4 KSOT
T\T1 dfaa ushr7/ushr7
Dfaahdthe.
XTH[71 drhgth tgkjh tgk4 gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
T\T1 dfaa ushr;/ushr;
Dfaahdthe.
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
7/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
XTH[;1 drhgth tgkjh tgk4 gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
T\T1 dfaa ushr4/ushr4
Dfaahdthe.
XTH[41 drhgth tgkjh tgk4 gs shjhdt * brfo ushrVfkmhdts9
Ugkjh drhgthe.
UGIH JHRHJ 7 DXOXJGULRH KGDIXS
Afw L go rhgey tf tgih g duoujgtlvh ladrhohatgj kgdiup, wnldn wljj drhgth g ahw kgdiup dfaslstla`
fb gjj tnh kjfdis tngt dnga`he sladh tnh prhvlfus jhvhj zhrf kgdiup.
[OGA1 kgdiup ladrhohatgj jhvhj 7 duoujgtlvh egtgkgsh tg` "JHRHJ-7-DXOXJGULRH-L"9
Ttgrtla` kgdiup gt 47-MGA-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 7 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
laput egtgbljh bljh auokhr?33334 agoh?/u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
laput egtgbljh bljh auokhr?33337 agoh?/u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
laput egtgbljh bljh auokhr?3333; agoh?/u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
laput egtgbljh bljh auokhr?33335 agoh?/u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
laput egtgbljh bljh auokhr?33338 agoh?/u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
laput egtgbljh bljh auokhr?33332 agoh?/u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
laput egtgbljh bljh auokhr?33330 agoh?/u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VVJHRHJV7VDXOXJG
ULRHVVkes32;s7V.kip tg`? JHRHJ-7-DXOXJGULRH-L dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
dngaahj F[GVELTIV7= stgrtla` dfoprhsshe ladrhohatgj jhvhj 7 egtgbljh kgdiup sht
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) la kgdiup sht
ladjuela` durrhat dfatrfj bljh la kgdiup shtladjuela` durrhat TSBLJH la kgdiup sht
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VVJHRHJV7VDXOXJG
ULRHVVkes325x;V.kip tg`? JHRHJ-7-DXOXJGULRH-L dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
Blalsnhe kgdiup gt 47-MGA-78
T\T1 shjhdt ushragoh, ehbgujtVtgkjhspgdh brfo ekgVushrs wnhrh ushragoh?'TDFUU'9
XTH[AGOH EHBGXJUVUGKJHTSGDH
------------------------------ ------------------------------
TDFUU XTH[T
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
8/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
T\T1 dfaa sdftt/tl`hr
Dfaahdthe.
TDFUU1 drhgth tgkjh tgk7(le auokhr, agoh vgrdngr;(78), sgjgry auokhr,
ofkljh auokhr, dlty vgrdngr;(78))9
Ugkjh drhgthe.
TDFUU1 KH@LA
; bfr l la 7..;33333 jffp
4 lashrt latf tgk7 vgjuhs(l ,'sgo',43333,
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
9/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
ladjuela` durrhat TSBLJH la kgdiup sht
dngaahj F[GVELTIV7= stgrtla` plhdh 7 gt 47-MGA-78
dngaahj F[GVELTIV7= blalsnhe plhdh 7 gt 47-MGA-78
plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VJHRHJV7VKGDIXSV
4Vkes3xeezV.kip tg`?JHRHJ-7-KGDIXS-4 dfoohat?AFAH
dngaahj F[GVELTIV7= kgdiup sht dfopjhth, hjgpshe tloh= 33=33=37
Blalsnhe kgdiup gt 47-MGA-78
Gbthr Jhvhj 7 ladrhohatgj kgdiup l go upegtla` bhw trgasgdtlfas la sdftt sdnhog kut L ef AFU ngvh
gay roga kgdiup bfr jgthst trgasgdtlfas.
TDFUU1 upegth tgk7 sht agoh?'TGOXHJT'9
;33333 rfws upegthe.
TDFUU1 dfoolt9
Dfoolt dfopjhth.
TDFUU1 drhgth tgkjh tgk; gs shjhdt * brfo tgk79
Ugkjh drhgthe.
JHUT DNHDI GJJ KGDIXS EHUGLJT
[OGA1 jlst kgdiup suoogry9
Jlst fb Kgdiups
???????????????
Ihy U\ JR T Ehvldh Uyph Dfopjhtlfa Uloh #Slhdhs #Dfplhs Dfoprhsshe Ug`
------- -- -- - ----------- --------------- ------- ------- ---------- ---
547 K G G ELTI 47-MGA-78 7 7 \HT JHRHJ-3-BXJJ-KGDIXS
54; K 3 G ELTI 47-MGA-78 7 7 \HT UG@;3783747U7;;447
544 K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-KGDIXS-7
545 K 3 G ELTI 47-MGA-78 7 7 \HT UG@;3783747U7;;447
548 K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-DXOXJGULRH-L
542 K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-DXOXJGULRH-L
540 K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-KGDIXS-;
54> K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-KGDIXS-7
54< K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-KGDIXS-;
553 K G G ELTI 47-MGA-78 7 7 \HT JHRHJ-3-BXJJ-KGDIXS
557 K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-KGDIXS-4
55; K 7 G ELTI 47-MGA-78 7 7 \HT JHRHJ-7-KGDIXS-4
[OGA1 jlst kgdiup9
Jlst fb Kgdiup Thts???????????????????
KT Ihy Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh------- ---------- ----------- ------------ ---------------547 ;.33I ELTI 33=33=33 47-MGA-78
KS Ihy= 55; Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-3-BXJJ-KGDIXS
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
10/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVgaaaaVJHRHJV3VBXJJVKGDIXSVke
ryzk8tV.kip
Jlst fb Grdnlvhe Jf`s la kgdiup sht 547
Unre Thq Jfw TDA Jfw Uloh Ahxt TDA Ahxt Uloh
---- ------- ---------- --------- ---------- ---------7 8; ;88;735 47-MGA-78 ;88;752 47-MGA-78
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
54; Ladr 3 ;27.22O ELTI 33=33=57 47-MGA-78
KS Ihy= 554 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= UG@;3783747U7;;447
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae3VUG@;3783747U7;;447Vker
yzdt7V.kip
Jlst fb Egtgbljhs la kgdiup sht 54;
Bljh JR Uyph Dip TDA Dip Uloh Agoh
---- -- ---- ---------- --------- ----
7 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
; 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
4 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
5 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
8 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
2 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
0 3 Ladr ;88;782 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
544 Ladr 7 7.;;O ELTI 33=33=33 47-MGA-78
KS Ihy= 555 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-KGDIXS-7
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VJHRHJV7VKGDIXSV7Vkerzd
02tV.kip
TSBLJH Ladjuehe= Ofelbldgtlfa tloh= 47-MGA-78
TSBLJH ekVualquhVagoh= D[OT
Dfatrfj Bljh Ladjuehe= Dip TDA= ;88;4V.kip
TSBLJH Ladjuehe= Ofelbldgtlfa tloh= 47-MGA-78
TSBLJH ekVualquhVagoh= D[OT
Dfatrfj Bljh Ladjuehe= Dip TDA= ;88;7>5 Dip tloh= 47-MGA-78
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
11/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
548 Ladr 7 7.8>O ELTI 33=33=33 47-MGA-78
KS Ihy= 552 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-DXOXJGULRH-L
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VVJHRHJV7VDXOXJGULRHVVk
es32;s7V.kip
Jlst fb Egtgbljhs la kgdiup sht 548
Bljh JR Uyph Dip TDA Dip Uloh Agoh
---- -- ---- ---------- --------- ----
7 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
; 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
4 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
5 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb8 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
2 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
0 7 Ladr ;8845;3 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
542 Ladr 7 7.;;O ELTI 33=33=33 47-MGA-78
KS Ihy= 550 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-DXOXJGULRH-L
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VVJHRHJV7VDXOXJGULRHVVk
es325x;V.kip
TSBLJH Ladjuehe= Ofelbldgtlfa tloh= 47-MGA-78
TSBLJH ekVualquhVagoh= D[OT
Dfatrfj Bljh Ladjuehe= Dip TDA= ;8845;7 Dip tloh= 47-MGA-78
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
540 Ladr 7 7.5>O ELTI 33=33=33 47-MGA-78
KS Ihy= 55> Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-KGDIXS-;
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV;Vkerzt
>0;V.kip
Jlst fb Egtgbljhs la kgdiup sht 540
Bljh JR Uyph Dip TDA Dip Uloh Agoh
---- -- ---- ---------- --------- ----
7 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
; 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
4 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
5 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
8 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
2 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
0 7 Ladr ;8847;; 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
12/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
54> Ladr 7 24;.33I ELTI 33=33=33 47-MGA-78
KS Ihy= 55< Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-KGDIXS-7
Slhdh Agoh=/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV7Vkerzd
5z5V.kip
Jlst fb Egtgbljhs la kgdiup sht 54>
Bljh JR Uyph Dip TDA Dip Uloh Agoh
---- -- ---- ---------- --------- ----
7 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
; 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
4 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
5 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
8 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
2 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
0 7 Ladr ;88;4>< 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---- -- ---------- ----------- ------------ ---------------
54< Ladr 7 7.;;O ELTI 33=33=33 47-MGA-78
KS Ihy= 583 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-KGDIXS-;
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVadsa7VJHRHJV7VKGDIXSV;Vkerzt
kndV.kipTSBLJH Ladjuehe= Ofelbldgtlfa tloh= 47-MGA-78
TSBLJH ekVualquhVagoh= D[OT
Dfatrfj Bljh Ladjuehe= Dip TDA= ;8847;5 Dip tloh= 47-MGA-78
KT Ihy Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh
------- ---------- ----------- ------------ ---------------
553 75.33I ELTI 33=33=33 47-MGA-78
KS Ihy= 587 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-3-BXJJ-KGDIXS
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVgaaaaVJHRHJV3VBXJJVKGDIXSVke
rz3vnqV.kip
Jlst fb Grdnlvhe Jf`s la kgdiup sht 553
Unre Thq Jfw TDA Jfw Uloh Ahxt TDA Ahxt Uloh
---- ------- ---------- --------- ---------- ---------
7 84 ;88;752 47-MGA-78 ;88;7
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
13/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
TSBLJH Ladjuehe= Ofelbldgtlfa tloh= 47-MGA-78
TSBLJH ekVualquhVagoh= D[OT
Dfatrfj Bljh Ladjuehe= Dip TDA= 4;>3050 Dip tloh= 47-MGA-78
KT Ihy Uyph JR Tlzh Ehvldh Uyph Hjgpshe Uloh Dfopjhtlfa Uloh------- ---- -- ---------- ----------- ------------ ---------------
55; Ladr 7 ;5.;7O ELTI 33=33=33 47-MGA-78
KS Ihy= 584 Ttgtus= GRGLJGKJH Dfoprhsshe= \HT Ug`= JHRHJ-7-KGDIXS-4
Slhdh Agoh=
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV4Vkes3x
55>V.kip
Jlst fb Egtgbljhs la kgdiup sht 55;
Bljh JR Uyph Dip TDA Dip Uloh Agoh
---- -- ---- ---------- --------- ----
7 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
; 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
4 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
5 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
8 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
2 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
0 7 Ladr 4;>3055 47-MGA-78 /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
[OGA1 rhpfrt sdnhog9
[hpfrt fb egtgkgsh sdnhog bfr egtgkgsh wltn ekVualquhVagoh D[OT
Jlst fb Shrogahat Egtgbljhs
???????????????????????????
Bljh Tlzh(OK) Ugkjhspgdh [K sh`s Egtgbljh Agoh
---- -------- -------------------- ------- ------------------------
7 2>3 T\TUHO *** /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
; 853 T\TGX^ *** /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
4 720 XTH[T *** /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
8 83 D[OT *** /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
2 83 N[OT *** /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb0 83 KSOT *** /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
Jlst fb Uhopfrgry Bljhs
???????????????????????
Bljh Tlzh(OK) Ugkjhspgdh Ogxslzh(OK) Uhopbljh Agoh
---- -------- -------------------- ----------- --------------------
7 ;3 UHOS 4;020 /u3;/gpp/frgdjh/frgegtg/dros/thop37.ekb
EHJHULA@ GJJ BLJHT GU FT JHRHJ OGAXGJJ\
$ de /u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/dros/
$ ro *
$ de /u3;/gpp/frgdjh/frgegtg/dros
$ ro *
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
14/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
$ hxpfrt F[GDJHVTLE?dros
$ rjroga tgr`ht /
[hdfvhry Ogag`hr= [hjhgsh 77.;.3.7.3 - Srfeudtlfa fa Tgt Mga 47 74=7>=50 ;378
Dfpyrl`nt (d) 7;, ;334; kyths
[hef Kubbhrs 7;27
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
15/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
$ rjroga tgr`ht /
[hdfvhry Ogag`hr= [hjhgsh 77.;.3.7.3 - Srfeudtlfa fa Tgt Mga 47 74=;>=8> ;378
Dfpyrl`nt (d) 7;, ;33;>5> Mga 47 7;=;5 f7VobVaaae3VUG@;3783747U7;;447Vkeryzdt7V.kip
Gs L sgle gkfvh, tnh dfatrfjbljh & spbljh grh kgdihe up gddfrela` tf tnh kgdiup pfjldy gae `ft ga
[OGA `hahrgthe tg` (UG@;3783747U7;;447. [OGA ladjuehs tnh durrhat dfatrfj bljh gae TSBLJH la tnh
sgoh kgdiup sht gs tnh egtgbljhs. Ph dga silp rhquhsthe tg` (JHRHJ-3-BXJJ-KGDIXS).
[OGA1 rhstfrh dfatrfjbljh brfo '/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/
f7VobVadsa3VUG@;3783747U7;;447Vkerz3t3>V.kip'9
Ttgrtla` rhstfrh gt 37-BHK-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= rhstfrla` dfatrfj bljh
dngaahj F[GVELTIV7= rhstfrh dfopjhth, hjgpshe tloh= 33=33=70
futput bljh agoh?/u3;/gpp/frgdjh/frgegtg/dros/dfatrfj37.dtj
futput bljh agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/dros/dfatrfj3;.dtj
Blalsnhe rhstfrh gt 37-BHK-78
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
16/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
[OGA1 gjthr egtgkgsh ofuat9
egtgkgsh ofuathe
[OGA1 vgjlegth egtgkgsh9
Ttgrtla` vgjlegth gt 37-BHK-78
Ttgrtla` lopjldlt drfssdnhdi kgdiup gt 37-BHK-78
gjjfdgthe dngaahj= F[GVELTIV7
dngaahj F[GVELTIV7= TLE?7< ehvldh typh?ELTI
Drfssdnhdihe ; fkmhdts
Blalsnhe lopjldlt drfssdnhdi kgdiup gt 37-BHK-78
Ttgrtla` lopjldlt drfssdnhdi dfpy gt 37-BHK-78
usla` dngaahj F[GVELTIV7
Drfssdnhdihe 5 fkmhdts
Blalsnhe lopjldlt drfssdnhdi dfpy gt 37-BHK-78
shgrdnla` bfr gjj bljhs la tnh rhdfvhry grhg
dgtgjf`la` bljhs...
dgtgjf`la` efah
Jlst fb Dgtgjf`he Bljhs
???????????????????????
bljhs.txt
usla` dngaahj F[GVELTIV7
[OGA-3272
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
17/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
7 NL@N FSHA 37-BHK-78 Fah fr ofrh afa-systho egtgbljhs grh olssla`
gagjyzla` gutfogtld rhpglr fptlfas9 tnls ogy tgih sfoh tloh
usla` dngaahj F[GVELTIV7gagjyzla` gutfogtld rhpglr fptlfas dfopjhth
Ogaegtfry Ogaugj Gdtlfas
????????????????????????
af ogaugj gdtlfas gvgljgkjh
Fptlfagj Ogaugj Gdtlfas
???????????????????????
7. Lb yfu ngvh tnh dfrrhdt vhrslfa fb tnh dfatrfj bljh, tnha snutefwa tnh egtgkgsh gae rhpjgdh tnh
fje dfatrfj bljh
;. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
4. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
5. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
8. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
2. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
0. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
>. Lb bljh /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb wgs ualathatlfagjjy rhagohe fr ofvhe, rhstfrh
lt
Gutfogthe [hpglr Fptlfas
????????????????????????
Fptlfa [hpglr Ehsdrlptlfa
------ ------------------
7 Shrbfro ladfopjhth egtgkgsh rhdfvhry
Ttrgth`y= Unh rhpglr ladjuehs pflat-la-tloh rhdfvhry wltn sfoh egtg jfss
[hpglr sdrlpt= /u3;/gpp/frgdjh/elg`/rekos/dros/dros/no/rhdfV;7453
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
18/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
Ttgrtla` rhstfrh gt 37-BHK-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` egtgbljh kgdiup sht rhstfrh
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) tf rhstfrh brfo kgdiup shtdngaahj F[GVELTIV7= rhstfrla` egtgbljh 33337 tf /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
dngaahj F[GVELTIV7= rhstfrla` egtgbljh 3333; tf /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
dngaahj F[GVELTIV7= rhstfrla` egtgbljh 33334 tf /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
dngaahj F[GVELTIV7= rhstfrla` egtgbljh 33335 tf /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
dngaahj F[GVELTIV7= rhstfrla` egtgbljh 33338 tf /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
dngaahj F[GVELTIV7= rhstfrla` egtgbljh 33332 tf /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
dngaahj F[GVELTIV7= rhstfrla` egtgbljh 33330 tf /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= rhgela` brfo kgdiup plhdh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae3VUG@;3783747U7;;447Vker
yzdt7V.kip
dngaahj F[GVELTIV7= plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae3VUG@;3783747U7;;
447Vkeryzdt7V.kip tg`?UG@;3783747U7;;447
dngaahj F[GVELTIV7= rhstfrhe kgdiup plhdh 7
dngaahj F[GVELTIV7= rhstfrh dfopjhth, hjgpshe tloh= 33=32=70
Blalsnhe rhstfrh gt 37-BHK-78
Ttgrtla` rhdfvhr gt 37-BHK-78
usla` dngaahj F[GVELTIV7
dngaahj F[GVELTIV7= stgrtla` ladrhohatgj egtgbljh kgdiup sht rhstfrh
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) tf rhstfrh brfo kgdiup shtehstlagtlfa bfr rhstfrh fb egtgbljh 33337= /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 3333;= /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33334= /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33335= /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33338= /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33332= /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33330= /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= rhgela` brfo kgdiup plhdh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VVJHRHJV7VDXOXJGULRHVVk
es32;s7V.kip
dngaahj F[GVELTIV7= plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VVJHRHJV7VDXOXJG
ULRHVVkes32;s7V.kip tg`? JHRHJ-7-DXOXJGULRH-L
dngaahj F[GVELTIV7= rhstfrhe kgdiup plhdh 7
dngaahj F[GVELTIV7= rhstfrh dfopjhth, hjgpshe tloh= 33=33=34
dngaahj F[GVELTIV7= stgrtla` ladrhohatgj egtgbljh kgdiup sht rhstfrh
dngaahj F[GVELTIV7= sphdlbyla` egtgbljh(s) tf rhstfrh brfo kgdiup sht
ehstlagtlfa bfr rhstfrh fb egtgbljh 33337= /u3;/gpp/frgdjh/frgegtg/dros/systho37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 3333;= /u3;/gpp/frgdjh/frgegtg/dros/sysgux37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33334= /u3;/gpp/frgdjh/frgegtg/dros/uaeftks37.ekbehstlagtlfa bfr rhstfrh fb egtgbljh 33335= /u3;/gpp/frgdjh/frgegtg/dros/ushrs37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33338= /u3;/gpp/frgdjh/frgegtg/dros/dros37.ekb
ehstlagtlfa bfr rhstfrh fb egtgbljh 33332= /u3;/gpp/frgdjh/frgegtg/dros/nros37.ekb
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
19/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
ehstlagtlfa bfr rhstfrh fb egtgbljh 33330= /u3;/gpp/frgdjh/frgegtg/dros/kpos37.ekb
dngaahj F[GVELTIV7= rhgela` brfo kgdiup plhdh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV4Vkes3x
55>V.kip
dngaahj F[GVELTIV7= plhdh
ngaejh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/kgdiupsht/;378V37V47/f7VobVaaae7VJHRHJV7VKGDIXSV
4Vkes3x55>V.kip tg`?JHRHJ-7-KGDIXS-4
dngaahj F[GVELTIV7= rhstfrhe kgdiup plhdh 7
dngaahj F[GVELTIV7= rhstfrh dfopjhth, hjgpshe tloh= 33=33=78
stgrtla` ohelg rhdfvhry
grdnlvhe jf` bfr tnrhge 7 wltn shquhadh 85 ls gjrhgey fa elsi gs bljh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V85Vkes3`p3bV.grd
grdnlvhe jf` bfr tnrhge 7 wltn shquhadh 88 ls gjrhgey fa elsi gs bljh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V88Vkes3`xniV.grd
grdnlvhe jf` bfr tnrhge 7 wltn shquhadh 82 ls gjrhgey fa elsi gs bljh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V82Vkes3myq8V.grd
grdnlvhe jf` bfr tnrhge 7 wltn shquhadh 80 ls gjrhgey fa elsi gs bljh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V80Vkes3i>osV.grd
grdnlvhe jf` bfr tnrhge 7 wltn shquhadh 8> ls gjrhgey fa elsi gs bljh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V8>Vkes3iaboV.grd
grdnlvhe jf` bfr tnrhge 7 wltn shquhadh 8< ls gjrhgey fa elsi gs bljh
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V8
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
20/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf̀ /;378V37V47/f7VobV7V88Vkes3̀ xniV.grd
tnrhge?7 shquhadh?88
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf̀ /;378V37V47/f7VobV7V82Vkes3myq8V.grd
tnrhge?7 shquhadh?82
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf̀ /;378V37V47/f7VobV7V80Vkes3i>osV.grd
tnrhge?7 shquhadh?80
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf̀ /;378V37V47/f7VobV7V8>Vkes3iaboV.grd
tnrhge?7 shquhadh?8>
grdnlvhe jf` bljh
agoh?/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf̀ /;378V37V47/f7VobV7V8038;;;
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
21/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
Hxpjfrla` tnh Frgdjh EKG Uhdnafjf`y ky
@uagshigrga ,Unlyg`u
/u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/D[OT/grdnlvhjf`/;378V37V47/f7VobV7V28Vkes3zo4eV.grd
Ladfopjhth [hdfvhry gppjlhe uatlj dnga`h 4;>70
-
8/9/2019 LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP.pdf
22/22
JFTT FB BXJJ EGUGKGTH GAE EGUGKGTH [HDFRH[\ | F[GDJH 77 `
NFP UF BLAE EKLE 6
Tfohtlohs yfu ahhe tf THU EKLE khbfrh yfu [HTUF[H DFAU[FJBLJH khdgush Frgdjh ushs tnh EKLE tf
vhrlby lb tnh dfatrfjbljh ls bfr tnh sgoh egtgkgsh. Jht“s try nfw tf blae EKLE6
Lb tnh tgr`ht egtgkgsh kgdiup gs dfoprhsshe tnha bfjjfwla` ohtnfe AFU gkjh tf blae EKLE gae kgdiupls AFU dfoprhsshe fah, yfu dga ush tnls ohtnfe. Bljh agoh snfuje dfatgla systho egtg bljh.
$ strla`s kgdiupVplhdhVbljhVagoh | `rhp OG^RGJXH
[OGA1 jlst kgdiup suoogry9
usla` tgr`ht egtgkgsh dfatrfj bljh lasthge fb rhdfvhry dgtgjf`
Jlst fb Kgdiups
???????????????
Ihy U\ JR T Ehvldh Uyph Dfopjhtlfa Uloh #Slhdhs #Dfplhs Dfoprhsshe Ug`
------- -- -- - ----------- --------------- ------- ------- ---------- ---288 K G G ELTI 37-BHK-78 7 7 AF JHRHJ-3-BXJJ-KIS
282 K 3 G ELTI 37-BHK-78 7 7 AF UG@;3783;37U;77444
280 K 7 G ELTI 37-BHK-78 7 7 AF JHRHJ-7-KGDIXS-L
28> K G G ELTI 37-BHK-78 7 7 AF JHRHJ-3-BXJJ-KIS
28< K 7 G ELTI 37-BHK-78 7 7 AF JHRHJ-7-KGDIXS-LL
223 K 7 G ELTI 37-BHK-78 7 7 AF JHRHJ-7-KGDIXS-L
227 K 7 G ELTI 37-BHK-78 7 7 AF JHRHJ-7-KGDIXS-LL
22; K 7 G ELTI 37-BHK-78 7 7 AF JHRHJ-7-DXOXJGULRH-L
224 K 3 G ELTI 37-BHK-78 7 7 AF UG@;3783;37U;77444
225 K 7 G ELTI 37-BHK-78 7 7 AF JHRHJ-7-DXOXJGULRH-L
$ js -j /u3;/gpp/frgdjh/bjgsnVrhdfvhryVgrhg/N[OT/kgdiupsht/;378V3;V37/
tftgj 7723>>5
-rw-r----- 7 frgdjh flastgjj ;823 Bhk 7 ;7=74 f7VobVgaaaaVJHRHJV3VBXJJVKISVkewjb5atV.kip
-rw-r----- 7 frgdjh flastgjj 2282 Bhk 7 ;7=75 f7VobVgaaaaVJHRHJV3VBXJJVKISVkewj`;3aV.kip
-rw-r----- 7 frgdjh flastgjj 74>;>33;>3;>3 Bhk 7 ;7=74 f7VobVaaae3VUG@;3783;37U;77444Vkewjb227V.kip
-rw-r----- 7 frgdjh flastgjj ;3>>088; Bhk 7 ;7=;5 f7VobVaaae7VJHRHJV7VKGDIXSVLLVkewo7a03V.kip
-rw-r----- 7 frgdjh flastgjj 5852823 Bhk 7 ;7=;0 f7VobVaaae7VJHRHJV7VDXOXJGULRHVLVkewo0rwjV.kip
$ strla`s f7VobVaaae3VUG@;3783;37U;77444Vkewjb227V.kip | `rhp OG^RGJXH
..
...
YUrloohe_
OG^RGJXH, OG^RGJXH,