Requesting a 2nd opinion on 10g RMAN backup strategy
Hi,
I have a 10G R2 database running on RHL 4.0 AS.
The flash recovery area is pointing to a windows server on our network having over a Terabyte of storage. This has been mounted using cifs.
I have the following RMAN script which will take a daily full database backup of our database to the windows shared disk (flash recovery area).
Code:
connect target sys/passwd@targetsid
connect catalog rman/passwd@catsid
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
run {
allocate channel ch1 type disk maxpiecesize=2G;
backup database plus archivelog;
BACKUP ARCHIVELOG UNTIL TIME 'SYSDATE-7' delete input;
}
delete obsolete;
The strategy is as follows
1. The backups are taken to the disk and are picked up by tape on a daily basis.
2. The tapes are recycled every 14 days hence our retention policy is 14 days after which RMAn will delete the backups if it needs to.
I would really appreciate critical/non critical feedback on this strategy.
One problem that we have though is that since we are using flash recovery area oracle is doing space management and occupies the space for 14 days backups even though they have been backedup on tape by our network administrator. I know that they have a backup of backupset option but thats not useful for us as I dont manage the tapes. I am looking for a way to have the Flash recovery area only occupy the space for 1 backup but still be able to have the 13 addiional backups in record and restore/recover when the need be.
Please help.
Thanks
Ron
Last edited by ronnie; 04-24-2006 at 05:40 PM.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.