KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359068363' post='1303169188'] arc logs unte, danito cheyochu.. recover database using controlfile until cancel and nee arc logs okkoti ista undu.. adi recover chestadi.. [/quote] eppudu ayina chesava bhayya idi?? oka okati ante ma environment 2 hrs ki okasari arcivelog clean up untndi appudu em ayina commad undi just archivelog backup ni recover cheyadaniki?
CheGuevara Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359069045' post='1303169231'] eppudu ayina chesava bhayya idi?? oka okati ante ma environment 2 hrs ki okasari arcivelog clean up untndi appudu em ayina commad undi just archivelog backup ni recover cheyadaniki? [/quote] archive log ala ela delete chestaru without backing it up...ala cheste ante ...you cant recover database....
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CheGuevara' timestamp='1359069450' post='1303169259'] archive log ala ela delete chestaru without backing it up...ala cheste ante ...you cant recover database.... [/quote] clean up ade backup chestam ani
CheGuevara Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359069845' post='1303169283'] clean up ade backup chestam ani [/quote] simple mama backup unantha varaku restore cheyyali....inka poin in time recovery kavalante backup cheyyani archivel ogs nundi teesukovali............. archive log concept ade....so that we dont loose even small size of data
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CheGuevara' timestamp='1359070080' post='1303169311'] simple mama backup unantha varaku restore cheyyali....inka poin in time recovery kavalante backup cheyyani archivel ogs nundi teesukovali............. archive log concept ade....so that we dont loose even small size of data [/quote] ade complete recover ayindi ani ela telusundi bhayya em ayina command undha, i mean e time varaku ayindi ani??
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CheGuevara' timestamp='1359070080' post='1303169311'] simple mama backup unantha varaku restore cheyyali....inka poin in time recovery kavalante backup cheyyani archivel ogs nundi teesukovali............. archive log concept ade....so that we dont loose even small size of data [/quote] Matter enti ante cheptha vinnu bhayya,nenu oka clean recover chesi dani document cheyali so dani conditions 1)edi ayina oka table delete cheydam malli dani recover cheydam 2) leka motham database lo edo oka file ni delete chesi motham database ni recover cheydam Pyna CBZ bhayya chepinatu pakka point in recovery use cheyali,kani chesaka recover compelte ayindi ani ela chudali e time varaku ayindi ani ela chudali??
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 chesa... okasari/two times anukunta.. nenu auto pettesta.... recovering ki...
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359070557' post='1303169356'] chesa... okasari/two times anukunta.. [size=6]nenu auto pettesta[/size].... recovering ki... [/quote] endi bhayya adi document em ayina chesava ala ayinapudu??
CheGuevara Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359070360' post='1303169338'] Matter enti ante cheptha vinnu bhayya,nenu oka clean recover chesi dani document cheyali so dani conditions 1)edi ayina oka table delete cheydam malli dani recover cheydam 2) leka motham database lo edo oka file ni delete chesi motham database ni recover cheydam Pyna CBZ bhayya chepinatu pakka point in recovery use cheyali,kani chesaka recover compelte ayindi ani ela chudali e time varaku ayindi ani ela chudali?? [/quote] one way to know to which point of time it recoeverd is using the current_scn number..... select current_scn from v$database;
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CheGuevara' timestamp='1359070754' post='1303169364'] one way to know to which point of time it recoeverd is using the current_scn number..... select current_scn from v$database; [/quote] bhayya a current_scn 1 sec koni 100 change avutai ardham avale nuv scn tho ela compare chestavo? nenu a command dataguard sync lo undha ledh ani teliyataniki use chesta
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359070616' post='1303169358'] endi bhayya adi document em ayina chesava ala ayinapudu?? [/quote] ledu bhayya.. ila icha.. recover database using backup controfile until cancel; dani tarvata I typed 'auto' and hit enter.. ante, ade chesukundi.. kaani nak telisi autorecovery on lo undali DBki, or u can set it to on with this 'set autorecovery on' test DB ne ga.. try seyi
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359070921' post='1303169375'] ledu bhayya.. ila icha.. [size=6]recover database using backup controfile until cancel;[/size] dani tarvata I typed 'auto' and hit enter.. ante, ade chesukundi.. kaani nak telisi autorecovery on lo undali DBki, or u can set it to on with this 'set autorecovery on' test DB ne ga.. try seyi [/quote] a bold chesina command em chestundi bhayya daniki point of recovery ki difference enti na scenaro chusava pyna nenu oka clean recover cheyali??
peru_edaite_enti Posted January 24, 2013 Report Posted January 24, 2013 [quote name='KOTC' timestamp='1359071393' post='1303169394'] a bold chesina command em chestundi bhayya daniki point of recovery ki difference enti na scenaro chusava pyna nenu oka clean recover cheyali?? [/quote] rman to mamul restore cheste, arc logs apply avvakamundu varake kada restore chestadii... adi aiynaka idi cheste aa migilina arc logs lo unna data kuda restore chestundi @pundits correct me if i am wrong
Gachibowli_Diwakar Posted January 24, 2013 Report Posted January 24, 2013 asalu point-in-time recovery ki complete recovery ki difference telsa ? point-in-time recovery recovers your database or datafiles to a specific point of time (ante u will get to see loss of data) complete recovery ante.. u need to have online redo logs to do complete recovery select [font=monospace][size=3]CHECKPOINT_CHANGE# from v$datafile; ani type cheyi.. anni data-files same scn lo untaay.. that says ur database has recovered till some point of time[/size][/font] [font=monospace][size=3]scn to sysdate conversion untundi anukunta..google it[/size][/font]
KOTC Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='CBZ' timestamp='1359071500' post='1303169396'] rman to mamul restore cheste, arc logs apply avvakamundu varake kada restore chestadii... adi aiynaka idi cheste aa migilina arc logs lo unna data kuda restore chestundi @pundits correct me if i am wrong [/quote] so point of recovery chesaka a command evali antava anthe appudu adi migilina arch logs lo unna data kuda restore chetundi anthe na????
Recommended Posts