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

最新推荐文章于 2021-04-06 03:35:42 发布

转载最新推荐文章于 2021-04-06 03:35:42 发布 · 1.1k 阅读

备份&还原&修复专栏收录该内容

25 篇文章

订阅专栏

本文详细介绍了如何使用RMAN处理NOCATALOG备份集位置改变和控制文件重建的情况，包括将备份集重新注册到控制文件和执行完整的数据库恢复过程。

来自http://blog.youkuaiyun.com/tianlesoftware/article/details/8836092

一．说明

RMAN 备份分2种，Catalog 和Nocatalog，对于Nocatalog，oracle 会使用控制文件来保存RMAN备份的一些记录。而且实际上多数也是使用Nocatalog来备份。因为使用Nocatalog比较方便。

但对于使用Nocatalog的情况就会让RMAN 恢复的时候依赖与控制文件中记录的备份的信息。如果不一致，就会导致不能进行有效的恢复。

我们这里演示二种情况：

（1）使用RMAN 的nocatalog 进行备份，然后将备份转移到其他的目录，在进行恢复。

（2）使用Nocatalog 备份，然后重建控制文件，在使用RMAN 备份进行恢复。

两种方法都是使用catalog 命令把RMAN备份集的信息重新注册到控制文件。

二．备份集位置发生改变

在我们RMAN 进行异地恢复的时候，就会遇到路径的问题，如果路径不同，就没办法进行有效的恢复，我们看这时候怎么处理。

2.1 使用RMAN Nocatalog 进行全库备份

Nocatalog 下的RMAN 增量备份 shell脚本

http://blog.youkuaiyun.com/tianlesoftware/article/details/6164931

2.2 查看备份信息

[oracle@dave scripts]$ exportNLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

[oracle@dave scripts]$ rman target /

Recovery Manager: Release 11.2.0.3.0 -Production on Tue Apr 16 04:49:49 2013

connected to target database: ANQING(DBID=743034417)

RMAN> list backup 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 2013-04-16 04:25:53 1 1 NO DAVE_LEV0

19 B 0 A DISK 2013-04-16 04:26:01 1 1 NO DAVE_LEV0

21 B 0 A DISK 2013-04-16 04:26:16 1 1 NO DAVE_LEV0

22 B A A DISK 2013-04-16 04:26:26 1 1 NO ARC_BAK

24 B F A DISK 2013-04-16 04:26:31 1 1 NO BAK_CTLFILE

这里通过list 命令查看，也可以通过如下视图来查看详细信息：

V$BACKUP_PIECE,

V$BACKUP_SET,

V$BACKUP_DATAFILE,

V$BACKUP_REDOLOG,

V$BACKUP_SPFILE.

通过V$BACKUP_PIECE 查询出来的备份集：

/u01/backup/dave_lev0_0jo76nh7_1_1_20130416

/u01/backup/dave_lev0_0io76nh7_1_1_20130416

/u01/backup/dave_lev0_0ko76nim_1_1_20130416

/u01/backup/arch_0no76njh_1_1_20130416

/u01/backup/ctl_file_0oo76njm_1_1_20130416

我这里备份集保存在/u01/backup的目录：

[oracle@dave admin]$ cd /u01/backup

[oracle@dave backup]$ 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.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

2.5 将备份集重新注册到控制文件

因为之前备份集的位置发生改变，导致corsscheck之后，将之前备份的记录标记为expired，我们后来手工删除了这些expired的备份集信息。

现在我们要进行恢复，必须将之前的备份信息重新注册到控制文件中来。

2.5.1 方法一：注册单个备份片

RMAN> CATALOG BACKUPPIECE '/u01/bak/arch_0no76njh_1_1_20130416','/u01/bak/ctl_file_0oo76njm_1_1_20130416';

cataloged backup piece

backup piecehandle=/u01/bak/arch_0no76njh_1_1_20130416 RECID=25 STAMP=812872014

cataloged backup piece

backup piece handle=/u01/bak/ctl_file_0oo76njm_1_1_20130416RECID=26 STAMP=812872014

