Oracle8

[Mark_596]

Again thanks

I will do some more investigating tomorrow. The reason why I asked about the backup. Was because I asked our DBA to check the backup script to ensure everything is in there what we needed.

follows more info from the log file.

Shutting down instance (normal)
License high water mark
time stamp
shutdown waiting for logins to complete
time stamp
shutting down instance (abort)
timestame
starting oracle instance (normal)

Thanks

[Steven E. Protter]

EEEK!

After any shutdown abort, you need to bring the database back up again and shut id down normally.

shutdown abort

.... messages

startup

.... messages

shutdown immediate

Also, you may have a licensing issue on your hands. WE still have Oracle 8 and I don't ever see that message.

SEP

[Patti Johnson]

Mark,

From what you posted from the alert log you might have a concern - if the backup is done after the shutdown (abort).


Shutting down instance (normal)
License high water mark
time stamp
shutdown waiting for logins to complete
time stamp
shutting down instance (abort)
timestame
starting oracle instance (normal)

If you do a shutdown - without any option - normal is the default. This means that Oracle will wait for all connected users to logout. If they leave a session open - oracle will wait and wait... regardless of activity.
The shutdown abort will bring the instance down quickly - but the database will not be is a consistent state to do a cold backup.

A better option is to do a shutdown immediate, oracle will then cancel all active session and rollback the transactions before shutting down. The database is then in a consistent state and your backup is valid. If you must do a shutdown abort ( because the shutdown immediate hangs ) then do a startup and shutdown immediate before running your backup.

Patti

[Yogeeraj_1]

hi,

i would check the logs at the OS level also. If there is no messages about a shutdown in the alert.log then it must have been some sort of crash at the OS level!

did the server restart?
Are there any core dumps?

i would check the shutdown.log and also verify if the database is configured to start automatically or manually...

just some thoughts.

can you post your alert.log?

just some thoughts

regards
Yogeeraj

[Jean-Luc Oudart]

Hi Mark,

if someone connect as SYSDBA (or internal) he/she will be logged into the audiot trace file.

The audit trace file is located in $ORACLE_HOME/rdbms/audit

cf . Metalink Note:103964.1

Regards
Jean-Luc