4 Replies Latest reply: Nov 9, 2012 11:56 AM by mseberg RSS

    RMAN error code

    eakabote
      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
          12cdb
          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
            Hi,

            Only option is RMAN backup log file.

            Thanks,
            Robin
            • 3. Re: RMAN error code
              Levi Pereira
              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
                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