ORA-01613: thread 2 only has 1 logs - at least 2 logs required to enable
204213Jan 8 2004 — edited Jan 8 2004Hello,
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.