Database Backup and Recovery (MOSC)

MOSC Banner

Incremental backup recoveries when backups are performed on different media

edited Jul 11, 2013 9:31PM in Database Backup and Recovery (MOSC) 7 commentsAnswered ✓
Hi,
We are using a backup solution which backups Oracle Database with RMAN, directly to tape.
It uses scripts such like these:

RUN {
shutdown immediate;
startup mount;
ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
BACKUP
incremental level 0
 FORMAT 'BackupIncrementalCloseNoarc_%d_%s_%T'
 DATABASE
;
RELEASE CHANNEL CH1;
alter database open;
}

and

RUN {
shutdown immediate;
startup mount;
ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
BACKUP
incremental level 1
 FORMAT 'BackupIncrementalCloseNoarc_%d_%s_%T'
 DATABASE
;
RELEASE CHANNEL CH1;
alter database open;
}


And we also have databases that backup using this scripts:

run {
ALLOCATE CHANNEL t1 TYPE 'SBT_TAPE';
backup
incremental level = 1
cumulative
format  BackupOpenCumulative_Incremental_Level_1_%d_%s_%T  database plus archive log delete all input;

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