现在的位置: 首页 > 综合 > 正文

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

2013年05月27日 ⁄ 综合 ⁄ 共 28675字 ⁄ 字号 评论关闭
文章目录

一.说明

 

     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.csdn.net/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

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

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.csdn.net/tianlesoftware/article/details/4974440

 

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

 

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

 

 

3.1 使用RMAN Nocatalog 进行全库备份

 

Nocatalog 下的RMAN 增量备份 shell脚本

http://blog.csdn.net/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

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

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.csdn.net/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

 

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 datafile backupset 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 datafile00014 to /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: piecehandle=/u01/bak/dave_lev0_0ko76nim_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

Finished restore at 2013-04-16 06:12:14

 

RMAN> recover database;

 

Starting recover at 2013-04-16 06:12:17

using channel ORA_DISK_1

 

starting media recovery

 

archived log for thread 1 with sequence 24is already on disk as file/u01/app/oracle/fast_recovery_area/ANQING/archivelog/2013_04_16/o1_mf_1_24_8prydhlc_.arc

archived log for thread 1 with sequence 25is already on disk as file /u01/app/oracle/fast_recovery_area/ANQING/archivelog/2013_04_16/o1_mf_1_25_8prxqnrq_.arc

archived log for thread 1 with sequence 26is already on disk as file/u01/app/oracle/fast_recovery_area/ANQING/archivelog/2013_04_16/o1_mf_1_26_8prydhsm_.arc

channel ORA_DISK_1: starting archived logrestore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=23

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

channel ORA_DISK_1: piece handle=/u01/bak/arch_0no76njh_1_1_20130416tag=ARC_BAK

channel ORA_DISK_1: restored backup piece 1

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

archived log filename=/u01/app/oracle/fast_recovery_area/ANQING/archivelog/2013_04_16/o1_mf_1_23_8pryt3dw_.arcthread=1 sequence=23

channel default: deleting archived log(s)

archived log filename=/u01/app/oracle/fast_recovery_area/ANQING/archivelog/2013_04_16/o1_mf_1_23_8pryt3dw_.arcRECID=19 STAMP=812873540

archived log file name=/u01/app/oracle/fast_recovery_area/ANQING/archivelog/2013_04_16/o1_mf_1_24_8prydhlc_.arcthread=1 sequence=24

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

Finished recover at 2013-04-16 06:12:23

 

RMAN> alter database open;

 

database opened

 

RMAN>

 

 

 

测试OK。

 

 

 

 

 

 

 

 

 

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

版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!

QQ:      251097186

Skype:    tianlesoftware

Email:    tianlesoftware@gmail.com

Blog:     http://blog.csdn.net/tianlesoftware

Weibo:    http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

抱歉!评论已关闭.