Friday, October 21, 2011

How to move Standby Database to a new server

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    How to move Standby Database to a new server


1. Prepare the new host with fresh rdbms installation same operating system and database patch level
Make sure you handle and files outside ORACLE_HOME (/var/opt/oracle/oratab)

2. Make sure you create necessary directory structure and the listener.ora & tnsnames.ora
( Listener.ora should have the new servername and IP address.)

3. Defer the redo transport from primary

alter system set log_archive_dest_state=defer scope=both sid='*';

4. Shutdown the standby

alter database recover managed standby database cancel;
shu immediate

5. Copy standby database files (data,ctrl,online log,spfile) to new host

6. Make sure we able to connect to new host using tns alias from the primary after modifying the prod tnsnames to reflect the new configuration

7. Bring up the standby
startup mount
alter database recover managed standby database disconnect;



8. Resume redo transport from primary

alter system set log_archive_dest_state=enable scope=both sid='*';




Get Oracle Certifications for all Exams
Free Online Exams.com

175 comments:

Anonymous said...

buy tramadol tramadol for dogs no prescription - long does 100mg tramadol last

Anonymous said...

tramadol 50mg tramadol 50 mg order online - celebrity tramadol addiction

Anonymous said...

buy tramadol online no prescription cod can you buy tramadol over the counter - cheap tramadol without prescriptions

Anonymous said...

buy tramadol tramadol hcl 50 mg addiction - buy tramadol for dogs online

Anonymous said...

tramadol online tramadol 100mg for sale - tramadol 50 mg and alcohol

Anonymous said...

buy clonazepam klonopin side effects long term usage - klonopin dosage maximum daily

Anonymous said...

tramadol cheap where to buy tramadol cod - tramadol hcl breastfeeding

Anonymous said...

tramadol online tramadol 50mg buzz - tramadol hcl half life

Anonymous said...

buy klonopin online cheap companies make generic klonopin - klonopin withdrawal death

Anonymous said...

buy ativan side effects generic ativan - ativan overdose mg amount

Anonymous said...

cheap tramadol tramadol no prescription usa - buy tramadol 50mg usa

Anonymous said...

order ambien online buying ambien online safe - ambien urinalysis drug test

Anonymous said...

generic ambien get ambien online - ambien cr recreational use

Anonymous said...

purchase ativan ativan lethal dose - ativan to buy uk

Anonymous said...

tramadol 100mg tramadol apap high - how get high tramadol

Anonymous said...

buy tramadol overnight cod tramadol narcotic high - buy 180 tramadol online

Anonymous said...

legal buy tramadol online buy tramadol with mastercard - buy tramadol prescription

Anonymous said...

buy ambien online overnight delivery cheap ambien light meter - buy ambien pills online

Anonymous said...

buy klonopin online buy klonopin online mastercard - interactions between klonopin and alcohol

Anonymous said...

soma online generic soma mg - order soma usa

Anonymous said...

buy tramadol online tramadol online australia - legal buy tramadol mexico

Anonymous said...

tramadol online tramadol overdose emedicine - tramadol for dogs itching

Anonymous said...

tramadol online buy tramadol online no prescription cod - tramadol online missouri

Anonymous said...

buy ambien online generic ambien walmart - ambien cr side effects nightmares

Anonymous said...

buy klonopin online cheap long klonopin high - klonopin m 751

Anonymous said...

tramadol online tramadol hcl sleep aid - buy tramadol online by cod

Anonymous said...

buy soma 350mg soma online us pharmacy - soma 2011 results

Anonymous said...

buy tramadol 100mg ultram 50 mg tablet - tramadol 50mg overnight

Anonymous said...

cheap generic soma buy soma online usa - soma san diego map

Anonymous said...

tramadol online buy tramadol online free shipping - illegal to buy tramadol online

Anonymous said...

klonopin no prescription buy clonazepam europe - xanax klonopin erowid

Anonymous said...

buy tramadol cheap order tramadol online sweden - tramadol for dogs with liver disease

Anonymous said...

buy tramadol cheap buy tramadol australia online - buy tramadol hydrochloride online uk

Anonymous said...

ambien online ambien buy canada - ambien online no prescription canada

Anonymous said...

buy lorazepam side effects not taking ativan - ativan overdose complications

