Home » RDBMS Server » Backup & Recovery » backup archivelog keep forever
backup archivelog keep forever [message #214175] Mon, 15 January 2007 04:57 Go to next message
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
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
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

Re: backup archivelog keep forever [message #214189 is a reply to message #214175] Mon, 15 January 2007 06:25 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
With this statement
>>delete noprompt obsolete;
The behaviour is quit expected. Remove it.
Previous Topic: How to create script of a user/role definition
Next Topic: Name column in v$archived_log is null
Goto Forum:

Current Time: Fri Jul 28 14:39:21 CDT 2017

Total time taken to generate the page: 0.28468 seconds