Si necesitas verificar cuanto espacio del FRA, se encuentra ocupado dentro de la base de datos, lo puedes hacer a través de una consulta directa a la vista dinámica :
V$FLASH_RECOVERY_AREA_USAGE
root@lab01-db1:~# su - oracle
Oracle Corporation SunOS 5.11 11.2 August 2015
-bash-4.1$ sqlplus /nolog
SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 18 16:42:21 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5653
Next log sequence to archive 5658
Current log sequence 5658
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
SQL> set linesize 200
SQL> /
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE .03 0 1 0
REDO LOG 0 0 0 0
ARCHIVED LOG 4.58 0 2333 0
BACKUP PIECE 0 0 0 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 0 0 0 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
8 rows selected.
SQL>
No hay comentarios:
Publicar un comentario
Te agradezco tus comentarios. Te esperamos de vuelta.