REPORT Command

   

위와 같이 상태를 변경하면 아래와 같이 백업을 꼭 해줘야 한다.

   

RMAN> backup as compressed backupset database;

RMAN> delete obsolete;

RMAN> report obsolete;      delete obsolete와 같은 내용

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

no obsolete backups found

RMAN> report need backup redundancy 2;         백업을 한번밖에 안한 or 백업 안한(대상), datafile 단위

Report of files with less than 2 redundant backups

File #bkps Name

---- ----- -----------------------------------------------------

1 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_3trzfl2y_.dbf

2 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_3trzflk7_.dbf

3 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_3trzfl4m_.dbf

4 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_3trzflmk_.dbf

5 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_3trzjjxo_.dbf

6 1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_rcat_ts_58z6l11h_.dbf