Datafile without backups – how to restore?

Originally posted on “Databases at CERN” blog

Have you ever had a problem with restoring datafiles without any backups available? It’s easy, of course if you have all archived logs from the time datafile was created. Please check it here: Re-Creating Data Files When Backups Are Unavailable. Moreover, RMAN is clever enough to create empty datafile automatically during restore phase and then recover it using archived logs. So far, so good, but…

Continue reading “Datafile without backups – how to restore?”

Advertisements