2 Story Goals?
Question: Can a main character have 2 story goals or should there only be one main goal that takes precedence over all others?
Answer: In a fully developed story, the main character will have two main goals. On the one hand, there is the story goal, the one which most of the characters are involved with or affected by in one way or another.
On the other hand, the main character will be wrestling with a personal dilemma, an inner conflict over what kind of person he should be, how he should deal with his personal problems, etc.
Ideally, what makes him (or her) the main character is that the choice he makes that resolves his personal dilemma also determines whether the overall story goal is achieved.
To take some examples everyone knows, when Luke Skywalker decides to trust his feelings rather than his targeting computer, he is able to destroy the Death Star. When Richard Blaine puts his personal feelings aside and starts sticking his neck out for the greater good, he is able to help Victor Laslow escape Casablanca and defeat the Nazis. When Romeo and Juliet decide to kill themselves rather than live without each other, it causes a reconciliation between their two feuding families.
Of course, there are stories where the main character lacks inner conflict (for instance, old pulp novels and comics books), but they tend to be emotionally flat. Similarly, a story without an overall goal may paint an emotional picture of a character, but seem pointless (and often plotless).
In a longer work, you could also give a main character additional goals, perhaps within subplots. But you should make sure they make a meaningful contribution to the overall theme of the story.
It is also possible to have two or more stories contained within a single novel, each with their own story goal, and possibly their own main character. The danger is that you may not have the space to fully develop each story. Often it's better to write a series of books, in which all the stories are connected somehow.