ok pak. tp nanti klo misal emang ada yang checkpoint_change# nya ada yg beda, minta recover nya biasa kan cukup dengan perintah recover database aja kan ?
2009/6/19 Leonard Sukendro <[email protected]> > > > 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]<pejantan4u%40gmail.com>> > wrote: > > From: Andes Febrian <[email protected] <pejantan4u%40gmail.com>> > Subject: Re: [indo-oracle] oldest online sequence bermasalah > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
