管理备份：LIST ,REPORT,CROSSCHECK,DELETE
|
1 |
LIST:
(1)概述可用的 备份： RMAN> list backup summary;
using target database control file instead of recovery catalog
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 1 B F A DISK 02-FEB-16 1 2 NO TAG20160202T233201 2 B F A DISK 02-FEB-16 1 2 NO TAG20160202T233201 5 B F A DISK 02-FEB-16 1 2 NO TAG20160202T234045 11 B F A DISK 03-FEB-16 1 1 NO TAG20160203T120401 12 B F A DISK 03-FEB-16 1 1 NO TAG20160203T120448 13 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120737 14 B F A DISK 03-FEB-16 1 1 NO TAG20160203T120744 15 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120815 16 B F A DISK 03-FEB-16 1 1 NO TAG20160203T120822 17 B 0 A DISK 03-FEB-16 1 1 NO TAG20160203T120904 18 B F A DISK 03-FEB-16 1 2 NO TAG20160203T120919 19 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121144 20 B F A DISK 03-FEB-16 1 2 NO TAG20160203T121152 21 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121444 22 B F A DISK 03-FEB-16 1 2 NO TAG20160203T121451 23 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121512 24 B F A DISK 03-FEB-16 1 2 NO TAG20160203T121520 25 B F A DISK 03-FEB-16 1 3 NO TAG20160203T122250 26 B F A DISK 03-FEB-16 1 2 NO TAG20160203T122251 27 B F A DISK 03-FEB-16 1 1 NO TAG20160203T123802 28 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130537 29 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130552 30 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130710 31 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130726 32 B F A DISK 03-FEB-16 6 1 NO SECTON_DF1 33 B F A DISK 03-FEB-16 1 1 NO TAG20160203T133654 34 B A A DISK 03-FEB-16 1 1 NO TAG20160203T141013 35 B F A DISK 03-FEB-16 1 1 NO TAG20160203T141014 36 B A A DISK 03-FEB-16 1 1 NO TAG20160203T141351 37 B F A DISK 03-FEB-16 1 1 NO TAG20160203T141353 38 B A A DISK 03-FEB-16 1 1 NO TAG20160203T141356 39 B F A DISK 03-FEB-16 1 1 NO TAG20160203T141357
RMAN> list backup of database summary;
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 1 B F A DISK 02-FEB-16 1 2 NO TAG20160202T233201 13 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120737 15 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120815 17 B 0 A DISK 03-FEB-16 1 1 NO TAG20160203T120904 19 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121144 21 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121444 23 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121512 25 B F A DISK 03-FEB-16 1 3 NO TAG20160203T122250 28 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130537 30 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130710 32 B F A DISK 03-FEB-16 6 1 NO SECTON_DF1
RMAN> list backup of archivelog all summary;
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 34 B A A DISK 03-FEB-16 1 1 NO TAG20160203T141013 36 B A A DISK 03-FEB-16 1 1 NO TAG20160203T141351 38 B A A DISK 03-FEB-16 1 1 NO TAG20160203T141356 RMAN> list backup of tablespace users summary;
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 13 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120737 15 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120815 17 B 0 A DISK 03-FEB-16 1 1 NO TAG20160203T120904 19 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121144 21 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121444 23 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121512 25 B F A DISK 03-FEB-16 1 3 NO TAG20160203T122250 28 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130537 30 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130710
RMAN> list backup of datafile 1,2 summary;
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 1 B F A DISK 02-FEB-16 1 2 NO TAG20160202T233201 13 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120737 15 B 1 A DISK 03-FEB-16 1 1 NO TAG20160203T120815 17 B 0 A DISK 03-FEB-16 1 1 NO TAG20160203T120904 19 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121144 21 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121444 23 B 1 A DISK 03-FEB-16 1 2 NO TAG20160203T121512 28 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130537 30 B F A DISK 03-FEB-16 1 1 NO TAG20160203T130710 32 B F A DISK 03-FEB-16 6 1 NO SECTON_DF1
（2）列出详细备份 RMAN> list backup; (3)列出过期备份： RMAN> list expired backup;
specification does not match any backup in the repository （4）列出所有数据文件的备份集： RMAN> list backup of database;
List of Backup Sets ===================
BS Key Type LV Size ------- ---- -- ---------- 1 Full 644.25M List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1007458 02-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf
Backup Set Copy #1 of backup set 1 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:09 02-FEB-16 NO TAG20160202T233201
List of Backup Pieces for backup set 1 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 1 1 AVAILABLE /home/oracle/ts_system_01qsv0ni_1_1
Backup Set Copy #2 of backup set 1 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:09 03-FEB-16 NO TAG20160202T233201
List of Backup Pieces for backup set 1 Copy #2 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 28 1 AVAILABLE /home/oracle/01qsv0ni_1_2.all
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 13 Incr 1 320.00K DISK 00:00:05 03-FEB-16 BP Key: 33 Status: AVAILABLE Compressed: NO Tag: TAG20160203T120737 Piece Name: /home/oracle/12qt0d09_1_2.all List of Datafiles in backup set 13 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 1 Incr 1011663 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 1 Incr 1011663 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 1 Incr 1011663 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 1 Incr 1011663 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 1 Incr 1011663 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 15 Incr 1 320.00K DISK 00:00:05 03-FEB-16 BP Key: 35 Status: AVAILABLE Compressed: NO Tag: TAG20160203T120815 Piece Name: /home/oracle/14qt0d1f_1_2.all List of Datafiles in backup set 15 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 1 Incr 1011697 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 1 Incr 1011697 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 1 Incr 1011697 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 1 Incr 1011697 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 1 Incr 1011697 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 17 Incr 0 1.03G DISK 00:00:09 03-FEB-16 BP Key: 37 Status: AVAILABLE Compressed: NO Tag: TAG20160203T120904 Piece Name: /home/oracle/16qt0d30_1_2.all List of Datafiles in backup set 17 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 0 Incr 1012014 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 0 Incr 1012014 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 0 Incr 1012014 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 0 Incr 1012014 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 0 Incr 1012014 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
BS Key Type LV Size ------- ---- -- ---------- 19 Incr 1 288.00K List of Datafiles in backup set 19 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 1 Incr 1012118 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 1 Incr 1012118 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 1 Incr 1012118 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 1 Incr 1012118 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 1 Incr 1012118 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
Backup Set Copy #1 of backup set 19 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:05 03-FEB-16 NO TAG20160203T121144
List of Backup Pieces for backup set 19 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 19 1 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121144_cc2zj11r_.bkp
Backup Set Copy #2 of backup set 19 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:05 03-FEB-16 NO TAG20160203T121144
List of Backup Pieces for backup set 19 Copy #2 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 39 1 AVAILABLE /home/oracle/18qt0d80_1_2.all
BS Key Type LV Size ------- ---- -- ---------- 21 Incr 1 528.00K List of Datafiles in backup set 21 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 1 Incr 1012298 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 1 Incr 1012298 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 1 Incr 1012298 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 1 Incr 1012298 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 1 Incr 1012298 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
Backup Set Copy #1 of backup set 21 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:05 03-FEB-16 NO TAG20160203T121444
List of Backup Pieces for backup set 21 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 21 1 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121444_cc2zonk3_.bkp
Backup Set Copy #2 of backup set 21 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:05 03-FEB-16 NO TAG20160203T121444
List of Backup Pieces for backup set 21 Copy #2 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 41 1 AVAILABLE /home/oracle/1aqt0ddk_1_2.all
BS Key Type LV Size ------- ---- -- ---------- 23 Incr 1 528.00K List of Datafiles in backup set 23 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 1 Incr 1012330 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 1 Incr 1012330 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 1 Incr 1012330 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 1 Incr 1012330 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 1 Incr 1012330 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
Backup Set Copy #1 of backup set 23 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:05 03-FEB-16 NO TAG20160203T121512
List of Backup Pieces for backup set 23 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 23 1 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121512_cc2zpjxb_.bkp
Backup Set Copy #2 of backup set 23 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:05 03-FEB-16 NO TAG20160203T121512
List of Backup Pieces for backup set 23 Copy #2 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 43 1 AVAILABLE /home/oracle/1cqt0deg_1_2.all
BS Key Type LV Size ------- ---- -- ---------- 25 Full 1.30M List of Datafiles in backup set 25 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1012607 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf
Backup Set Copy #1 of backup set 25 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:00 03-FEB-16 NO TAG20160203T122250
List of Backup Pieces for backup set 25 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 25 1 AVAILABLE /home/oracle/ts_users_1fqt0dsq_1_1.dbf
Backup Set Copy #2 of backup set 25 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:00 03-FEB-16 NO TAG20160203T122250
List of Backup Pieces for backup set 25 Copy #2 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 26 1 AVAILABLE /home/oracle/ts_users_1fqt0dsq_1_2.dbf
Backup Set Copy #3 of backup set 25 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:00 03-FEB-16 NO TAG20160203T122250
List of Backup Pieces for backup set 25 Copy #3 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 45 1 AVAILABLE /home/oracle/1fqt0dsq_1_3.all
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 28 Full 1.03G DISK 00:00:07 03-FEB-16 BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20160203T130537 Piece Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130537_cc32o1qp_.bkp List of Datafiles in backup set 28 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1035294 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 Full 1035294 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 Full 1035294 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 Full 1035294 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 Full 1035294 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf 6 Full 1035105 03-FEB-16 /u01/app/oracle/oradata/ts_xxf_01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 30 Full 1.03G DISK 00:00:07 03-FEB-16 BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20160203T130710 Piece Name: /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130710_cc32qz6j_.bkp List of Datafiles in backup set 30 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1035376 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf 2 Full 1035376 03-FEB-16 /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 Full 1035376 03-FEB-16 /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 Full 1035376 03-FEB-16 /u01/app/oracle/oradata/PROD1/users01.dbf 5 Full 1035376 03-FEB-16 /u01/app/oracle/oradata/PROD1/ts_catalog.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 32 Full 644.54M DISK 00:00:07 03-FEB-16 List of Datafiles in backup set 32 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1038117 03-FEB-16 /u01/app/oracle/oradata/PROD1/system01.dbf
Backup Set Copy #1 of backup set 32 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:07 03-FEB-16 NO SECTON_DF1
List of Backup Pieces for backup set 32 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 52 1 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hht8_.bkp 53 2 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjkx_.bkp 54 3 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjmb_.bkp 55 4 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjnn_.bkp 56 5 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hl96_.bkp 57 6 AVAILABLE /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hol4_.bkp （5）列出控制文件的备份集； RMAN> list backup of CONTROLFILE; （6）列出spfile备份集： RMAN> list backup of spfile;
|
|
2 |
Report （1）报告目标数据库的物理结构： RMAN> report schema;
Report of database schema for database with db_unique_name PROD1
List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 750 SYSTEM *** /u01/app/oracle/oradata/PROD1/system01.dbf 2 540 SYSAUX *** /u01/app/oracle/oradata/PROD1/sysaux01.dbf 3 90 UNDOTBS1 *** /u01/app/oracle/oradata/PROD1/undotbs01.dbf 4 5 USERS *** /u01/app/oracle/oradata/PROD1/users01.dbf 5 20 TS_CATALOG *** /u01/app/oracle/oradata/PROD1/ts_catalog.dbf 6 10 TS_XXF *** /u01/app/oracle/oradata/ts_xxf_01.dbf
List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 29 TEMP 32767 /u01/app/oracle/oradata/PROD1/temp01.dbf （2）报告已丢弃的备份集（配置了保留策略） RMAN> report obsolete;
RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 1 02-FEB-16 Backup Piece 1 02-FEB-16 /home/oracle/ts_system_01qsv0ni_1_1 Backup Set 1 03-FEB-16 Backup Piece 28 03-FEB-16 /home/oracle/01qsv0ni_1_2.all Backup Set 2 02-FEB-16 Backup Piece 2 02-FEB-16 /home/oracle/ts_system_02qsv0o1_1_1 Backup Set 2 03-FEB-16 Backup Piece 29 03-FEB-16 /home/oracle/02qsv0o1_1_2.all Datafile Copy 1 02-FEB-16 /home/oracle/cp_system_data_D-PROD1_I-2124121348_TS-SYSTEM_FNO-1_05qsv17t Control File Copy 2 02-FEB-16 /home/oracle/cp_system_cf_D-PROD1_id-2124121348_06qsv18d Backup Set 5 02-FEB-16 Backup Piece 5 02-FEB-16 /home/oracle/cp_system_07qsv18e_1_1 Backup Set 5 03-FEB-16 Backup Piece 30 03-FEB-16 /home/oracle/07qsv18e_1_2.all Backup Set 11 03-FEB-16 Backup Piece 31 03-FEB-16 /home/oracle/0rqt0cph_1_2.all Backup Set 12 03-FEB-16 Backup Piece 32 03-FEB-16 /home/oracle/11qt0cr0_1_2.all Backup Set 13 03-FEB-16 Backup Piece 33 03-FEB-16 /home/oracle/12qt0d09_1_2.all Backup Set 14 03-FEB-16 Backup Piece 34 03-FEB-16 /home/oracle/13qt0d0g_1_2.all Backup Set 15 03-FEB-16 Backup Piece 35 03-FEB-16 /home/oracle/14qt0d1f_1_2.all Backup Set 16 03-FEB-16 Backup Piece 36 03-FEB-16 /home/oracle/15qt0d1m_1_2.all Backup Set 17 03-FEB-16 Backup Piece 37 03-FEB-16 /home/oracle/16qt0d30_1_2.all Backup Set 18 03-FEB-16 Backup Piece 38 03-FEB-16 /home/oracle/17qt0d3f_1_2.all Backup Set 18 03-FEB-16 Backup Piece 18 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902837359_cc2zcho6_.bkp Backup Set 19 03-FEB-16 Backup Piece 39 03-FEB-16 /home/oracle/18qt0d80_1_2.all Backup Set 19 03-FEB-16 Backup Piece 19 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121144_cc2zj11r_.bkp Backup Set 20 03-FEB-16 Backup Piece 40 03-FEB-16 /home/oracle/19qt0d88_1_2.all Backup Set 20 03-FEB-16 Backup Piece 20 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902837512_cc2zj876_.bkp Backup Set 21 03-FEB-16 Backup Piece 41 03-FEB-16 /home/oracle/1aqt0ddk_1_2.all Backup Set 21 03-FEB-16 Backup Piece 21 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121444_cc2zonk3_.bkp Backup Set 22 03-FEB-16 Backup Piece 42 03-FEB-16 /home/oracle/1bqt0ddr_1_2.all Backup Set 22 03-FEB-16 Backup Piece 22 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902837691_cc2zovn3_.bkp Backup Set 23 03-FEB-16 Backup Piece 23 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121512_cc2zpjxb_.bkp Backup Set 23 03-FEB-16 Backup Piece 43 03-FEB-16 /home/oracle/1cqt0deg_1_2.all Backup Set 24 03-FEB-16 Backup Piece 24 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902837720_cc2zpr3t_.bkp Backup Set 24 03-FEB-16 Backup Piece 44 03-FEB-16 /home/oracle/1dqt0deo_1_2.all Backup Set 25 03-FEB-16 Backup Piece 45 03-FEB-16 /home/oracle/1fqt0dsq_1_3.all Backup Set 25 03-FEB-16 Backup Piece 26 03-FEB-16 /home/oracle/ts_users_1fqt0dsq_1_2.dbf Backup Set 25 03-FEB-16 Backup Piece 25 03-FEB-16 /home/oracle/ts_users_1fqt0dsq_1_1.dbf Backup Set 26 03-FEB-16 Backup Piece 46 03-FEB-16 /home/oracle/1gqt0dsr_1_2.all Backup Set 26 03-FEB-16 Backup Piece 27 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902838171_cc304voc_.bkp Archive Log 9 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_10_cc326jj5_.arc Backup Set 27 03-FEB-16 Backup Piece 47 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902839082_cc311b7b_.bkp Backup Set 29 03-FEB-16 Backup Piece 49 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902840752_cc32ojs8_.bkp Backup Set 31 03-FEB-16 Backup Piece 51 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902840846_cc32rg89_.bkp Backup Set 33 03-FEB-16 Backup Piece 58 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902842614_cc34hpst_.bkp Backup Set 35 03-FEB-16 Backup Piece 60 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902844614_cc36g6kp_.bkp Backup Set 37 03-FEB-16 Backup Piece 62 03-FEB-16 /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_ncnnf_TAG20160203T141353_cc36o2fx_.bkp （3）报告当前数据库中不可恢复的数据文件(即没有这个数据文件的备份、或者该数据文件的备份已经过期） RMAN> report unrecoverable; （4）报告最近2天没有备份的数据文件 RMAN> report need backup days=2; （5）报告恢复数据文件需要的增量备份个数超过2次的数据文件； RMAN> report need backup incremental 2; （6）报告备份文件低于2份的所有数据文件； RMAN> report need backup redundancy 2 database;
Report of files with less than 2 redundant backups File #bkps Name ---- ----- ----------------------------------------------------- 6 1 /u01/app/oracle/oradata/ts_xxf_01.dbf
|
|
3 |
Crosscheck （1）校验所有的备份集
RMAN> crosscheck backup; （2）校验特定表空间的备份集 RMAN> crosscheck backup of tablespace users;
using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/12qt0d09_1_2.all RECID=33 STAMP=902839052 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/14qt0d1f_1_2.all RECID=35 STAMP=902839054 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/16qt0d30_1_2.all RECID=37 STAMP=902839056 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121144_cc2zj11r_.bkp RECID=19 STAMP=902837505 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/18qt0d80_1_2.all RECID=39 STAMP=902839072 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/1aqt0ddk_1_2.all RECID=41 STAMP=902839075 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121444_cc2zonk3_.bkp RECID=21 STAMP=902837684 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnnd1_TAG20160203T121512_cc2zpjxb_.bkp RECID=23 STAMP=902837712 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/1cqt0deg_1_2.all RECID=43 STAMP=902839077 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/ts_users_1fqt0dsq_1_1.dbf RECID=25 STAMP=902838170 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/1fqt0dsq_1_3.all RECID=45 STAMP=902839079 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/ts_users_1fqt0dsq_1_2.dbf RECID=26 STAMP=902838170 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130537_cc32o1qp_.bkp RECID=48 STAMP=902840737 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130710_cc32qz6j_.bkp RECID=50 STAMP=902840831 Crosschecked 14 objects
（3）校验控制文件的备份集： RMAN> crosscheck backup of controlfile; （4）校验所有的映像副本； RMAN> crosscheck copy of database;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=28 device type=DISK validation succeeded for datafile copy datafile copy file name=/home/oracle/cp_system_data_D-PROD1_I-2124121348_TS-SYSTEM_FNO-1_05qsv17t RECID=1 STAMP=902792454 Crosschecked 1 objects （5）校验特定数据文件的映像副本： RMAN> crosscheck copy of database;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=28 device type=DISK validation succeeded for datafile copy datafile copy file name=/home/oracle/cp_system_data_D-PROD1_I-2124121348_TS-SYSTEM_FNO-1_05qsv17t RECID=1 STAMP=902792454 Crosschecked 1 objects （6）校验所有归档 RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=28 device type=DISK validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_10_cc326jj5_.arc RECID=9 STAMP=902840272 validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_11_cc36g4x6_.arc RECID=10 STAMP=902844612 validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_12_cc36nzwn_.arc RECID=11 STAMP=902844831 validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_13_cc36o4b8_.arc RECID=12 STAMP=902844836 validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_14_cc37lw3p_.arc RECID=13 STAMP=902845788 validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_15_cc37tp51_.arc RECID=14 STAMP=902846038 validation succeeded for archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_16_cc37w7n0_.arc RECID=15 STAMP=902846087 Crosschecked 7 objects
|
|
4 |
Delete （1）删除过时备份（超出备份策略的备份） RMAN> delete obsolete; （2）删除过期备份（校验失败的备份） RMAN> delete expired backup;
（3）删除过期副本（校验失败副本） RMAN> delete expired copy;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=28 device type=DISK specification does not match any datafile copy in the repository specification does not match any control file copy in the repository specification does not match any archived log in the repository （4）删除所有备份集 RMAN> delete backupset;
using channel ORA_DISK_1
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 48 28 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130537_cc32o1qp_.bkp 50 30 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130710_cc32qz6j_.bkp 52 32 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hht8_.bkp 53 32 2 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjkx_.bkp 54 32 3 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjmb_.bkp 55 32 4 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjnn_.bkp 56 32 5 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hl96_.bkp 57 32 6 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hol4_.bkp 59 34 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_annnn_TAG20160203T141013_cc36g5bm_.bkp 61 36 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_annnn_TAG20160203T141351_cc36o04t_.bkp 63 38 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_annnn_TAG20160203T141356_cc36o4kj_.bkp 64 39 1 1 AVAILABLE DISK /u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902844837_cc36o5rk_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130537_cc32o1qp_.bkp RECID=48 STAMP=902840737 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_TAG20160203T130710_cc32qz6j_.bkp RECID=50 STAMP=902840831 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hht8_.bkp RECID=52 STAMP=902842607 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjkx_.bkp RECID=53 STAMP=902842608 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjmb_.bkp RECID=54 STAMP=902842608 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hjnn_.bkp RECID=55 STAMP=902842608 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hl96_.bkp RECID=56 STAMP=902842610 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_nnndf_SECTON_DF1_cc34hol4_.bkp RECID=57 STAMP=902842613 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_annnn_TAG20160203T141013_cc36g5bm_.bkp RECID=59 STAMP=902844613 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_annnn_TAG20160203T141351_cc36o04t_.bkp RECID=61 STAMP=902844832 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/backupset/2016_02_03/o1_mf_annnn_TAG20160203T141356_cc36o4kj_.bkp RECID=63 STAMP=902844836 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_02_03/o1_mf_s_902844837_cc36o5rk_.bkp RECID=64 STAMP=902844837 Deleted 12 objects
（5）删除所有映像副本： RMAN> delete copy;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=28 device type=DISK specification does not match any datafile copy in the repository specification does not match any control file copy in the repository List of Archived Log Copies for database with db_unique_name PROD1 =====================================================================
Key Thrd Seq S Low Time ------- ---- ------- - --------- 10 1 11 A 03-FEB-16 Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_11_cc36g4x6_.arc
11 1 12 A 03-FEB-16 Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_12_cc36nzwn_.arc
12 1 13 A 03-FEB-16 Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_13_cc36o4b8_.arc
13 1 14 A 03-FEB-16 Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_14_cc37lw3p_.arc
14 1 15 A 03-FEB-16 Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_15_cc37tp51_.arc
15 1 16 A 03-FEB-16 Name: /u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_16_cc37w7n0_.arc
Do you really want to delete the above objects (enter YES or NO)? y deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_11_cc36g4x6_.arc RECID=10 STAMP=902844612 deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_12_cc36nzwn_.arc RECID=11 STAMP=902844831 deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_13_cc36o4b8_.arc RECID=12 STAMP=902844836 deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_14_cc37lw3p_.arc RECID=13 STAMP=902845788 deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_15_cc37tp51_.arc RECID=14 STAMP=902846038 deleted archived log archived log file name=/u01/app/oracle/fast_recovery_area/PROD1/archivelog/2016_02_03/o1_mf_1_16_cc37w7n0_.arc RECID=15 STAMP=902846087 Deleted 6 objects |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30606702/viewspace-1986060/ ，如需转载，请注明出处，否则将追究法律责任。
