2.3 将整个备份集目录进行修改
[Oracle@dave u01]$ mv backup bak
[oracle@dave u01]$ cd bak
[oracle@dave bak]$ ls
arch_0no76njh_1_1_20130416 block_change_tracking.f dave_lev0_0io76nh7_1_1_20130416 dave_lev0_22o687qp_1_1_20130404
arch_1ho6566m_1_1_20130403 ctl_file_0oo76njm_1_1_20130416 dave_lev0_0jo76nh7_1_1_20130416 dave_spfile_1mo65679_1_1_20130403
arch_1io6566n_1_1_20130403 ctl_file_1lo65676_1_1_20130403 dave_lev0_0ko76nim_1_1_20130416 dave_spfile_29o687sc_1_1_20130404
arch_26o687rp_1_1_20130404 ctl_file_28o687sa_1_1_20130404 dave_lev0_20o687pl_1_1_20130404
arch_27o687s8_1_1_20130404 ctl_file_2ao6vobb_1_1_20130413 dave_lev0_21o687pl_1_1_20130404
2.4用RMAN 效验
--使用RMAN进行效验:
RMAN> list backupset summary;
using target database control file insteadof recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ---------------------- ------- ---------- ---
18 B 0 A DISK 16-APR-13 1 1 NO DAVE_LEV0
19 B 0 A DISK 16-APR-13 1 1 NO DAVE_LEV0
21 B 0 A DISK 16-APR-13 1 1 NO DAVE_LEV0
22 B A A DISK 16-APR-13 1 1 NO ARC_BAK
24 B F A DISK 16-APR-13 1 1 NO BAK_CTLFILE
备份集有两种状态:
A(Available,RMAN认为该项存在于备份介质上),
X(Expired,备份存在于控制文件或恢复目录中,但是并没有物理存在于备份介质上)
这里的状态是A。
RMAN> crosscheckbackup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 device type=DISK
crosschecked backup piece: found to be'EXPIRED'
backup piecehandle=/u01/backup/dave_lev0_0jo76nh7_1_1_20130416 RECID=18 STAMP=812867112
crosschecked backup piece: found to be'EXPIRED'
backup piecehandle=/u01/backup/dave_lev0_0io76nh7_1_1_20130416 RECID=19 STAMP=812867111
crosschecked backup piece: found to be'EXPIRED'
backup piecehandle=/u01/backup/dave_lev0_0ko76nim_1_1_20130416 RECID=21 STAMP=812867158
crosschecked backup piece: found to be'EXPIRED'
backup piecehandle=/u01/backup/arch_0no76njh_1_1_20130416 RECID=22 STAMP=812867185
crosschecked backup piece: found to be'EXPIRED'
backup piecehandle=/u01/backup/ctl_file_0oo76njm_1_1_20130416 RECID=24 STAMP=812867191
Crosschecked 5 objects
RMAN> list backupsetsummary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ---------------------- ------- ---------- ---
18 B 0 X DISK 16-APR-13 1 1 NO DAVE_LEV0
19 B 0 X DISK 16-APR-13 1 1 NO DAVE_LEV0
21 B 0 X DISK 16-APR-13 1 1 NO DAVE_LEV0
22 B A X DISK 16-APR-13 1 1 NO ARC_BAK
24 B F X DISK 16-APR-13 1 1 NO BAK_CTLFILE
--当我们corsscheck之后,状态就都变成X了。
--因为备份集物理不存在,这些都被标记为expired:
RMAN> list expired backup;
List of Backup Sets
===================
BS Key Type LV Size Device TypeElapsed Time Completion Time
------- ---- -- ---------- ----------------------- ---------------
18 Incr 0 633.95M DISK 00:00:42 16-APR-13
BP Key: 18 Status: EXPIRED Compressed: NO Tag: DAVE_LEV0
Piece Name: /u01/backup/dave_lev0_0jo76nh7_1_1_20130416
List of Datafiles in backup set 18
File LV Type Ckp SCN CkpTime Name
---- -- ---- ---------- --------- ----
2 0 Incr 3136508 16-APR-13/u01/app/oracle/oradata/dave/sysaux01.dbf
3 0 Incr 3136508 16-APR-13/u01/app/oracle/oradata/dave/undotbs01.dbf
4 0 Incr 3136508 16-APR-13/u01/app/oracle/oradata/dave/users01.dbf
8 0 Incr 3136508 16-APR-13 /u01/app/oracle/oradata/dave/FDA01.dbf
9 0 Incr 3136508 16-APR-13/u01/app/oracle/oradata/dave/FDA02.dbf
BS Key Type LV Size Device TypeElapsed Time Completion Time
------- ---- -- ---------- ----------------------- ---------------
19 Incr 0 908.19M DISK 00:00:50 16-APR-13
BP Key: 19 Status: EXPIRED Compressed: NO Tag: DAVE_LEV0
Piece Name: /u01/backup/dave_lev0_0io76nh7_1_1_20130416
List of Datafiles in backup set 19
File LV Type Ckp SCN CkpTime Name
------ ---- ---------- --------- ----
1 0 Incr 3136507 16-APR-13/u01/app/oracle/oradata/dave/system01.dbf
10 0 Incr 3136507 16-APR-13/u01/app/oracle/oradata/dave/FDA03.dbf
11 0 Incr 3136507 16-APR-13 /u01/app/oracle/oradata/dave/FDA04.dbf
12 0 Incr 3136507 16-APR-13/u01/app/oracle/oradata/dave/ts01.dbf
13 0 Incr 3136507 16-APR-13/u01/app/oracle/oradata/dave/ts02.dbf
BS Key Type LV Size Device TypeElapsed Time Completion Time
------- ---- -- ---------- ----------------------- ---------------
21 Incr 0 426.01M DISK 00:00:18 16-APR-13
BP Key: 21 Status: EXPIRED Compressed: NO Tag: DAVE_LEV0
Piece Name: /u01/backup/dave_lev0_0ko76nim_1_1_20130416
List of Datafiles in backup set 21
File LV Type Ckp SCN CkpTime Name
---- -- ---- ---------- --------- ----
5 0 Incr 3136645 16-APR-13/u01/app/oracle/oradata/dave/example01.dbf
6 0 Incr 3136645 16-APR-13/u01/app/oracle/oradata/dave/mssm01.dbf
7 0 Incr 3136645 16-APR-13/u01/app/oracle/oradata/dave/assm01.dbf
14 0 Incr 3136645 16-APR-13/u01/app/oracle/oradata/dave/dave01.dbf
15 0 Incr 3136645 16-APR-13/u01/app/oracle/oradata/dave/anqing01.dbf
BS Key Size Device Type ElapsedTime Completion Time
------- ---------- ----------- ---------------------------
22 40.93M DISK 00:00:01 16-APR-13
BP Key: 22 Status: EXPIRED Compressed: NO Tag: ARC_BAK
Piece Name: /u01/backup/arch_0no76njh_1_1_20130416
List of Archived Logs in backup set 22
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 23 3120875 15-APR-13 3136670 16-APR-13
1 24 3136670 16-APR-13 3136678 16-APR-13
BS Key Type LV Size Device TypeElapsed Time Completion Time
------- ---- -- ---------- ----------------------- ---------------
24 Full 9.64M DISK 00:00:01 16-APR-13
BP Key: 24 Status: EXPIRED Compressed: NO Tag: BAK_CTLFILE
Piece Name: /u01/backup/ctl_file_0oo76njm_1_1_20130416
Control File Included: Ckp SCN: 3136695 Ckp time: 16-APR-13
RMAN>
--删除这些过期的信息:
RMAN> delete noprompt expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ---------------------- ----------
18 18 1 1 EXPIRED DISK /u01/backup/dave_lev0_0jo76nh7_1_1_20130416
19 19 1 1 EXPIRED DISK /u01/backup/dave_lev0_0io76nh7_1_1_20130416
21 21 1 1 EXPIRED DISK /u01/backup/dave_lev0_0ko76nim_1_1_20130416
22 22 1 1 EXPIRED DISK /u01/backup/arch_0no76njh_1_1_20130416
24 24 1 1 EXPIRED DISK /u01/backup/ctl_file_0oo76njm_1_1_20130416
deleted backup piece
backup piecehandle=/u01/backup/dave_lev0_0jo76nh7_1_1_20130416 RECID=18 STAMP=812867112
deleted backup piece
backup piecehandle=/u01/backup/dave_lev0_0io76nh7_1_1_20130416 RECID=19 STAMP=812867111
deleted backup piece
backup piecehandle=/u01/backup/dave_lev0_0ko76nim_1_1_20130416 RECID=21 STAMP=812867158
deleted backup piece
backup piece handle=/u01/backup/arch_0no76njh_1_1_20130416RECID=22 STAMP=812867185
deleted backup piece
backup piecehandle=/u01/backup/ctl_file_0oo76njm_1_1_20130416 RECID=24 STAMP=812867191
Deleted 5 EXPIRED objects
RMAN>
--RMAN验证:
RMAN> list backupset summary;
specification does not match any backup inthe repository