This discussion is archived
4 Replies Latest reply: Nov 9, 2012 9:01 AM by Levi-Pereira RSS

RMAN error code

eakabote Newbie
Currently Being Moderated
Hi all,

in rman we can check the backups details is it completed or failed with V$RMAN_BACKUP_JOB_DETAILS and v$RMAN_STATUS views.
if it is failed status is there any query to get that code from the database or we need to depend on the logs only. currently i don't have logs to get error code.

thank you very much...
  • 1. Re: RMAN error code
    user296828 Expert
    Currently Being Moderated
    if it is failed status is there any query to get that code from the database or we need to depend on the logs only.
    Rman backup log or oracle alert<sid>.log.
  • 2. Re: RMAN error code
    Robin Newbie
    Currently Being Moderated
    Hi,

    Only option is RMAN backup log file.

    Thanks,
    Robin
  • 3. Re: RMAN error code
    Levi-Pereira Guru
    Currently Being Moderated
    Hi,

    You can use v$rman_ouput.
    Note: The v$rman_output view is memory-based so it will not persist thru a database restart (i.e will not recorded in the controlfile). The view can hold 32768 rows.

    If you want keep all data from v$rman_output you have 3 option:
    1. Use RMAN CATALOG on different database.
    2. Use a trigger on the V_$RMAN_OUTPUT view to keep track of all backup info on a separate table
    3. Use a RMAN Catalog on same Database only to this purpose. (not recommended)


    See this example:
    http://www.dbspecialists.com/blog/database-backups/using-vrman_output-to-review-your-backups/

    Edited by: Levi Pereira on Nov 9, 2012 2:58 PM
  • 4. Re: RMAN error code
    mseberg Guru
    Currently Being Moderated
    Hello;

    This is worth a look :

    http://www.pythian.com/news/25785/viewing-rma-jobs-status-and-output/#more-25785

    In Unix/Linux you can :
    $ script rmanbackup.log
    
    $ rman target /
    
    RMAN> backup database;
    
    RMAN> exit
    
    $ script done, file is rmanbackup.log
    This holds all the output from your backup

    Best Regards

    mseberg

    Edited by: mseberg on Nov 9, 2012 11:53 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points