Everything you have done here looks OK, but doe not resolve your problem
obviously. How did you MOVE (you really did a copy right?) the db
(e.g. shutdown, copy) and ensure that there was no issue with the files
moved? Are you sure that both db versions are exactly the same on both
servers? Are there any OS/platform differences (OS should NOT matter
per se, but you need to verify the certification and patch level, etc).
Mike
>>> "Parker Barbara E CIV COMLANTFLT "
<oracledba-ezmlmshield-x9253929.[Email address protected] 11/30/2007
11:55 AM >>>
I upgraded my 9i to 10g and then moved it to another machine that was
already running 10g with a starter database, which I replaced with the
upgraded one. I followed all the steps, but got errors on the ALTER
DATABASE OPEN RESETLOGS. The database has been opening, but I can't
get
it to stay up -- keeps crapping out about every 20-30 minutes with the
following error (SMON creates it): ORA-0600 [4194].
I look in the alert trace file and find that the smon is erroring out.
Error was NO VALID LOG MEMBER SEQ #35 FOR THREAD 1!
I shutdown the database (but that errored out) and finally when it had
killed itself, I opened it up STARTUP MOUNT. Then I did a
DATABASE RECOVER USING BACKUP CONTROLFILE UNTIL CANCEL
And gave it the sequence it was erroring on.
That was accepted with MEDIA RECOVERY COMPLETE. So I ran the ALTER
DATABASE OPEN RESETLOGS again. I got DATABASE ALTERED which I thought
meant everything was now fixed and good. No -- when I went to
shutdown
the database I got the same error again.
I have run the ALTER DATABASE CLEAR UNARCHIVED LOG GROUP # for
all
my logs. I can then shutdown the database 1 time, before I get the
errors again. I don't get the errors on STARTUP. Alert log just
shows
problems when trying to write to the redo logs. But I recreated all
of
them and dropped all the old ones.
Can anyone help?
Do I need to go back to the start with moving the db from the other
machine????
Thanks in advance,
Barb
Mrs. Barbara E. Parker
Helpdesk Manager
Assistant IAM
Comm: 850-452-0350
DSN: 922-0350
barbara.e.[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page