Monday, July 2, 2012

Unable to login to Database Because Archivelog

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

2 comments:

  1. Thank you osama for sharing;-).
    i have one question:how proactively monitoring the size of flash recovry area to avoid this problem ?

    ReplyDelete