Raman spectroscopy and X-ray diffraction studies of oxide thin films