Jump to content

Oracle Dba Lu Unte Oka Sari Itu Randi Vayya


Recommended Posts

Posted

[quote name='Silence..Please' timestamp='1351876261' post='1302731476']
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
[/quote]


let's say (correct me if am wrong)---disk meda anuko,nocatalog

Host A--(11G home with database)

motham database backup chesa using rman

Host B--(just same home as HOSTA)

next step pfile file from HOST A nuchi HOST B ki copy chesta chesi

RMAN> startup nomount using pfile='location';

rman> restore control file from'loaction of full backup from host A';

rman>catalog backup pieces"location of backup set from host A';

rman > restore database noredo;( kani ikkada missing archive log kavali daniki list backup of archivelog all from host A tesukoni HOst b ki copy chestha)


[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]connect target /[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]connect catalog user/password[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]run[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]{[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]allocate channel t1 type 'SBT_TAPE';[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]allocate channel t2 type 'SBT_TAPE';[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]set until time "to_date('09-22-2004 11:30:00','MM-DD-YYYY HH24:MI:SS')";[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]restore database;[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]recover database;[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]}[/b][/font][/color][/indent]

[color=#282828][font=helvetica, arial, sans-serif][indent=1]last step [/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]RMAN>alter database open restlogs;[/font][/color][/indent]

[color=#282828][font=helvetica, arial, sans-serif][indent=1]idi steps correct e na??[/font][/color][/indent]

Posted

[quote name='KOTC' timestamp='1351877693' post='1302731633']


let's say (correct me if am wrong)---disk meda anuko,nocatalog

Host A--(11G home with database)

motham database backup chesa using rman

Host B--(just same home as HOSTA)

next step pfile file from HOST A nuchi HOST B ki copy chesta chesi

RMAN> startup nomount using pfile='location';

rman> restore control file from'loaction of full backup from host A';

rman>catalog backup pieces"location of backup set from host A';

rman > restore database noredo;( kani ikkada missing archive log kavali daniki list backup of archivelog all from host A tesukoni HOst b ki copy chestha)


[indent=1][b]connect target /[/b][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][b]connect catalog user/password[/b][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]run[/b][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]{[/b][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]allocate channel t1 type 'SBT_TAPE';[/b][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]allocate channel t2 type 'SBT_TAPE';[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]set until time "to_date('09-22-2004 11:30:00','MM-DD-YYYY HH24:MI:SS')";[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]restore database;[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]recover database;[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]}[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif]last step [/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif]RMAN>alter database open restlogs;[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif]idi steps correct e na??[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]


[color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][/quote][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]
rman > restore database noredo;( kani ikkada missing archive log kavali daniki list backup of archivelog all from host A tesukoni HOst b ki copy chestha)

e step avasram ledhu anukunta ???

Posted

[quote name='KOTC' timestamp='1351877693' post='1302731633']


let's say (correct me if am wrong)---disk meda anuko,nocatalog

Host A--(11G home with database)

motham database backup chesa using rman

Host B--(just same home as HOSTA)

next step pfile file from HOST A nuchi HOST B ki copy chesta chesi

RMAN> startup nomount using pfile='location';

rman> restore control file from'loaction of full backup from host A';

rman>catalog backup pieces"location of backup set from host A';

rman > restore database noredo;( kani ikkada missing archive log kavali daniki list backup of archivelog all from host A tesukoni HOst b ki copy chestha)


[indent=1][b]connect target /[/b][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][b]connect catalog user/password[/b][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]run[/b][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]{[/b][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]allocate channel t1 type 'SBT_TAPE';[/b][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]allocate channel t2 type 'SBT_TAPE';[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]set until time "to_date('09-22-2004 11:30:00','MM-DD-YYYY HH24:MI:SS')";[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]restore database;[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]recover database;[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][b]}[/b][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif]last step [/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif]RMAN>alter database open restlogs;[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif]idi steps correct e na??[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][color=#282828][font=helvetica, arial, sans-serif][/quote][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]

if those disks are accessible on HOST B, then, Yes, above procedure should work

Posted

[quote name='KOTC' timestamp='1351877766' post='1302731644']
[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]
rman > restore database noredo;( kani ikkada missing archive log kavali daniki list backup of archivelog all from host A tesukoni HOst b ki copy chestha)

e step avasram ledhu anukunta ???
[/quote]agreed .. u need archive logs only when u r doing recovery .. so restore apudu u dont need

Posted

[quote name='KOTC' timestamp='1351877766' post='1302731644']
[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]
rman > restore database noredo;( kani ikkada missing archive log kavali daniki list backup of archivelog all from host A tesukoni HOst b ki copy chestha)

e step avasram ledhu anukunta ???
[/quote] just to make things easy .. if i were u . i would make a copy of archive logs from the time u started the backup till the time ur backup ended ..

Posted

[quote name='Silence..Please' timestamp='1351877872' post='1302731661']
[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]

if those disks are accessible on HOST B, then, Yes, above procedure should work
[/quote]
ardham kaledhu bhayya accessible ante nenu host A disks meda backup tesukoni a backup sets ni host B
ki copy chesta so host b enduku accessible ??

Posted

[quote name='Silence..Please' timestamp='1351878031' post='1302731685']
just to make things easy .. if i were u . i would make a copy of archive logs from the time u started the backup till the time ur backup ended ..
[/quote]


gotcha adi kuda catalog chesi recover cheste ok antavu anthe na??

Posted

[quote name='KOTC' timestamp='1351878038' post='1302731687']
ardham kaledhu bhayya accessible ante nenu host A disks meda backup tesukoni a backup sets ni host B
ki copy chesta so host b enduku accessible ??
[/quote] host b ki copy chesthe.. catalog enduku .. control file untundi ga .. dhaanni use chesi restore chesey

Posted

[quote name='Silence..Please' timestamp='1351878182' post='1302731711']
host b ki copy chesthe.. catalog enduku .. control file untundi ga .. dhaanni use chesi restore chesey
[/quote]


bhayya ikkade confusion enti ante

pfile copy chestam kadha host A to host B,adi use chesukoni database ni nomount start chesi rman use chesi control file backup chestam(a backup full backup from host A).travtha database ni mount chesi

ikkada catalog avasram ledhu antava direct until time clause use cheyali antav anthe na??

Posted

[quote name='KOTC' timestamp='1351878482' post='1302731753']


bhayya ikkade confusion enti ante

pfile copy chestam kadha host A to host B,adi use chesukoni database ni nomount start chesi rman use chesi control file backup chestam(a backup full backup from host A).travtha database ni mount chesi

ikkada catalog avasram ledhu antava direct until time clause use cheyali antav anthe na??
[/quote] 1st control file backup theeskovali .. then database backup theeskovali ..

Posted

[url="http://kamranagayev.com/"]http://kamranagayev.com/[/url]
search in this site u will get.

Posted

[quote name='manu1981' timestamp='1351878899' post='1302731827']
[url="http://kamranagayev.com/"]http://kamranagayev.com/[/url]
search in this site u will get.
[/quote]

Thanks !

  • 3 weeks later...
Posted

http://www.fuadarshad.com/

[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]Below are the procedures i followed to solve my rather simple problem.[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]1. Startup the auxiliary database in nomount[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]2. Restore the controlfile from the autobackup piece[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]RESTORE CONTROLFILE FROM '.... location and name of the autobackup piece ...';[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]3. Mount the database:[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]ALTER DATABASE MOUNT;[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]4. Clear the SBT related configurations, CHANNEL and DEVICE - Do a show all and make sure there are no parameters that you might have an issue with[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]See the RMAN reference guide under CONFIGURE for details on how to do this.[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]5. In SQLPLUS backup the controlfile:[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]ALTER DATABASE BACKUP CONTROLFILE TO '/location/of/backups/control.dbf';[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]6. Startup the auxiliary database in nomount[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]7. Move the controlfile autoback piece out of the backup location[/background][/size][/font][/color]
[color=#333333][font=Arial, Tahoma, Helvetica, FreeSans, sans-serif][size=3][background=rgb(254, 253, 250)]8. Run the Duplicate, which now will use the controlfile copy we created with correct RMAN configuration.[/background][/size][/font][/color]

×
×
  • Create New...