Quản trị Flash Recovery Area trong Oracle 19c Rac Database

0 Shares

Bài viết này sẽ cùng bạn demo về quản trị FRA trong oracle RAC 19c

Flash Recovery Area FRA là gì: https://datalinks.vn/flash-recovery-area-fra-la-gi/

Kiểm tra thông tin về FRA:

sqlplus / as sysdba

show parameter db_recovery_file

archive log list

word image 1662 1

Cấu hình: chúng ta có thể thay đổi thông tin về dung lượng lưu trữ, phân vùng lưu trữ:

alter system set db_recovery_file_dest_size=50G scope=both sid='*';

alter system set log_archive_dest_1='LOCATION=+FRA scope=both sid='*';

Check thông tin khác:

set lines 1000 pages 1000

select * from v$flash_recovery_area_usage;

alter system switch logfile;

exit

asmcmd

cd +FRA/

word image 1662 2

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
[oracle@rac1 ~]$ asmcmd
ASMCMD> ls
DATA/
FRA/
OCR/
ASMCMD> cd FRA
ASMCMD> ls
DUONG/
ORADB/
ASMCMD> cd duong
ASMCMD> ls
ARCHIVELOG/
AUTOBACKUP/
BACKUPSET/
CONTROLFILE/
FLASHBACK/
ONLINELOG/
ASMCMD> cd ARCHIVELOG/
ASMCMD> ls
2024_05_12/
ASMCMD> cd 2024_05_12/
ASMCMD> ls
thread_1_seq_10.304.1168785893
thread_1_seq_11.306.1168788551
thread_1_seq_12.307.1168788553
thread_1_seq_13.309.1168788555
thread_1_seq_14.311.1168789435
thread_1_seq_15.313.1168791601
thread_1_seq_16.314.1168792099
thread_1_seq_5.282.1168760473
thread_1_seq_6.286.1168760497
thread_1_seq_7.296.1168774883
thread_1_seq_8.297.1168774887
thread_1_seq_9.300.1168777463
thread_2_seq_1.280.1168735243
thread_2_seq_10.312.1168790709
thread_2_seq_2.283.1168760473
thread_2_seq_3.287.1168760497
thread_2_seq_4.290.1168766219
thread_2_seq_5.301.1168785887
thread_2_seq_6.302.1168785889
thread_2_seq_7.303.1168785889
thread_2_seq_8.308.1168788553
thread_2_seq_9.275.1168790707
ASMCMD>

Done!!!

Xem thêm:

Datalinks.vn