I am an IT professional with 10 years of professional experience,I have good proficiency on Oracle technologies, and at last 2 years of my career to study Real Application Clusters,data guard and participate actively on Oracle community ,If you want to hire me on Contract or to quote on project basis contact me at khurrampc@hotmail.com.

Tuesday, September 15, 2009

coreletion between report need backup and retention policy

Question :

Daily i used take full backup using rman,after that when query report need backup it showing all datafile list, i don't understand how come it showing all the datafile list thought i take full backup please help me in this issues.

Answer :

It relates to yours retention policy if you would have retention policy to 2 and you have one backupsets of USERS tablespace then it will require one more for tablespace users to mature yours retention policy.

RMAN> list backup
2> ;


List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       595.00K    DISK        00:00:03     15-SEP-09      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20090915T110249
        Piece Name: /u01/app/oracle/flash_recovery_area/MMI/backupset/2009_09_15/o1_mf_annnn_TAG20090915T110249_5bycjdm6_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    17      1320409    15-SEP-09 1320963    15-SEP-09

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    1005.51M   DISK        00:01:14     15-SEP-09      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20090915T110253
        Piece Name: /u01/app/oracle/flash_recovery_area/MMI/backupset/2009_09_15/o1_mf_nnndf_TAG20090915T110253_5bycjk2h_.bkp
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1320969    15-SEP-09 /u01/app/oracle/oradata/mmi/system01.dbf
  2       Full 1320969    15-SEP-09 /u01/app/oracle/oradata/mmi/sysaux01.dbf
  3       Full 1320969    15-SEP-09 /u01/app/oracle/oradata/mmi/undotbs01.dbf
  4       Full 1320969    15-SEP-09 /u01/app/oracle/oradata/mmi/users01.dbf
  5       Full 1320969    15-SEP-09 /u01/app/oracle/oradata/mmi/mydatafile.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7       10.00K     DISK        00:00:03     15-SEP-09      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20090915T110412
        Piece Name: /u01/app/oracle/flash_recovery_area/MMI/backupset/2009_09_15/o1_mf_annnn_TAG20090915T110412_5byclzbb_.bkp

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    18      1320963    15-SEP-09 1321005    15-SEP-09

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    9.39M      DISK        00:00:00     15-SEP-09      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20090915T110416
        Piece Name: /u01/app/oracle/flash_recovery_area/MMI/autobackup/2009_09_15/o1_mf_s_697633458_5bycm3q8_.bkp
  SPFILE Included: Modification time: 15-SEP-09
  SPFILE db_unique_name: MMI
  Control File Included: Ckp SCN: 1321012      Ckp time: 15-SEP-09


RMAN> show retention policy;

RMAN configuration parameters for database with db_unique_name MMI are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default


RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------



RMAN> configure retention policy to redundancy 2
2> ;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored

RMAN> report need backup
2> ;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of files with less than 2 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1    1     /u01/app/oracle/oradata/mmi/system01.dbf
2    1     /u01/app/oracle/oradata/mmi/sysaux01.dbf
3    1     /u01/app/oracle/oradata/mmi/undotbs01.dbf
4    1     /u01/app/oracle/oradata/mmi/users01.dbf
5    1     /u01/app/oracle/oradata/mmi/mydatafile.dbf

RMAN> configure retention policy to redundancy 1
2> ;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
new RMAN configuration parameters are successfully stored

RMAN> report need backup
2> ;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN> 

1 comment:

daspeac said...

I have heard about another way of exchange mail recovery. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.

Followers

About Me

My photo
Melbourne, Victoria, Australia