DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: crosscheck archivelog all .. takes for ever

  1. 03-11-2005, 10:03 AM #1
    Dosth
    Dosth is offline Junior Member
    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 ?
    Reply With Quote Reply With Quote
  2. 03-11-2005, 10:24 AM #2
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    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.
    Reply With Quote Reply With Quote
  3. 03-11-2005, 10:40 AM #3
    Dosth
    Dosth is offline Junior Member
    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 .
    Reply With Quote Reply With Quote
  4. 03-12-2005, 06:19 PM #4
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  5. 03-14-2005, 07:33 AM #5
    anandkl
    anandkl is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  6. 03-14-2005, 08:47 AM #6
    engiri
    engiri is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  7. 03-14-2005, 10:21 AM #7
    anandkl
    anandkl is offline Senior Advisor
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Friend,
    Can u please be little more clear in you statement.

    regards
    anandkl
    anandkl
    Reply With Quote Reply With Quote
  8. 03-14-2005, 11:15 AM #8
    engiri
    engiri is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  9. 03-14-2005, 11:21 AM #9
    anandkl
    anandkl is offline Senior Advisor
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Oh..ok

    I thought u were asking some question.

    regards
    anandkl
    anandkl
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width