$\newcommand\al\alpha\newcommand\de\delta\newcommand\R{\Bbb R}\newcommand\B{\mathrm B}$It follows from the ODE 
$$f''=f^{-\al} \tag{1}\label{10} $$
and the condition $f>0$ that $f$ is (strictly) convex. If $f(\infty-)<\infty$, then, by \eqref{10}, $f''(\infty-)>0$ and hence $f(\infty-)=\infty$. So, $f(\infty-)=\infty$. Similarly, $f(-\infty+)=\infty$. So, $\inf f=f(t_0)$ for some real $t_0$. By shifting, without loss of generality $t_0=0$. 

Now take any real $\de>0$ and let 
$$g(z):=\int_\de^z\frac{dy}{\sqrt{k(\de^{1-\al}-y^{1-\al})}}
\Big[=\frac{\de ^{(\al +1)/2} }
{\sqrt{2} \sqrt{\al -1}}\, 
\B_{1-(z/\de)^{1-\al}}\Big(\frac{1}{2},\frac{1}{1-\al }\Big)\Big]$$
for real $z\ge\de$, where $k:=\frac2{\al-1}$ and $\B$ is the [incomplete beta function][1]. Then $g\colon[\de,\infty)\to\R$ is a continuous function strictly increasing from $0$ to $\infty$ on the interval $[\de,\infty)$, and $g$ is smooth on the interval $(\de,\infty)$, whereas $g'(\de+)=\infty$. 

For real $t$, let $f(t):=g^{-1}(|t|)$. Then $f$ is a solution to ODE \eqref{10} with $\inf f=f(0)=\de$ (see the Detail below). So, $f$ is the only solution of \eqref{10} satisfying the initial conditions $f(0)=\de$ and $f'(0)=0$. 

Moreover, 
$|f'|=\sqrt{k(\de^{1-\al}-f^{1-\al})}\le\sqrt{k\de^{1-\al}}$, so that $f$ is Lipschitz and hence locally Hölder. However, this solution $f$ of ODE \eqref{10}, which is unique up to the shifting, is not globally Hölder with any exponent $<1$, because $f'(\infty-)=\sqrt{k\de^{1-\al}}>0$. 

**Detail:** On the interval $[0,\infty)$, we have $f'=\sqrt{k(\de^{1-\al}-f^{1-\al})}$ and hence 
$$f''=\frac{-k(1-\al)f^{-\al}f'}{2\sqrt{k(\de^{1-\al}-f^{1-\al})}}
=f^{-\al},$$
so that $f$ satisfies your ODE on the interval $[0,\infty)$. Similarly, $f$ satisfies your ODE on the interval $(-\infty,0]$.

---

For an illustration, with $\al=3/2$ and $\de=3/10$, here are the graphs $\{(z,g(z))\colon\de\le z\le5\}$ (left) and $\{(t,f(t))\colon|t|\le g(5)\}$ (right): 

[![enter image description here][2]][2]


  [1]: https://en.wikipedia.org/wiki/Beta_function#Incomplete_beta_function
  [2]: https://i.sstatic.net/fzxWpsQ6.png