OPTION 1: Try to delete old archive logs to free up space.
rman target /
delete archivelog all completed before 'sysdate-7';
OPTION 2: Change the archive log location:
In case you can’t delete the archive logs from existing location, then we can change the archive dest to a new mount point.
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------
log_archive_dest_1 string LOCATION=/archive/POCD
SQL> alter system set log_archive_dest_1='LOCATION=/dump/arch' scope=both;
System altered.
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- --------------------
log_archive_dest_1 string LOCATION=/dump/arch
-- Switch logfile
alter system switch logfile;
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন