archive logs as part of an RMAN backup
Hi
we take RMAN backups using the following
RUN {
ALLOCATE CHANNEL ch1 TYPE
DISK FORMAT '/RMAN/BACKUPS/FULL/%d_DB_%T_%u_%s_%p';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
BACKUP DATABASE PLUS ARCHIVELOG;
CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
RELEASE CHANNEL ch1;
}
EXIT;
EOF
we use the following to do the restore
rman target / <<EOF
startup nomount
restore spfile to pfile '/RMAN/BACKUPS/FULL/init$sid.ora' from '/RMAN/BACKUPS/FULL/$RMAN_CONTROLFILE';
shutdown immediate
startup nomount pfile='/RMAN/BACKUPS/FULL/init$sid.ora';
we take RMAN backups using the following
RUN {
ALLOCATE CHANNEL ch1 TYPE
DISK FORMAT '/RMAN/BACKUPS/FULL/%d_DB_%T_%u_%s_%p';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
BACKUP DATABASE PLUS ARCHIVELOG;
CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
RELEASE CHANNEL ch1;
}
EXIT;
EOF
we use the following to do the restore
rman target / <<EOF
startup nomount
restore spfile to pfile '/RMAN/BACKUPS/FULL/init$sid.ora' from '/RMAN/BACKUPS/FULL/$RMAN_CONTROLFILE';
shutdown immediate
startup nomount pfile='/RMAN/BACKUPS/FULL/init$sid.ora';
0