to pak andes, skdr masukan, mungkin bisa d perhatiin jg checkpoint_change# dr v$datafile_headernya, boss... coba d liat, mestinya checkpoint_change# nya sama utk smua datafile... klo ada yg beda, biasanya DBnya gk bs up n datafile yg checkpoint_change# nya beda itu bakal minta recover... moga2 bisa membantu, pak.... CMIIW, [L]
--- On Fri, 6/19/09, Andes Febrian <[email protected]> wrote: From: Andes Febrian <[email protected]> Subject: Re: [indo-oracle] oldest online sequence bermasalah To: [email protected] Date: Friday, June 19, 2009, 9:37 AM saya blm pernah switchover lagi siy setelah oldest sequence nya ga sama antara primary dan standby. ya klo saya query max(sequence# ) sudah sama antara standby dengan primary. ok d, thanks untuk sharing nya. nice \m/ Regards, 2009/6/18 F R <friza_...@yahoo. com> > > > Sekedar menyumbang saran pak. > > Seharusnya tidak bermasalah selama max(sequence# ) yang applied sama. > Tapi untuk menghindari bila tidak dapat di switchover atau di failover, > copy aja file archived lognya secara manual dari yang paling lama > kemudian recover database secara manual pada standby. > > Kalau database tidak mencari archived log yang lama, berarti sudah aman > biasanya hal ini terjadi bila db primary hasil dari failover bukan db yang > pertama kali dibuat. > > Smoga membantu dan tidak malah menyesatkan. > > Regards > Fatkhur Riza > > --- Pada Kam, 18/6/09, Leonard Sukendro <leon_190699@ yahoo.com<leon_190699% > 40yahoo.com> > > menulis: > > Dari: Leonard Sukendro <leon_190699@ yahoo.com <leon_190699% 40yahoo.com> > > Topik: Re: [indo-oracle] oldest online sequence bermasalah > Kepada: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Tanggal: Kamis, 18 Juni, 2009, 6:44 AM > > > to pak andes... > > emm, jujur saya ndiri jg gk tau sech itu masalah ato bukan, tp punya saya > jg gtu, boss :D... > selama ini saya cmn check max(sequence# ) applied n checkpoint_change# nya > aja... klo antara primary n stby nya dh sama, asumsi saya sech aman, pak.... > saya dh coba switchover bbrp kali dgn keadaan gtu d development, untungnya > bs jalan normal, pak... > mungkin ada tmen2 laen yg bs memberi pencerahan.. . > > > CMIIW, > [L] > > --- On Thu, 6/18/09, Andes Febrian <pejantan4u@ gmail. com> wrote: > > From: Andes Febrian <pejantan4u@ gmail. com> > Subject: Re: [indo-oracle] oldest online sequence bermasalah > To: indo-oracle@ yahoogroups. com > Date: Thursday, June 18, 2009, 5:20 PM > > oldest sequence di standby nya pak. bukankah seharus nya sama dengan yg ada > di primary pak (saya bold pak). nah ini berbeda, gimana cara atasi nya pak > ? > atau cuekin aja pak, karena ga berbahaya ? > > Many Thanks, > > 2009/6/18 Leonard Sukendro <leon_190699@ yahoo.com> > > > > > > > to pak andes.... > > > > brmasalahnya knp ya, pak? sorry nech, mungkin saya kurang teliti, tp > > kyaknya smua baek2 aja koq, pak :)... > > > > regards, > > [L] > > > > --- On Thu, 6/18/09, Andes Febrian <pejantan4u@ gmail. com<pejantan4u% > 40gmail.com> > > > wrote: > > > > From: Andes Febrian <pejantan4u@ gmail. com <pejantan4u% 40gmail.com> > > > Subject: [indo-oracle] oldest online sequence bermasalah > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > Date: Thursday, June 18, 2009, 4:17 PM > > > > > > Dear gurus, > > > > Environment database saya, DataGuard 10.2.0.1, kemudian oldest online > > sequence pada standby database bermasalah, ketika saya ketik archive log > > list, muncul sebagai berikut : > > STANDBY DATABASE : > > ============ ====== > > SQL> archive log list > > Database log mode Archive Mode > > Automatic archival Enabled > > Archive destination /oradata/archive > > *Oldest online log sequence 7077* > > Next log sequence to archive 0 > > Current log sequence 7097 > > > > PRIMARY DATABASE : > > ============ ====== > > SQL> archive log list > > Database log mode Archive Mode > > Automatic archival Enabled > > Archive destination /oradata/archive > > *Oldest online log sequence 7095* > > Next log sequence to archive 7097 > > Current log sequence 7097 > > ada masukan dari rekan - rekan gimana cara mengatasi masalah ini ? > > > > Many THanks, > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > Kenapa BBM mesti naik? Apakah tidak ada solusi selain itu? Temukan > jawabannya di Yahoo! Answers! http://id.answers. yahoo.com > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
