No, you don't need a vector database. You can get OK results by prompting "give me ten search terms that are relevant to this question", then running those searches against a regular full-text search engine and pasting those results back into the LLM as context along with the original question.
You're likely to get better results from vector-based semantic search though, just because it takes you beyond needing exact matches on search terms.