This content has been marked as final. Show 3 replies
To get some room you can delete archive like this :
Change the date as needed.
delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-8';
Run this script from the primary to get a better summary :
Alerts log are a great source of information to start.
On the Standby side try :
Make sure you see that RECOVER is still running ( MRP )
select process, status, thread#, sequence#, block#, blocks from v$managed_standby;
If not your FRA might be full and you might need to restart RECOVERY after some cleanup.
Thanks a lot mseberg. I am always thankful to you for your helpful and great inputs. At least forum RMAN is going great.
I apologize for very late reply. Actually, I can not give my feedback here any more as I handed over the matter to somebody else. But I have heard that recovery process was started again. noticed ora-600 error in the alert log and ora-4030. memory related errors.