Recently, after creating new physical standby from duplicated database I found that PERCENT_SPACE_RECLAIMABLE on standby is always 0, while on primary it is equal to PERCENT_SPACE_USED. Archivelog deletion policy was the same on both databases :
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
So in fresh, newly created physical standby I would be in trouble when recovery area free space will come to the end.
The solution was to open that standby database in 'read only' mode, after that PERCENT_SPACE_RECLAIMABLE had been refreshed to right value. After bouncing the standby into MOUNT state and after running it in normal mode the free space in the flash recovery area was shown correctly.
No comments:
Post a Comment