Hi all,
I hope you guys are doing good. In order to take backup, we are using the following RMAN script:
SQL 'alter system archive log current';
RUN
{
ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE = 10G;
BACKUP ARCHIVELOG ALL FORMAT 'F:\RMAN0\ARC_%D-%M-%Y-%s-%p_LevelZero' DELETE ALL INPUT;
BACKUP AS BACKUPSET FORMAT 'F:\RMAN0\DB_%D-%M-%Y-%s-%p_LevelZero'
INCREMENTAL LEVEL 0 DATABASE
PLUS ARCHIVELOG FORMAT 'F:\RMAN0\ARC_%D-%M-%Y-%s-%p_LevelZero';
BACKUP CURRENT CONTROLFILE TAG 'CTL' FORMAT 'F:\RMAN0\CTRL%U';
BACKUP SPFILE TAG 'SPFILE' FORMAT 'F:\RMAN0\SPfile%U';
DELETE BACKUP OF DATABASE COMPLETED BEFORE 'sysdate -1';
DELETE BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE 'sysdate -1';
RELEASE CHANNEL C1;
}
Do we really need this command, If yes, then what is the downside if we remove this command**?**
BACKUP ARCHIVELOG ALL FORMAT 'F:\RMAN0\ARC_%D-%M-%Y-%s-%p_LevelZero' DELETE ALL INPUT;