Maksudnya yg sudah dihapus itu gimana? - hapus file secara fisik dari os (pake rm) - atau hapus logfile dari oracle (pake alter database)
Kalau Anda cuma menghapus secara fisik, informasi logfile masih ada didatabase, jadi pasti error ketika menambah logfile group/member. Coba check dulu: --check current logfile group select group#,thread#,sequence# from v$log; --check current member of logfile select * from v$logfile; Apabila group 6 - 10 sudah ada, dan memang tdk digunakan, maka delete dahulu dengan: alter database drop logfile group 6; Utk menghapus logfile member: alter database drop logfile member '/oradata/system/log06a.dbf'; BTW, di sintax Anda dibawah, GROUP 9 muncul 2 KALI loo??? regards, tomi --- mamak_gadang <[EMAIL PROTECTED]> wrote: > Mohon pencerahan, > kemaren kami melakukan cloning data dari Prod > instance ke Test > Intance,kebeulan ada masalah saat melakukan create > redo log for RAC2 > nya. saatu itu kami jalankan script : > > alter database add logfile thread 2 > group 6 '/oradata/system/log06a.dbf' size 30m, > group 7 '/oradata/system/log07a.dbf' size 30m, > group 8 '/oradata/system/log08a.dbf' size 30m, > group 9 '/oradata/system/log09a.dbf' size 30m, > group 9 '/oradata/system/log10a.dbf' size 30m; > alter database enable thread 2; > > Kah katanya file log09a.dbf sudah ada.. > Kemudia kami hapus benar semua file dari log06a.dbf > sampai log09a.dbf > kemudian kami menjalankan script yang diatas, > katanya group 6 sudah > exist.... > nah gimana cara mengatasinya....? > mohon pencerahan... > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------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/
