OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » db start

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db start [message #64297]

Mon, 10 January 2005 09:26

Kapil
Messages: 145
Registered: May 2002

Senior Member

usually, Oracle OS user logs in as sys and starts and shut downs the db, so all db processes show oracle as the owner of that process.
Well, i logged in as xxxxx OS user and re-started a db and all the processes were owned by xxxxx OS USER FOR last couple of days including db-writer. today i saw and re-started it as oracle. so i was wondering would this cause any corruption since some of the data was written by oracle some data was written by xxxx user for few days?

Report message to a moderator

Re: db start [message #64300 is a reply to message #64297]

Mon, 10 January 2005 18:18

GOBU
Messages: 2
Registered: January 2005

Junior Member

sir

when the database is open the followin errors:

alter database open
Beginning crash recovery of 1 threads
Mon Jan 10 17:37:29 2005
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 4 Seq 452459 Reading mem 0
Mem# 0 errs 0: D:ORACLEORADATAIBMORAREDO04.LOG
Mem# 1 errs 0: D:ORACLEORADATAIBMORAREDO04A.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 452460 Reading mem 0
Mem# 0 errs 0: D:ORACLEORADATAIBMORAREDO03.LOG
Mem# 1 errs 0: D:ORACLEORADATAIBMORAREDO03A.LOG
ORA-354 signalled during: alter database open...
Mon Jan 10 17:37:50 2005
Errors in file d:OracleadminIBMORAudumpORA00242.TRC:
ORA-00600: internal error code, arguments: [[723]], [[26408]], [[26408]], [[memory leak]], [[]], [[]], [[]], [[]]

how i solve the problem?

gobu

Report message to a moderator