Finding the current status of the flash_recovery_area:
COL name FORMAT A32 HEADING 'File Name'
COL spc_lmt_mb FORMAT 99999.99 HEADING 'SpaceLimit(MB)'
COL spc_usd_mb FORMAT 99999.99 HEADING 'SpaceUsed(MB)'
COL spc_rcl_mb FORMAT 99999.99 HEADING 'ReclmSpace(MB)'
COL number_of_files FORMAT 99999 HEADING 'Files'
SELECT name ,space_limit /(1024*1024) spc_lmt_mb ,space_used /(1024*1024) spc_usd_mb ,space_reclaimable /(1024*1024) spc_rcl_mb ,number_of_files FROM v$recovery_file_dest;
+++
Increasing the space allocated to the Flash Recovery Area:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = '6G' SCOPE=BOTH SID='*';
+++
Clearing up the archive logs from the flash recovery area:
NOTE: You will need to take a full backup after doing the following...
1) Delete the ones that aren't needed.
2) Connect to RMAN
a) CROSSCHECK ARCHIVELOG ALL;
b) DELETE EXPIRED ARCHIVELOG ALL;
---
I'll meet you further on up the road.
Jim Hill
Showing posts with label 10g. Show all posts
Showing posts with label 10g. Show all posts
Monday, May 7, 2007
Subscribe to:
Posts (Atom)