ORA-1618 during database startup
SQL> startup ORACLE instance started. Total System Global Area 1336176640 bytes Fixed Size 2253024 bytes Variable Size 469765920 bytes Database Buffers 855638016 bytes Redo Buffers 8519680 bytes ORA-01618: redo thread 3 is not enabled - cannot mount Check logfiles SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- 1 1 335 52428800 512 2 YES INACTIVE 56390322 30-SEP-14 56393525 30-SEP-14 2 1 336 52428800 512 2 NO CURRENT 56393525 30-SEP-14 2.8147E+14 3 2 237 52428800 512 2 NO CURRENT 56387052 30-SEP-14 2.8147E+14 4 2 236 52428800 512 2 YES INACTIVE 56359748 30-SEP-14 56387052 30-SEP-14 --> Instance 3/ Thread 3 is missing REDO logs - Recreate REDO logs http://www.hhutzler.de/blog/duplex-online-redo-logs-to-fra/ Add LOGFILES: SQL> ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 5 size 50m; SQL> ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 6 size 50m; Database altered. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- 1 1 335 52428800 512 2 YES INACTIVE 56390322 30-SEP-14 56393525 30-SEP-14 2 1 336 52428800 512 2 NO CURRENT 56393525 30-SEP-14 2.8147E+14 3 2 237 52428800 512 2 NO CURRENT 56387052 30-SEP-14 2.8147E+14 4 2 236 52428800 512 2 YES INACTIVE 56359748 30-SEP-14 56387052 30-SEP-14 5 3 0 52428800 512 2 YES UNUSED 0 0 6 3 0 52428800 512 2 YES UNUSED 0 0 6 rows selected. Enable THREAD SQL> alter database enable public thread 3; SQL> select THREAD# , STATUS , ENABLED from v$thread; THREAD# STATUS ENABLED ---------- ------ -------- 1 OPEN PUBLIC 2 OPEN PUBLIC 3 CLOSED PUBLIC SQL> startup force ORACLE instance started. .. Database mounted. Database opened. Start and stop instance with srvctl [oracle@grac43 adump]$ srvctl stop instance -d grac4 -i grac43 [oracle@grac43 adump]$ srvctl start instance -d grac4 -i grac43 ---------------------
Your Site is very informative and helpful. You are a master
I just wanted know what is the actual command for “crs” as i dont see there is “CRS” command.
Following is one of the example you are using to find the svc details, but i could not use this command
I tried crsctl stat res -t /p etc., but couldnt get output what you get from this
crs | egrep ‘hr.svc|NAME|—-‘
Appreciate if you could help with this
Hi,
crs [ and crsi ] are both shell scripts to display the CRS status.
You can download these scripts by using Menu Path
RAC -> RAC Generic -> RAC Scripts
useful information provided