If you manage to find a good story, your novel is made. It means, only when you complete the novel, will you have a good story. If you're thinking of a story before even starting to write the novel, it amounts to the same thing as putting the cart before the horse. Most novelists have a vague idea of how their story will develop when they begin writing a novel.
Of course, you need to know the genre, the subject, the circumstances, the characters, and yes, the objective. A novel conveys a message to the audience. So what's the message that you want to convey to your audience? Remember, this is the highest level of fiction and at that level, you need to be as real as you possibly can although you need not necessarily be as factual.
There are scores of very good novels written by some of the best writers of their time and there are so many that I have missed that it embarrasses me to even acknowledge it. Let's consider a very interesting novel titled 'Exodus' written by an author named Leon Uris. In many ways, it's one of the best works of fiction that tells you the story of the country we now know as Israel.
The amount of research that might have gone into the book can only be guessed but it takes you through the different stages of the formation of this country in such detail that you would be inclined to believe that it's a true story. The fact that I am making this assertion proves Uris has managed to convey his message very effectively.
So, if you want to write a novel, instead of looking for a story right away, look for a subject. What is it that you want to write about? Maybe that's what you meant when you asked for a "good story" for your novel. Genre and subject are what you should first contemplate on before you can hope to begin writing your novel.
For instance, if history is an area of strength, pick up the theme of any historical city like Jaipur, Indore, Hyderabad or take a smaller historical town, like Alwar in Rajasthan or Murshidabad in West Bengal and identify your character immediately because, without a character, you just can't write a novel.