Anonymous said...

generic ambien ambien side effects sleep eating - buy ambien from india

Anonymous said...

soma online difference between soma generic - soma carisoprodol no prescription

Anonymous said...

cheap ambien no prescription 25 mg ambien high - do employers drug test ambien

Anonymous said...

buy klonopin online 2mg klonopin first time - klonopin side effects tongue

Anonymous said...

soma online soma medication generic - soma recreational drug use

Anonymous said...

tramadol 50mg tramadol veterinary dose - tramadol for back pain

Anonymous said...

klonopin price snort klonopin erowid - klonopin withdrawal help

Anonymous said...

legal buy tramadol online tramadol 319 high - safe take 2 50mg tramadol

Anonymous said...

buy ambien online overnight ambien generic 10 mg tablet picture - ambien no prescription

Anonymous said...

generic ambien ambien with alcohol side effects - what is ambien 10mg used for

Anonymous said...

buy viagra online buy viagra by paypal - cheap viagra jelly uk

Anonymous said...

buy tramadol online buy tramadol in canada - tramadol 377 high

Anonymous said...

generic zolpidem ambien side effects libido - dosage does ambien come

Anonymous said...

buy viagra sample cheap viagra jelly uk - viagra dosage vs cialis dosage

Anonymous said...

buy tramadol cod online buy ultram online cheap - tramadol dosage humans weight

Anonymous said...

buy tramadol online tramadol dosage chihuahua - tramadol 377 dosage

Anonymous said...

generic ambien generic ambien kmart - ambien cr cost

Anonymous said...

buy viagra houston viagra online indian pharmacy - generic viagra online 50mg

Anonymous said...

buy viagra las vegas generic viagra in canada is it legal - how to buy viagra in usa

Anonymous said...

order klonopin online klonopin euphoria dose - klonopin xr

Anonymous said...

buy ambien online no prescription ambien cr is it addictive - buy herbal ambien

Anonymous said...

buy cheap viagra safe buy generic viagra online - viagra user reviews

Anonymous said...

buy viagra online reviews buy viagra johannesburg - buy viagra super force

Anonymous said...

buy tramadol online no prescription tramadol online saturday delivery - buy tramadol australia

Anonymous said...

klonopin cost klonopin wafers 2mg - klonopin side effects leukopenia

Anonymous said...

how to order viagra viagra me buy online - best place buy viagra online uk

Anonymous said...

buy viagra online next day delivery cheap generic viagra online pharmacy - does viagra work yahoo answers

Anonymous said...

buy viagra online usa safe way buy viagra online - legal purchase viagra online

Anonymous said...

buy viagra generic viagra online pharmacy - buy viagra online low price

Anonymous said...

purchase cialis cialis and blood pressure - cialis 20mg online kaufen

Anonymous said...

buy viagra online legally is the viagra you buy online real - purchase viagra using paypal

Anonymous said...

somas online soma buy online no prescription - soma online no prescription overnight

Anonymous said...

where to order viagra online cheap generic viagra 100mg - common viagra dosage

Anonymous said...

cialis online how to buy cialis online forum - cheap cialis usa

Anonymous said...

soma pills cheap soma overnight - soma 1 2 ironman

Anonymous said...

generic cialis online order cialis phone - cialis daily or as needed

Anonymous said...

sildenafil tablets viagra online canadian pharmacy no prescription - can i legally buy viagra online

Anonymous said...

buy discount tramadol tramadol hydrochloride overdose - next day tramadol review

Anonymous said...

buy tramadol online buy tramadol us pharmacy - tramadol for dogs dose rate

Anonymous said...

is it safe to order viagra online viagra buy online india - cheap viagra online 100mg

Anonymous said...

buy cialis with paypal cialis online apotheke - cialis online+truffa

Anonymous said...

buy generic viagra cheap viagra by mail - viagra purchase online canada

Anonymous said...

order viagra now viagra online generic - men's health viagra online

Anonymous said...

order viagra online without a prescription buy viagra 100mg online uk - viagra online huhosp

Anonymous said...

buy cialis buy cialis in china - cialis 100mg. online

Anonymous said...

purchase tramadol tramadol dosage usa - tramadol 50mg tablets high

Anonymous said...

buy propecia online how much does propecia cost at costco - generic propecia the same

