Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01613: thread 2 only has 1 logs - at least 2 logs required to enable

204213Jan 8 2004 — edited Jan 8 2004
Hello,

I have just ran through the final stage (db creation using dbca) of the RAC install on redhat AS 2.1.

At the end i was informed

"ORA-01613: thread 2 only has 1 logs - at least 2 logs required to enable"

I gave heard that to create the log for that thread can be created using

alter database add logfile thread 2......

but i am not very familiar with oracle, so any suggestions/comments would be greatly appreciated.

When i run

select inst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status db_status, active_state state, host_name host FROM gv$instance;

it tells me:

INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS
---------- ---------- ---------------- --- ------------ -----------------
STATE HOST
--------- ----------------------------------------------------------------
1 1 orcl1 YES OPEN ACTIVE
NORMAL rac2.ractest.com


-- it does not show the rac1 node. I think it should be just something like creating a new redo log for thread 2 and mounting the instance on rac1, is that correct? what are the steps i should need to fix this?

any help HUGELY appreciated,

Ireland.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2004
Added on Jan 8 2004
3 comments
2,779 views