Lỗi examine archive trace files for archiving errors

 💡 Bị connection time out db

1. Check the current FRA destination.

SQL> show parameter db_recovery_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /dbaclassdb/oradata/FRA
db_recovery_file_dest_size big integer 20G

SQL> select name from V$RECOVERY_FILE_DEST;

NAME
--------------------------------------
/dbaclassdb/oradata/FRA

2. Change db_recovery_file_dest parameter.

$SQL> alter system set db_recovery_file_dest='/fradg/oradata/FRA' scope=both;
 and
$SQL> alter system set log_archive_dest_1='location=/u12/opt/oracle/mysid/arch1';

$SQL> show parameter log_archive_dest_2
$SQL> alter system set log_archive_dest_2='';

select name from V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
-------------------------------------- ----------- ---------- ----------------- --------------- ----------
/fradg/oradata/FRA 2.1475E+10 0 0 0 0

Nếu đang bật flashback thì phải thay đổi như sau

1. Drop restore point if any

SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point;

GUARANTEE_FLASHBACK_DATABASE NAME
-------------------------------- -----------------------------
YES RESTORE_UPGRDE

SQL > Drop restore point restore_point RESTORE_UPGRDE ;

2. Turn off and turn on flashback :

ALTER DATABASE FLASHBACK OFF;
ALTER DATABASE FLASHBACK ON;