DBA Hub

📋Steps in this guide1/2

Enable Flash Recovery Area In Oracle Database

The flash recovery area(FRA) is an Oracle-managed location ( it may be FILE SYSTEM or ASM ) for centralized backup and recovery files. It streamlines backup

oracle configurationintermediate
by OracleDba
16 views
1

Overview

The flash recovery area(FRA) is an Oracle-managed location ( it may be FILE SYSTEM or ASM ) for centralized backup and recovery files. It streamlines backup management. The Flash Recovery Area contains the following recovery-related files: - Flashback logs. - Control file auto backups. - Datafile and control file copies. - Backup pieces. - Archived redo logs. - Online redo logs. - Current control file. DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST these are 2 initial parameters are required for enabling FRA. - DB_RECOVERY_FILE_DEST_SIZE: It is the disk quota size for the flash recovery area. - DB_RECOVERY_FILE_DEST : It is a valid destination Parameter for the Flash Recovery Area. It can be a directory, file system, or ASM disk group. NOTE : DB_RECOVERY_FILE_DEST_SIZE must be set before DB_RECOVERY_FILE_DEST.
2

Section 2

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
SQL> show parameter db_recovery_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0

SQL> select * from V$RECOVERY_FILE_DEST;

no rows selected

SQL> alter system set db_recovery_file_dest_size=20G scope=both;

System altered.

SQL> alter system set db_recovery_file_dest='/data/app/oracle/oradata/FRA' scope=both;

System altered.


SQL> show parameter db_recovery_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /data/app/oracle/oradata/FRA
db_recovery_file_dest_size big integer 20G


select * from V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
-------------------------------------- ----------- ---------- ----------------- --------------- ----------
/data/app/oracle/oradata/FRA 2.1475E+10 0 0 0 0

SQL> alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 816
Next log sequence to archive 818
Current log sequence 818
SQL> alter system switch logfile;

System altered.
1* select * from v$flash_recovery_area_usage
SQL> /

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 0 0 0 0
REDO LOG 0 0 0 0
ARCHIVED LOG .01 0 1 0
BACKUP PIECE 0 0 0 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG .49 0 2 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0

8 rows selected.

SQL> alter system set db_recovery_file_dest_size=20G scope=both sid='*';

System altered.

SQL> alter system set db_recovery_file_dest='+FRADG' scope=both sid='*';

System altered.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!