KOTC Posted January 8, 2013 Author Report Posted January 8, 2013 Rman full backup jobs direct ga tapes ki undi control file retention emo 7 days undi.ippudu a 7 days mundu backup job current control file ela catalog cheyali? retention lo unnapudu control will know the tapes number kani retention munde aithe ela data ni tesukovali from tapes.sysadmin ki no idea
CheGuevara Posted January 8, 2013 Report Posted January 8, 2013 naaku nee requirement ardamkaledu baa....inkonchem clear ga explain cheyyagalava....
KOTC Posted January 8, 2013 Author Report Posted January 8, 2013 [quote name='CheGuevara' timestamp='1357684191' post='1303074308'] naaku nee requirement ardamkaledu baa....inkonchem clear ga explain cheyyagalava.... [/quote] sure bhayya, matter enti ante ikkada backups are directly set to tapes.so naku oka one month back backup nuchi restore cheyali adi ela? filesystem backup anuko a files ni rman use chesi catalog chesi rescover inka restore chestam. ade tape aithe ela chestam?
CheGuevara Posted January 8, 2013 Report Posted January 8, 2013 first rman nundi backups list chey with the command list backup dantlo anni details vastai tape name, backup name and the date....akkada neeku kavalisina date backup tho unde piece name untadi ...adi teesukoni aa backup ni restore chey... i hope you this is what you are looking for
CheGuevara Posted January 8, 2013 Report Posted January 8, 2013 [size=5][color=black]Use the RMAN "list backup" command, locate the backup, review the tape name in the Media section of the output. Use the RMAN "restore database preview" command to list the backups to be used for a restore then review the tape name in the Media section of the output. The "Media" section of the output will display the tape name/number. [/color][/size]
KOTC Posted January 9, 2013 Author Report Posted January 9, 2013 [quote name='CheGuevara' timestamp='1357686158' post='1303074505'] [size=5][color=black]Use the RMAN "list backup" command, locate the backup, review the tape name in the Media section of the output. Use the RMAN "restore database preview" command to list the backups to be used for a restore then review the tape name in the Media section of the output. The "Media" section of the output will display the tape name/number. [/color][/size] [/quote] ade bhayya a process ok kani for example two months old files undavu kadha.backup tapes lo velaka control file retention period tho ne kadha nuv chepina "list backup" lo unna latest backups ani vastai? let say control file rentention policy 7 days undi anukoo kani a seven days lo ok full backup undi a job fail ayindi so ippudu full database backup restore cheyali ela??
peru_edaite_enti Posted January 9, 2013 Report Posted January 9, 2013 retention policy prakaram old vi anni delete aiyipotai ga.. mari ekkada nundi testav delete aiyinavi?
KOTC Posted January 9, 2013 Author Report Posted January 9, 2013 [quote name='CBZ' timestamp='1357691307' post='1303074997'] retention policy prakaram old vi anni delete aiyipotai ga.. mari ekkada nundi testav delete aiyinavi? [/quote] a 7 days kanna mundu manam tapes lo ki full backup chestam kadha a backup ela catalog chestam ani?? ade bhayya na question kuda filesystem meda unnavi aithe catalog chesi restore chestav ade tapes lo unnavi ela chestav annadi question ? tapes lo old backup files ela catalog chestaru annadi question?
peru_edaite_enti Posted January 9, 2013 Report Posted January 9, 2013 [quote name='KOTC' timestamp='1357691808' post='1303075041'] a 7 days kanna mundu manam tapes lo ki full backup chestam kadha a backup ela catalog chestam ani?? ade bhayya na question kuda filesystem meda unnavi aithe catalog chesi restore chestav ade tapes lo unnavi ela chestav annadi question ? tapes lo old backup files ela catalog chestaru annadi question? [/quote] neeku backup piece name telusa?? if yes, this might help: [i]"There is an undocumented command that allows catalog backuppiece from tape,[/i] [i]catalog device type 'SBT_TAPE' backuppiece '<name>';[/i] [i]You need first configure an sbt_tape device and then you can execute the catalog device type sbt_tape[/i] [i]command.[/i] [i]As and example the following will catalog a backuppiece on netbackup:[/i] [i]CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'[/i] [i]PARMS 'ENV=(NB_ORA_CLASS=sv2n2admoraclelogbkup, SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.sl64';[/i] [i]catalog device type 'SBT_TAPE' backuppiece 'orig-lij1qaa3_1_1';[/i] [i]Note: This command works from 10g. The reason why it is not documented for tape is if the backupset contains more than one piece, then it will take long time to catalog backup piece. As long as there is one backuppiece per backupset, then the undocumented way should work without any issues."[/i] [color=#000000][font=tahoma, verdana, sans-serif][size=2]This solution is for netbackup when i try the following in TSM [/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]RMAN> CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2] RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE 'XXXXX';[/size][/font][/color]
KOTC Posted January 9, 2013 Author Report Posted January 9, 2013 [quote name='CBZ' timestamp='1357692114' post='1303075055'] neeku backup piece name telusa?? if yes, this might help: [i]"There is an undocumented command that allows catalog backuppiece from tape,[/i] [i]catalog device type 'SBT_TAPE' backuppiece '<name>';[/i] [i]You need first configure an sbt_tape device and then you can execute the catalog device type sbt_tape[/i] [i]command.[/i] [i]As and example the following will catalog a backuppiece on netbackup:[/i] [i]CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'[/i] [i]PARMS 'ENV=(NB_ORA_CLASS=sv2n2admoraclelogbkup, SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.sl64';[/i] [i]catalog device type 'SBT_TAPE' backuppiece 'orig-lij1qaa3_1_1';[/i] [i]Note: This command works from 10g. The reason why it is not documented for tape is if the backupset contains more than one piece, then it will take long time to catalog backup piece. As long as there is one backuppiece per backupset, then the undocumented way should work without any issues."[/i] [color=#000000][font=tahoma, verdana, sans-serif][size=2]This solution is for netbackup when i try the following in TSM [/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]RMAN> CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE 'XXXXX';[/size][/font][/color] [/quote] Thanks bhayya ade backup piece number netbackup client lo untndi anukunta kani several pieces untai kadha avani catalog cheyala a link zara pm anna ikkada anna veyi nenu two scenarios lo restore cheyali backup okati with in the rention period okati old back up use cheyi Really appreciate bhayya
KOTC Posted January 9, 2013 Author Report Posted January 9, 2013 [quote name='CBZ' timestamp='1357692114' post='1303075055'] neeku backup piece name telusa?? if yes, this might help: [i]"There is an undocumented command that allows catalog backuppiece from tape,[/i] [i]catalog device type 'SBT_TAPE' backuppiece '<name>';[/i] [i]You need first configure an sbt_tape device and then you can execute the catalog device type sbt_tape[/i] [i]command.[/i] [i]As and example the following will catalog a backuppiece on netbackup:[/i] [i]CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'[/i] [i]PARMS 'ENV=(NB_ORA_CLASS=sv2n2admoraclelogbkup, SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.sl64';[/i] [i]catalog device type 'SBT_TAPE' backuppiece 'orig-lij1qaa3_1_1';[/i] [i]Note: This command works from 10g. The reason why it is not documented for tape is if the backupset contains more than one piece, then it will take long time to catalog backup piece. As long as there is one backuppiece per backupset, then the undocumented way should work without any issues."[/i] [color=#000000][font=tahoma, verdana, sans-serif][size=2]This solution is for netbackup when i try the following in TSM [/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]RMAN> CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE 'XXXXX';[/size][/font][/color] [/quote] backup piece teliyakunda ela cheyalo teliste adi kuda chepu bhayya ikkada dengtunaru a scenario lo ela chestav e scenario o ela chestav anii
peru_edaite_enti Posted January 9, 2013 Report Posted January 9, 2013 https://forums.oracle.com/forums/thread.jspa?threadID=1067809 http://oracleprof.blogspot.com/2010/02/rman-and-sbttape-backup-pieces-how-to.html http://www.freelists.org/post/oracle-l/Catalog-RMAN-backups-on-Tape,18 https://www.google.com/search?q=how+to+catalog+backup+piece+on+tape+with+rman&oq=how+to+catalog+backup+piece+on+tape+with+rman&sugexp=chrome,mod=8&sourceid=chrome&ie=UTF-8 atb ... work aite document cheyi... naku kuda pampuduvu gani.. naku aite a scenario rale... ipaptivaraki
Recommended Posts