This discussion is archived
4 Replies Latest reply: Sep 19, 2013 12:39 AM by Hemant K Chitale RSS

RMAN Backup Confusion

yxes2013 Newbie
Currently Being Moderated

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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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






  • 2. Re: RMAN Backup Confusion
    Hemant K Chitale Oracle ACE
    Currently Being Moderated

    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

  • 3. Re: RMAN Backup Confusion
    yxes2013 Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    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


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points