crosscheck archivelog all .. takes for ever
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: crosscheck archivelog all .. takes for ever

  1. #1
    Join Date
    Apr 2001
    Location
    United Kingdom
    Posts
    31

    Angry crosscheck archivelog all .. takes for ever

    Hi , I have issued a crosscheck archivelog all command to sort an issue which is caused to due to manual deletion for archivelogs ...


    ITs takingfor ever and i have not got any output yet ? Any idea on how else i can solve this ?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968

    Re: crosscheck archivelog all .. takes for ever

    Originally posted by Dosth
    Hi , I have issued a crosscheck archivelog all command to sort an issue which is caused to due to manual deletion for archivelogs ...


    ITs takingfor ever and i have not got any output yet ? Any idea on how else i can solve this ?
    Don't manually delete archive logs. Isn't there an automated way to get rman to clean up the old archive logs? For example can you setup a special backup of the archive logs and have the job delete them once they are backed up? I thought I think remeber reading something about that, you may want to look it up.
    this space intentionally left blank

  3. #3
    Join Date
    Apr 2001
    Location
    United Kingdom
    Posts
    31
    Yes Gandolph , that would be the best option but now since the logs are gone already I have no choice but wait.

    But this process seems to take like for ever.

    Are you / anyone else aware of decent checklist for implementing RMAN ? ( Well please dont post the URL tot he documentation . its exhaustive .. but would be nice ot have some maintenance , backup and test scripts .

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Which release?

    I've never had any problmes with "crosscheck archivelog all ", even when there have been deleted archived logs at OS level.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Friends,
    I am using this script to regularly clean up old archive logs.

    allocate channel for maintenance type disk;
    change archivelog until time 'sysdate-1' delete;
    change archivelog all crosscheck;
    release channel;

    Its working fine for me.

    regards
    anandkl
    anandkl

  6. #6
    Join Date
    Apr 2003
    Posts
    353
    In your weekly archivelog backup use

    backup ( archivelog all delete input );

    will delete once in week.

    Or Use the same in monthly backup.

  7. #7
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Friend,
    Can u please be little more clear in you statement.

    regards
    anandkl
    anandkl

  8. #8
    Join Date
    Apr 2003
    Posts
    353
    After taking the archivelog backup it will delete the archivelogs.

    when we add the delete input command.
    backup ( archivelog all delete input )


    we can schedule this backup for a weekly backup of the archivelog.


    Refer Rman doc for further details.

  9. #9
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Oh..ok

    I thought u were asking some question.

    regards
    anandkl
    anandkl

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