--可以正常查看：

RMAN> list backupset summary;

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

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

25 B A A DISK 16-APR-13 1 1 NO ARC_BAK

26 B F A DISK 16-APR-13 1 1 NO BAK_CTLFILE

RMAN> catalog start with'/data01/';

2.5.2 方法二：注册整个目录

---ASM:

CATALOG START WITH '+disk'; # catalog allfiles from an ASM disk group

--本地目录：最后一定要加/

CATALOG START WITH '/fs1/datafiles/'; #catalog all files in directory

--有多个目录，注册多次：

RMAN> catalog start with'/data01/';
RMAN>catalog start with '/data02/';
RMAN>catalog start with '/data03/';

--示例：

RMAN> catalog start with '/u01/bak';

searching for all files that match thepattern /u01/bak

List of Files Unknown to the Database

=====================================

File Name: /u01/bak/dave_lev0_0io76nh7_1_1_20130416

File Name:/u01/bak/dave_lev0_21o687pl_1_1_20130404

File Name:/u01/bak/dave_spfile_1mo65679_1_1_20130403

File Name:/u01/bak/arch_27o687s8_1_1_20130404

File Name:/u01/bak/ctl_file_2ao6vobb_1_1_20130413

File Name: /u01/bak/arch_26o687rp_1_1_20130404

File Name:/u01/bak/arch_1ho6566m_1_1_20130403

File Name:/u01/bak/dave_lev0_20o687pl_1_1_20130404

File Name:/u01/bak/arch_1io6566n_1_1_20130403

File Name:/u01/bak/dave_spfile_29o687sc_1_1_20130404

File Name: /u01/bak/ctl_file_1lo65676_1_1_20130403

File Name: /u01/bak/block_change_tracking.f

File Name:/u01/bak/ctl_file_28o687sa_1_1_20130404

File Name:/u01/bak/dave_lev0_0ko76nim_1_1_20130416

File Name:/u01/bak/dave_lev0_22o687qp_1_1_20130404

File Name: /u01/bak/dave_lev0_0jo76nh7_1_1_20130416

Do you really want to catalog the abovefiles (enter YES or NO)? YES

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name:/u01/bak/dave_lev0_0io76nh7_1_1_20130416

File Name: /u01/bak/ctl_file_2ao6vobb_1_1_20130413

File Name:/u01/bak/dave_lev0_0ko76nim_1_1_20130416

File Name:/u01/bak/dave_lev0_0jo76nh7_1_1_20130416

List of Files Which Where Not Cataloged

=======================================

File Name: /u01/bak/dave_lev0_21o687pl_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_spfile_1mo65679_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name: /u01/bak/arch_27o687s8_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/arch_26o687rp_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name: /u01/bak/arch_1ho6566m_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_lev0_20o687pl_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name: /u01/bak/arch_1io6566n_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_spfile_29o687sc_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/ctl_file_1lo65676_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name: /u01/bak/block_change_tracking.f

RMAN-07529: Reason: catalog is not supported for this file type

File Name: /u01/bak/ctl_file_28o687sa_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_lev0_22o687qp_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

RMAN>

--验证：

RMAN> list backupset summary;

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

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

25 B A A DISK 16-APR-13 1 1 NO ARC_BAK

26 B F A DISK 16-APR-13 1 1 NO BAK_CTLFILE

27 B 0 A DISK 16-APR-13 1 1 NO DAVE_LEV0

28 B F A DISK 13-APR-13 1 1 NO BAK_CTLFILE

29 B 0 A DISK 16-APR-13 1 1 NO DAVE_LEV0

30 B 0 A DISK 16-APR-13 1 1 NO DAVE_LEV0

2.6 使用RMAN 进行完全恢复

RMAN> startup mount force

Oracle instance started

database mounted

Total System Global Area 818401280 bytes

Fixed Size 2232800 bytes

Variable Size 482348576 bytes

Database Buffers 331350016 bytes

Redo Buffers 2469888 bytes

RMAN> restore database;

