4 Replies Latest reply on Dec 11, 2018 11:45 AM by Dude!

    RMAN  database backup issue

    1020114

      hi Team,

      We are running ORACLE database 11.2.0.4 version database .We have an issue while running database full backup using RMAN .

       

      Our  RMAN full backup runs  after completing the full database validation .We are seeing the below error. It fails after the below error.

       

      PSDRPC returns significant error 3113.

      RMAN-03009: failure of backup command on ORA_DISK_4 channel at 12/07/2018 07:21:20

      ORA-03113: end-of-file on communication channel

      channel ORA_DISK_4 disabled, job failed on it will be run on another channel

      channel ORA_DISK_5: starting full datafile backup set

       

      Where as when we run same backup again ,it is running fine and even the backup validation is showing as success.

      Precisely to say ,the second time when the backup is ran it is completing fine .

       

      Please let us know  any inputs.

        • 1. Re: RMAN  database backup issue
          top.gun

          You are backing up to disk, so I don;t know exactly why you need to do a "backup validation" before you do a backup.

           

          You'll need to post the script you are using to do the validation and the backup.

          • 2. Re: RMAN  database backup issue
            3417708

            Hi,

             

            If the rman script is runing successfully completed second time, it means there is no issue with Script and you can ignore it.

            • 3. Re: RMAN  database backup issue
              WadhahDaouehi

              Hi,

               

              If you want to check the database before backup, you can use the RMAN> database validate;

              but when a backup RMAN, it will check the database files during the backup.

              Backup validate is to check the status of your backup thats mean after backup and when you want to restore.

               

              while your backup is done , means ok but you can display your scripts .

               

              Best regards

              • 4. Re: RMAN  database backup issue
                Dude!

                RMAN-03009: failure of backup command on ORA_DISK_4 channel at 12/07/2018 07:21:20

                ORA-03113: end-of-file on communication channel

                channel ORA_DISK_4 disabled, job failed on it will be run on another channel

                Your backup will be OK because RMAN resumes on another channel. You might however have unnecessary I/O, time and space usage.

                 

                It's not possible to tell the reason from the current output. What are these channels? Network, local disk, tape? It could be that the storage path did not respond was disconnected. Keep in mind that parallel processing is not necessarily an advantage if you do not have the necessary hardware, in which case you may "oversell" your system and cause processing delays and overhead.