💡 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
- 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;