INSTANCE LOCK, deleting tablespace Options

[tbtbs]

Greetings all

In the past, we setup a standby database on our production server. My OS is HPUX, Oracle 10g and my database is in archive mod. We are no longer using the standby database method. My problem now is that one of my tablespace (/oradata/tn/rd2_temp 20gb) became 100% full on my production system. In trying to provide more space, I removed one of the standby redo logs. Instead of using ALTER database, I just did a rm from the OS. As I said earlier my STANDBY DB is inoperatable.

When I tried to drop the tablespace(/oradata/tn/rd2_temp it is 20gb), I am getting an oracle error (ora-19528 redo logs being cleared may need access to files). Im also getting and INSTANCE LOCK on ARC4. The rd2_temp tablespace is now offline. If I get rid of rd2_temp, I will be able to gain more space back to /oradata/tn.

My database is still up and working okay.

What can I do to fix the problem.

Any suggestions will be greatly appreciated.

Thank you
tbtbs

[HelloRavi]

To resolve this , you need to re-create the control file. You may go thru the below link,

http://aprakash.wordpress.com/2010/03/06/ora-19528/

[burleson]

>> In trying to provide more space, I removed one of the standby redo logs.

Oops!

You need to recover the instance.

>> Instead of using ALTER database,

Did you try the alter command?

When you do something that is clearly "wrong", you need to contact Oracle technical support:

http://support.oracle.com

[tbtbs]

thanks for the replies. Will work both to see which is best for us

tbtbs

Greetings all

In the past, we setup a standby database on our production server. My OS is HPUX, Oracle 10g and my database is in archive mod. We are no longer using the standby database method. My problem now is that one of my tablespace (/oradata/tn/rd2_temp 20gb) became 100% full on my production system. In trying to provide more space, I removed one of the standby redo logs. Instead of using ALTER database, I just did a rm from the OS. As I said earlier my STANDBY DB is inoperatable.

When I tried to drop the tablespace(/oradata/tn/rd2_temp it is 20gb), I am getting an oracle error (ora-19528 redo logs being cleared may need access to files). Im also getting and INSTANCE LOCK on ARC4. The rd2_temp tablespace is now offline. If I get rid of rd2_temp, I will be able to gain more space back to /oradata/tn.

My database is still up and working okay.

What can I do to fix the problem.

Any suggestions will be greatly appreciated.

Thank you
tbtbs