Use this phrase when you can't remember something that you're supposed to remember. For example:
I'm sorry. What was your name again?
How old is your daughter again?
What was the password again?
We use this expression mostly in spoken English. It's not common in formal writing, prepared speeches, and so on.