KOTC Posted January 24, 2013 Report Posted January 24, 2013 deni amma jeevitham point recovery lekunda database ni recover cheyalema?
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 ippudu test chesa oka tablespace create chesi andulo table create chesa. travtha incremental backup tesukuna. travtha a table ni drop chesa. rman> sql 'alter database datafile 190 offline'; rman > run { restore datafile 190; recover datafile 190; sql 'alter database datafile 190 online'; } pyna process use chesa appudu velli a table restore avali kadha? avaledhu? enduku ani avaledhu nenu ekkada wrong chesanu.point of recovery use cheyakunda process undha.
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 naku telisi, Point in time recovery lekunda nuvvu recent ga delete chesina table ni recover cheyalevu.. 1. if running in arc log mode, PIT recovery avuddi, but thats not like restoring one datafile, it restores and recovers all the DBF's 2. no arc log mode aite, last tesina backup ke u can recover/restore
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359066185' post='1303168909'] naku telisi, Point in time recovery lekunda nuvvu recent ga delete chesina table ni recover cheyalevu.. 1. if running in arc log mode, PIT recovery avuddi, but thats not like restoring one datafile, it restores and recovers all the DBF's 2. no arc log mode aite, last tesina backup ke u can recover/restore [/quote] nadi archivelog plus rAC+ASM yeah ade a point of recovery kakukunda single datafile lo table ni restore cheydam le .. [url="http://www.yenlo.nl/nl/restore-datafile-using-rman-backup/"]http://www.yenlo.nl/...ng-rman-backup/[/url] pyna link chuste motham datfile ni delete chesi cheyali ani undi kani asm lo file delete avtam le bhayya
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359066547' post='1303168957'] nadi archivelog plus rAC+ASM yeah ade a point of recovery kakukunda single datafile lo table ni restore cheydam le .. [url="http://www.yenlo.nl/nl/restore-datafile-using-rman-backup/"]http://www.yenlo.nl/...ng-rman-backup/[/url] pyna link chuste motham datfile ni delete chesi cheyali ani undi kani asm lo file delete avtam le bhayya [/quote] datafile restoring ante nuvvu existing di delete cheyali kada.. leka pote it wont write anukunta ga
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 ade bhayya adi drop chesina appudu rman lo datafile number tho kadha restore avtundi nenu drop chesaka malli ela recover chesta a datafile ni?
nexus Posted January 24, 2013 Report Posted January 24, 2013 hi baa, ela unnav? oka clarification baa, asalu nuv em accomplish cheyalanukuntunnav? table restore cheyala? or are you practicing how to restore a datafile?
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='nexus' timestamp='1359067319' post='1303169072'] hi baa, ela unnav? oka clarification baa, asalu nuv em accomplish cheyalanukuntunnav? table restore cheyala? or are you practicing how to restore a datafile? [/quote] practicing bhayya,kani nenu oka restore cheyali motham database ni,kani recover successful ga ayindi ani ela telsundi so adukani nenu a table delete chesi,recover chedam ani.. but both case lo point of recovery use cheyakunda cheyacha anna di question?
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359067056' post='1303169035'] ade bhayya adi drop chesina appudu rman lo datafile number tho kadha restore avtundi nenu drop chesaka malli ela recover chesta a datafile ni? [/quote] mari ade ga purpose.. nuvu datafile egaragottesaka ne kada rman ni adugutavu, babu babu aa datafile nee backups lo nundi tesi malla pettava.. madi poindi ani
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359067496' post='1303169097'] practicing bhayya,kani nenu oka restore cheyali motham database ni,kani recover successful ga ayindi ani ela telsundi so adukani nenu a table delete chesi,recover chedam ani.. but both case lo point of recovery use cheyakunda cheyacha anna di question? [/quote] NO.. PIT cheyakunda you cannot restore to its previous state before you have deleted the table.... all you can do, is, from existing backups, you can restore to tht backup time, but not PIT
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359067518' post='1303169100'] mari ade ga purpose.. nuvu datafile egaragottesaka ne kada rman ni adugutavu, babu babu aa datafile nee backups lo nundi tesi malla pettava.. madi poindi ani [/quote] bhayya neku question ardham avatam ledhu sare a datafile ni rm command use chesi cheste ok datafile number tho restore cheyachu kani nenu drop chestuna datafile( avi rendu equal e na deleting manual inka droping datafile from sql's??)) so ala drop chesinapudu a oka datafile ni nenu ela recover cheyalii??i guess motham database ni recover cheste a datafile malli vastundi anukunta,kani ikkada malli point of recovery use cheyali appude vastundha? leka mamulu ga restore and recover ante a datafile malli radhu kadha??
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359067609' post='1303169113'] NO.. PIT cheyakunda you cannot restore to its previous state before you have deleted the table.... all you can do, is, from existing backups, you can restore to tht backup time, but not PIT [/quote] sare bhayya nuv chepinate chedam,point of recovery ante 4pm ki na database crash ayindi na dagara 12 pm ki full database backup undi so a time ki point of recovery chesta,appudu 12 - 4 changes ayina data ela recover cheyalii??
nexus Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359067817' post='1303169145'] bhayya neku question ardham avatam ledhu sare a datafile ni rm command use chesi cheste ok datafile number tho restore cheyachu kani nenu drop chestuna datafile( avi rendu equal e na deleting manual inka droping datafile from sql's??)) so ala drop chesinapudu a oka datafile ni nenu ela recover cheyalii??i guess motham database ni recover cheste a datafile malli vastundi anukunta,kani ikkada malli point of recovery use cheyali appude vastundha? leka mamulu ga restore and recover ante a datafile malli radhu kadha?? [/quote] nuv sql command use chesi drop chesthe, control file lo update avthundhi kadha aa datafile drop aipoyinattu...so unless PIT(to before dropping that datafile) recover chesthe thappa aa datafile recover kaadhu nuv rm command use chesi delete chesthe control file lo update kaadhu, so rman still assumes that datafile should exist and recovers it.
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='nexus' timestamp='1359068066' post='1303169163'] nuv sql command use chesi drop chesthe, control file lo update avthundhi kadha aa datafile drop aipoyinattu...so unless PIT(to before dropping that datafile) recover chesthe thappa aa datafile recover kaadhu nuv rm command use chesi delete chesthe control file lo update kaadhu, so rman still assumes that datafile should exist and recovers it. [/quote] oka doubt clear,mari a point of recovery gurchi chepu bhayya,pakka ga man CBZ bhayya chepinatu we can't recover a database with point of recovery aa?appudu a pont of recovery travtha data ni ela recover cheyali bhayya?
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359067974' post='1303169159'] sare bhayya nuv chepinate chedam,point of recovery ante 4pm ki na database crash ayindi na dagara 12 pm ki full database backup undi so a time ki point of recovery chesta,appudu 12 - 4 changes ayina data ela recover cheyalii?? [/quote] arc logs unte, danito cheyochu.. recover database using controlfile until cancel and nee arc logs okkoti ista undu.. adi recover chestadi..
Recommended Posts