OraFAQ Forum: Backup & Recovery » Backup doubt (archivelogs)

Home » RDBMS Server » Backup & Recovery » Backup doubt (archivelogs)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backup doubt (archivelogs) [message #265223]

Wed, 05 September 2007 16:14

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

Report message to a moderator

Re: Backup doubt (archivelogs) [message #265224 is a reply to message #265223]

Wed, 05 September 2007 16:25

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

i want to keep my backups 3 days

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: Backup doubt (archivelogs) [message #265231 is a reply to message #265224]

Wed, 05 September 2007 17:02

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

Report message to a moderator

Re: Backup doubt (archivelogs) [message #265232 is a reply to message #265231]

Wed, 05 September 2007 17:06

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

yes just write shell scripts for that.

Report message to a moderator

Previous Topic:	create backup daily
Next Topic:	HOT BACKUP RESTORE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 19:13:16 CDT 2025