Automatic delete Archivelogs STANDBY Database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Automatic delete Archivelogs STANDBY Database

Hybrid View

  1. #1
    Join Date
    Feb 2011
    Posts
    8

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,967
    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 {} \;
    this space intentionally left blank

  3. #3
    Join Date
    Feb 2011
    Posts
    8
    Thanks for you reply.

    But I use ASM, any idea?

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,441

    Wink

    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 04:11 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,967
    Quote Originally Posted by LKBrwn_DBA View Post
    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...
    this space intentionally left blank

  6. #6
    Join Date
    Feb 2011
    Posts
    8
    Thanks for you help.

    But my backup is from primary.

    Another way?

  7. #7
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Quote Originally Posted by lgargano77 View Post
    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.

  8. #8
    Join Date
    Feb 2011
    Posts
    8
    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.

  9. #9
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  10. #10
    Join Date
    Feb 2011
    Posts
    8
    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
  •  



Click Here to Expand Forum to Full Width