Database Backup and Recovery (MOSC)

MOSC Banner

Deleting standby archive file manually from ASM.

edited Jun 25, 2009 8:20AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 I have a physical standby setup in ASM, We are not taking a backup of the standby archive files generated from the primary and we need to delete the archive files
generated manaualy using asmcmd ( as they are occupying space).

I Want to verify if the following approach is good to follow.

Step 1) rman target /
crosscheck archivelog all

Step2) get archivelog to be deleted


select name from v$archived_log where status='A'and APPLIED='YES' and REGISTRAR='RFS' ORDER BY COMPLETION_TIME;


Step3) Delete the files generate in previous step using ASMCMD

Step4) Run again rman target /a
crosscheck archivelog all

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center