Home » RDBMS Server » Backup & Recovery » Backup doubt (archivelogs)
Backup doubt (archivelogs) [message #265223] Wed, 05 September 2007 16:14 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
hi, i am using rman
but i have a problem
when i do a backup archivelog
rman backup all destinations (i have 3 destinations in diferents filesystems)
but i only want to backup 1 destination
how can i backup archivelog from only 1 destination?

i have another question
when i use recovery window, when i do a rman backup i do a

crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
release channel C1;

i want to keep my backups 3 days at least and my archivelogs only 1 day
how can i do that?
thnx in advance
Re: Backup doubt (archivelogs) [message #265224 is a reply to message #265223] Wed, 05 September 2007 16:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
i want to keep my backups 3 days


RMAN> configure retention policy to recovery window of 3
days; 



Quote:
at least and my archivelogs only 1 day


write a script to delete one days old archivelogs and schelude it after RMAN backup.
Re: Backup doubt (archivelogs) [message #265231 is a reply to message #265224] Wed, 05 September 2007 17:02 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
is more easy to put
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
after that ...
crosscheck archivelog all;
delete expired archivelog all;

and after that
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
and after that...
crosscheck backup;
delete expired backup;
delete obsolete;

Wink
but my question is if does exist a way to do that
Re: Backup doubt (archivelogs) [message #265232 is a reply to message #265231] Wed, 05 September 2007 17:06 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
yes just write shell scripts for that.
Previous Topic: create backup daily
Next Topic: HOT BACKUP RESTORE
Goto Forum:
  


Current Time: Sat May 18 15:55:53 CDT 2024