Lots of good advice already in here. Easier said than done but try not to fear it, your body was made to do this - and if things go 'wrong' you have an experienced medical team to ensure the safe delivery of your Bub and minimise (or eliminate) your pain if you wish. Assuming you're not home-birthing! (Not that there is anything wrong with that, each to their own).
I was always told fear = tension = pain. So anything you can do to minimise fear will minimise your pain.
My first birth was horrendous. Well the last few hours (which ended in an emergency c) were. The first 15 or so were fine because I was 'in the zone'. As soon as I panicked, all hell broke loose and it was painful as.
My second birth was empowering. It was fast - 5 hour labor - intense - but I never once even considered pain relief. It's not that it didn't hurt - I just didn't register the pain - instead saw it as progress. However I did a lot of mental and physical preparation in order to do this.
I personally looked forward to both of my births. A little naive with the first, but all guns blazing with the second. If things are going to go wrong there isn't much you can do about it, so try think positively and focus on the end goal. And absolutely trust your body!