Automatic delete Archivelogs STANDBY Database

[lgargano77]

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.

[gandolf989]

If you use Linux/Unix you can put this in your cron command.
Just verify the path to your archive logs.

find /oracle/admin/sidname/archive/* -type f -mtime +6 -exec rm -rf {} \;

[lgargano77]

Thanks for you reply.

But I use ASM, any idea?

[LKBrwn_DBA]

Try this if you are backing up from standby:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

Or just use gandolf989's suggestion.

[gandolf989]

Try this if you are backing up from standby:

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

[lgargano77]

Thanks for you help.

But my backup is from primary.

Another way?

[vnktummala]

My problem is on STANDBY Database, archives aren't deleted.

How can I purge archivelogs on STANDBY Database?

what is your another question?

Thanks,

[lgargano77]

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.

[vnktummala]

yes, there is a way. Please follow gandolfs' suggestion.

Thanks,

[lgargano77]

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