KOTC Posted November 2, 2012 Report Posted November 2, 2012 [b] RESTORE RMAN BACKUP FROM ONE SERVER TO ANOTHER SERVER IN 11G[/b] naku document kavali evaru ayina chesina valu unnara? inka rman restore kuda chesina valu unnara?
Joey_Tribbiani Posted November 2, 2012 Report Posted November 2, 2012 I did vayya .. konchem nee scenario cheppu .. Backup ela teeskunnav .. tape meeda naa or Media server aa .. Using catalog aa without catalog aa ?
deals2buy Posted November 2, 2012 Report Posted November 2, 2012 vaarini nuvvu last time SQL ante Oracle SQL aa vaaa? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
Joey_Tribbiani Posted November 2, 2012 Report Posted November 2, 2012 [indent=1]Set until time clause lo backup end time +1 or 2 min ivvu vay .. [/indent] [indent=1][b]connect target /[/b][/indent] [indent=1][b]connect catalog user/password[/b][/indent] [indent=1][b]run[/b][/indent] [indent=1][b]{[/b][/indent] [indent=1][b]allocate channel t1 type 'SBT_TAPE';[/b][/indent] [indent=1][b]allocate channel t2 type 'SBT_TAPE';[/b][/indent] [indent=1][b]set until time "to_date('09-22-2004 11:30:00','MM-DD-YYYY HH24:MI:SS')";[/b][/indent] [indent=1][b]restore database;[/b][/indent] [indent=1][b]}[/b][/indent]
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='Joey_Tribbiani' timestamp='1351872028' post='1302731090'] [indent=1]Set until time clause lo backup end time +1 or 2 min ivvu vay ..[/indent] [indent=1][b]connect target /[/b][/indent] [indent=1][b]connect catalog user/password[/b][/indent] [indent=1][b]run[/b][/indent] [indent=1][b]{[/b][/indent] [indent=1][b]allocate channel t1 type 'SBT_TAPE';[/b][/indent] [indent=1][b]allocate channel t2 type 'SBT_TAPE';[/b][/indent] [indent=1][b]set until time "to_date('09-22-2004 11:30:00','MM-DD-YYYY HH24:MI:SS')";[/b][/indent] [indent=1][b]restore database;[/b][/indent] [indent=1][b]}[/b][/indent] [/quote] tapes,nocatalog so pakka until time clause use cheyala??adi na question
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='deals2buy' timestamp='1351871858' post='1302731078'] vaarini nuvvu last time SQL ante Oracle SQL aa vaaa? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] [/quote] yup!
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='Joey_Tribbiani' timestamp='1351871770' post='1302731074'] I did vayya .. konchem nee scenario cheppu .. Backup ela teeskunnav .. tape meeda naa or Media server aa .. Using catalog aa without catalog aa ? [/quote] [b]RESTORE RMAN BACKUP FROM ONE SERVER TO ANOTHER SERVER IN 11G idi chesava??[/b]
Joey_Tribbiani Posted November 2, 2012 Report Posted November 2, 2012 [quote name='KOTC' timestamp='1351873224' post='1302731198'] tapes,nocatalog so pakka until time clause use cheyala??adi na question [/quote] Yes , Use cheyaali ... Catalog kaka pote Control file use chesi restore cheyali .. Still until time is required !! catalog clause teesesi try chei ..
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='Joey_Tribbiani' timestamp='1351873432' post='1302731219'] Yes , Use cheyaali ... Catalog kaka pote Control file use chesi restore cheyali .. Still until time is required !! catalog clause teesesi try chei .. [/quote] neku pm chesa chudu na doubts?
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='Joey_Tribbiani' timestamp='1351873432' post='1302731219'] Yes , Use cheyaali ... Catalog kaka pote Control file use chesi restore cheyali .. Still until time is required !! catalog clause teesesi try chei .. [/quote] malli pm chesa chudu boss
Gachibowli_Diwakar Posted November 2, 2012 Report Posted November 2, 2012 to clone the db or to clone physical standby .. on remote host .. u can use duplicate database command.. from 11g u have the ability to clone remotely
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='Silence..Please' timestamp='1351875691' post='1302731400'] to clone the db or to clone physical standby .. on remote host .. u can use duplicate database command.. from 11g u have the ability to clone remotely [/quote] Thanks bhayya. [url="http://www.dbatutor.com/2010/12/rman-restore-rman-backup-to-different.html"]http://www.dbatutor.com/2010/12/rman-restore-rman-backup-to-different.html[/url] link kuda undi kani evaru ayina chesara ani real time lo??
KOTC Posted November 2, 2012 Author Report Posted November 2, 2012 [quote name='Silence..Please' timestamp='1351875691' post='1302731400'] to clone the db or to clone physical standby .. on remote host .. u can use duplicate database command.. from 11g u have the ability to clone remotely [/quote] duplicat ela chestaru any idea?? full backup tesukoni source database nuchi host pyna catalog chesi duplicate command use cheyala?
Gachibowli_Diwakar Posted November 2, 2012 Report Posted November 2, 2012 [quote name='KOTC' timestamp='1351875933' post='1302731434'] duplicat ela chestaru any idea?? full backup tesukoni source database nuchi host pyna catalog chesi duplicate command use cheyala? [/quote] host payina catalog cheyatam enti ? catalog stores the info about your backups .. backup set disk meedha unte .. u dont need catalog .. no catalog option use cheyochu ( i may be wrong.. but give it a try.. worst case lo .. clone avvadhu anthe) yes, nuvu ye host meedha aithe db clone avvaali anukuntunnaavo .. akada rman script (like it was mentioned above ) run cheyi
Recommended Posts