Regarding to heavy duty On Database , Database start Generates Archive log with time size for flash recovery become full , so what i have to do :
first you will not be able login for database or rman
Solution :
Step1 :
-Go to archivelog detestation and delete archivelog (old first) , if you have space on your server you can move them from direcotry to another .
-Flash Recovery On ASM , Follow the below steps
export ORACLE_SID=+ASM1
asmcmd
now you are inside ASM head to Archivelog destation and delete archive log manually (old first )
Step 2 :
Now you will be able to login to rman :
Run
{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT '/u01/';
backup archivelog all delete input ;
release c1 ; }
Now you clean Archivelog .
THis solution for Both Cluster and Single Node Database
Enjoy
Thank you
Osama mustafa
Technology Geek 
Thank you osama for sharing;-).i have one question:how proactively monitoring the size of flash recovry area to avoid this problem ?
LikeLike
Check new Post
LikeLike