Anonymous said...

cialis online cialis trial - buy cialis uk no prescription

Anonymous said...

buy viagra cheap viagra gel - can i purchase viagra online

Anonymous said...

cheap tramadol no prescription order tramadol cod - tramadol withdrawal body aches

Anonymous said...

buy tramadol online buy cheap tramadol online cod - tramadol hcl

Anonymous said...

buy viagra viagra online without prescription+25 mg - cheap viagra online australia

Anonymous said...

buy tramadol online with mastercard tramadol for dogs high - where to order tramadol online

Anonymous said...

cheap viagra 100mg buy viagra online to canada - viagra for women jimmy kimmel

Anonymous said...

buy propecia online generic brand of propecia - generic equivalent propecia

Anonymous said...

buy tramadol overnight tramadol xr dosage - tramadol addiction treatment program

Anonymous said...

buy tramadol online mexican tramadol 100mg - tramadol for dogs addictive

Anonymous said...

where to buy retin-a online retin a cream amazon - is retin-a cream or gel better

Anonymous said...

buy tramadol reliable online pharmacy tramadol - tramadol hcl and alcohol

Anonymous said...

finasteride without prescription propecia ingredients - propecia results one month

Anonymous said...

buy tramadol uk tramadol withdrawal heart palpitations - tramadol withdrawal in a neonate

Anonymous said...

discount propecia what's cost propecia - where can i buy generic propecia in the united states

Anonymous said...

buy tramadol cash on delivery buy tramadol online with paypal - buy generic tramadol online

Anonymous said...

tramadol overnight shipping tramadol hcl addiction - generic tramadol no prescription overnight

Anonymous said...

buy tramadol tramadol constipation - tramadol repeat order

Anonymous said...

buy retin-a online buy retin a from usa - retin a micro how long to see results

Anonymous said...

buy tramadol tramadol hydrochloride 50mg used - buy tramadol with cod

Anonymous said...

buy finasteride online is the generic propecia as effective - buy generic propecia uk

Anonymous said...

tramadol 50mg order tramadol no prescription overnight - tramadol for dogs uses

Anonymous said...

buy tramadol tramadol 50mg biogaran - tramadol dosage daily

Anonymous said...

order tramadol overnight buy tramadol online legally - tramadol addiction how long

Anonymous said...

buy tramadol with mastercard buy tramadol for dogs - tramadol hcl 319

Anonymous said...

buy tramadol what's the tramadol high like - tramadol 50 mg info

Anonymous said...

retin a online pharmacy retin a micro ingredient list - retin a micro .4

Anonymous said...

order tramadol online mastercard cheap tramadol free shipping - buy tramadol no prescription needed

Anonymous said...

buy tramadol online tramadol 37.5 high - get tramadol online no prescription

Anonymous said...

finasteride without prescription does generic propecia exist - can i buy propecia in mexico

Anonymous said...

buy tramadol uk xymel 50mg tramadol hydrochloride - tramadol dosage feline

Anonymous said...

order strattera online strattera amphetamine drug test - strattera drug cost

Anonymous said...

buy retin-a buy retin a online in australia - retin a cream dry skin

Anonymous said...

generic tramadol buy tramadol online illegal - tramadol hcl acetaminophen par

Anonymous said...

buy propecia online propecia side effects on sperm - cheap propecia london

Anonymous said...

tramadol online tramadol liver - buy tramadol cheap online no prescription

Anonymous said...

buy tramadol buy brand name ultram - tramadol online cod overnight

Anonymous said...

tramadol 50 mg tramadol hcl prescribed - tramadol for dogs after surgery

Anonymous said...

cheap viagra does viagra work better on an empty stomach - viagra buy pakistan

Anonymous said...

buy cialis cheap daily use cialis reviews - how quickly does cialis daily work

Anonymous said...

order tramadol online tramadol 37.5-325 - tramadol 50 mg and alcohol

Anonymous said...

cheap viagra cheap viagra online prescription - generic viagra online fast delivery

Anonymous said...

buy cialis generic cialis 40 mg - cheap cialis in uk

Anonymous said...

buy cialis buy real cialis online - cialis online in usa

Anonymous said...

cheap viagra cheap viagra online pharmacy prescription - cheap viagra 50mg

