Learning the hard way on Oracle Database Clustering and Application

Today learning the hard way on Oracle Database clustering and Application.

On last Saturday 0200h++, I perform altering temp tempfile to temp2 tempfile on my PROD database. It was not as what I expected which I had done it on other database before. The alteration is OK but not completed.

No error for the whole day.

Last night 2040h++, I want to alter back from temp2 to temp but faced a big error, the whole Oracle application halt. I forget to check the session on PROD which is still access the temp.

To continue...