removing arch files from standby DB

[PaulH]

Currently, I am using RMAN to bacup my standby DB's. With in RMAN,once the DB and arch logs are backedup I remove the arch logs.

I am considering not backing up my standby DB's since the are basically a copy of my primary DB's there the cleaning up of the arch files will not happen.

Is there a query I can run that can figure out the arch files that were applied to the standby DB. Once applied I want to remove those arch files from disk.

thanks to all who answer this post

[LKBrwn_DBA]

Try:

SELECT SEQUENCE#, THREAD#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#, THREAD#;

PS: You can save cpu's & storage in primary if you do your backups from standby only.
.

[PaulH]

And this will give you the name of the archive file or do I have to write some code to parse the seq number from the archive file based on the output of the query.

[LKBrwn_DBA]

If you are smart, you would have configured the archive log format (name) to contain the SEQUENCE# and THREAD#, kinda like this:

log_archive_format='orcl_%t_%s_%r.dbf'

[PaulH]

I did have the foresight to include the seq number as part of my arch name. I can certainly parse the name and get the right answer but I was hoping there was some table that stored the name of the whole arhive file so I can use that data instead of parsing every name.

[LKBrwn_DBA]

I did have the foresight to include the seq number as part of my arch name. I can certainly parse the name and get the right answer but I was hoping there was some table that stored the name of the whole arhive file so I can use that data instead of parsing every name.

Did you try desc v$archived_log?

[PaulH]

I will check out that table and see if it has what I need.

Thanks for your help

[PaulH]

Let me try this again. I want to be able to run a script to removed all applied
archive files that are part of my stand by database.

When I query the V$ARCHIVED_LOG, the colums where APPLIED='YES' no
longer have the archive file path associated with them. The name becomes
is changed to my database name.

Example:

NAME APP
stdby YES

Those files, which have not been applied still have the valid path name (see
below)

NAME APP
/t4data/oracle_data/pri/arch/arch_1347_1_684356798.arc NO

Does anybody know how I can generate a script to remove arc files from
disk that have been applied ONLY!!!

[hrishy]

Hi

Have you tried this

in standby do
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY
and then

from RMAN at the standby database
DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO SBT COMPLETED BEFORE ‘SYSDATE-7’


if you go down the route currently you are on you still dont need the archivelog names just use

RMAN>delete archivelog until squence#

or
RMAN>delete archivelog until squence# noprompt


regards
Hrishy