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

    RMAN Backup Confusion


      Hi all,


      Aix 6.1


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


      The script said:




      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





          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.



          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

              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.




              • 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