Pakai init<SID>.ora or spfile<SID>.ora Mas? SQL> show parameter spfile kalau nilainya blank, artinya menggunakan init<SID>.ora berarti anda harus edit file init<SID>.ora tsb dng system editor. kemudian restart database instancenya.
Kalau menggunakan SPFILE SQL> ALTER SYSTEM SET log_archive_start=TRUE SCOPE=SPFILE; SQL> startup force SQL> ARCHIVE LOG LIST Bowo --- In [email protected], "Toni Iskandar" <[EMAIL PROTECTED]> wrote: > > Dear members.... > > ----- Original Message ----- > From: "Yulius Wibowo" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, April 05, 2006 3:24 PM > Subject: [indo-oracle] Re: Thread 1 cannot allocate new log ???...help pliz. > > > > Coba parameter LOG_ARCHIVE_START nya di set TRUE > > > > SQL> conn / as sysdba > > SQL> show parameter log_archive_start > > > > hasil eksekusi perintah ini : > log_archive_start = FALSE > > > SQL> ALTER SYSTEM SET log_archive_start = TRUE; > > Pada saat perintah ini di execute ada error sbb: > ORA-02095 : specified initialization parameter cannot be modified. > > kenapa ya....gimana solusinya ???? > > > > > atau > > > > SQL> ARCHIVE LOG START > > > > Perintah ini berhasil di eksekusi, Tetapi apabila komputer di restart > maka parameter Automatic Archival menjadi disable kembali karena waktu > perintah show parameter log_archive_start di eksekusi lagi maka nilai > log_archive_start = FALSE > > SQL> archive log list; > Database log mode Archive Mode > Automatic Archived Enabled > Archive Destination C:\oracle\oradata\dbspmp\archivelog > > SQL> show parameter log_archive_start; > > log_archive_start = FALSE > > apakah kalau nilai Automatic Archival Enable maka nilai > log_archive_start = TRUE ??? > > Mohon bantuannya lagi nih...rekan2. > > Thanks a lot > > > CMIIW; > > > > Bowo; > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
