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