4 Replies Latest reply on Sep 19, 2013 7:39 AM by Hemant K Chitale

    RMAN Backup Confusion

    yxes2013

      Hi all,

       

      11.2.0.1

      Aix 6.1

       

      I am reviewing the RMAN backup scripts in our prod database which was written by the previous dba.

       

      The script said:

       

      run

      {

      crosscheck archivelog all;

      crosscheck backup;

      delete noprompt expired backup;

      delete noprompt expired archivelog all;

      delete noprompt obsolete;

      allocate channel ch1 type disk;

      allocate channel ch2 type disk;

      allocate channel ch3 type disk;

      allocate channel ch4 type disk;

      backup as compressed backupset database plus archivelog format '/rmanbackup/prod/backup/db/db_%U';

      backup current controlfile for standby format '/rmanbackup/prod/backup/db/ctrl_stby_%U';

      backup current controlfile format '/rmanbackup/prod/backup/db/ctrl_%U';

      }

       

      Then I check the content of /rmanbackup/prod/backup/db

       

      oracle[/rmanbackup/prod/backup/db] ls -l

      total 0

      -rw-r-----    1 oracle   backup      8617984 Sep 18 2012  ctrl_0knlh44v_1_1

      -rw-------    1 oracle   dba        11698176 Sep 18 01:24 ctrl_2sok4bqk_1_1

      -rw-------    1 oracle   dba        11698176 Sep 19 01:21 ctrl_3aok7001_1_1

      -rw-------    1 oracle   dba        11698176 Sep 18 01:24 ctrl_stby_2rok4bqi_1_1

      -rw-------    1 oracle   dba        11698176 Sep 19 01:21 ctrl_stby_39ok6vvu_1_1

      -rw-------    1 oracle   dba         8598016 Sep 17 01:24 db_2cok1ne6_1_1

      -rw-------    1 oracle   dba      3942116864 Sep 18 01:17 db_2hok4acs_1_1

      -rw-------    1 oracle   dba      3570494976 Sep 18 01:18 db_2iok4acs_1_1

      -rw-------    1 oracle   dba       130300928 Sep 18 01:16 db_2jok4bap_1_1

      -rw-------    1 oracle   dba         8078848 Sep 18 01:24 db_2qok4bqh_1_1

      -rw-------    1 oracle   dba      3205571072 Sep 19 01:14 db_2tok6uot_1_1

      -rw-------    1 oracle   dba      2845661696 Sep 19 01:14 db_2uok6uot_1_1

      -rw-------    1 oracle   dba      3153846272 Sep 19 01:14 db_2vok6uot_1_1

      -rw-------    1 oracle   dba      2851247104 Sep 19 01:14 db_30ok6uot_1_1

      -rw-------    1 oracle   dba       104608256 Sep 19 01:14 db_31ok6vjb_1_1

      -rw-------    1 oracle   dba         7869440 Sep 19 01:21 db_38ok6vvt_1_1

       

      Are the above backup complete?

       

      I also check the flash_recovery_area:


      oracle[/rmanonline/flash_recovery_area/PROD/backupset/2013_09_19] ls -l

      total 0

      -rw-------    1 oracle   dba         1867776 Sep 19 01:19 o1_mf_ncnnf_TAG20130919T011455_93mr5j77_.bkp

      -rw-------    1 oracle   dba      1314160640 Sep 19 01:19 o1_mf_nnndf_TAG20130919T011455_93mqwkc1_.bkp

      -rw-------    1 oracle   dba      1329709056 Sep 19 01:20 o1_mf_nnndf_TAG20130919T011455_93mqwkfr_.bkp

      -rw-------    1 oracle   dba      1459748864 Sep 19 01:20 o1_mf_nnndf_TAG20130919T011455_93mqwlhc_.bkp

      -rw-------    1 oracle   dba      1779367936 Sep 19 01:20 o1_mf_nnndf_TAG20130919T011455_93mqwlvo_.bkp

      -rw-------    1 oracle   dba           98304 Sep 19 01:19 o1_mf_nnsnf_TAG20130919T011455_93mr5kgk_.bkp

       

       

      Why is that there is another backup here? Do we have duplicate backups? Please validate.

       

      Thanks a lot, zxy

        • 1. Re: RMAN Backup Confusion
          Mahir M. Quluzade

          Hi,

           

          run

          {

          crosscheck archivelog all; -- Crosschecking all  archived log

          crosscheck backup; -- Crosschecking all  backups

          delete noprompt expired backup; -- deleting expirted backups

          delete noprompt expired archivelog all; -- deleting expired backups

          delete noprompt obsolete; -- deleting obsolete backups

           

          }

           

          You  must learn what is obsolete backups? What is retention policy?

          How to working REPORT OBSOLETE, DELETE OBSOLETE ?

           

          Read Configuring the RMAN Environment

           

          There have other backups, because you are not delete obsolete backups after backup  command.

          You delete obsolete backups before backup command.

           

          Regards

          Mahir M. Quluzade






          1 person found this helpful
          • 2. Re: RMAN Backup Confusion
            Hemant K Chitale

            Yes, you have two different scripts running RMAN Backups.

            Find the other one (e.g. it could have been configured through Oracle Enterprise Manager ?)

             

            Hemant K Chitale

            1 person found this helpful
            • 3. Re: RMAN Backup Confusion
              yxes2013

              But I checked the cron and I only see the first backup script scheduled in there

               

              And oem is not configured yet?

               

              oracle[/oracle] emctl start dbconsole;

              Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

               

               

              Thanks

              • 4. Re: RMAN Backup Confusion
                Hemant K Chitale

                Enterprise Manager does not have to be DB Console.  It can be Grid Control or Cloud Control.

                 

                The backup job could have been scheduled through DBMS_SCHEDULER.

                It could have been scheduled through a non-cron external scheduler.

                 

                 

                Hemant K Chitale