I have had relatively few failures of media of any kind, but have had some hard drives, CD-ROMs, ZIP disks and floppies fail. Media failure has been less common than drive failure. Which then gets to the heart of your problem.
If you want to read your data 10, 20 or 30 years from now you will need to assure that you have a reader operating. Availability of new readers for purchase declines rapidly as the time scale increases. It is virtually impossible to buy "new" floppy or ZIP drives now. I expect the same problem to develop over the next decade or two for CD disks.
The only solution for long term data archiving is a plan to continually move the data onto new media as the technology moves along. And this problem is why when this civilization eventually crashes (they all do), almost all of the knowledge we have assembled will be lost with it.