Database Backup and Recovery (MOSC)

MOSC Banner

incremental backup query

edited Oct 2, 2013 6:27PM in Database Backup and Recovery (MOSC) 1 commentAnswered
 I have two optons of incremental backups.

1.which one is better A or B?

A.  backup to disk first then to tape
RUN
{
  RECOVER COPY OF DATABASE 
    WITH TAG 'INCRE_UPDATE';
  BACKUP
    INCREMENTAL LEVEL 1
    FOR RECOVER OF COPY WITH TAG 'INCRE_UPDATE'
    DATABASE;
}

what happens if level 0 is corrupted, i need to take from tape.Is it my correct understanding?


B. -- Eevery sunday  , first backup to disk then to tape.
run {
configure channel device type disk format 'D:\backups\testdb\%d_%T_s%s_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\backups\testdb\%d_%F';

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