Today I got an alert for My OMS is down and when I checked the oem url
I see OMS down message.
[oracle@OMS_SERVER bin]$ ./emctl status oms
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Down
JVMD Engine is Down
BI Publisher Server is Up
Checked OMS repository database(EMREPO) and i see database and listener
is up and running fine but found below error in alert log…………
*************************************************************
Unable to allocate flashback log of 6377 blocks from
current recovery area of size 32212254720 bytes.
Recovery Writer (RVWR) is stuck until more space
is available in the recovery area.
recovery area is full, presence of a guaranteed
restore point and no reusable flashback logs.
Mon Nov 07 10:51:46 2016
*************************************************************
SQL> select space_limit/1024/1024/1024
maxGB,space_used/1024/1024/1024 usedGB from v$recovery_file_dest;
MAXGB USEDGB
---------- ----------
30 29.9878693
SQL> SELECT FILE_TYPE "Type",PERCENT_SPACE_USED "%
Used",PERCENT_SPACE_RECLAIMABLE "% Reclaim",
NUMBER_OF_FILES "# Files" FROM
V$FLASH_RECOVERY_AREA_USAGE;
Type
% Used % Reclaim # Files
---------------------------------------------------------------------
---------- ---------- ----------
CONTROL
FILE
0
0 0
REDO
LOG
0
0 0
ARCHIVED
LOG
0
0 0
BACKUP
PIECE
.06
.06 1
IMAGE COPY
0
0 0
FLASHBACK
LOG
99.9
0 154
FOREIGN ARCHIVED
LOG
0
0 0
AUXILIARY DATAFILE
COPY
0
0 0
8 rows selected.
SQL> show parameter db_recovery
NAME
TYPE
VALUE
------------------------------------
-----------------------------------------------------------------------------
------
db_recovery_file_dest
string
/opt/oem/u20
db_recovery_file_dest_size
big
integer
30G
SQL> SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT;
NAME
SCN TIME
DATABASE_INCARNATION# GUARANTEE STORAGE_SIZE
--------------------------------- ----------
-------------------------------------------- --------------------- ---------
------------
EMREPO_BEFORE_UPGRADE13C
3.1001E+11 27-OCT-16 11.04.22.000000000
AM
2 YES 3.2181E+10
Now, I remember it is because of the Grantee Restore point which
I have created during my recent OMS upgrade and now I can drop this since it’s
been so many days and everything looks good.
SQL> DROP RESTORE POINT EMREPO_BEFORE_UPGRADE13C;
Restore point dropped.
SQL>
SQL> SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT;
no rows selected
SQL> select space_limit/1024/1024/1024
maxGB,space_used/1024/1024/1024 usedGB from v$recovery_file_dest;
MAXGB USEDGB
---------- ----------
30 .651931763
[oracle@OMS_SERVER bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Already Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server ...
BI Publisher Server Already Started
BI Publisher Server is Up
Now I see my OEM url is working fine…………….
