eee sorry "_1" blum di delete... seharusnya SQL> alter system set log_archive_ dest='location =/u01/app/ oracle/product/ 9.2.0/dbs/ arch' ; tapi muncul error spt email di bawah...
--- On Mon, 27/7/09, aly rmb <[email protected]> wrote: From: aly rmb <[email protected]> Subject: Re: [indo-oracle] Log Archive To: [email protected] Date: Monday, 27 July, 2009, 7:29 PM Pa' Bukhari, baik dalam archive mode atau tidak, setelah command SQL> alter system set log_archive_ dest_1='location =/u01/app/ oracle/product/ 9.2.0/dbs/ arch' ; muncul erro sbb : ORA-02097 : parameter cannot be modified because specified value is invalid ORA-16032 : parameter LOG_ARCHIVE_ DEST destination string cannot be translated ORA-07286 : sksagdi : cannot obtain device information kira* error apa lagi ?, sy google, tp masih ngga' jelas solve problem-nya. salam/Aly --- On Mon, 27/7/09, bukhari yahya <bukhariyahya@ gmail.com> wrote: From: bukhari yahya <bukhariyahya@ gmail.com> Subject: Re: [indo-oracle] Log Archive To: indo-oracle@ yahoogroups. com Date: Monday, 27 July, 2009, 2:19 AM harus archivelog mode dan pakai parameter yang ini : SQL> alter system set log_archive_ dest='location= /u01/app/ oracle/product/ 9.2.0/dbs/ arch' ga pakai _1 hanya "log_archive_ dest" 2009/7/24 aly rmb <aly_...@yahoo. com> > > > sebelum dan setelah archive mode, dua* sudah di coba dan errornya sama. > > > --- On Fri, 24/7/09, bukhari yahya <bukhariyahya@ gmail.com<bukhariya hya% > 40gmail.com> > > wrote: > > From: bukhari yahya <bukhariyahya@ gmail.com <bukhariyahya% 40gmail.com> > > Subject: Re: [indo-oracle] Log Archive > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Date: Friday, 24 July, 2009, 4:26 PM > > > > > SQL> alter system set > log_archive_ dest='location= /u01/app/ oracle/product/ 9.2.0/dbs/ arch' > scope=both; > > sebelumnya apakah sudah di set ke archivelog mode? > > log_archive_ dest_1 bs jalan di Oracle 9i EE tidak di SE > > salam > s73py > > On 7/24/09, aly rmb <aly_...@yahoo. com> wrote: > > sorry masih awam dng DBA, > > bisa di share cara penggunaan log_archive_ dest ? > > > > ada yg bilang, klo > > SQL> alter system set > > log_archive_ dest_1='location =/u01/app/ oracle/product/ 9.2.0/dbs/ arch' > > scope=both; > > > > bisa jalan di oracle 9i, bener ngga' ya ? > > jadi pening nich .... > > > > > > --- On Fri, 24/7/09, bukhari yahya <bukhariyahya@ gmail.com> wrote: > > > > > > From: bukhari yahya <bukhariyahya@ gmail.com> > > Subject: Re: [indo-oracle] Log Archive > > To: indo-oracle@ yahoogroups. com > > Date: Friday, 24 July, 2009, 2:30 PM > > > > > > > > > > > > > > yup betul sebelum oracle 11 memang SE itu begitu. > > ga bisa. > > > > ORA-00439: feature not enabled: Managed Standby > > artinya adalah tidak support standby database, artinya tidak support > > Dataguard. > > > > Memang SE itu tidak support Dataguard. > > gunakan saja log_archive_ dest untuk archive log > > > > On 7/24/09, aly rmb <aly_...@yahoo. com> wrote: > >> Pa' Bukhari, > >> Terimakasih atas responnya. > >> Sebenarnya pertanyaan email di bawah, itu karena error dari intruksi di > >> bawah ini : > >> > >> SQL> alter system set > >> log_archive_ dest_1='location =/appl/oracle/ product/9. 2.0/dbs/arch' > >> scope=both; > >> > >> muncul errornya : > >> ORA-32017: failure in updating SPFILE > >> ORA-00439: feature not enabled: Managed Standby > >> > >> pertanyaan selanjutnya : > >> apa yg musti di cek, agar alter di atas bisa jalan di Oracle 9i under > >> linux > >> ? > >> > >> Salam/Aly > >> > >> --- On Fri, 24/7/09, bukhari yahya <bukhariyahya@ gmail.com> wrote: > >> > >> > >> From: bukhari yahya <bukhariyahya@ gmail.com> > >> Subject: Re: [indo-oracle] Log Archive > >> To: indo-oracle@ yahoogroups. com > >> Date: Friday, 24 July, 2009, 5:00 AM > >> > >> > >> > >> > >> > >> > >> Memang tidak bisa walaupun hanya diarahkan lokal. > >> Hal tersebut salah satunya karena Dataguard pada SE tidak termasuk dalam > >> fitur. > >> > >> Pada Oracle 11 dapat digunakan tapi hanya yang diarahkan ke archive log > >> lokal. > >> > >> On Thu, Jul 23, 2009 at 10:24 AM, aly rmb <aly_...@yahoo. com> wrote: > >> > >>> > >>> > >>> Salam semua, > >>> Langsung saja, > >>> Bagaimana cara "log_archive_ dest_%" bisa jalan di Oracle 9i SE ? > >>> atau memang harga mati, ngga' bakalan bisa ? > >>> Mohon sharingnya.. . > >>> Terimakasih sebelumnya. > >>> Salam/Aly > >>> > >>> New Email names for you! > >>> Get the Email name you've always wanted on the new @ymail and > >>> @rocketmail. > >>> Hurry before someone else does! > >>> http://mail. promotions. yahoo.com/ newdomains/ aa/ > >>> > >>> [Non-text portions of this message have been removed] > >>> > >>> > >>> > >> > >> [Non-text portions of this message have been removed] > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> Get your preferred Email name! > >> Now you can @ymail.com and @rocketmail. com. > >> http://mail. promotions. yahoo.com/ newdomains/ aa/ > >> > >> [Non-text portions of this message have been removed] > >> > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Get your new Email address! > > Grab the Email name you've always wanted before someone else does! > > http://mail. promotions. yahoo.com/ newdomains/ aa/ > > > > [Non-text portions of this message have been removed] > > > > > > Get your new Email address! > Grab the Email name you've always wanted before someone else does! > http://mail. promotions. yahoo.com/ newdomains/ aa/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail. promotions. yahoo.com/ newdomains/ aa/ [Non-text portions of this message have been removed] New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]
