Sat Apr 22 00:32:14 2017
Errors in the file/u01/app/oracle/diag/RDBMS/SDMDDB SDMDDB1/trace/SDMDDB1_m000_82504 TRC:
ORA - 19815: WARNING: db_recovery_file_dest_size of 1471152128000 bytes is 97.18%, informs, and from the remaining 41450209280 bytes available.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
You have the following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using the Data Guard,
Then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device to as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and happens db_recovery_file_dest_size parameter to
Reflect the new space.
4. Delete unnecessary files using RMAN the Delete command. If an operating
The system command was 2 delete files, then use RMAN CROSSCHECK and
The DELETE EXPIRED commands.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Check the file
SQL> Archive log list;
The Database log mode Archive mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
The Oldest online log sequence 82272
Next the log sequence to archive 82274
The Current log sequence 82274
SQL>
SQL>
SQL> Show parameter recover
The NAME, TYPE, VALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Db_recovery_file_dest string + ARCH
Db_recovery_file_dest_size big integer 1403000 m
Db_unrecoverable_scn_tracking Boolean TRUE
Recovery_parallelism integer 0
As you can see the archive using the + ARCH disk group, the quota is about 1.4 T
Check the V $FLASH_RECOVERY_AREA_USAGE; And found a piece of very low utilization rate is added, space remaining many
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
NUMBER_OF_FILES
-- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The CONTROL FILE 0 0
1
REDO LOG. 33 0
9
ARCHIVED LOG. 26 0
18
BACKUP PIECE 36.79 0
51
The IMAGE COPY 0 0
0
11
FLASHBACK LOG. 18.5
FOREIGN ARCHIVED LOG 0 0
0
Check the v $recovery_file_dest; Found SPACE_USED usage and V $FLASH_RECOVERY_AREA_USAGE completely; Is not the same, the total number of files are not the same as
SQL> Select substr (name, 1, 30), SPACE_LIMIT/1024/1024/1024, SPACE_USED/1024/1024/1024, SPACE_RECLAIMABLE/1024/1024/1024, NUMBER_OF_FILES
2 the from v $recovery_file_dest;
SUBSTR (NAME, 1, 30)
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SPACE_LIMIT SPACE_USED/1024/1024/1024/1024/1024/1024
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SPACE_RECLAIMABLE/1024/1024/1024 NUMBER_OF_FILES
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
+ ARCH
1370.11719 1137.01855
1.50292969 3210
Check the asm disk group use
ASMCMD> LSDG
State the Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 1433597 863617 863617 0 N the ARCH/
MOUNTED NORMAL N 512 4096 1048576 3069 2017 1023 497 0 Y CRS/
MOUNTED EXTERN N 512 4096 1048576 1126393 209072 209072 0 0 N DATA/
ASMCMD> CD arch
ASMCMD>
SDMDDB/
ASMCMD> Du
Used_MB Mirror_used_MB
569803, 569803,
CodePudding user response:
upupupupupup