ORA-01149: cannot shutdown 1

[gatetec]

I need to shutdown this db, but am getting this error.
How do I resolve this?

thx much


SQL*Plus: Release 9.2.0.5.0 - Production on Sat Aug 25 08:52:34 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> Connected.
SQL> ORA-01149: cannot shutdown - file 177 has online backup set
ORA-01110: data file 177: '/dev/rdgold_0000086'
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Prn
JServer Release 9.2.0.5.0 - Production

 

[gatetec]

aloert log only says:

Sat Aug 25 08:44:04 2007
Shutting down instance: further logons disabled
Shutting down instance: further logons disabled
Shutting down instance: further logons disabled
Shutting down instance: further logons disabled
Shutting down instance: further logons disabled
Starting ORACLE instance (normal) ==> I was trying to restart
Shutting down instance: further logons disabled

 

[SantaMufasa]

First, Gatec, could it be that you (or someone else) initiated a "hot backup" on the tablespace that owns '/dev/rdgold_0000086'? If so, try issuing this command on the owning tablespace:

ALTER TABLESPACE <name of owning tablespace> END BACKUP;

If that doesn't allow you to gracefully shutdown the instance, then I would simply issue a:

shutdown abort

command. That command should shutdown the database as though you had pulled the power plug on the computer. Then, you should be able to do successfully a

startup

command.

Let us know your findings.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[gatetec]

YES, YES, YES,

ALTER TABLESPACE <name of owning tablespace> END BACKUP; is the one!

Thanks much!!!!