117 - [Oracle 19C] Configuring fast recovery area

 

 

• 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.