Re: locks DB 19c
Posted by Roshan on May 12, 2023; 3:20pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/locks-DB-19c-tp11870p11871.html
v$log output. how can I fix . In fact we restore from RAC to standalone.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
1 1 563 1.0737E+10 512 1 NO
CURRENT 1.4582E+12 12-MAY-23 9.2954E+18 0
2 1 561 6442450944 512 1 YES
ACTIVE 1.4582E+12 12-MAY-23 1.4582E+12 12-MAY-23 0
3 1 562 1.0737E+10 512 1 YES
ACTIVE 1.4582E+12 12-MAY-23 1.4582E+12 12-MAY-23 0
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
4 2 1 6442450944 512 1 YES
INACTIVE 1.4560E+12 05-MAY-23 1.4560E+12 05-MAY-23 0
5 1 560 1.0737E+10 512 1 YES
ACTIVE 1.4582E+12 12-MAY-23 1.4582E+12 12-MAY-23 0
7 2 0 1.0737E+10 512 1 YES
UNUSED 0 0 0
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
8 2 0 1.0737E+10 512 1 YES
UNUSED 0 0 0