5 Replies Latest reply on Dec 6, 2018 4:21 PM by Dude!

    how rman backup to fastest + 11gr2

    1035940

      Dear,

      With large data, how rman backup to fastest +11gr2.

      I use ENABLE BLOCK CHANGE TRACKING; parallel rman.

      But, rman run along time and after then shutdown my database.

      Please help me. Thanks so much!

       

      Message was edited by: 1035940

        • 1. Re: how rman backup to fastest + 11gr2
          EdStevens

          1035940 wrote:

           

          Dear,

          With large data, how rman backup to fastest +11gr2.

          I use ENABLE BLOCK CHANGE TRACKING; parallel rman.

          But, rman run along time and after then shutdown my database.

          Please help me. Thanks so much!

           

          Message was edited by: 1035940

          We don't know what you have.

          We don't know what you did.

          We don't know if your expectations for backup run time exceeds reality.

           

          With your statement "rman run along time and after then shutdown my database" you seem to imply that rman itself shutdown the database unexpectedly.  I have a hard time believing that. But without seeing your backup script, the output log and the relevant portion of the db alert log it is impossible to comment further.

          • 2. Re: how rman backup to fastest + 11gr2
            1035940

             

             

             

             

            Dear !

             

            There is script i run to backup:

            run

            {

            allocate channel t1 device type disk;

            allocate channel t2 device type disk;

            allocate channel t3 device type disk;

            allocate channel t4 device type disk;

            BACKUP as compressed backupset INCREMENTAL FROM SCN 36852345666  DATABASE FORMAT '/data/backup/db_181206_%U';

            backup current controlfile for standby format '/data/backup/control01.ctl';

            }

             

            when rman backup database, alert_log have message:

             

            Thu Dec 06 03:51:27 2018

            Running KSFV I/O slave I801 os pid=163821

            Thu Dec 06 03:51:27 2018

            Running KSFV I/O slave I802 os pid=163823

            Thu Dec 06 03:51:27 2018

            Running KSFV I/O slave I803 os pid=163825

            Thu Dec 06 03:51:27 2018

            Running KSFV I/O slave I804 os pid=163827

            Thu Dec 06 03:52:20 2018

            KSFV I/O slave I902 dp=0x59d16b180 exiting

            Thu Dec 06 03:52:20 2018

            KSFV I/O slave I903 dp=0x59a6a0c90 exiting

            Thu Dec 06 03:52:20 2018

            KSFV I/O slave I904 dp=0x599b30058 exiting

            Thu Dec 06 03:52:39 2018

             

             

            1. Ater run 2hour, my database be stop.
            2. I want' hint to backup rman to faster.

             

            Thank so much!

            • 3. Re: how rman backup to fastest + 11gr2
              CristianR-Oracle

              Why do you use "INCREMENTAL FROM SCN" are you trying to roll forward a standby database?

               

              Was this working well in the past? What changed since last good run ?

               

              What is your backup strategy ? What RDBMS version do you use ? Do you use a recovery catalog ? What version is ?

               

              Do you bag bigfiles in your database ?

              • 4. Re: how rman backup to fastest + 11gr2
                WadhahDaouehi

                Hi,

                 

                For parallel backup, it is related to Enterprise Edition, and check what you have?

                 

                You can enable CHANGE BLOCK TRACKING and make a INCREMENTAL backup daily and full LEVEL 0 weekly or monthly .

                 

                Best regards.

                • 5. Re: how rman backup to fastest + 11gr2
                  Dude!

                  There is no universal way to speed up RMAN. BCT and incremental backups are usually the fastest, but it depends on previous backups and how much data changed. Parallel processing will help if the hardware has appropriate resources, otherwise it can cause unnecessary processing overhead and slow down. I'm afraid there will be no other possible answer as available tuning options and the results depends on your hardware and database source.