loss of full database & recovery - rman backup.pdf

Upload: grthiyagu-oracle-dba

Post on 01-Jun-2018

229 views

Category:

Documents


0 download

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,