1. parameter yg anda tuliskan salah, seharusnya: *.log_archive_dest_1='LOCATION=/u03/archive'
a. kurang tanda kutip satu b. kurang opsi LOCATION --- In [email protected], "Yulius Wibowo" <[EMAIL PROTECTED]> wrote: > > 1. parameter yg anda tuliskan salah, seharusnya: > *.log_archive_dest_1='/u03/archive' > > !!! kurang tanda kutip satu ... hehehe > > 2. Parameter LOG_ARCHIVE_START di DB 10G sudah deprecated, > artinya, pada versi/release yg sekarang "masih" boleh dipakai, > tapi untuk next version/release sudah > dianggap "obsolete"/kadaluwarsa. > Jadi tidak usah diset pun secara otomatis Oracle akan memebri nilai > TRUE utk nilainya. > > 3. fungsi dari Flash recovery area itu untuk apa ya .. ? > Flash recovery area adalah area (berupa folder) yg dipakai utk > menyimpan: > - archived log file > - backup file (kalau pakai RMAN) > - flashback log file > - change tracking file > > Dan bisa anda set size-nya, misal 2GB. Kalau total file size yg ada > di area tsb melebihi size yg ditentukan, maka Oracle secara otomatis > akan menghapus file2 yg lama. > > Di database 10G utk mode ARCHIVELOG, anda cukup melakukan settingan > parameter berikut saja: > db_recovery_file_dest > db_recovery_file_dest_size > > tanpa perlu set parameter lainnya: log_archive_* > > > CMIIW > > Bowo > > > --- In [email protected], "cyuniart" <[EMAIL PROTECTED]> wrote: > > > > Dear all, > > Tolong dong, Saat startup db (10g), muncul error > > > > ORA-32006: LOG_ARCHIVE_START initialization parameter has been > > deprecated > > ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed > > > > sebelumnya saya ubah destination archive log nya (di pfile).. > > > > *.db_recovery_file_dest='/oracle/flash_recovery_area' > > *.db_recovery_file_dest_size=2147483648 > > *.log_archive_format='%t_%s_%r.dbf' > > *.log_archive_start=TRUE > > *.log_archive_dest_1=/u03/archive > > > > dan fungsi dari Flash recovery area itu untuk apa ya .. ? > > > > Trims sebelumnya, > > Condro > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