Anonymous said...

buy tramadol tramadol hcl 150 mg - tramadol cost

Anonymous said...

generic viagra viagra online trusted - order viagra online australia

Anonymous said...

buy tramadol online tramadol high triglycerides - usual dosage tramadol

Anonymous said...

buy tramadol buy tramadol no prescription cod - buy tramadol legit

Anonymous said...

buy tramadol 300 mg tramadol high - order tramadol online international

Anonymous said...

buy cialis cheap cialis super active - can you buy cialis online with no prescription

Anonymous said...

generic cialis cialis daily tolerance - cialis online canada

Anonymous said...

buy cialis cheap cialis from india - adcirca vs cialis price

Anonymous said...

cialis online no prescription cialis online with paypal - buy cialis online no rx

Anonymous said...

generic cialis order cialis over internet - cialis rash

Anonymous said...

buy tadalafil online cialis coupon offer - cialis testimonials

Anonymous said...

buy somas online soma drug breastfeeding - soma the muscle relaxer

Anonymous said...

viagra online viagra - generic viagra 50mg

Anonymous said...

tadalafil no prescription cialis 40 mg reviews - buy cialis 10mg online

Anonymous said...

buy cialis cialis daily or as needed - cialis prescription

Anonymous said...

buy cialis buy cialis no prescription india - cialis price canadian pharmacy

Anonymous said...

buy tramadol online tramadol experiences - buy tramadol hydrochloride 50mg

Anonymous said...

viagra online order generic viagra forum - purchase viagra 100mg

Anonymous said...

viagra online viagra and blood pressure - viagra online canadian pharmacy no prescription

Anonymous said...

buy cialis cialis online yahoo - how buy cialis online

Anonymous said...

soma online soma medication buy online - buy cheap soma no prescription

Anonymous said...

buy soma soma san diego hotels - how to order soma online

Anonymous said...

soma pills soma wiki - soma intimates online store

Anonymous said...

buy soma soma bras promotion code - soma uses

Anonymous said...

soma drug soma online overnight delivery - soma bra reviews

Anonymous said...

buy soma soma pills description - buy soma no prescription overnight

Anonymous said...

soma drug discount furniture soma - soma condos for sale san francisco

Anonymous said...

order soma online generic soma good - soma 350

Anonymous said...

generic tadalafil cheap cialis in nz - cialis online pharmacy us

Anonymous said...

buy soma generic soma cheap - cheap soma no prescription

Anonymous said...

retin a buy retin a gel para que sirve - retin a micro gel ingredients

Anonymous said...

buy tramadol online no prescription cheap tramadol 50 mg buy uk - is it legal to purchase tramadol online

Anonymous said...

buy tramadol medication tramadol hcl blood thinner - tramadol hcl online

Anonymous said...

buy tramadol online buy tramadol online next day delivery - tramadol online no prescription needed

Anonymous said...

buy retin a cream retin-a micro gel benefits - retin a micro for acne scars

Anonymous said...

buy tramadol dose of tramadol - buy tramadol in uk no prescription

Anonymous said...

buy retin a retin a micro effectiveness - retin a micro and benzoyl peroxide

Anonymous said...

buy retin-a online safe buy retin online - buy retin a micro generic

Anonymous said...

cheap tramadol inurl forum buy cheap tramadol - tramadol hcl mechanism of action

Anonymous said...

buy tramadol cod order tramadol with no prescription - buy tramadol tennessee

Anonymous said...

tramadol 50 mg what is tramadol 100mg - buy tramadol online no prescription mastercard

Anonymous said...

order tramadol online cod tramadol hcl 50 mg does get you high - where to buy tramadol online legal

Anonymous said...

cheap tramadol buy tramadol online for saturday delivery - buy tramadol with paypal

Anonymous said...

tramadol overnight shipping buy tramadol 50mg net - day 5 tramadol withdrawal

Anonymous said...

cheap tramadol buy generic tramadol online - get cheap tramadol

Anonymous said...

order tramadol online mastercard tramadol high cholesterol - tramadol vs hydrocodone

Anonymous said...

buy tramadol online buy tramadol online no rx - where can i buy tramadol online usa

Anonymous said...

buy tramadol 180 how much tramadol dosage - tramadol dosage cats