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
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:
Post a Comment