Database Software

Hi,

I have a Standby Database and the DR log synchronization with Primary Database was interrupted due to below errors:

Unable to allocate flashback log of 1946 blocks from
current recovery area of size 2147483648 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.
Use ALTER SYSTEM SET db_recovery_file_dest_size command
to add space. DO NOT manually remove flashback log files
to create space.

--> On DR server

SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;

DATABASE_ROLE INSTANCE PROTECTION PROTECTION_LEVEL
---------------- ------------------------------ ---------- --------------------
SWITCHOVER_STATUS
--------------------
PHYSICAL STANDBY A80 MOUNTED MAXIMUM PERFORMANCE
SESSIONS ACTIVE

SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby;

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 APPLYING_LOG 1 29118 125049 186723
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0

6 rows selected.

--> Alert log

Sat Mar 17 04:51:00 2012
RFS[606]: Archived Log: 'L:\ORACLE\A80\ORAARCH\A80ARCH\ARC29222_0681431456.001'
Primary database is in MAXIMUM PERFORMANCE mode
Sat Mar 17 05:51:07 2012
RFS[606]: Archived Log: 'L:\ORACLE\A80\ORAARCH\A80ARCH\ARC29223_0681431456.001'
Primary database is in MAXIMUM PERFORMANCE mode
Sat Mar 17 06:51:04 2012
RFS[606]: Archived Log: 'L:\ORACLE\A80\ORAARCH\A80ARCH\ARC29224_0681431456.001'
Primary database is in MAXIMUM PERFORMANCE mode
Sat Mar 17 08:50:40 2012
RFS[606]: Archived Log: 'L:\ORACLE\A80\ORAARCH\A80ARCH\ARC29225_0681431456.001'
Sat Mar 17 12:28:30 2012
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL


I did a "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL" to stop the log shipping on DR server but the command is hanging.

I also tried freeing up the disk space in my flashback drive but I think it won't help as indicated in the error message:
"DO NOT manually remove flashback log files to create space".

What is the best way to set the DR server back to normal operation?
I do not need the flashback logs and will disable the flashback once this is rectified.

This is Oracle 10.2.0.4 Physical Standby using Oracle Dataguard.

Thanks a lot!