السلام عليكم الأخوة الأعزاء

خلال محاولة تطبيق بعض الأوامر في موضوع RMAN ، توقفت الداتابيز وظهر عندي مشكلة ، مرفقاً لكم الخطوات التي قمت بتفيذها بالتريتب
1) عمل BACKUP باستخدام RMAN ولم تنجح العملية
2) عمل RECOVER باستخدام RMAN ولم تنجح العملية
3) محاولة فتح DB ولم تنجح العملية

راجياً منكم مساعدتي وشكراً

you don't have space found in the Flash recovery Area for new archive log file
1-you need to increase the Flash recovery Area
2-or empty the Flash recovery Area

first thank you
how i can increase my flash back??? i can it as windows commands

SIZE FLASH_BACK_RECOVERY =20M
I THINK THATS ENOUGH
IF HAVE OTHER SOLUTION TELL ME IT

Flash recovery Area of 20M is very small
you should add more space to it,for example let it 3G or 5G
use this command
alter system set db_recovery_file_dest_size=3G SCOPE=BOTH;

for FRA full

1.backup the FRA it goes to tape
backup recoverarea

2.increase the size of FRA

3.if ,2 can be apllied to space problem
rman> shutdown immediate;
move the files in FRA to another drive/filesystem where you have space
rman>startup mount
rman> crosscheck archivelog all;
rman> delete expired archivelog all;
rman> crosscheck backup;
rman> delete expired backup;
rman>crosscheck copy;
rman> delete expired copy;
rman> alter database open;