My partner had a herniated disc, in the majority of cases they do not perform surgery. She has recurrent back problems which transpired to be exacerbated by the fact she has a spinal deformity from birth (only took 39 years to figure that one out)
OP depending on your reasons for the pain and also general fitness level you may find benefit in doing a dead hang from whatever convenient thing you can hang from.
Put your hands straight above your head, try and keep as much of your body even and straight as possible and hang from your hands for a comfortable period of time. Keep your shoulders engaged (look up pull up technique for an explanation of that, you don't want to injure more of you) Depending on how that feels/confidence you can add in a tiny bit of hip rotation if the pain allows. try and relax as much of your body as you can. Repeat this a few times if you feel able.
You don't even really need to lift your feet right off the floor tbh, any transfer of weight from your feet/lower spine will be beneficial
A lot of the time the pain is caused by some form of spinal compression
In the longer term any exercise that strengthens your core muscles will help with recurrence of symptoms and with your body being able to deal better with any future attacks as the front part of your core will help support you better and relieve the work your back is doing to a degree. Also light stretches that encourage your spine to open rather than compress
Sorry if I've totally over estimated your fitness level!
my partner has suffered with back pain for years and we've tried a load of different things over the years. This has generally proven to be most effective short term relief and has never been advised against by any of the specialists she has seen
Good luck with it