Database Software

Hi,

I have Production Database going to live this week..

this is my RMAN Backup script for taking daily Full Hot Backup night 12pm...

I have enabled FLASH_RECOVERY_AREA

------------------------------------------------------------

DB_RECOVERY_FILE_DEST=/backup/flash_recovery_area
log_archive_dest=/backup/archivelog
log_archive_format='arch_%d_%S_%T';

=========================================================

rman target=/

configure controlfile autobackup on;

run
{
allocate channel c1 device type disk;
crosscheck backup;
backup as compressed backupset database;
sql 'alter system switch logfile';
crosscheck backup;
release channel c1;
}
exit
===========================================================

Above script is scheduled usgin cron job...

=============================================================

Here I am not taking the archive logs backup...because..by default..archive logs are created in 2 places

(a) FLASH RECOVERY AREA
(b) /backup/archivelog

so archive logs are created by date wise in Flash Recovery Area....

----------------------------------------------------

I have flash recovery area structure like this for ever day

/backup/flash_recovery_area/PROD/archivelog/29_09_2007
/backup/flash_recovery_area/PROD/autobackup/29_09_2007



/backup/flash_recovery_area/PROD/archivelog/30_09_2007
/backup/flash_recovery_area/PROD/autobackup/30_09_2007


Above are 2 days backups of 29th and 30th....

I can simply send those 30_09_2007 and 29_09_2007 directories to TAPE Drive....


=======================================================================

When disaster recovery, i can restore those directories to flash_recovery_area and do the recovery using rman...



=============================================


Friends...am i goin in correct way..if anything wrong...please correct me..

my doubt is..I am not used any command of backuping up archivelogs in rman script.......becasue..archive logs are created in flash_recovery_area by date wise......

am i correct..