Kalau hanya sekedar dipakai utk reporting pada "waktu tertentu", physical standby database pun bisa di OPEN READ ONLY. Dengan catatan, selama dalam state OPEN READ ONLY, di physical standby, redo information yg diterima dari primary database tidak bisa di apply, karena apply dari redo information, hanya bisa dilakukan pada stage MOUNTed & MANAGED RECOVERY.
cara: stop manage recoverynya , lalu open read only. Tapi, kalau reportingnya setiap saat, dan data2 yg diinginkan "sedikit" real-time, disarankan utk menggunakan LOGICAL STANDBY database. CMIIW, Bowo --- In [email protected], sambi <[EMAIL PROTECTED]> wrote: > > Iya Whisnu, > untuk physical standby database dalam keadaan standby. tidak open. > > > > On 12/20/06, Whisnu Kurniawan <[EMAIL PROTECTED]> wrote: > > > > Jadi databasenya harus logical standby database gak bisa kalo physical > > standby ya ? > > > > Ujang Jaenudin <[EMAIL PROTECTED] <ujang.jaenudin%40gmail.com>> > > wrote: 1. dgn menggunakan logical standby database > > caranya baca aja oracle docs :( > > 2. bisa dgn outline atau sqltrace+tkprof > > > > salam, > > J > > > > On 12/18/06, Whisnu Kurniawan <[EMAIL PROTECTED] <wh_kurnia% 40yahoo.com>> > > wrote: > > > > > > Abang2 dan rekan2 saya mau bertanya. > > > Saya ada dua pertannyaan: > > > > > > 1.Bagaimana setting standby database biar bisa open read only dan > > diakses > > > untuk reporting? > > > 2. Bagaimana cara mentrack sql dari user tertentu sebab saya ditugasi > > bos > > > untuk menganalisa sql dari sebuah aplikasi yg kami buat? > > > > > > Demikian terimakasih > > > > > > Whisnu > > > > > Recent Activity > > > > > > - 12 > > > New Members< > > http://groups.yahoo.com/group/indo- oracle/members;_ylc=X3oDMTJmMjc2Njc5BF9TAzk3MzU5NzE0BGdycElkAzMyMTMyM jUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzExNjY0MT k2MTE- > > > > > > > > > Visit Your Group > > > < > > http://groups.yahoo.com/group/indo- oracle;_ylc=X3oDMTJldHJuOTQ3BF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc 3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTE2NjQxOTYxMQ-- > > > > > > SPONSORED LINKS > > > > > > - Thin client server< > > http://groups.yahoo.com/gads;_ylc=X3oDMTJjbjZhMHM2BF9TAzk3MzU5NzE0BF9 wAzEEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA3NsbW9kBHN0aW1l AzExNjY0MTk2MTI-? t=ms&k=Thin+client+server&w1=Thin+client+server&w2=Database+marketing +software&w3=Database+management+software&w4=Online+database+software &w5=Customer+database+software&c=5&s=153&g=2&.sig=l6x14tUPBiWx7- VhiGyK_g > > > > > > - Database marketing software< > > http://groups.yahoo.com/gads;_ylc=X3oDMTJjdTkxM2lxBF9TAzk3MzU5NzE0BF9 wAzIEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA3NsbW9kBHN0aW1l AzExNjY0MTk2MTI-? t=ms&k=Database+marketing+software&w1=Thin+client+server&w2=Database+ marketing+software&w3=Database+management+software&w4=Online+database +software&w5=Customer+database+software&c=5&s=153&g=2&.sig=JrZqNEFE- uziLwVGDX_Ypw > > > > > > - Database management software< > > http://groups.yahoo.com/gads;_ylc=X3oDMTJjMm4zdWNpBF9TAzk3MzU5NzE0BF9 wAzMEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA3NsbW9kBHN0aW1l AzExNjY0MTk2MTI-? t=ms&k=Database+management+software&w1=Thin+client+server&w2=Database +marketing+software&w3=Database+management+software&w4=Online+databas e+software&w5=Customer+database+software&c=5&s=153&g=2&.sig=W9APGjLvk ZcZn6nVRtAQDw > > > > > > - Online database software< > > http://groups.yahoo.com/gads;_ylc=X3oDMTJjb2g0bWxqBF9TAzk3MzU5NzE0BF9 wAzQEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA3NsbW9kBHN0aW1l AzExNjY0MTk2MTI-? t=ms&k=Online+database+software&w1=Thin+client+server&w2=Database+mar keting+software&w3=Database+management+software&w4=Online+database+so ftware&w5=Customer+database+software&c=5&s=153&g=2&.sig=dZZh710vr5pNb 5a5Bnre_A > > > > > > - Customer database software< > > http://groups.yahoo.com/gads;_ylc=X3oDMTJjaHY2djA3BF9TAzk3MzU5NzE0BF9 wAzUEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA3NsbW9kBHN0aW1l AzExNjY0MTk2MTI-? t=ms&k=Customer+database+software&w1=Thin+client+server&w2=Database+m arketing+software&w3=Database+management+software&w4=Online+database+ software&w5=Customer+database+software&c=5&s=153&g=2&.sig=xs2QLR1UQnZ q795E_w0MEA > > > > > > > > > Money Matters > > > > > > Yahoo! HotJobs!< > > http://us.ard.yahoo.com/SIG=12iisvf5m/M=493064.9803220.10510213.86745 78/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1166426812/A=3848553/R=0/SIG= 111mtgddu/*http://hotjobs.yahoo.com/salary > > > > > > > > > What are you worth? > > > New web site? > > > > > > Drive traffic now.< > > http://us.ard.yahoo.com/SIG=12i1odo1i/M=493064.9803227.10510220.86745 78/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1166426812/A=3848642/R=0/SIG= 131eshi2t/*http://searchmarketing.yahoo.com/arp/srchv2.php? o=US2004&cmp=Yahoo&ctv=Groups3&s=Y&s2=&s3=&b=50 > > > > > > > > > Get your business > > > > > > on Yahoo! search. > > > Yahoo! Groups > > > > > > Start a group< > > http://groups.yahoo.com/start;_ylc=X3oDMTJvZWNqaGJpBF9TAzk3MzU5NzE0BF 9wAzMEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA25jbW9kBHNsawN ncm91cHMyBHN0aW1lAzExNjY0MTk2MTE- > > > > > > > > > in 3 easy steps. > > > > > > Connect with others. > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > > [Non-text portions of this message have been removed] > > > > > > > > > [Non-text portions of this message have been removed] >
