Dear aly kalau saya liat di statementnya, koq ada spasi nya ya
SQL> alter system set log_archive_ dest='location =/u01/app/ oracle/product/ 9.2.0/dbs/ arch' ; coba dengan : alter system set log_archive_ dest='location =/u01/app/oracle/product/9.2.0/dbs/arch' ; regards henri From: [email protected] [[email protected]] On Behalf Of aly rmb [[email protected]] Sent: Tuesday, July 28, 2009 8:36 AM To: [email protected] Subject: External Email : --> Re: [indo-oracle] Log Archive 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] This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference.
