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/
