DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: RMAN-05019 Warning

  1. #11
    Join Date
    May 2007
    Posts
    24

    Error Message

    I tried to run the delete obsolete commands, this is what Im getting:

    RMAN> delete noprompt obsolete expired backup;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01009: syntax error: found "expired": expecting one of: "device, high, orph
    an, redundancy, recovery, ;, until"
    RMAN-01007: at line 1 column 26 file: standard input

    RMAN>

    WHat is it looking for?

    Paul

  2. #12
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Paul

    Apologies please try

    Code:
    RMAN>DELETE NOPROMPT EXPIRED BACKUP ;
    RMAN>DELETE NOPROMPT EXPIRED ARCHIVELOG ALL ;
    RMAN>DELETE NOPROMPT EXPIRED COPY;
    And please run your backupscript again and post the results if you get the error that you are getting

    regards
    Hrishy

  3. #13
    Join Date
    May 2007
    Posts
    24

    Delete

    Ok, I ran the 3 commands to delete and they ran fine. But when I run the REPORT OBSOLETE command, it still lists a whole mess of stuff. So I ran DELETE OBSOLETE, and this failed. The error said: "no channel allocated for maintenance (of an appropriate type)". Could this be because it is trying to delete some of the BackupExec jobs? I see jobs listed in the report that have "BE_" in the front of the name. The report is still showing the "+FLASH" datafile copes also. Thanks

  4. #14
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Please try

    Code:
    allocate channel c1 for maintenance device type disk;
    crosscheck backup;
    delete noprompt obsolete;
    and then run the

    regards
    Hrishy

  5. #15
    Join Date
    May 2007
    Posts
    24

    Error

    Tried to run that command and got an error:

    RMAN> allocate channel c1 for maintenance device type disk;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01009: syntax error: found "identifier": expecting one of: "for"
    RMAN-01008: the bad identifier was: c1
    RMAN-01007: at line 1 column 18 file: standard input

    I've been in meetings all day, so I havent had a chance to look it up. I'll see if I can fix it later. I would much rather be learning more Oracle!

    Paul

  6. #16
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Paul

    Apologies again as i dont have a database to test my commands at the moment

    Here is what you need to do

    Code:
    allocate channel for maintenance device type disk ;
    crosscheck backup;
    delete noprompt obsolete

  7. #17
    Join Date
    May 2007
    Posts
    24

    Errors

    I'm still getting a failure for the Delete Obsolete command. The other 2 worked, but when I run the delete it still says no cahannel allocated for maiintenance(of an appropriate type). I don't get that, it allocates the disk ok. Any thoughts?

  8. #18
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Please try

    Code:
    run {  
    allocate channel device type sbt;  
    delete force obsolete;
    }

  9. #19
    Join Date
    May 2007
    Posts
    24

    delete worked

    Hey thay worked! deleated a whole bunch of obsolete archive logs. Great! Thanks! Deleted 899 objects. I noticed it deleted the stuff on the +FLASH and some of the stuff from BE. HOw come allocating the SBT worked and not the disk?

    Paul
    Last edited by pam61; 09-25-2007 at 09:28 AM. Reason: Added info

  10. #20
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Did the folks before you leave some documentation behind ?

    It worked because sbt channel was used earlier to make copies etc.You need to look at the earlier docs and all what those people gave you before you were there.

    Can you please run the oracle reccommended backup strategy and then let us know if you are still hitting that error for which you started this thread

    regards
    Hrishy

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