dg11g最大保护模式可以认为是DataGuard的同步机制

Oracle11GStandbydatabase配置11、物理StandbyDatabase4、UsingReal-Time2 。 um um SQL>showparametersDGMGRL>connectsys/oracle1@bjDGMGRL>createconfigurationbjasprimarydatabaseisbjconnectidentifierisDGMGRL>enableDGMGRL>adddatabasetjasconnectidentifierisDGMGRL>enabledatabase

DGMGRL>editdatabasebjsetpropertyStaticConnectIdentifier= DGMGRL>editdatabasebjsetpropertylogxptmode=sync;DGMGRL>editdatabasetjsetpropertylogxptmode=sync;SQL>altersystemsetDB_RECOVERY_FILE_DEST_SIZE=SQL>alterdatabaseflashbackSQL>recovermanagedstandbydatabaseSQL>altersystemsetDB_RECOVERY_FILE_DEST_SIZE=SQL>alterdatabaseflashback$ "startDGMGRL>editdatabasebjsetpropertyDGMGRL>editdatabasetjsetpropertybj-Primarytj-Physicalstandby

====FastStartFailoverPmyShutdown=Fast-StartFailover:DISABLEDConfigurationStatus:

=>tj-Primarybj-Physicalstandby

====FastStartFailoverAutoReinstate='TRUE'FastStartFailoverPmyShutdown='TRUE' ='ALL'ConfigurationStatus:5、启用fast-startfailoverDGMGRLenablefast_startfailover

30LagLimit: 30seconds(notinPriry: Fast-StartFailover(FSFO)hasbeenenabledbetween:Primary="tj"Standby=、DGMGRLshowDGMGRL>showconfigurationbj-Primarytj-(*)PhysicalstandbyConfigurationStatus:UsingReal-Time$export SnapshotStandby2、转换成快照toSNAPSHOTstandbydatabase：SQLalterdatabaseconverttoSNAPSHOTSTANDBY;SQL>alterdatabase4、SQLselectopen_modefromv$database;5、转换成正常的standbydatabase：SQL>startupSQL>alterdatabaseconverttoPHYSICALSTANDBY;SQL>shutdownimmediateSQL>st