Oracle英文版培训课件之Data Guard Administration：L02-Architecture

UnderstandingtheOracle

DataGuardArchitectureObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:DescribetheDataGuardarchitectureExplaintheoperationalrequirementsofDataGuardDescribehowDataGuardprocesses,transports,andappliesredologsDescribestandbydatabasemodesDataGuardOperationalRequirements:HardwareandOperatingSystemThehardwarecanbedifferentfortheprimaryandstandbydatabases.Theoperatingsystemandplatformarchitecturefortheprimaryandstandbydatabasesmustbethesame.Theoperatingsystemreleasesfortheprimaryandstandbydatabasescanbedifferent.Ifalldatabasesareonthesamesystem,verifythattheOSallowsyoutomountmorethanonedatabasewiththesamename.DataGuardOperationalRequirements:OracleDatabaseSoftwareSamereleaseofOracleDatabaseEnterpriseEditionmustbeinstalledforalldatabases.SYSDBAprivilegesarerequiredfortheaccountsusedtomanagethedatabaseinstances.Eachdatabasemusthaveitsowncontrolfile.PrimarydatabasemustoperateinARCHIVELOGmode.EnableFORCE

LOGGINGontheprimarydatabasebeforetakingdatafilebackupsforstandbycreation.IfanydatabasesuseASMand/orOMF,allshouldusethesamecombination.OracleDataGuard:ArchitectureLGWRPrimarydatabasetransactionsOnlineredologsARC0FALRFSMRPorLSPArchivedredologsARC0StandbydatabaseReports(MRPonly)StandbyredologsArchivedredologsBackupOraclenetLNSn(Real-timeapply)PrimaryDatabaseFlowLGWRPrimarydatabasetransactionsOnlineredologsARC0FALRFSMRPorLSPArchivedredologsARC0StandbydatabaseReports(MRPonly)StandbyredologsArchivedredologsBackupOraclenetLNSn(Real-timeapply)StandbyDatabaseFlowLGWRPrimarydatabasetransactionsOnlineredologsARC0FALRFSMRPorLSPArchivedredologsARC0StandbydatabaseOraclenetReports(MRPonly)StandbyredologsArchivedredologsBackupLNSn(Real-timeapply)StandbyRedoLogsRedofromprimarydatabaseRFSARC0StandbyredologsArchivedredologsMRP/LSPStandbydatabasePhysicalStandbyDatabase:

RedoApplyArchitecturePhysicalstandbydatabasePrimarydatabaseProductiondatabasePhysicalstandbydatabaseRedoapplyRedostreamRedotransportBackupLogicalStandbyDatabase:

SQLApplyArchitecturePrimarydatabaseRedotransportTransformredoinformationintoSQLSQLApplyReportsProductiondatabaseLogicalstandbydatabaseLogicalstandbydatabaseRedo

recordsLCR

LCR

:SharedpoolTransactiongroupsTransactionssortedindependencyorderLogMiningApplyprocessingLogicalchangerecordsnotgroupedintotransactionsTransactionstobeappliedReaderPreparerBuilderAnalyzerCoordinatorApplierDatafilesRedodatafromprimarydatabaseSQLApplyProcess:ArchitectureReal-TimeApplyRFSStandbyredologfilesMRPorLSPARC0PrimarydatabaseStandbydatabaseArchivedredologfilesSettingtheDB_UNIQUE_NAMEParameter

DB_UNIQUE_NAME=SF1_DBSanFranciscoSF1_DBSpecifyingRole-BasedDestinationsPrimarydatabaseStandbydatabaseLOG_ARCHIVE_DEST_2=location="/u01/app/oracle/oradata/orcldg2/arc",valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)DB_UNIQUE_NAME=HRDB2NotusedCombinationsforVALID_FORCombinationPrimaryPhysicalLogicalONLINE_LOGFILE,PRIMARY_ROLE

Valid

Ignored

Ignored

ONLINE_LOGFILE,STANDBY_ROLE

IgnoredIgnoredValidONLINE_LOGFILE,ALL_ROLES

ValidIgnoredValidSTANDBY_LOGFILE,STANDBY_ROLE

IgnoredValidValidSTANDBY_LOGFILE,ALL_ROLES

IgnoredValidValidALL_LOGFILES,PRIMARY_ROLE

Valid

Ignored

Ignored

ALL_LOGFILES,STANDBY_ROLE

IgnoredValidValidALL_LOGFILES,ALL_ROLES

ValidValidValidIdentifyingDestinationSettingsSQL>SELECTDEST_ID,VALID_TYPE,VALID_ROLE,VALID_NOW2FROMV$ARCHIVE_DEST;DEST_IDVALID_TYPEVALID_ROLEVALID_NOW------------------------------------------------1ALL_LOGFILESALL_ROLESYES2STANDBY_LOGFILESTANDBY_ROLEWRONGVALID_TYPE3ONLINE_LOGFILESTANDBY_ROLEWRONGVALID_ROLE4ALL_LOGFILESALL_ROLESUNKNOWN5ALL_LOGFILESALL_ROLESUNKNOWN6ALL_LOGFILESALL_ROLESUNKNOWN7ALL_LOGFILESALL_ROLESUNKNOWN8ALL_LOGFILESALL_ROLESUNKNOWN9ALL_LOGFILESALL_ROLESUNKNOWN10ALL_LOGFILESALL_ROLESUNKNOWN11ALL_LOGFILESALL_ROLESYES11rowsselected.StandbyRedoLogConfigurationRedoshipmentRFSStandbyredologsOnlineredologsPrimarydatabaseStandbydatabaseUsingSQLtoAddStandbyRedoLogsUsetheALTER

DATABASEstatementtocreatethestandbyredologfiles:Addmemberstoagroupwiththefollowingstatement:Viewinformationaboutthegroupsasfollows:SQL>ALTERDATABASEADDSTANDBYLOGFILEMEMBER2'/oracle/oradata/orcl/log2b.rdo'TOGROUP2;SQL>ALTERDATABASEADDSTANDBYLOGFILE2('/oracle/oradata/orcl/log1c.rdo',3'/oracle/oradata/orcl/log2c.rdo')SIZE500K;SQL>SELECT*FROMv$standby_log;SQL>SELECT*FROMv$logfile2WHEREtype='STANDBY';UsingEnterpriseManager

toAddStandbyRedoLogsStandbyDatabaseModesYoucanmaintainthestandbydatainoneofthefollowingmodes:ForphysicalstandbydatabasesRedoApplyOpenread-onlymodeForlogicalstandbydatabasesOpenread/writemodeSummaryInthislesson,youshouldhavelearnedhowtodescribethefollowing:DataGuardarchitectureprocessesOperationalrequirementsofaDataGuardenvironmentHowDataGuardprocesses,transports,andappliesredologsModesofstandbydatabasesandwhentouseeachmodePractice2-1:ArchitectureReviewThispractic