If I am using the following RMAN script for hot backup daily, will it be able to recover my whole database?
I will crosscheck obsolete backup and delete them weekly... Is there a more automated way of controlling the old backups or archived logs?
connect target /
set snapshot controlfile name to '/backup/orcl_snapshot.ctl';
allocate channel ch1 type disk;
sql 'alter system archive log current';
backup format '/backup/orcl/%d_t%t_s%s_p%p'
database plus archivelog;
release channel ch1;
Click Here to Expand Forum to Full Width