Hi guys:
I keep getting the ora-00257 error and i don't know how to fix it.
I've went to rman and deleted all expired and obsolete backups (there were none), so i've deleted all.
My siebel instance started but a few hours later it happend the same so i went to sqlplus, gave me the same error and told me that i could only connect locally.
I've connect using sqlplus /as sysdba and run the select * from v$log;
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 545 52428800 1 NO INACTIVE
6048085187 22-SEP-16
2 1 546 52428800 1 NO INACTIVE
6048128372 22-SEP-16
3 1 547 52428800 1 NO ACTIVE
6048471275 22-SEP-16
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 548 52428800 1 NO CURRENT
6048522470 23-SEP-16
I've used alter database clear unarchived logfile group 1; and now the service is running.
I've noticed on all my google searches that tries to fix this, that all logs are archived (besides the current one). I don't know how to do this .
I know that these are transactional logs or redologs and they are supposed to overwrite themselfs once they get filled. I think this is happening because the logs are not being automatically cleared and they get filled up.
My question is, why is this happening over and over again and what am i doing wrong.
I'm not a dba expert, i need lots of training (i know that)
Thanks so much and i'll appreciate all help
Regards.
Francisco.