rac 3节点，有一个损坏了，如何删除坏的这个节点？

wing hong

Hi Warehouse,

1. if the instance is in shutdown state, then the thread status is "closed", that should be fine.

2. What I did is in the  normal siutation , i.e. all my disk and log file is OK. so in that case,  you should be able to disable your thread first and then drop your log file group. you might need to do a archive log all before you can drop the last log group.
( in my previous post, I said drop logfile group first , then disable the thread, which looks incorrect, the sequence should be disable your thread first , then drop the logfile group , I have done a quick test now. it works.

3. but in your case,  the situations may be different, since your current log is dead, then no way you can do the archivelog all, so maybe in this case you need to do a media incomplete recovery first to fix the dead logfile issue.

warehouse

最初由 wing hong 发布
[B]Hi Warehouse,

1. if the instance is in shutdown state, then the thread status is "closed", that should be fine.

2. What I did is in the  normal siutation , i.e. all my disk and log file is OK. so in that case,  you should be able to disable your thread first and then drop your log file group. you might need to do a archive log all before you can drop the last log group.
( in my previous post, I said drop logfile group first , then disable the thread, which looks incorrect, the sequence should be disable your thread first , then drop the logfile group , I have done a quick test now. it works.

3. but in your case,  the situations may be different, since your current log is dead, then no way you can do the archivelog all, so maybe in this case you need to do a media incomplete recovery first to fix the dead logfile issue. [/B]

非常感谢，做不完全恢复是不太可能了，因为我没有任何备份的！