Thisdocoutlinesthestepstobefollowedtocreateasnapshotstandbywhichcanbeusedas
apartofDRDrillwithouttheneedofrecreatingthephysicalstandbyagain.
SnapshotstandbyletsyouopentheDRDbforreadwriteandlateronconvertitbackto
physicalstandby.
Stepstobefollowedarementionedbelow:
DISCONNECTALLPOSSIBLECONNECTIVITYBETWEENPRODANDDR
1. RemoveTNSentryofDRonPRODandtnsentryofPRODonDR.
2. Removeetc/hostconnectivity
Ensuretheyareunabletodotnspingtoeachother
Toconvertphysicalstandbytosnapshotstandby:
altersystemsetdb_recovery_file_dest='/DR_data/STDBY/flashbacklogs'scope=spfile
altersystemsetdb_recovery_file_dest_size=200GSCOPE=spfile
ALTERDATABASERECOVERMANAGEDSTANDBYDATABASECANCEL
SELECTflashback_onFROMv$database
ALTERDATABASECONVERTTOSNAPSHOTSTANDBYthiswilltakearound5mins
ALTERDATABASEOPEN
SELECTflashback_onFROMv$database
SQL>alterusersystemidentifiedbyDRSystem#1234
SQL>alterusersysidentifiedbyDRSystem#1234
*********************************************************************************************************
RunnodeclearonDRDBbeforemovingahead.
connecttoappsusingprodappspassword:
BELOWSTEPISVERYIMPORTANT
SQL>EXECFND_CONC_CLONE.SETUP_CLEAN
PL/SQLproceduresuccessfullycompleted.
SQL>commit
Commitcomplete.
SQL>selectnode_namefromapps.fnd_nodes
norowsselected
iftheoutputgivesanyrows.
STOP.
*************************************************
Thenbringdownthedatabaseandtakeabackupofthepfileandthecontrolfilesalongwith
listnerandtnsnames.orabecuasewhenyouwillrunadcfgclone.plitwilloverwritethis.
EnsureyougivetheportnumbersameasyouhadgivenduringthetimeofinitiallyDR
configurationasitwillhamperyourconfigonPRODforDRlateron.
thenrunadcfgclone.plonthedbtiergivesameportasgivenduringcreation,whichas
1527.[portpool6]
SQL>selectnode_namefromapps.fnd_nodes
NODE_NAME
SFITOLDDB01
Ensureithasonlyoneentryasofnow.Only1whichisofthedbhost!
verifytheparametersec_case_sensitive_logonandiftrue,setthistofalseelseyourapps
passwordwillnotbevalidanditwilllocktheusercausingappsautoconfigtofail.
verifyallthelogfiles
Therunadcfgclone.plontheappstier.
<HereverifyneithertheDBxmlnortheapplicationxmlhasanyinformationpointingto
thePRODDB.Becauseyouvealreadyrunadcfgcloneandtheyarenewlycreatedfrom
theDRsitedetails.>
Postthat,beforestartingtheapp,startonlyadoacorectlandthenloginintoapps,open
formsandreducethenumberofmanagersspeciallyOPPalsochangethesitenameand
color.
Tochangesitenamefrombackend:
updateapps.FND_PROFILE_OPTION_VALUESsetprofile_option_value='DR_clone_<date>'
whereprofile_option_id=125
selectprofile_option_valuefromapps.FND_PROFILE_OPTION_VALUESwhere
profile_option_id=125
*******************************************************************************************************
Profileoption:%java%andchangetored
changesysadminpassword
FNDCPASSapps/<appspwd>0Ysystem/DRSystem#1234USERsysadmin
1amDrTest
ChangeAppspassword
FNDCPASSapps/<appspwd>0Ysystem/DRSystem#1234SYSTEMAPPLSYS
DrTest#123
runautoconfigonbothnodesstartingwithDBnodeandthenappnodegivingnewapps
passwordandensureitcompletessuccessfully!
*******************************************************************************************************
Postthatstarttheconcurrentmanagerservicesandthenandverifytheapplicationand
proceedwithyourDRDRILL.
********************************************************************************************************
Toconvertbacktohowitwasbefore:
Stoptheapplication
RemoveapplicationfromDRsiteasithasbeenalteredtoagreatextentandnowneedstobe
resyncedfromthePROD
Stopthedatabaseandstartupinmountstate:
startupmount
alterdatabaseconverttophysicalstandby
<hereitwillapplytheflashbacklogsgeneratedandbringthesystembacktothestate
beforethedrconversion>
Logwillbeasbelow:
**********************************************************************************************************
****
FlashbackRestoreComplete
Dropguaranteedrestorepoint
StoppingbackgroundprocessRVWR
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn0x5qjo_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn0x5zs4_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1gdjvx_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1j20s8_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1jf1qq_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1jk4sk_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1jm8pv_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1jybh3_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn1lxq33_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn226xd4_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn27gqp7_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn27s4n2_.flb
ThuApr3018:05:332015
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn283bjn_.flb
DeletedOraclemanagedfile/DR_data/STDBY/flashbacklogs/STDBY/flashback/o1_mf_bn28ds8g_.flb
******
*********
Guaranteedrestorepointdropped
ClearingstandbyactivationID290131679(0x114b0edf)
Theprimarydatabasecontrolfilewascreatedusingthe
'MAXLOGFILES32'clause.
Thereisspaceforupto24standbyredologfiles
UsethefollowingSQLcommandsonthestandbydatabasetocreate
standbyredologfilesthatmatchtheprimarydatabase:
ALTERDATABASEADDSTANDBYLOGFILE'srl1.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl2.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl3.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl4.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl5.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl6.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl7.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl8.f'SIZE1073741824
ALTERDATABASEADDSTANDBYLOGFILE'srl9.f'SIZE1073741824
Shuttingdownarchiveprocesses
Archivingisdisabled
ThuApr3018:05:472015
ARCHshuttingdown
ARC0:Archivalstopped
Completed:alterdatabaseconverttophysicalstandby
************************************************************************************************
Thenshutdowntheinstanceandstartupmountagain:
shutimmediate
startupmount
AtthismomenttheDRisbackontrack,howeveritnowhastobebroughtinsyncwiththe
PRODandcoverthearchiveloggap.Stepsbelow:
ReplacetheoldlistenerandTNSwhichwerebackedupwiththeexistingone
EnablethehostentriesonbothPRODandDRsothatnowtheycantnspingeachotherand
starttheMRPprocess.
recovermanagedstandbydatabasedisconnectfromsession
selectsequence#,process,statusfromv$managed_standbytoseethestatus
Ifthereisanissueandnoneoftheprocessisstarting,thenverifythealertlogonPROD.
************************EndofDocument************************
