- Configuring fast recovery area
show user;
show con_name;
/*
USER is "SYS"
CON_NAME
------------------------------
CDB$ROOT
*/
The fast recovery area is an Oracle managed directory file system, or Oracle automatic storage management disk group that provides centralized storage for backup and recovery files.
The fast recovery area is usually used to store the Oracle archived redo logs, the database flashback change logs and RMAN backup sets
Two parameters control the fast recovery area.
1. db_recovery_file_dest
2. db_recovery_file_dest_size
Alter system set DB_RECOVERY_FILE_DEST_SIZE = 5G;
Alter system set DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fast_recovery_area';
# DB_RECOVERY_FILE_DEST_SIZE 사이즈는 환경에 따라 달라짐
SQL> show parameter db_rec
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0
db_recycle_cache_size big integer 0
SQL> Alter system set DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fast_recovery_area';
Alter system set DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fast_recovery_area'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
SQL> Alter system set DB_RECOVERY_FILE_DEST_SIZE = 5G;
System altered.
SQL> Alter system set DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fast_recovery_area';
System altered.
SQL>
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 5G
db_recycle_cache_size big integer 0
# 백업 테스트를 위해서 불필요한 PDB들은 삭제. 백업시 용량을 줄이기 위함
SQL> alter pluggable database pdb11 close;
Pluggable database altered.
SQL> drop pluggable database PDB11 including datafiles;
Pluggable database dropped.
SQL> alter pluggable database pdb10 close;
Pluggable database altered.
SQL> drop pluggable database PDB10 including datafiles;
Pluggable database dropped.