|
|
list命令 | ————list 查看备份信息 RMAN> list;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "all, archivelog, backup, backuppiece, backupset, backed, completed, copy, controlfilecopy, datafilecopy, device, expired, global, incarnation, like, proxy, recoverable, script, tag" RMAN-01007: at line 1 column 5 file: standard input ————list backup 查看所有的备份集 RMAN> list backup;
List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 81 Full 362.29M DISK 00:00:18 20-DEC-11 BP Key: 81 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142150 Piece Name: /disk1/rman/prod/PROD_PROD.bak List of Datafiles in backup set 81 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 4 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 6 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 82 Full 189.68M DISK 00:00:31 20-DEC-11 BP Key: 82 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142301 Piece Name: /disk1/rman/prod/2smumi26_1_1.bak List of Datafiles in backup set 82 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 2 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/undotbs01.dbf 1 3 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/sysaux01.dbf 5 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/test01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 83 Full 362.29M DISK 00:00:41 20-DEC-11 BP Key: 83 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142301 Piece Name: /disk1/rman/prod/2rmumi25_1_1.bak List of Datafiles in backup set 83 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 4 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 6 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 84 Full 7.36M DISK 00:00:01 20-DEC-11 BP Key: 84 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142346 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770393312_7h0bhmgx_.bkp Control File Included: Ckp SCN: 1561789 Ckp time: 20-DEC-11 SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 85 Full 7.36M DISK 00:00:00 20-DEC-11 BP Key: 85 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142736 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp Control File Included: Ckp SCN: 1562150 Ckp time: 20-DEC-11 SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 86 Full 7.36M DISK 00:00:00 20-DEC-11 BP Key: 86 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142637 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp Control File Included: Ckp SCN: 1562096 Ckp time: 20-DEC-11 SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 87 Full 7.36M DISK 00:00:02 20-DEC-11 BP Key: 87 Status: AVAILABLE Compressed: NO Tag: TAG20111220T143404 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp Control File Included: Ckp SCN: 1562236 Ckp time: 20-DEC-11 SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 88 Full 552.03M DISK 00:01:19 20-DEC-11 BP Key: 88 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183532 Piece Name: /disk1/rman/prod/31mun0rk_1_1 List of Datafiles in backup set 88 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 2 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/undotbs01.dbf 3 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/sysaux01.dbf 4 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 5 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/test01.dbf 6 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 89 Full 7.36M DISK 00:00:02 20-DEC-11 BP Key: 89 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183659 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp Control File Included: Ckp SCN: 1569859 Ckp time: 20-DEC-11 SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 90 Full 8.48M DISK 00:00:01 20-DEC-11 BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230502 Piece Name: /disk1/rman/prod/users_99.bak List of Datafiles in backup set 90 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1601155 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 91 Full 7.36M DISK 00:00:01 20-DEC-11 BP Key: 91 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230507 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770425507_7h1913z5_.bkp Control File Included: Ckp SCN: 1601166 Ckp time: 20-DEC-11 SPFILE Included: Modification time: 20-DEC-11 ————查看数据库的备份信息 RMAN> list backup of database;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 81 Full 362.29M DISK 00:00:18 20-DEC-11 BP Key: 81 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142150 Piece Name: /disk1/rman/prod/PROD_PROD.bak List of Datafiles in backup set 81 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 4 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 6 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 82 Full 189.68M DISK 00:00:31 20-DEC-11 BP Key: 82 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142301 Piece Name: /disk1/rman/prod/2smumi26_1_1.bak List of Datafiles in backup set 82 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 2 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/undotbs01.dbf 3 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/sysaux01.dbf 5 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/test01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 83 Full 362.29M DISK 00:00:41 20-DEC-11 BP Key: 83 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142301 Piece Name: /disk1/rman/prod/2rmumi25_1_1.bak List of Datafiles in backup set 83 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 4 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 6 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 88 Full 552.03M DISK 00:01:19 20-DEC-11 BP Key: 88 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183532 Piece Name: /disk1/rman/prod/31mun0rk_1_1 List of Datafiles in backup set 88 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 2 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/undotbs01.dbf 3 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/sysaux01.dbf 4 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 5 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/test01.dbf 6 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 90 Full 8.48M DISK 00:00:01 20-DEC-11 BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230502 Piece Name: /disk1/rman/prod/users_99.bak List of Datafiles in backup set 90 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1601155 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf ————备份信息解释 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 88 Full 552.03M DISK 00:01:19 20-DEC-11 BP Key: 88 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183532 Piece Name: /disk1/rman/prod/31mun0rk_1_1 List of Datafiles in backup set 88 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf 2 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/undotbs01.dbf 3 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/sysaux01.dbf 4 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf 5 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/test01.dbf 6 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/lx01.dbf BS Key:备份集编号 Type:备份的类型 Elapsed Time:备份所花时间 BP Key:备份片的编号 Status:状态信息,AVAILABLE可用,UNAVAILABLE不可用,EXPIRED过期。
————查看表空间的备份信息
RMAN> list backup of tablespace users;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 81 Full 362.29M DISK 00:00:18 20-DEC-11 BP Key: 81 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142150 Piece Name: /disk1/rman/prod/PROD_PROD.bak List of Datafiles in backup set 81 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 83 Full 362.29M DISK 00:00:41 20-DEC-11 BP Key: 83 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142301 Piece Name: /disk1/rman/prod/2rmumi25_1_1.bak List of Datafiles in backup set 83 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 88 Full 552.03M DISK 00:01:19 20-DEC-11 BP Key: 88 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183532 Piece Name: /disk1/rman/prod/31mun0rk_1_1 List of Datafiles in backup set 88 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 90 Full 8.48M DISK 00:00:01 20-DEC-11 BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230502 Piece Name: /disk1/rman/prod/users_99.bak List of Datafiles in backup set 90 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1601155 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf
————查看指定数据文件的备份 RMAN> list backup of datafile 1;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 81 Full 362.29M DISK 00:00:18 20-DEC-11 BP Key: 81 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142150 Piece Name: /disk1/rman/prod/PROD_PROD.bak List of Datafiles in backup set 81 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 83 Full 362.29M DISK 00:00:41 20-DEC-11 BP Key: 83 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142301 Piece Name: /disk1/rman/prod/2rmumi25_1_1.bak List of Datafiles in backup set 83 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1561789 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 88 Full 552.03M DISK 00:01:19 20-DEC-11 BP Key: 88 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183532 Piece Name: /disk1/rman/prod/31mun0rk_1_1 List of Datafiles in backup set 88 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1569815 20-DEC-11 /u01/app/oracle/oradata/prod/system01.dbf
————查看控制文件备份信息 RMAN> list backup of controlfile;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 84 Full 7.36M DISK 00:00:01 20-DEC-11 BP Key: 84 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142346 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770393312_7h0bhmgx_.bkp Control File Included: Ckp SCN: 1561789 Ckp time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 85 Full 7.36M DISK 00:00:00 20-DEC-11 BP Key: 85 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142736 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp Control File Included: Ckp SCN: 1562150 Ckp time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 86 Full 7.36M DISK 00:00:00 20-DEC-11 BP Key: 86 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142637 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp Control File Included: Ckp SCN: 1562096 Ckp time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 87 Full 7.36M DISK 00:00:02 20-DEC-11 BP Key: 87 Status: AVAILABLE Compressed: NO Tag: TAG20111220T143404 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp Control File Included: Ckp SCN: 1562236 Ckp time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 89 Full 7.36M DISK 00:00:02 20-DEC-11 BP Key: 89 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183659 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp Control File Included: Ckp SCN: 1569859 Ckp time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 91 Full 7.36M DISK 00:00:01 20-DEC-11 BP Key: 91 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230507 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770425507_7h1913z5_.bkp Control File Included: Ckp SCN: 1601166 Ckp time: 20-DEC-11 ————查看SPFILE备份 RMAN> list backup of spfile;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 84 Full 7.36M DISK 00:00:01 20-DEC-11 BP Key: 84 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142346 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770393312_7h0bhmgx_.bkp SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 85 Full 7.36M DISK 00:00:00 20-DEC-11 BP Key: 85 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142736 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 86 Full 7.36M DISK 00:00:00 20-DEC-11 BP Key: 86 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142637 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 87 Full 7.36M DISK 00:00:02 20-DEC-11 BP Key: 87 Status: AVAILABLE Compressed: NO Tag: TAG20111220T143404 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 89 Full 7.36M DISK 00:00:02 20-DEC-11 BP Key: 89 Status: AVAILABLE Compressed: NO Tag: TAG20111220T183659 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 91 Full 7.36M DISK 00:00:01 20-DEC-11 BP Key: 91 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230507 Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770425507_7h1913z5_.bkp SPFILE Included: Modification time: 20-DEC-11 ————查看所有归档日志的备份 RMAN> list backup of archivelog all;
————查看昨天这个时间之前的所归档日志的备份信息
RMAN> list backup of archivelog until time "sysdate-1"; ————查看拷贝 RMAN> list copy;
List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - --------- ---- 264 1 1 A 20-DEC-11 /u01/arch1/1_1_770385366.log 265 1 1 A 20-DEC-11 /u01/arch2/1_1_770385366.log 266 1 1 A 20-DEC-11 /u01/arch1/1_1_770386134.log 267 1 1 A 20-DEC-11 /u01/arch2/1_1_770386134.log 268 1 2 A 20-DEC-11 /u01/arch1/1_2_770386134.log 269 1 2 A 20-DEC-11 /u01/arch2/1_2_770386134.log 270 1 3 A 20-DEC-11 /u01/arch1/1_3_770386134.log ————查看指定编号的备份集 RMAN> list backupset 90;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 90 Full 8.48M DISK 00:00:01 20-DEC-11 BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230502 Piece Name: /disk1/rman/prod/users_99.bak List of Datafiles in backup set 90 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1601155 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf
————查看指定编号的备份片 RMAN> list backuppiece 90;
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 90 90 1 1 AVAILABLE DISK /disk1/rman/prod/users_99.bak ————查看指定名称的备份片 RMAN> list backuppiece '/disk1/rman/prod/users_99.bak';
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 90 90 1 1 AVAILABLE DISK /disk1/rman/prod/users_99.bak ————查看数据文件镜像 RMAN> backup as copy datafile 5 format '/disk1/rman/prod/%U.bak';
Starting backup at 22-DEC-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=140 devtype=DISK channel ORA_DISK_1: starting datafile copy input datafile fno=00005 name=/u01/app/oracle/oradata/prod/test01.dbf output filename=/disk1/rman/prod/data_D-PROD_I-181201175_TS-TEST_FNO-5_35murfr9.bak tag=TAG20111222T111553 recid=57 stamp=770555756 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 Finished backup at 22-DEC-11
Starting Control File and SPFILE Autobackup at 22-DEC-11 piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770555760_7h587knt_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 22-DEC-11 RMAN> list copy;
List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 57 5 A 22-DEC-11 1640564 22-DEC-11 /disk1/rman/prod/data_D-PROD_I-181201175_TS-TEST_FNO-5_35murfr9.bak
RMAN> list datafilecopy 57;
List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 57 5 A 22-DEC-11 1640564 22-DEC-11 /disk1/rman/prod/data_D-PROD_I-181201175_TS-TEST_FNO-5_35murfr9.bak
|
crosscheck命令 | 备份后 Status:值为AVAILABLE ,但如果手工在操作系统上把这个文件删除,则list backup查看来这个文件的状态仍然为可用,因为控制文件中不知道你在操作系统下执行了删除命令,crosscheck命令就是检测备份集是否在操作系统下还可用并记录到控制文件中。检测可以还可用的话才能说明这个备份真的可用。 RMAN> crosscheck backup;
using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/PROD_PROD.bak recid=81 stamp=770394112 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/2smumi26_1_1.bak recid=82 stamp=770394182 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/2rmumi25_1_1.bak recid=83 stamp=770394182 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770393312_7h0bhmgx_.bkp recid=84 stamp=770394227 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp recid=85 stamp=770394761 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp recid=86 stamp=770394761 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp recid=87 stamp=770394845 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/31mun0rk_1_1 recid=88 stamp=770409333 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp recid=89 stamp=770409421 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/users_99.bak recid=90 stamp=770425502 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770425507_7h1913z5_.bkp recid=91 stamp=770425507 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770555760_7h587knt_.bkp recid=92 stamp=770555761 Crosschecked 12 objects 如果不可用则为 EXPIRED ————查看指定备份集 RMAN> list backupset 90;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 90 Full 8.48M DISK 00:00:01 20-DEC-11 BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230502 Piece Name: /disk1/rman/prod/users_99.bak List of Datafiles in backup set 90 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1601155 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf ————操作系统下删除备份集 [oracle@backup ~]$ rm /disk1/rman/prod/users_99.bak ————再查看备份集,还是可用 RMAN> list backupset 90;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 90 Full 8.48M DISK 00:00:01 20-DEC-11 BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20111220T230502 Piece Name: /disk1/rman/prod/users_99.bak List of Datafiles in backup set 90 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 1601155 20-DEC-11 /u01/app/oracle/oradata/prod/users01.dbf ————这时执行检测,可以看到不可用的备份
RMAN> crosscheck backup;
using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/PROD_PROD.bak recid=81 stamp=770394112 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/2smumi26_1_1.bak recid=82 stamp=770394182 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/2rmumi25_1_1.bak recid=83 stamp=770394182 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770393312_7h0bhmgx_.bkp recid=84 stamp=770394227 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp recid=85 stamp=770394761 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp recid=86 stamp=770394761 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp recid=87 stamp=770394845 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/31mun0rk_1_1 recid=88 stamp=770409333 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp recid=89 stamp=770409421 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/disk1/rman/prod/users_99.bak recid=90 stamp=770425502 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770425507_7h1913z5_.bkp recid=91 stamp=770425507 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770555760_7h587knt_.bkp recid=92 stamp=770555761 Crosschecked 12 objects ————删除过期的备份 RMAN> delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 90 90 1 1 EXPIRED DISK /disk1/rman/prod/users_99.bak
Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/disk1/rman/prod/users_99.bak recid=90 stamp=770425502 Deleted 1 EXPIRED objects ————这时就没有过期的备份了 RMAN> crosscheck backup;
using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/PROD_PROD.bak recid=81 stamp=770394112 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/2smumi26_1_1.bak recid=82 stamp=770394182 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/2rmumi25_1_1.bak recid=83 stamp=770394182 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770393312_7h0bhmgx_.bkp recid=84 stamp=770394227 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp recid=85 stamp=770394761 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp recid=86 stamp=770394761 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp recid=87 stamp=770394845 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/disk1/rman/prod/31mun0rk_1_1 recid=88 stamp=770409333 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp recid=89 stamp=770409421 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_20/o1_mf_s_770425507_7h1913z5_.bkp recid=91 stamp=770425507 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770555760_7h587knt_.bkp recid=92 stamp=770555761 Crosschecked 11 objects ————用CROSSCHECK 检测COPY RMAN> crosscheck copy; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=140 devtype=DISK validation succeeded for datafile copy datafile copy filename=/disk1/rman/prod/data_D-PROD_I-181201175_TS-TEST_FNO-5_35murfr9.bak recid=57 stamp=770555756 validation succeeded for archived log archive log filename=/u01/arch1/1_1_770385366.log recid=264 stamp=770386135 validation succeeded for archived log archive log filename=/u01/arch2/1_1_770385366.log recid=265 stamp=770386135 ————删除过期的COPY RMAN> delete expired copy;
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=140 devtype=DISK
List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - --------- ---- 281 1 8 X 20-DEC-11 /u01/arch2/1_8_770386134.log
Do you really want to delete the above objects (enter YES or NO)? yes deleted archive log archive log filename=/u01/arch2/1_8_770386134.log recid=281 stamp=770389730 Deleted 1 EXPIRED objects
|
report命令 | report命令,通过资料库生成一些报告,报告中记录数据库的物理结构。 ————report schema 查看数据库的物理结构 RMAN> report schema;
Report of database schema
List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 480 SYSTEM *** /u01/app/oracle/oradata/prod/system01.dbf 2 25 UNDOTBS1 *** /u01/app/oracle/oradata/prod/undotbs01.dbf 3 260 SYSAUX *** /u01/app/oracle/oradata/prod/sysaux01.dbf 4 10 USERS *** /u01/app/oracle/oradata/prod/users01.dbf 5 20 TEST *** /u01/app/oracle/oradata/prod/test01.dbf 6 20 LX *** /u01/app/oracle/oradata/prod/lx01.dbf
List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 20 TEMP 32767 /u01/app/oracle/oradata/prod/temp01.dbf ————report need backup 查看需要做哪些备份 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> delete backup;
————就时可以看到需要做哪些备份 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 ---- ----- ----------------------------------------------------- 1 0 /u01/app/oracle/oradata/prod/system01.dbf 2 0 /u01/app/oracle/oradata/prod/undotbs01.dbf 3 0 /u01/app/oracle/oradata/prod/sysaux01.dbf 4 0 /u01/app/oracle/oradata/prod/users01.dbf 6 0 /u01/app/oracle/oradata/prod/lx01.dbf ————备份 RMAN> backup database format '/disk1/rman/prod/%U.bak';
Starting backup at 22-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbf input datafile fno=00003 name=/u01/app/oracle/oradata/prod/sysaux01.dbf input datafile fno=00002 name=/u01/app/oracle/oradata/prod/undotbs01.dbf input datafile fno=00005 name=/u01/app/oracle/oradata/prod/test01.dbf input datafile fno=00006 name=/u01/app/oracle/oradata/prod/lx01.dbf input datafile fno=00004 name=/u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: starting piece 1 at 22-DEC-11 channel ORA_DISK_1: finished piece 1 at 22-DEC-11 piece handle=/disk1/rman/prod/37muri07_1_1.bak tag=TAG20111222T115239 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55 Finished backup at 22-DEC-11
Starting Control File and SPFILE Autobackup at 22-DEC-11 piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770558014_7h5bfzd3_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 22-DEC-11 ————再查看所需备份,这时就没有了 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 ---- ----- -----------------------------------------------------
————report obsolete,根据备份冗余策略来判断,那些备份是陈旧的(obsolete),当制定好备份策略后,备份在磁盘上会越来越多,可能把磁盘占满,所以要定期的清理一些备份,要把一些旧的备份删除,但手工删除又不好判断哪些备份要删除,哪些备份不能删除,
retention备份的保护策略:在RMAN中保护策略有两种,一种是建立备份冗余度,另一种是建立恢复窗口 备份冗余度:建立多个备份,相同的备份保留几份,如冗余为2,我有三个对数据库的全备,则有一个备份是过期的,RMAN会把这个过期的备份列出来。 恢复窗口:如果数据库出现故障,可以恢复到一个月(或其他时间)内的任意一天。
RMAN> show all;
RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default //默认情况下,备份的保护策略通过冗余的方式实现 CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_prod.f'; # default CONFIGURE RETENTION POLICY TO REDUNDANCY 1; //RETENTION POLICY:保护策略。REDUNDANCY:冗余。这个配置为如果是相同的备份我只保留一份。下面来验证一下: ————先查看一下,这里没有多余的冗余 RMAN> report obsolete;
RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 no obsolete backups found ————这里备份USERS表空间 RMAN> backup datafile 4 format '/disk1/rman/prod/%U.bak';
Starting backup at 22-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00004 name=/u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: starting piece 1 at 22-DEC-11 channel ORA_DISK_1: finished piece 1 at 22-DEC-11 piece handle=/disk1/rman/prod/39murjdm_1_1.bak tag=TAG20111222T121654 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 22-DEC-11
Starting Control File and SPFILE Autobackup at 22-DEC-11 piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770559417_7h5cst8n_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 22-DEC-11 ————这里再备份一次USERS表空间 RMAN> backup datafile 4 format '/disk1/rman/prod/%U.bak';
Starting backup at 22-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00004 name=/u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: starting piece 1 at 22-DEC-11 channel ORA_DISK_1: finished piece 1 at 22-DEC-11 piece handle=/disk1/rman/prod/3bmurjhi_1_1.bak tag=TAG20111222T121858 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 22-DEC-11
Starting Control File and SPFILE Autobackup at 22-DEC-11 piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770559539_7h5cxmt5_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 22-DEC-11 ————现在就可以看到冗余的备份了 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 94 22-DEC-11 Backup Piece 94 22-DEC-11 /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770558014_7h5bfzd3_.bkp Backup Set 95 22-DEC-11 Backup Piece 95 22-DEC-11 /disk1/rman/prod/39murjdm_1_1.bak Backup Set 96 22-DEC-11 Backup Piece 96 22-DEC-11 /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770559417_7h5cst8n_.bkp ————修改备份的冗余度,改为2 RMAN> show all;
RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters: CONFIGURE RETENTION POLICY TO REDUNDANCY 2; new RMAN configuration parameters are successfully stored ————再查看陈旧的备份,USERS表空间的陈旧备份就不出现了 RMAN> report obsolete;
RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 2 Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 94 22-DEC-11 Backup Piece 94 22-DEC-11 /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770558014_7h5bfzd3_.bkp
————设置恢复窗口
RMAN> CONFIGURE RETENTION POLICY TO ;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "none, redundancy, recovery" RMAN-01007: at line 1 column 31 file: standard input
RMAN> CONFIGURE RETENTION POLICY TO recovery;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "window" RMAN-01007: at line 1 column 39 file: standard input
RMAN> CONFIGURE RETENTION POLICY TO recovery window;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "of" RMAN-01007: at line 1 column 46 file: standard input
RMAN> CONFIGURE RETENTION POLICY TO recovery window of;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "integer" RMAN-01007: at line 2 column 1 file: standard input
RMAN> CONFIGURE RETENTION POLICY TO recovery window of 7;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "days" RMAN-01007: at line 1 column 51 file: standard input
RMAN> CONFIGURE RETENTION POLICY TO recovery window of 7 days;
old RMAN configuration parameters: CONFIGURE RETENTION POLICY TO REDUNDANCY 2; new RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; new RMAN configuration parameters are successfully stored ————备份的保护策略只能选择一种,要么冗余度,要么恢复窗口,不能同时使用。 RMAN> show all;
RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_prod.f'; # default ————应该都没有陈旧 RMAN> report obsolete;
RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 7 days no obsolete backups found
|
delete | RMAN> delete backup of datafile 2; RMAN> delete backup of tablespace system; RMAN> delete backup ; RMAN> delete backup of controlfile; RMAN> delete noprompt backup of controlfile; ;删除noprompt 不提示 RMAN> delete copy; RMAN> delete copy of datafile 10; RMAN> delete copy of tablespace users; RMAN> delete expired backup; 删除过期的备份 RMAN> delete expired copy; RMAN> delete obsolete ;删除陈旧的备份 RMAN> delete noprompt obsolete; 删除不加提示
————delete backup删除所有的备份 RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 93 93 1 1 AVAILABLE DISK /disk1/rman/prod/37muri07_1_1.bak 94 94 1 1 AVAILABLE DISK /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770558014_7h5bfzd3_.bkp 95 95 1 1 AVAILABLE DISK /disk1/rman/prod/39murjdm_1_1.bak 96 96 1 1 AVAILABLE DISK /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770559417_7h5cst8n_.bkp 97 97 1 1 AVAILABLE DISK /disk1/rman/prod/3bmurjhi_1_1.bak 98 98 1 1 AVAILABLE DISK /u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770559539_7h5cxmt5_.bkp
Do you really want to delete the above objects (enter YES or NO)? n ————删除指定的备份集 RMAN> delete backupset 93;
using channel ORA_DISK_1
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 93 93 1 1 AVAILABLE DISK /disk1/rman/prod/37muri07_1_1.bak
Do you really want to delete the above objects (enter YES or NO)? n ————删除镜像 RMAN> copy datafile 4 to '/disk1/rman/prod/%U.bak';
Starting backup at 22-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile fno=00004 name=/u01/app/oracle/oradata/prod/users01.dbf output filename=/disk1/rman/prod/data_D-PROD_I-181201175_TS-USERS_FNO-4_3dmurovc.bak tag=TAG20111222T135140 recid=58 stamp=770565101 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 22-DEC-11
Starting Control File and SPFILE Autobackup at 22-DEC-11 piece handle=/u01/app/oracle/flash_recovery_area/PROD/autobackup/2011_12_22/o1_mf_s_770565101_7h5kcgb1_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 22-DEC-11
RMAN> list copy;
specification does not match any archive log in the recovery catalog
List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 58 4 A 22-DEC-11 1645641 22-DEC-11 /disk1/rman/prod/data_D-PROD_I-181201175_TS-USERS_FNO-4_3dmurovc.bak
RMAN> delete noprompt datafilecopy 58;//不加任何提示,直接删除
released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=140 devtype=DISK
List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 58 4 A 22-DEC-11 1645641 22-DEC-11 /disk1/rman/prod/data_D-PROD_I-181201175_TS-USERS_FNO-4_3dmurovc.bak deleted datafile copy datafile copy filename=/disk1/rman/prod/data_D-PROD_I-181201175_TS-USERS_FNO-4_3dmurovc.bak recid=58 stamp=770565101 Deleted 1 objects
|
catalog | 6、catalog :可以把手工备份的文件,转换到rman
-------将手工备份注册为image RMAN> catalog datafilecopy '/disk1/backup/prod/hot_bak/users01.dbf';
cataloged datafile copy datafile copy filename=/disk1/backup/prod/hot_bak/users01.dbf recid=68 stamp=759556193
RMAN> list copy of datafile 2;
List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 68 2 A 19-AUG-11 1457868 19-AUG-11 /disk1/backup/prod/hot_bak/users01.dbf
RMAN> delete copy of datafile 2;
-------将手工备份注册成备份集
RMAN> catalog backuppiece '/disk1/backup/prod/hot_bak/users01.dbf';
---------注册目录下所有的备份(image)
RMAN> catalog start with ‘/disk1/backup/prod/hot_bak/’;
7、change: 修改备份状态 RMAN> change backupset 66 unAVAILABLE; RMAN> change backupset 66 AVAILABLE;
————将手工备份注册成备份集 RMAN> catalog backuppiece '/disk1/backup/prod/hot_bak/users01.dbf'; ————默认情况下不可以直接转换手工拷贝过来的控制文件,可以通过以下方式转换 SQL> alter database backup controlfile to '/disk1/backup/prod/control.bak';
RMAN> catalog controlfilecopy '/disk1/backup/prod/control.bak';
cataloged control file copy control file copy filename=/disk1/backup/prod/control.bak recid=59 stamp=770566800 RMAN> list copy;
specification does not match any archive log in the recovery catalog
List of Control File Copies Key S Completion Time Ckp SCN Ckp Time Name ------- - --------------- ---------- --------------- ---- 59 A 22-DEC-11 1240183 15-DEC-11 /disk1/backup/prod/control.bak
|
|
|
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-1980237/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30606702/viewspace-1980237/