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 <[email protected]> > > > sebelum dan setelah archive mode, dua* sudah di coba dan errornya sama. > > > --- On Fri, 24/7/09, bukhari yahya > <[email protected]<bukhariyahya%40gmail.com>> > wrote: > > From: bukhari yahya <[email protected] <bukhariyahya%40gmail.com>> > Subject: Re: [indo-oracle] Log Archive > To: [email protected] <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]
