-
Automatic delete Archivelogs STANDBY Database
Hi all,
I have a Oracle Dataguard, 10g (10.2.0.5.0). I have RMAN backup on primary database, full and archive. When I do archive backup, I use delete input clause, then archives are deleted. My problem is on STANDBY Database, archives aren't deleted.
How can I purge archivelogs on STANDBY Database?
Thanks in advance.
Leonardo.
-
If you use Linux/Unix you can put this in your cron command.
Just verify the path to your archive logs.
Code:
find /oracle/admin/sidname/archive/* -type f -mtime +6 -exec rm -rf {} \;
-
Thanks for you reply.
But I use ASM, any idea?
-
Try this if you are backing up from standby:
Code:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
Or just use gandolf989's suggestion.
Last edited by LKBrwn_DBA; 02-08-2011 at 05:11 PM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by LKBrwn_DBA
Try this if you are backing up from standby:
Code:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
Or just use gandolf989's suggestion.
You are probably better off letting RMAN delete log files. There may be an option to let the standby keep 4 hours of redo. Perhaps a different option with the same command.
If you can do something with Oracle, then chances are you can do it a hundred different ways with Oracle...
-
Thanks for you help.
But my backup is from primary.
Another way?
-
Originally Posted by lgargano77
My problem is on STANDBY Database, archives aren't deleted.
How can I purge archivelogs on STANDBY Database?
what is your another question?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
LKBrwn_DBA said: ...Try this if you are backing up from standby:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
But my backup is on primary database, isn't from standby. My question is: is there any another way for delete archivelogs on STANDBY Database?
Thanks in advance.
-
yes, there is a way. Please follow gandolfs' suggestion.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Hi Vijay Tummala, thanks for your help.
I think Linux script is a good idea, but I would prefer a solution from Oracle, as such any RMAN command.
Also, I don't use file system for my archivelogs, I use ASM. How can I do this Linux script with ASM ?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|