Originally Posted by mp1508
can save me all the troubles in future!!
I don't know what the problem was, but to save you troubles in the future:
1. If this is your production system don't play around with it. If you have to play around make a backup first.
2. Always read the screen output, this could have saved you the time for troubleshooting.
3. If you don't understand what exactly will happen when you confirm a question, ask here first, not after confirming.
4. Can't say it often enough: Backup, Backup, Backup, especially when this is a production system. This is the point many people simply omit, but that is the worst idea ever.