Database Backup and Recovery (MOSC)

MOSC Banner

Create consistent, self-contained incrementally merged backup

edited May 15, 2017 11:52PM in Database Backup and Recovery (MOSC) 2 commentsAnswered

We use the following script to create a self-contained, consistent full backup --

run {

        set nocfau;

        allocate channel ch1 device type disk format '/backup03/%U';

        allocate channel ch2 device type disk format '/backup04/%U';

        backup as copy database plus archivelog;

        backup as copy current controlfile;

}

We are attempting to develop a similar script but one that does an incremental backup and merge --

run {

      set nocfau;

      allocate channel ch1 device type disk format '/backup03/%U';

      allocate channel ch2 device type disk format '/backup04/%U';

      backup incremental level 1 for recover of copy with tag 'tag' database plus archivelog;

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