السلام عليكم
الى اهل العلم اصحاب العقول المبدعه
لدى سوال مهم جدا وارجو المساعده
ما هى المشكله التى تحدث عندما تملى الflash recovary area وذلك داخل الenterprise manger
و ماهوعالجها? وجزاكم الله عنا كل الخير

السلام عليكم و رحمة الله و بركاته

فى حالة لو الflash recovery بقى full فى الاول هيديك رسالة تحذيرية و لما يتملا على الاخر مش هتقدر يكمل الjobs بتاعة الbackup لان مفيش مساحة.

و بمنتها البساطة تروح تكبر المساحة بتاعتة

to enable the flash recovery area, you must set the two initialization parameters

• DB_RECOVERY_FILE_DEST_SIZE
• DB_RECOVERY_FILE_DEST
  
  

DB_RECOVERY_FILE_DEST_SIZE must be set before DB_RECOVERY_FILE_DEST.

to set DB_RECOVERY_FILE_DEST_SIZE

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='*';

The V$RECOVERY_FILE_DEST and V$FLASH_RECOVERY_AREA_USAGE views can help you determine whether you have allocated enough space for your flash recovery area.

Query the V$RECOVERY_FILE_DEST view to find out the current location, disk quota, space in use, space reclaimable by deleting files, and total number of files in the flash recovery area.


SQL> SELECT * FROM V$RECOVERY_FILE_DEST;


Query the V$FLASH_RECOVERY_AREA_USAGE view to find out the percentage of the total disk quota used by different types of files, and how much space for each type of file can be reclaimed by deleting files that are obsolete, redundant, or already backed up to tape.

SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;


to set DB_RECOVERY_FILE_DEST

This parameter specifies a valid disk location for file creation, which can be a directory on a file system, or Automatic Storage Management disk group.


ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/disk1/flash_recovery_area' SCOPE=BOTH SID='*';

If the flash recovery area location is an Automatic Storage Management disk group named disk1, for example, then you can do the following:
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '+disk1' SCOPE=BOTH SID='*';

طبعاً تحط الSID بتاعتك