| backup archivelog keep forever [message #214175] |
Mon, 15 January 2007 04:57  |
dzeljko
Messages: 19
Registered: April 2005
|
Junior Member |
|
|
Hi Gurus,
So, I use RMAN script for full database backup (goes every Friday) and script for backup archivelog files (goes every day).
The scripts looks like:
connect target system/passwd
run{
allocate channel db_fullback_disk1 type disk
format '/backup/rmanbackup/%U';
backup database;
release channel db_fullback_disk1;
restore database validate;
delete noprompt obsolete;
host 'cp /opt/oracle/9.2.0/network/admin/listener.ora /backup/rmanbackup';
host 'cp /opt/oracle/9.2.0/network/admin/tnsnames.ora /backup/rmanbackup';
host 'cp /opt/oracle/9.2.0/dbs/orapwsid /backup/rmanbackup';
}
connect target system/passwd
run{
allocate channel arch_backup_disk1 type disk
format '/backup/rmanbackup/logarch/%U';
backup archivelog all not backed up 2 times;
delete archivelog until time ' sysdate -7' backed up 2 times to device type disk;
release channel arch_backup_disk1;
}
But every friday the full backup script delete all archivelog files wich are obsolete and I would like to avoid that. I would like to keep all archivelog file for every case as long as I have enough space.
I didn't mention that my retention policy is set to 2;
So if somebody has some idea please let me know.
THANX in advance
Zeki
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
