Linux

Ask something
Discussion Locked

Solaris-Deleting failed state databases

0 helpful
4 replies

by cp409sd 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have two state databases on separate disks that later became raw partitions used by Oracle. When the raw partitions were defined, I think that they overlapped the state db's because looking at a metadb command, I can see that these state databases are now invalid.

I would like to delete these state databases, but I want to make sure that this will NOT actually delete any of the data IN the state databases, since the raw partitions have overlapped them. I am hoping that the metadb -d command will only delete the reference to these invalid state databases, as I believe that if the actual blocks that the state databases are using were erased, it would corrupt the data in the raw partition used by Oracle's redo logs. Does this make sense?

I would appreciate if someone, or several people could let me know for sure if deleting these state databases is safe for me to do. This is a very important production system. Thanks.

4 replies

by martin simons

As long as there are other state databases (if these state dbs are in a disk set, then there must be other state dbs in the same disk set) then the data will not be lost. All information is stored in every state db (within the disk set if it is a disk set). So go ahead and delete them.

by cp409sd

ghislain:
Unfortunately I cannot find that document. I do not have a subscription to Sunsolve.

Martin:
Thank you, as I do have enough other state databases I am not worried about that issue. What I am concerned with is that it will corrupt the data that has been used for the Oracle raw partition, thinking it is deleting the state database.

This discussion is closed to new replies.