I used an older HP4195A to do these measurements (I know what circuit you built based on seeing it on LinkedIn, hello from the writer of that App Note!). While that piece of equipment says it only does 10Hz, it can actually go down to 3Hz with reasonable fidelity.
If you're wanting to just get stuff in the 1Hz to 10Hz range, you can also just take a few discrete points and add them to your data, I would not expect anything to be nonlinear down there.
Thank you, Todd! Nice to meet you here as well 
I have access to SDS2000X plus, SDG6022 to perform the Bode plot.
I don't yet have access to the SDS2000X plus internal AWG ( need to open this option).
I must say that the manual for these devices lacks enough depth on how to connect the devices and perform well the sweep.
I also have access to Magnova scope. But its AWG/Bode plotter will be available in July.
I do want to try the white noise option. It looks very fun. The SDG6022 has Gaussian noise output which can be frequency-limited.
You can perform Bode plot with internal AWG even without AWG license.
But if you have SDG6000X that use it, it is better.
Mike already said everything about Bode plot. Nothing to add.
As for frequencies lower than 10 Hz....
You keep wiring as for Bode plot.
In measurements, you have both amplitude related measurements and phase too.
You set measurements to measure P-P and Stdev on input(CH1) and output (CH2) and Phase between CH1 and CH2. Enable statistics. Even histicons. Mini histograms will be useful to judge quality of data.
Decide how many points per decade you need between 0.1Hz and 10Hz.
Set SDG6000X to 0.1Hz, set timebase to 100ms/div and let it run so it gathers measurements and stats.
Stop scope. Write down data. Or do screen shot.
Set next frequency on AWG. Adjust timebase on scope. Run scope again.
Wait.. Rinse and repeat.
Enter data in spreadsheet, calculate amplitude ratios and plot.
For calculations, use Mean value of the measurement from stats, that is averaged value.
It is half manual method but all results are in same place so easy to collect.
It is pretty quick as it is, for one time measurement.
If you need to repeat measurement often then some SCPI/Python scripting might save time long term.
With both scope and AWB on Ethernet, it can be scripted to be fully automatic.
Normally, expect this process to be slow. Like minutes per point at lowest end. Capturing only 12 periods at 0.1 Hz is already two minutes. You want to capture at least 10-20 for averaging to do its thing.