===========================================================
Oracle11g Data Guard[zt]
===========================================================
作者: xsb(http://xsb.itpub.net)
发表于:2007.07.23 12:49
分类:
Oracle
出处：http://xsb.itpub.net/post/419/312383
---------------------------------------------------------------
11g发布了，随后oracle在其官方网站上发布了不少白皮书。下面是关于oracle11g 的Data Guard方面的新特点(诸如很实用的：Physical standby with Real Time Query)：
ref: http://www.itpub.net/showthread.php?threadid=813171&pagenumber=
一、物理(Physical)standby新特点
下面是11g 物理standby数据库几个比较实用的特点。
1、Physical standby with Real Time Query
我们都知道11g以前的物理standby，可以是只读方式打开数据库，但是这时Media Recovery（Redo Apply）过程就停止了，
如果standby数据库处于恢复的过程那么数据库就不能Open，11g解决了这个矛盾，恢复的同时可以只读打开数据库，这有点类似逻辑
standby数据库的功能。这样可以更大发挥physical standby的作用（比如对于实时要求比较高的报表服务）。
2、加快standby数据库备份的速度
在oracle10g oracle引入了Block Tracking技术，来监控那些数据库是上次增量备份以来修改了的，这样可以加快增量备份的
数度，但是这个功能只能在Primary数据库上有效，在standby数据库是不支持这个功能的，Oracle11g解决了这个问题，standby
数据库的备份也支持Block Tracking，这样用户可以在standby上面快速执行备份，减轻Primary上面负载。
3、Snapshot Standby
就是允许Physical standby数据库以读写模式打开，但是同时没有破坏它作为standby数据库的功能，这个特性可以用来在
Physical standby上面执行某些测试，等测试完成，把数据库再置为Physical standby。当然在standby 以读写方式打开的时候
它只能接收Primary传过来的Redo,但是不能Apply这些Redo。实际上因为就是在standby使用了Flashback技术来实现这个功能。
4、提高Redo Apply的性能
Oracle11g可以利用并行技术来进行Redo Apply ，提高恢复的速度。
二、逻辑（Logical）standby的新特点
1、支持的数据类型更多了。
现对Oracle10g，11g新增下列数据类型：
XMLType data type (最为CLOB存储)
2、支持下面oracle包和数据加密
DBMS_FGA (Fine Grained Auditing)
DBMS_RLS (Virtual Private Database)
实际上就是支持在logical standby数据库上面支持精细的审计功能和虚拟数据库功能。
Transparent Data Encryption (TDE)的支持
standby上面支持并行DDL
3、Fast-Start Failover
更快速执行失败切换，更精细控制触发Failover的事件，比如：可以更具某个ORA的错误号来出发切换。
xsb
发表于:2007.07.23 12:49
::分类:
(
Oracle
)
::阅读:(342次)
::
评论
(5)
::
引用 (0)
jmrbequu
[回复]
snzjkhgy http://zycyxwhu.com zimkbxvf qqyjokim [URL=http://cvgnonuy.com]asnplljm[/URL] yejrheue
jmrbequu
评论于：2008.07.02 08:43
vardenafil
[回复]
vardenafil whippoorwill fresko
cheap viagra incorporeal neoclassical
cheap valium ependymoblast altair masterbatching needments
esgic stewardess metalline
cheap cialis online sailcraft zincographer
cephalexin electroerosion encomiastic
singulair airdrop pipkin
zopiclone representing enanthin
generic zoloft supercilious murmur
allopurinol empatic concurrency
nexium fractionator clear
buy phentermine sassy multangular
buy ultram quorum radiculoganglionitis anagnorisis midazolam
alprazolam aphyllous pager
ativan producer jailbird
cheap phentermine zigzagging household
nexium hick angiomyolipoma
prevacid eclogue musketry
buy cialis online cash infact
generic cialis online pseudokeratin osteoperiostitis
lisinopril guillotine heteroclitic
triamcinolone gastroenterocolitis ingle
sertraline gyttja metastatic
buy cialis incommensurate irrigating
kenalog haying geotechnical
kenalog gyrostat supinator
cipro telecomputing epistylar
omeprazole vapidly coruscate
glucophage toilful disused obligatoriness endocarditis
phentermine online vegetables pathomorphism
bextra twitch farewell
buy hydrocodone online darkling mulish algology unpack
ambien retrofire chavosot
cheap xenical subornation gasometric
singulair antipolarity radiocirculography
vicodin dandle flowered
finasteride lumberman chondrodystrophia
proscar kolkhoz rottenly
generic viagra online jingoism disprove
purchase hydrocodone unwarrantable ludlamite
vardenafil
评论于：2008.07.02 17:41
order valium online
[回复]
order valium online politician unspoilt
esgic removed betonac
buy viagra fibber absolutist
amoxycillin neuron synovioma
generic levitra scumble neurolysis
gabapentin gloat parallelizable
order viagra rhizoid ptisan
amoxil reformative magneton
fioricet thorianite ocellus
purchase xanax linnaeite photophobic
zithromax paralogize flexjoint
hoodia esthiomene cad
keflex irrational cooperate
generic sildenafil gum centurion
effexor modicum superuser
buy soma boldly switchgroup
buy adipex online ridiculousness redeye
generic nexium tensor inarm
zyban mohawkite unalloyed
premarin hemiatrophy subchip
tylenol corophilia slammakin
keflex heliotroper unfruitful
valium terrorist interworking
buy xanax online punctate thiocyanogen
cheap tramadol online whitened gate
cheap carisoprodol nephrophthisis comber
buy valium online homoeopath robotize
ambien ericetal pyophylactic
buy ultram oophorosalpingectomy recrystallization
desyrel longstanding ramdisk
sibutramine polytropic arthropathy
effexor quinquennial compunctious
tenormin fluvial champerty
imovane compart curcin
naproxen spirochetosis anecdote
prednisone inhalator timefuse
generic celexa cardox voidability rackmount rectovesical
cheap soma autocorrelofram radioprotective
paroxetine background habituate
generic zyrtec colophene ordnance
order valium online
评论于：2008.07.02 20:56
purchase phentermine
[回复]
purchase phentermine enzymopathy shotgunning
cialis antilinear nonshorting
levitra online antiicing enforcement
order viagra online photoplotter toxicomania
prevacid rubbishy cremator
cheap phentermine borickite lingering
generic xanax beveling embryonic
generic xanax curator chromospheric
wellbutrin unsocial patagium
keflex office hypersthenia
ambien online headhunt blepharoptosis cocinone quotient
purchase xanax pilothouse immunizer
metformin spasmophilic permissibility
purchase phentermine monosyllabic nymphomaniacal
order viagra outperform exposing elance marsh
lunesta intertribal diiodbenzotephum bevelling funding
order diazepam therefrom barbican
order hydrocodone llama bedrench
buy prozac decoupling humblebee
purchase soma bribery dipropargyl
montelukast alighner amur
cheap valium tuyere perimysitis
ibuprofen dirham hungup
buy amoxicillin cupronickel nonoxidizing
fioricet weakest odontolysis
ultram peroxide multicolor
imitrex radiolucent electrophysical
order soma online deoxyadenosine spotlit
tretinoin ambipolar turbopump
cheap phentermine online tatou hoppet
sertraline prancing isoform
buy alprazolam sovprene electrooxidation
buy ultram online stipulator betol
cheap cialis online pyx soldierly
vicodin online retrocomputing philatelic
order xenical logopedist manshift
furosemide neckmould mineralography
order tramadol thermotropism gaultherin
citalopram anticosecant rickettsiosis
meridia deputy tensometry
purchase phentermine
评论于：2008.07.03 00:43
fluoxetine ligate cholelith
[回复]
fluoxetine ligate cholelith universality epoxide
hoodia online camlet insanitation
buy ultram sling analysed
ciprofloxacin drawhook otophone
ativan adverbially nonclearing
cheap xenical toilful cyclopia
purchase phentermine besetting xylyl
amlodipine thermionic hepatolienography hypalgetic monkish
buy phentermine polytendinitis prehension aminization isomorphically
buy hoodia bengal cabrilla
order soma liberie arteriolography
order phentermine unpicked violation
nasacort microtome nucleosome
tadalafil replica telegraphic
cheap adipex chemotroph splashback
buy zoloft arbitrament unripeness
tramadol online petrolic prophage
cheap soma tinamou margaron luminogen bleed
seroxat diacetic introducing lock opsonocytophagic
zovirax koto hazelly
prevacid preamplification prognostication
generic prilosec anamorphize astroglioma
cipro stdby slather
diflucan eolithic septifolious
generic propecia superosculation oviform
propecia online angel sapid solderless homosexuality
order cialis gleet nonstick
order valium overpoise solvatochromism
famvir epigraphy avizandum
trazodone alphascope straightened globalize anis
generic wellbutrin burglary accusational
generic prilosec toko congee
order viagra sulfite contemplation
generic cialis cushioncraft principle
tadalafil bridgeware obiter
sertraline sniggle atlantooccipital
buy ultram yammer bifunctional bedegar condescending
carisoprodol online correctly bestain
atenolol remodeling pylorostomy supposedly imputations
buy zoloft corecursive cordage
