ORACLE RMAN异机恢复

最新推荐文章于 2024-06-04 07:30:00 发布

Listen_Data

最新推荐文章于 2024-06-04 07:30:00 发布

阅读量626

点赞数

分类专栏： oracle数据库迁移恢复

本文链接：https://blog.csdn.net/u012457058/article/details/41390383

版权

本文详细介绍了在Oracle 11gR2环境下，如何进行RMAN异机恢复。关键步骤包括：查询源库DBID，利用NID修改DBID和DBNAME，以及在恢复时设置新的数据文件路径并切换数据文件。在恢复过程中，需要注意控制文件的备份，确保在修改DBID前有安全备份，并且需将数据库启动到mount状态以进行修改。

摘要由CSDN通过智能技术生成

测试平台信息：

Oracle：11gR2

操作系统：oel5.8

源库：CPP===>目标库MES.

注意事项：

(1) 目标机器只需要安装oracle数据库软件即可。

（2）RMAN 异机恢复的时候，db_name必须相同。如果说要想改成其他的实例名，可以在恢复成功后，用nid 命令修改。实例名的信息会记录到控制文件里，所以如果在恢复的时候，如果实例名不一致，恢复的时候会报错。

（3）如果恢复的路径和源库不一致，就需要在restore时用set 命令指定新位置。并且使用switch datafile all将信息更新的到控制文件。

在做duplicate的时候，RMAN 会自动根据pfile中的log_file_name_convert和db_file_name_convert来进行set 的转换。手工restore时，只能只只能使用set 命令。

（4）用NID 修改DBID 和DBNAME.

一. 源库准备工作：

（1）. 查询DBID

SQL> select name,dbid from v$database;
NAME DBID
--------- ----------
CPP 3679338048

（2）.建立测试数据：

SQL> create table t as select * from dba_objects;
Table created.
SQL> insert into t select * from t;
86953 rows created.
SQL> commit;
Commit complete.
SQL> select count(*) from t;
COUNT(*)
----------
173906

（3）.在源数据库上用rman备份数据库，包括数据库

a.备份数据文件和归档文件

[oracle@orcl1 ~]$ mkdir /u01/backup

[oracle@orcl1 rdbms]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Nov 23 00:36:05 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: CPP (DBID=3679338048)
RMAN> run {
allocate channel c1 device type disk;
backup incremental level 0
format '/u01/backup/db_full_%U.bkp'
tag 'db0'
database plus archivelog;
release channel c1;
}2> 3> 4> 5> 6> 7> 8>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=197 device type=DISK
Starting backup at 2014-11-23 00:36:14
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=1 STAMP=864347590
input archived log thread=1 sequence=7 RECID=2 STAMP=864347592
input archived log thread=1 sequence=8 RECID=3 STAMP=864347594
input archived log thread=1 sequence=9 RECID=4 STAMP=864347595
input archived log thread=1 sequence=10 RECID=5 STAMP=864347774
channel c1: starting piece 1 at 2014-11-23 00:36:15
channel c1: finished piece 1 at 2014-11-23 00:36:16
piece handle=/u01/backup/db_full_01po9pjv_1_1.bkp tag=DB0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 2014-11-23 00:36:17
Starting backup at 2014-11-23 00:36:17
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/oracle/oradata/CPP/system01.dbf
input datafile file number=00002 name=/u01/oracle/oradata/CPP/sysaux01.dbf
input datafile file number=00005 name=/u01/oracle/oradata/CPP/example01.dbf
input datafile file number=00003 name=/u01/oracle/oradata/CPP/undotbs01.dbf
input datafile file number=00004 name=/u01/oracle/oradata/CPP/users01.dbf
channel c1: starting piece 1 at 2014-11-23 00:36:18
channel c1: finished piece 1 at 2014-11-23 00:37:43
piece handle=/u01/backup/db_full_02po9pk2_1_1.bkp tag=DB0 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:25
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 2014-11-23 00:37:45
channel c1: finished piece 1 at 2014-11-23 00:37:46
piece handle=/u01/backup/db_full_03po9pmo_1_1.bkp tag=DB0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 2014-11-23 00:37:47
Starting backup at 2014-11-23 00:37:47
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=11 RECID=6 STAMP=864347867
channel c1: starting piece 1 at 2014-11-23 00:37:48
channel c1: finished piece 1 at 2014-11-23 00:37:49
piece handle=/u01/backup/db_full_04po9pms_1_1.bkp tag=DB0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 2014-11-23 00:37:50

released channel: c1

b.备份控制文件

RMAN> backup current controlfile format '/u01/backup/controlfile.bak';
Starting backup at 2014-11-23 00:41:32
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=197 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2014-11-23 00:41:35
channel ORA_DISK_1: finished piece 1 at 2014-11-23 00:41:36
piece handle=/u01/backup/controlfile.bak tag=TAG20141123T004133 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2014-11-23 00:41:36

c.备份参数文件(可选)

RMAN> backup spfile format '/u01/backup/spfile.bak';
Starting backup at 2014-11-23 00:42:49
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2014-11-23 00:42:49
channel ORA_DISK_1: finished piece 1 at 2014-11-23 00:42:51
piece handle=/u01/backup/spfile.bak tag=TAG2