Mad Jock
At your home base, if another visual approach could be fitted in, it would be offered to you with a maximum altitude given if necessary. eg "Right hand circuit, not above 2000ft". Otherwise we would expect you to execute a standard missed approach to altitude 3000ft (or 2500ft if radio fail).
I think that I have only seen it happen once at Aberdeen, when a Budgie pilot lost visual reference on right base for RW34. In that case he was given a climbing right turn heading 345 to alt 3000ft.