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…………….
0 comments:
Post a Comment