Friday, 9 January 2015

Recovery Writer (RVWR) is stuck until more space - DR database is not sync error with

We are getting below error in the alert log of DR database and archives are not applying the DB is not in sync

ERROR:
*************************************************************
Unable to allocate flashback log of 4568 blocks from
current recovery area of size 483183820800 bytes.
Recovery Writer (RVWR) is stuck until more space
is available in the recovery area.
Unable to write Flashback database log data because the
recovery area is full, presence of a guaranteed
restore point and no reusable flashback logs.
Fri Jan 09 13:45:47 2015
*************************************************************


On verification,when we see in v$restore_point we had guarantee restoration point,Which we did during DR drill.
So we dropped the guarantee


SQL> select scn,name,time from v$restore_point;

       SCN
----------
NAME
--------------------------------------------------------------------------------
TIME
---------------------------------------------------------------------------
2.8271E+12
BEFORE_SWITCH_TO_PRIMARY
09-DEC-14 09.38.24.000000000 AM

Then dropped the restore point

SQL>drop restore point BEFORE_SWITCH_TO_PRIMARY;

++ Now recovery started


No comments: