Hi, I have an Oracle RAC with 3 nodes on Suse Linux enterprise server on IBM PPC. The version of oracle is SE 10gR2 (10.2.0.3.0).
The last week one of my node was reboot because it lost the connection of ocr. I don't reboot it, it was it self. I don't use catalog,instead of I use the controlfile on my rman script for backup. However, when this node was rebooted the catalog of my controlfiles lost the old backups and now my script don't update my datafiles (I use image copy).
Anyone can help me and tell me why oracle lost my old backups?
In my disk I have the backups but no in the catalog. why?
NOTE: I post my rman script for backup.
RUN {
allocate channel oem_backup_disk1 type disk ;
RECOVER COPY OF DATABASE WITH TAG 'incr_update' UNTIL TIME 'SYSDATE - 7';
BACKUP INCREMENTAL LEVEL 1 cumulative copies=1 FOR RECOVER OF COPY WITH TAG 'incr_update' DATABASE;
backup as copy archivelog all not backed up delete all input;
release channel oem_backup_disk1;
}
# Hacemos un crosscheck de las copias de seguridad, para comparar lo que tenemos en disco con lo del catalogo
CROSSCHECK BACKUP;
# Eliminamos los backups antiguos
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK;
#Hacemos lo mismo para los archivelog (realmente lo deberia de haber hecho antes, pero asi nos aseguramos)
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
# End of RMAN command script;