subbayya Posted May 15, 2013 Report Posted May 15, 2013 Guys, I have one doubt... Do we need archive logs to restore database to very older point? Scenario is: I need to restore my database to Nov 29th 2012, I have Nov 29th 2012 backup piece. is it possible?
KOTC Posted May 15, 2013 Author Report Posted May 15, 2013 [font=arial,helvetica,sans-serif][quote name='grandfather' timestamp='1368654367' post='1303755889'] Guys, I have one doubt... Do we need archive logs to restore database to very older point? Scenario is: I need to restore my database to Nov 29th 2012, I have Nov 29th 2012 backup piece. is it possible? [/quote][/font] [font=arial, helvetica, sans-serif]it all depends on what type of backups your are running level 0 or level 1 or full database backups[/font] [font=arial, helvetica, sans-serif]backups are going to tapes or disks,what is the retention policy ?[/font] [font="arial, helvetica, sans-serif"]if the backups are too old and they are on the disks you can restore them by cataloging the backup pieces.you can do a restore [/font][font=arial, helvetica, sans-serif]if the backup's are level 0.[/font] [font=arial,helvetica,sans-serif]If you had level 0 and level 1,to the day and time to restore the database, you are good to restore.If you have full database backup and any of the archive log is missing you can't restore the database. to check the level 0,level 1 or F RMAN> list backup of database summary;[/font] [font=arial,helvetica,sans-serif]list backup of database device type 'sbt_tape' completed between "to_date('2003 mar 21 11:00','yyyy mon dd hh24:mi')" and "to_date('2003 may 25 18:00','yyyy mon dd hh24:mi')";[/font] [font=arial,helvetica,sans-serif]LIST backup of database device type 'sbt_tape' completed after "to_date('03/21/2013','mm/dd/yyyy')";[/font] [font=arial,helvetica,sans-serif][size=3][background=rgb(250, 250, 250)] run {[/background] [background=rgb(250, 250, 250)]2> restore database preview;[/background] [background=rgb(250, 250, 250)]3> }[/background][/size][/font] [color=#ff0000][font=arial, helvetica, sans-serif][size=4][background=rgb(250, 250, 250)] set echo on[/background] [background=rgb(250, 250, 250)]spool log to prev.out[/background] [background=rgb(250, 250, 250)]run[/background] [background=rgb(250, 250, 250)]{[/background] [background=rgb(250, 250, 250)]set until time "to_date('Nov 29 2012 23:00:00', 'Mon dd yyyy HH24:MI:SS')";[/background] [background=rgb(250, 250, 250)]restore database preview;[/background] [background=rgb(250, 250, 250)]}[/background] [background=rgb(250, 250, 250)]spool log off[/background][/size][/font][/color] [font=arial, helvetica, sans-serif][background=rgb(250, 250, 250)]i don't think you can use the above command because retention period will be more 3 months but still depends on your management.[/background][/font]
KOTC Posted May 15, 2013 Author Report Posted May 15, 2013 [quote name='grandfather' timestamp='1368654367' post='1303755889'] Guys, I have one doubt... Do we need archive logs to restore database to very older point? Scenario is: I need to restore my database to Nov 29th 2012, I have Nov 29th 2012 backup piece. is it possible? [/quote] plan properly before you do a restore,it's very important. find out what type of a database it is level 0 or level 1 or Full,then verify the backup piece whether it can be used to restore the database.
subbayya Posted May 15, 2013 Report Posted May 15, 2013 [quote name='STFU' timestamp='1368656324' post='1303756057'] plan properly before you do a restore,it's very important. find out what type of a database it is level 0 or level 1 or Full,then verify the backup piece whether it can be used to restore the database. [/quote] It's level 0 backup dude. I'm facing space issue. Actual issue enti ante: schema lo oka table lo 1 year worth data vundali...but schema owner teliyaka oka purge job pettadu to keep only 180 days old data ani.... but monna vadiki year old data kavali ani edchadu kasepu....apudu ma old tapes anni review chesthe Nov 29th level 0 backup dorikindi.... danini edanna vere server meeda restore cheyyali...aa backup Nov 29th di kabatti aa table lo inko 6 months old data vuntadi....so present date ki 1 year worth data avuthadi....ee backup ni vere server meeda ki restore chesi aa table datani original server ki load cheddam ani plan.... idi plan...inka emanna alternative way vunte suggest me.
KOTC Posted May 15, 2013 Author Report Posted May 15, 2013 [quote name='grandfather' timestamp='1368660638' post='1303756408'] It's level 0 backup dude. I'm facing space issue. Actual issue enti ante: schema lo oka table lo 1 year worth data vundali...but schema owner teliyaka oka purge job pettadu to keep only 180 days old data ani.... but monna vadiki year old data kavali ani edchadu kasepu....apudu ma old tapes anni review chesthe Nov 29th level 0 backup dorikindi.... danini edanna vere server meeda restore cheyyali...aa backup Nov 29th di kabatti aa table lo inko 6 months old data vuntadi....so present date ki 1 year worth data avuthadi....ee backup ni vere server meeda ki restore chesi aa table datani original server ki load cheddam ani plan.... idi plan...inka emanna alternative way vunte suggest me. [/quote] datapumps em ayina unnai nov 29th vi? Db version enti? Os ? [right]http://www.dbatutor.com/2010/12/rman-restore-rman-backup-to-different.html[/right] http://oracledbahub.com/2012/04/restore-rman-backup-from-one-server-to-another-server-in-10g/
victor_raja Posted May 16, 2013 Report Posted May 16, 2013 [img]http://www.brahmanandamgifs.com/Images/GIFs/Bhayam/23.gif[/img]
victor_raja Posted May 16, 2013 Report Posted May 16, 2013 [quote name='grandfather' timestamp='1368654367' post='1303755889'] Guys, I have one doubt... Do we need archive logs to restore database to very older point? Scenario is: I need to restore my database to Nov 29th 2012, I have Nov 29th 2012 backup piece. is it possible? [/quote] [img]http://www.brahmanandamgifs.com/Images/GIFs/Bhayam/23.gif[/img]
subbayya Posted May 16, 2013 Report Posted May 16, 2013 [quote name='STFU' timestamp='1368661988' post='1303756492'] datapumps em ayina unnai nov 29th vi? Db version enti? Os ? [right][url="http://www.dbatutor.com/2010/12/rman-restore-rman-backup-to-different.html"]http://www.dbatutor....-different.html[/url][/right] [url="http://oracledbahub.com/2012/04/restore-rman-backup-from-one-server-to-another-server-in-10g/"]http://oracledbahub....-server-in-10g/[/url] [/quote] no data pumps... it's 9i R2.
peru_edaite_enti Posted May 16, 2013 Report Posted May 16, 2013 [quote name='grandfather' timestamp='1368660638' post='1303756408'] It's level 0 backup dude. I'm facing space issue. Actual issue enti ante: schema lo oka table lo 1 year worth data vundali...but schema owner teliyaka oka purge job pettadu to keep only 180 days old data ani.... but monna vadiki year old data kavali ani edchadu kasepu....apudu ma old tapes anni review chesthe Nov 29th level 0 backup dorikindi.... danini edanna vere server meeda restore cheyyali...aa backup Nov 29th di kabatti aa table lo inko 6 months old data vuntadi....so present date ki 1 year worth data avuthadi....ee backup ni vere server meeda ki restore chesi aa table datani original server ki load cheddam ani plan.... idi plan...inka emanna alternative way vunte suggest me. [/quote] Its the best way to do.. go ahead.. tapes lone na unnai backups? if so, then ee server meda space lekapote, vere server meda duplicate until peti cheseyi..tarvata data ni main ki tesuko..
KOTC Posted May 16, 2013 Author Report Posted May 16, 2013 [quote name='CBZ' timestamp='1368725270' post='1303759896'] Its the best way to do.. go ahead.. tapes lone na unnai backups? if so, then ee server meda space lekapote, vere server meda duplicate until peti cheseyi..tarvata data ni main ki tesuko.. [/quote] duplicate until evvacha retention policy em petina adi like 6 months back backup anta.ippudu anthani retention policy 90 days pedite ??
peru_edaite_enti Posted May 16, 2013 Report Posted May 16, 2013 [quote name='STFU' timestamp='1368727835' post='1303760245'] duplicate until evvacha retention policy em petina adi like 6 months back backup anta.ippudu anthani retention policy 90 days pedite ?? [/quote] backup pieces kanipistunai ani anadu ga catalog lo.. avi kanapadutunte inkemi tala noppi.. direst ga set until time aa backup piece ki ettesi duplicate seseyatame..
victor_raja Posted May 16, 2013 Report Posted May 16, 2013 [img]http://i1354.photobucket.com/albums/q681/mutamesthri/DR3_zpsec865334.gif[/img][img]http://i1354.photobucket.com/albums/q681/mutamesthri/DR3_zpsec865334.gif[/img]
subbayya Posted May 17, 2013 Report Posted May 17, 2013 Mama...data guard, RAC training manchi real time scenarios tho teach/training iche vallu vunte cheppandi plz.
KOTC Posted May 21, 2013 Author Report Posted May 21, 2013 [quote name='CBZ' timestamp='1367349078' post='1303687202'] yep... nen eveninng maa SME gani folder lo etiki chepta ... [/quote] @CBZ command edi ??
Recommended Posts