Database Backup and Recovery (MOSC)

MOSC Banner

Controlfile autobackup vs manual backup (include current controlfile vs backup current controlfile)

edited Feb 1, 2022 11:55AM in Database Backup and Recovery (MOSC) 4 comments

Hi

19.14

I was wondering, is there any difference regarding restoration perspective.

Ofcourse, controlfile autobackup includes spfile also (others probably not). But if we leave this aside. Is there any reason why to prefer one to another..?

run {
 backup incremental level 0 database FORMAT '..' plus archivelog FORMAT '..' include current controlfile;
}

vs

run {
 backup incremental level 0 database FORMAT '..' plus archivelog FORMAT '..';
 backup current controlfile;
}

vs

# Having controlfile autobackup on previously "CONFIGURE CONTROLFILE AUTOBACKUP ON;"
run {
 backup incremental level 0 database FORMAT '..' plus archivelog FORMAT '..';
}

Regards

Raul

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