We re revising our backup strategy and I have a few questions
We do a FULL backup every night from 12:00 am to 2:am, we backup the DB files and Arc files.
.
1) We are currently removing the old backup files via a Unix command and then use CROSSCHECK BACKUP and DELETE EXPIRED to remove it from the repository (control file) .. I was reading on this and it seems to be better to have RMAN remove the files .. just wanted to know the advantages in using RMAN to remove the physical files.
.
2) This is the BACKUP script we will use, any comment or better way to do this.
We can only keep 1 backup because of space restriction, once the backup is created around 2:00 am, it goes on tape, so the current backup has to be removed before the other one is created.
.
rman target / <<EOF
startup mount;
configure controlfile autobackup on;
configure retention policy to redundancy 1;
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
set controlfile autobackup format for device type disk to '/s2/oraback/$db/rman/$B_type/cf_%F';
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt backup ;
run {
allocate channel d1 type disk ;
backup
format = '/s2/oraback/$db/rman/$B_type/%T_%s_%p.bkup_db'
database
plus archivelog
format = '/s2/oraback/$db/rman/$B_type/%T_%s_%p.bkup_arc';
release channel d1;
}
run
{
delete noprompt archivelog all backed up 1 times to disk;
}
exit
EOF
.
3) I've read that some people are recommending to do a "ALTER SYSTEM ARCHIVE LOG CURRENT" at the start , but others were mentioning that the "Backup Database plus Archivelog" does it automatically .. what is the recommendation ?
.
4) From the RMAN log, I can see that the archive logs are backuped and the DB files are backuped, also a RESTORE .. VALIDATE confirmed it, we also tested the Restore and it worked. But why are we getting the following message right after those backups. Can this be safely ignored ?
"specification does not match any archived log in the repository backup cancelled because there are no files to backup Finished backup at 02-FEB-17"
.
Thanks in advance