Starting restore at 16-APR-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafilebackup set restore

channel ORA_DISK_1: specifying datafile(s)to restore from backup set

channel ORA_DISK_1: restoring datafile00001 to /u01/app/oracle/oradata/dave/system01.dbf

channel ORA_DISK_1: restoring datafile00010 to /u01/app/oracle/oradata/dave/FDA03.dbf

channel ORA_DISK_1: restoring datafile00011 to /u01/app/oracle/oradata/dave/FDA04.dbf

channel ORA_DISK_1: restoring datafile00012 to /u01/app/oracle/oradata/dave/ts01.dbf

channel ORA_DISK_1: restoring datafile00013 to /u01/app/oracle/oradata/dave/ts02.dbf

channel ORA_DISK_1: reading from backuppiece /u01/bak/dave_lev0_0io76nh7_1_1_20130416

channel ORA_DISK_1: piecehandle=/u01/bak/dave_lev0_0io76nh7_1_1_20130416 tag=DAVE_LEV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete,elapsed time: 00:00:35

channel ORA_DISK_1: starting datafilebackup set restore

channel ORA_DISK_1: specifying datafile(s)to restore from backup set

channel ORA_DISK_1: restoring datafile00002 to /u01/app/oracle/oradata/dave/sysaux01.dbf

channel ORA_DISK_1: restoring datafile00003 to /u01/app/oracle/oradata/dave/undotbs01.dbf

channel ORA_DISK_1: restoring datafile00004 to /u01/app/oracle/oradata/dave/users01.dbf

channel ORA_DISK_1: restoring datafile00008 to /u01/app/oracle/oradata/dave/FDA01.dbf

channel ORA_DISK_1: restoring datafile00009 to /u01/app/oracle/oradata/dave/FDA02.dbf

channel ORA_DISK_1: reading from backuppiece /u01/bak/dave_lev0_0jo76nh7_1_1_20130416

channel ORA_DISK_1: piecehandle=/u01/bak/dave_lev0_0jo76nh7_1_1_20130416 tag=DAVE_LEV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete,elapsed time: 00:00:25

channel ORA_DISK_1: starting datafilebackup set restore

channel ORA_DISK_1: specifying datafile(s)to restore from backup set

channel ORA_DISK_1: restoring datafile00005 to /u01/app/oracle/oradata/dave/example01.dbf

channel ORA_DISK_1: restoring datafile00006 to /u01/app/oracle/oradata/dave/mssm01.dbf

channel ORA_DISK_1: restoring datafile00007 to /u01/app/oracle/oradata/dave/assm01.dbf

channel ORA_DISK_1: restoring datafile 00014to /u01/app/oracle/oradata/dave/dave01.dbf

channel ORA_DISK_1: restoring datafile00015 to /u01/app/oracle/oradata/dave/anqing01.dbf

channel ORA_DISK_1: reading from backuppiece /u01/bak/dave_lev0_0ko76nim_1_1_20130416

channel ORA_DISK_1: piece handle=/u01/bak/dave_lev0_0ko76nim_1_1_20130416tag=DAVE_LEV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete,elapsed time: 00:00:25

Finished restore at 16-APR-13

RMAN> recover database;

Starting recover at 16-APR-13

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time:00:00:03

Finished recover at 16-APR-13

RMAN> alter database open;

database opened

RMAN>

成功恢复。

三 .重建控制文件

第二节中我们演示的备份集的位置发生改变。那么还有另一种情况，就是控制文件被重建了。这时候也会清空RMAN 备份中的相关信息。

而重建控制文件又分两种情况：resetlogs 和noresetlogs。

Oracle 控制文件说明

http://blog.youkuaiyun.com/tianlesoftware/article/details/4974440

使用使用resetlogs 重建控制文件后，RMAN恢复又会涉及到incarnation 问题，而Noresetlogs 就不会出现这种问题。

我们这里演示Noresetlogs 的方式重建控制文件并恢复的问题。

3.1 使用RMAN Nocatalog 进行全库备份

