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.
:p

Quote:

---

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.
:p

---

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... :p

Thanks for you help.

But my backup is from primary.

Another way?

Quote:

---

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,

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,

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

well, you need to use ASM command line for that. Click on the below URL for more information.

http://download.oracle.com/docs/cd/B...5/asm_util.htm

Thanks,