Database Backup and Recovery (MOSC)

MOSC Banner

Is it possible to do incremental backups and restores without using datafile copies?

edited Dec 3, 2016 1:09AM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓

Hi,

version 11.2.0.3

Is it possible to do incremental backups and restores without using datafile copies?

I thought I was doing incremental backups some years ago with very simple scripts, eg:

backup as compressed backupset incremental level 0 database format... plus archivelog format...

backup as compressed backupset incremental level 1 database format... plus archivelog format...

When I try and restore them with a (also) very simple restore and recover script the restore is successful but when I do the recover it complains:

run {

     <channel conf...>

       set until time "to_date...

       restore database;

}

channel c1: restoring datafile 00001 to +DATA...

(completed without errors)

The alert log shows though:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center