oracle备份集注册,Oracle RMAN 将 备份集 重新 注册到控制文件 说明

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