Nocatalog 下的RMAN 增量备份 shell脚本

http://blog.youkuaiyun.com/tianlesoftware/article/details/6164931

3.2 查看备份信息

[oracle@dave bak]$ exportNLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

[oracle@dave bak]$ rman target /

Recovery Manager: Release 11.2.0.3.0 -Production on Tue Apr 16 05:59:00 2013

connected to target database: ANQING(DBID=743034417)

RMAN> list backup summary;

using target database control file insteadof recovery catalog

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

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

25 B A A DISK 2013-04-16 04:26:25 1 1 NO ARC_BAK

26 B F A DISK 2013-04-16 04:26:30 1 1 NO BAK_CTLFILE

27 B 0 A DISK 2013-04-16 04:25:11 1 1 NO DAVE_LEV0

28 B F A DISK 2013-04-13 12:56:11 1 1 NO BAK_CTLFILE

29 B 0 A DISK 2013-04-16 04:25:58 1 1 NO DAVE_LEV0

30 B 0 A DISK 2013-04-16 04:25:11 1 1 NO DAVE_LEV0

我这里使用的还是之前的备份，所以我这里所有的备份集都是之前修改过多路径:/u01/bak.

3.3 使用noresetlogs重建控制文件

SQL> oradebug setmypid

Statement processed.

SQL> alter database backup controlfileto trace;

Database altered.

SQL> oradebug tracefile_name

/u01/app/oracle/diag/rdbms/anqing/anqing/trace/anqing_ora_8932.trc

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 818401280 bytes

Fixed Size 2232800 bytes

Variable Size 482348576 bytes

Database Buffers 331350016 bytes

Redo Buffers 2469888 bytes

SQL> CREATE CONTROLFILE REUSE DATABASE"ANQING" NORESETLOGS ARCHIVELOG

2 MAXLOGFILES 16

3 MAXLOGMEMBERS 3

4 MAXDATAFILES 100

5 MAXINSTANCES 8

6 MAXLOGHISTORY 292

7 LOGFILE

8 GROUP 1'/u01/app/oracle/oradata/dave/redo01.log' SIZE 50M BLOCKSIZE 512,

9 GROUP 2'/u01/app/oracle/oradata/dave/redo02.log' SIZE 50M BLOCKSIZE 512,

10 GROUP 3 '/u01/app/oracle/oradata/dave/redo03.log' SIZE 50M BLOCKSIZE 512

11 DATAFILE

12 '/u01/app/oracle/oradata/dave/system01.dbf',

13 '/u01/app/oracle/oradata/dave/sysaux01.dbf',

14 '/u01/app/oracle/oradata/dave/undotbs01.dbf',

15 '/u01/app/oracle/oradata/dave/users01.dbf',

16 '/u01/app/oracle/oradata/dave/example01.dbf',

17 '/u01/app/oracle/oradata/dave/mssm01.dbf ',

18 '/u01/app/oracle/oradata/dave/assm01.dbf',

19 '/u01/app/oracle/oradata/dave/FDA01.dbf',

20 '/u01/app/oracle/oradata/dave/FDA02.dbf',

21 '/u01/app/oracle/oradata/dave/FDA03.dbf',

22 '/u01/app/oracle/oradata/dave/FDA04.dbf',

23 '/u01/app/oracle/oradata/dave/ts01.dbf',

24 '/u01/app/oracle/oradata/dave/ts02.dbf',

25 '/u01/app/oracle/oradata/dave/dave01.dbf',

26 '/u01/app/oracle/oradata/dave/anqing01.dbf'

27 CHARACTER SET AL32UTF8

28 ;

Control file created.

SQL> RECOVER DATABASE

ORA-00283: recovery session canceled due toerrors

ORA-00264: no recovery required

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE'/u01/app/oracle/oradata/dave/temp01.dbf'

2 SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

Tablespace altered.

具体说明参考：

Oracle控制文件说明

http://blog.youkuaiyun.com/tianlesoftware/article/details/4974440

3.4 查看重建控制文件的RMAN 备份信息

