Pages

Sunday, 22 November 2015

ORA-16179 Error ketika mengganti Lokasi ArchiveLOG

Kita mungkin menemukan error ORA-16179 saat menentukan lokasi ArchiveLog.

SQL> ARCHIVE LOG LISTDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 12Next log sequence to archive 13Current log sequence 13
SQL> ALTER SYSTEM SET log_archive_dest_1='C:\oracle\db\ora11g\admi \adump';ALTER SYSTEM SET log_archive_dest_1='C:\oracle\db\ora11g\admin\adump'*ERROR at line 1:ORA-32017: failure in updating SPFILEORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE



Diperlukan variabel LOCATION pada parameter LOG_ARCHIVE_DEST_1

SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=C:\oracle\db\ora11g\admin\adump';System altered.
SQL> ARCHIVE LOG LISTDatabase log mode Archive ModeAutomatic archival EnabledArchive destination C:\oracle\db\ora11g\admin\adumpOldest online log sequence 12Next log sequence to archive 13Current log sequence 13

Keterangan :
– adump : merupakan folder penyimpanan archiveLOG yang baru.

No comments:

Post a Comment

GPT Protective Partition pada Hard disk

  Terkadang, setelah menyambungkan hard disk internal atau eksternal ke sistem Anda, Disk Management Windows memberi tahu bahwa hard disk te...