RMAN> list backupset summary;

using target database control file insteadof recovery catalog

specification does not match any backup inthe repository

--什么信息都没。

3.5 将备份集重新注册到控制文件

RMAN> catalog start with '/u01/bak';

searching for all files that match thepattern /u01/bak

List of Files Unknown to the Database

=====================================

File Name:/u01/bak/arch_0no76njh_1_1_20130416

File Name: /u01/bak/dave_lev0_0io76nh7_1_1_20130416

File Name:/u01/bak/dave_lev0_21o687pl_1_1_20130404

File Name:/u01/bak/dave_spfile_1mo65679_1_1_20130403

File Name:/u01/bak/arch_27o687s8_1_1_20130404

File Name:/u01/bak/ctl_file_2ao6vobb_1_1_20130413

File Name: /u01/bak/arch_26o687rp_1_1_20130404

File Name:/u01/bak/arch_1ho6566m_1_1_20130403

File Name:/u01/bak/dave_lev0_20o687pl_1_1_20130404

File Name:/u01/bak/arch_1io6566n_1_1_20130403

File Name:/u01/bak/dave_spfile_29o687sc_1_1_20130404

File Name: /u01/bak/ctl_file_1lo65676_1_1_20130403

File Name: /u01/bak/block_change_tracking.f

File Name:/u01/bak/ctl_file_0oo76njm_1_1_20130416

File Name:/u01/bak/ctl_file_28o687sa_1_1_20130404

File Name:/u01/bak/dave_lev0_0ko76nim_1_1_20130416

File Name: /u01/bak/dave_lev0_22o687qp_1_1_20130404

File Name:/u01/bak/dave_lev0_0jo76nh7_1_1_20130416

Do you really want to catalog the abovefiles (enter YES or NO)? YES

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/bak/arch_0no76njh_1_1_20130416

File Name:/u01/bak/dave_lev0_0io76nh7_1_1_20130416

File Name:/u01/bak/ctl_file_2ao6vobb_1_1_20130413

File Name:/u01/bak/ctl_file_0oo76njm_1_1_20130416

File Name:/u01/bak/dave_lev0_0ko76nim_1_1_20130416

File Name: /u01/bak/dave_lev0_0jo76nh7_1_1_20130416

List of Files Which Where Not Cataloged

=======================================

File Name:/u01/bak/dave_lev0_21o687pl_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_spfile_1mo65679_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/arch_27o687s8_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/arch_26o687rp_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/arch_1ho6566m_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_lev0_20o687pl_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/arch_1io6566n_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_spfile_29o687sc_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/ctl_file_1lo65676_1_1_20130403

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name: /u01/bak/block_change_tracking.f

RMAN-07529: Reason: catalog is not supported for this file type

File Name:/u01/bak/ctl_file_28o687sa_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

File Name:/u01/bak/dave_lev0_22o687qp_1_1_20130404

RMAN-07518: Reason: Foreign database file DBID: 854240218 Database Name: DAVE

RMAN>

--效验：

RMAN> list backupset summary;

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

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

1 B A A DISK 2013-04-16 04:26:25 1 1 NO ARC_BAK

2 B 0 A DISK 2013-04-16 04:25:11 1 1 NO DAVE_LEV0

3 B F A DISK 2013-04-13 12:56:11 1 1 NO BAK_CTLFILE

4 B F A DISK 2013-04-16 04:26:30 1 1 NO BAK_CTLFILE

5 B 0 A DISK 2013-04-16 04:25:58 1 1 NO DAVE_LEV0

6 B 0 A DISK 2013-04-16 04:25:11 1 1 NO DAVE_LEV0

3.6 执行RMAN 恢复

RMAN> startup mount force;

Oracle instance started

database mounted

Total System Global Area 818401280 bytes

Fixed Size 2232800 bytes

Variable Size 482348576 bytes

Database Buffers 331350016 bytes

Redo Buffers 2469888 bytes

RMAN> restore database;

Starting restore at 2013-04-16 06:10:47

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1 device type=DISK