rman异机恢复
rman异机恢复
注意事项：
1.源与目标数据库的目录结构相同
2.目标数据库只需要安装ORACLE软件（但是参数文件中指定的目录要创建）
3.要将源数据库的数据文件，参数文件，控制文件，密码文件，归档日志统统备份
1.源数据库备份
参数文件与控制文件自动备份
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/rmanback/level_cont_spfile_%F';
备份数据库及归档日志
backup incremental level 0 database format '/home/oracle/rmanback/level0_%d_%s_%p_%u.bak'
plus archivelog format '/home/oracle/rmanback/level0arclog_%d_%s_%p_%u.bak'
2.拷贝备份的文件到目标数据库的相同路径下
scp level* 192.170.100.12:/home/oracle/rmanback
3.启动数据库到nomount状态下
[oracle@server8 ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jan 7 13:53:54 2015
Copyright (c) ,
and/or its affiliates.
All rights reserved.
connected to target database (not started)
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/u01/app/oracle/product/11.2.0/db_1/dbs/initghsjdb.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area
Fixed Size
2226456 bytes
Variable Size
Database Buffers
Redo Buffers
5439488 bytes
4.恢复参数文件
RMAN& restore spfile to pfile '/home/u01/app/oracle/product/11.2.0/db_1/dbs/initghsjdb.ora' from '/home/oracle/rmanback/level_cont_spfile_c--'
RMAN& sql 'create spfile from pfile';
sql statement: create spfile from pfile
5.创建参数文件中指定的路径
mkdir -p admin/ghsjdb/adump
mkdir -p oradata/ghsjdb
mkdir -p fast_recovery_area/ghsjdb
mkdir archivelog
6.重启到nomount
Oracle instance started
Total System Global Area
Fixed Size
2239176 bytes
Variable Size
Database Buffers
Redo Buffers
7.恢复控制文件
RMAN& restore controlfile from '/home/oracle/rmanback/level_cont_spfile_c--';
Starting restore at 07-JAN-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1141 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/home/u01/app/oracle/oradata/ghsjdb/control01.ctl
output file name=/home/u01/app/oracle/fast_recovery_area/ghsjdb/control02.ctl
Finished restore at 07-JAN-15
8.启动数据库到mount状态
database mounted
released channel: ORA_DISK_1
9.由于目标数据库与源数据库的备份路径相同所以不需要重新在控制文件中注册
RMAN& catalog start with '/home/oracle/rmanback';
Starting restore at 07-JAN-15
Starting implicit crosscheck backup at 07-JAN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1141 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=7 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=574 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1142 device type=DISK
Crosschecked 7 objects
Crosschecked 2 objects
Finished implicit crosscheck backup at 07-JAN-15
Starting implicit crosscheck copy at 07-JAN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
Finished implicit crosscheck copy at 07-JAN-15
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /home/u01/app/oracle/oradata/ghsjdb/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/u01/app/oracle/oradata/ghsjdb/users01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /home/u01/app/oracle/oradata/ghsjdb/shine_fm.dbf
channel ORA_DISK_1: restoring datafile 00017 to /home/u01/app/oracle/oradata/ghsjdb/tbs_ogg.dbf
channel ORA_DISK_1: restoring datafile 00018 to /home/u01/app/oracle/oradata/ghsjdb/ghsj_pwjc.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/rmanback/level0_GHSJDB_ps538h.bak
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to /home/u01/app/oracle/oradata/ghsjdb/system01.dbf
channel ORA_DISK_2: restoring datafile 00008 to /home/u01/app/oracle/oradata/ghsjdb/sde.dbf
channel ORA_DISK_2: restoring datafile 00012 to /home/u01/app/oracle/oradata/ghsjdb/ts_platform_index.dbf
channel ORA_DISK_2: restoring datafile 00016 to /home/u01/app/oracle/oradata/ghsjdb/index_assess.dbf
channel ORA_DISK_2: reading from backup piece /home/oracle/rmanback/level0_GHSJDB_ps538h.bak
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00006 to /home/u01/app/oracle/oradata/ghsjdb/GHSJ_JCSJ.dbf
channel ORA_DISK_3: restoring datafile 00010 to /home/u01/app/oracle/oradata/ghsjdb/shine_fm_index.dbf
channel ORA_DISK_3: restoring datafile 00011 to /home/u01/app/oracle/oradata/ghsjdb/ts_platform.dbf
channel ORA_DISK_3: restoring datafile 00013 to /home/u01/app/oracle/oradata/ghsjdb/GHSJ_pwgl.dbf
channel ORA_DISK_3: reading from backup piece /home/oracle/rmanback/level0_GHSJDB_ps538h.bak
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00002 to /home/u01/app/oracle/oradata/ghsjdb/sysaux01.dbf
channel ORA_DISK_4: restoring datafile 00005 to /home/u01/app/oracle/oradata/ghsjdb/ghsj_xm.dbf
channel ORA_DISK_4: restoring datafile 00007 to /home/u01/app/oracle/oradata/ghsjdb/ghsj_index.dbf
channel ORA_DISK_4: restoring datafile 00014 to /home/u01/app/oracle/oradata/ghsjdb/ghsj_psdb.dbf
channel ORA_DISK_4: restoring datafile 00015 to /home/u01/app/oracle/oradata/ghsjdb/dgh.dbf
channel ORA_DISK_4: reading from backup piece /home/oracle/rmanback/level0_GHSJDB_ps538h.bak
channel ORA_DISK_1: piece handle=/home/oracle/rmanback/level0_GHSJDB_ps538h.bak tag=TAG510
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:06:36
channel ORA_DISK_2: piece handle=/home/oracle/rmanback/level0_GHSJDB_ps538h.bak tag=TAG510
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:08:36
channel ORA_DISK_3: piece handle=/home/oracle/rmanback/level0_GHSJDB_ps538h.bak tag=TAG510
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:11:56
channel ORA_DISK_4: piece handle=/home/oracle/rmanback/level0_GHSJDB_ps538h.bak tag=TAG510
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:12:06
Finished restore at 07-JAN-15
11.recover database
Starting recover at 07-JAN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=991
channel ORA_DISK_1: reading from backup piece /home/oracle/rmanback/level0arclog_GHSJDB_ps540p.bak
channel ORA_DISK_1: piece handle=/home/oracle/rmanback/level0arclog_GHSJDB_ps540p.bak tag=TAG808
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archived log file name=/home/u01/app/oracle/archivelog/1_991_.dbf thread=1 sequence=991
unable to find archived log
archived log thread=1 sequence=992
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/07/:41
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 992 and starting SCN of
RMAN& recover database until scn ;
Starting recover at 07-JAN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 07-JAN-15
12 .打开数据库
RMAN& alter dat
database opened
结束了，查看库里面的信息是否正确查看: 2350|回复: 6
请教一个令人费解的异机恢复问题~！RMAN的~！
论坛徽章:3
先说明环境：A生产机上面有一个实力叫ABC，每晚A上面的数据通过RMAN出备份集NETWORKER写入存储。
& && && && &B是测试机。
& && && && &现在数据库版本和操作系统版本一样，ORA10G+SOLAIRS10~！
恢复过程：我吧A的SPFILE COPY到B上面（然后一直在B上面操作），配置.PROFILE，启动数据库到NOMOUNT状态，然后我利用RMAN通过存储来恢复A的CF（A有开自动备份cf），但是RMAN竟然提示我“RMAN-06496：MUST USE THE TO CLAUSE WHEN THE DATABASE IS MOUNTED OR OPEN”！第一个疑问是：如果我的数据库状态是MOUNT或者OPEN，拿我还用恢复CF吗？在网上找了一些答案，说要连接到恢复目录再恢复或者恢复控制文件,目标数据库不能MOUNT,只能nomount.你这种情况可能是:1.对应的目录不存在,2目录存在,相应的控制文件也存在,restore过程无法覆盖它!
这里我把A的CF COPY过来，数据库可以MOUNT状态。好，然后我走脚步去恢复DB文件，提示ORA-03113: end-of-file on communication channel&&。这里网上答案说由几个原因导致，我看过alter。log，没有什么提示错误。我怀疑是不是对应的空间不够~！又不是啊·！还有 好多，最后这里不知道怎样解决~！要请教个各位一下！~谢谢~！
论坛徽章:302
不知所云。
论坛徽章:51
你先设置A库的DBID
然后NOMOUNT
然后 有个set 命令指定控制文件的路径，然后restore就行了 google一下很好找的
因为你NOMOUNT阶段 RMAN的设置不能生效的，所以你直接恢复controfile肯定不行
招聘 : 论坛徽章:4
你可以启动到nomount状态，然后restore controlfile from '&备份的cf文件路径&'
论坛徽章:8
论坛徽章:3
原帖由 cjq1018 于
10:46 发表
你可以启动到nomount状态，然后restore controlfile from ''
我就是在RMAN状态下允许restore controlfile from '&备份的cf文件路径&'
这个命令~！但是提示我上面的错误·！
论坛徽章:3
原帖由 iori809 于
08:45 发表
你先设置A库的DBID
然后NOMOUNT
然后 有个set 命令指定控制文件的路径，然后restore就行了 google一下很好找的
因为你NOMOUNT阶段 RMAN的设置不能生效的，所以你直接恢复controfile肯定不行
但是我想通过存储来恢复我A库的自动备份cf~！
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号查看: 606|回复: 5
rman异机恢复的问题
认证徽章论坛徽章:5
ORA-01103: database name 'PROD' in control file is not 'DUMMY'机器A,B上是DG,每日备份
现在要在机器C上做异机恢复,等于是测试环境搭建
在机器C上先执行以下步骤就报错
echo $ORACLE_SID
export ORACLE_SID=prod
export ORA_RMAN_SGA_TARGET=350
echo $ORACLE_SID
显示的是prod
但是执行rman trarget /后
[oracle@omstest dbs]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 17 14:38:30 2015
Copyright (c) , Oracle and/or its affiliates.&&All rights reserved.
connected to target database: DUMMY (not mounted)
依然是dummy,在完成spfile和controlfile的导入后,alter database mount
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/17/:29
ORA-01103: database name 'PROD' in control file is not 'DUMMY'
求解?已经看过很多办法,都不能使用.机器C上原有数据库orcl,应该不影响的吧
认证徽章论坛徽章:5
知道原因了.正好把整个过程贴一遍
异机恢复的步骤分好几部分,设机器A为备份端,机器B为恢复端
1.A进行全备,查询一些文件的位置
2.B在sqlplus下进行nomount
3.B在rman下进行mount
4.restore & recover
论坛徽章:302
export ORACLE_SID=PROD
认证徽章论坛徽章:5
本帖最后由 peng163fj 于
08:58 编辑
2-1.设置当前窗口的环境变量
echo $ORACLE_SID
export ORACLE_SID=prod
export ORA_RMAN_SGA_TARGET=350
echo $ORACLE_SID
2-2.在sqlplus下导入pfile,dg环境中pfile有很多无用的行,将其删除
sqlplus &/ as sysdba&
startup nomount pfile='位置'
注意pfile的权限
3-1恢复controlfile,注意要建立对应A的文件夹及权限
restore controlfile from '位置'
alter database mount
4-1恢复文件,不完整打开
crosscheck backupset看一下是否找得到备份集(availiable)
RMAN-03002: failure of recover command at 03/18/:07
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 6173 and starting SCN of
认证徽章论坛徽章:5
recover database until scn ; 完成恢复
alter dat进行不完全恢复后要resetlogs打开
MAN-03002: failure of alter db command at 03/18/:20
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
再回到sqlplus
startup upgrade pfile='位置'
成功打开,恢复结束,记得做个备份
认证徽章论坛徽章:2
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号查看: 3987|回复: 10
关于RMAN 异机恢复问题
论坛徽章:2
二台windows平台,ORACLE9i,
在一台机器A做了RMAN全备份.备份放在F:盘
在另一台机器B恢复,但因备份太大,想不把备份拷过来.B服务器没有F:盘.
将A机器上的备份共享,然后在B机器映射成F盘.
结果恢复时提示找不到源备份文件.
RMAN& restore spfile to pfile 'E:\oracle\oradata\test\initTEST.ora' from 'F:\bac
開始 restore, 於 07-10月-09
使用通道 ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/07/:47
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
将自动备份文件COPY到本机,就可以.
RMAN& restore spfile to pfile 'E:\oracle\oradata\test\initTEST.ora' from 'E:\ora
開始 restore, 於 07-10月-09
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 找到自動備份: E:\oracle\C--
通道 ORA_DISK_1: 從自動備份回復 SPFILE 完成
完成 restore, 於 07-10月-09
这应该是共享出现问题,以前在LINUX平台遇到过,MOUNT参数有误,RMAN也识别不到备份文件.
(LINUX:192.10.20.02:/orabackup&&/orabackup& && && & nfs& &&&ro,bg,hard,nointr,rsize=32768,wsize=3
2768,tcp,vers=3,timeo=600,actimeo=0 0 0)
请问各位大侠如何设置共享或有其它方法?
备份文件太大,B机器无法放下.
[ 本帖最后由 MRQ_sa 于
15:23 编辑 ]
论坛徽章:2
是nocatalog
论坛徽章:98
先把controlfile copy过来恢复了。
然后rman用catalog start with注册一下看看。
论坛徽章:2
回复 #3 五“宅”一生 的帖子
是nocatalog
这一篇有启示,是用户访问权限的问题.
我也这要试了,
不知道哪里出错了.
论坛徽章:98
照着来还不行吗？卡在哪里了？
论坛徽章:15
记得好像两台机子的os账户和密码必须一样。还要是管理员账户且是ora_dba组
论坛徽章:13
用ip加共享目录名称的方式试试吧，映射驱盘符方式不行。
论坛徽章:2
回复 #5 五“宅”一生 的帖子
那篇文章是备份到网络中其它机器里。
我的操作是将网络其它机器的备份还原，如果将备份COPY到本机一样的目录，是可以恢复的。
因为是NOCATALOG，是通过控制文件恢复的，原来备份的控制文件已经记录备份集路径。
论坛徽章:2
回复 #6 tam509 的帖子
试过了，不行。
不知道错在哪里。
论坛徽章:2
回复 #7 smartcobra 的帖子
将网络上的备份恢复，除SPFILE、CONTROLFILE外，不可以指定路径吧，
还是NOCATALOG方式的RMAN备份，备份集路径已经在备份的控制文件上了。
如果用共享，映射方式，老提示不能识别映射的路径。
不知能不能这样映射或者其它地方没有设置好。
不行，只能加硬盘了。
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号博客访问： 333940
博文数量： 69
博客积分： 145
博客等级： 入伍新兵
技术积分： 1072
注册时间：
专注于小机，数据库。
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： Oracle
RMAN> restore controlfile from '/oracle/app/rmanbackup/hnzz_level0__br181e1_1_1.dbf';
Starting restore at 24-MAR-:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output file name=+ORADATA/hnzz/controlfile/current01.ctl
output file name=+FRA/hnzz/controlfile/current02.ctl
Finished restore at 24-MAR-:29
database mounted
released channel: ORA_DISK_1
RMAN> catalog start with '/oracle/app/rmanbackup/';
Starting implicit crosscheck backup at 24-MAR-:46
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 24-MAR-:48
Starting implicit crosscheck copy at 24-MAR-:48
using channel ORA_DISK_1
Finished implicit crosscheck copy at 24-MAR-:48
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +fra/HNZZ/ARCHIVELOG//thread_1_seq_2.260.
File Name: +fra/HNZZ/ARCHIVELOG//thread_1_seq_1.259.
File Name: +fra/HNZZ/ARCHIVELOG//thread_1_seq_2.258.
File Name: +fra/HNZZ/ARCHIVELOG//thread_1_seq_3.257.
File Name: +fra/HNZZ/ARCHIVELOG//thread_1_seq_1.261.
File Name: +fra/HNZZ/ARCHIVELOG//thread_1_seq_2.262.
searching for all files that match the pattern /oracle/app/rmanbackup/
List of Files Unknown to the Database
=====================================
File Name: /oracle/app/rmanbackup/archive_level0__fr181fl_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__r181cd_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__cr181ev_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__r181cc_1_1.dbf
File Name: /oracle/app/rmanbackup/archive_level0__dr181fl_1_1.dbf
File Name: /oracle/app/rmanbackup/archive_level0__er181fl_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__br181e1_1_1.dbf
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /oracle/app/rmanbackup/archive_level0__fr181fl_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__r181cd_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__cr181ev_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__r181cc_1_1.dbf
File Name: /oracle/app/rmanbackup/archive_level0__dr181fl_1_1.dbf
File Name: /oracle/app/rmanbackup/archive_level0__er181fl_1_1.dbf
File Name: /oracle/app/rmanbackup/hnzz_level0__br181e1_1_1.dbf
1，RMAN> run{
2> allocate channel t1
3> allocate channel t2
4> allocate channel t3
5> allocate channel t4
6> set newname for datafile 1 to '+ORADATA/hnzz/DATAFILE/system01.dbf';
7> set newname for datafile 2 to '+ORADATA/hnzz/DATAFILE/undotbs01.dbf';
8> set newname for datafile 3 to '+ORADATA/hnzz/DATAFILE/sysaux01.dbf';
9> set newname for datafile 4 to '+ORADATA/hnzz/DATAFILE/users01.dbf';
10> set newname for datafile 5 to '+ORADATA/hnzz/DATAFILE/example01.dbf';
11> set newname for datafile 6 to '+ORADATA/hnzz/DATAFILE/tbs_f1.dbf';
13> release channel t1;
14> release channel t2;
15> release channel t3;
16> release channel t4;
allocated channel: t1
channel t1: SID=31 device type=DISK
allocated channel: t2
channel t2: SID=34 device type=DISK
allocated channel: t3
channel t3: SID=35 device type=DISK
allocated channel: t4
channel t4: SID=36 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 24-MAR-:23
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/24/:25
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
解决方法：
RMAN> LIST INCARNATION OF DATABASE
List of Database Incarnations
DB Key& Inc Key DB Name& DB ID&&&&&&&&&&& STATUS& Reset SCN& Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1&&&&&& 1&&&&&& HNZZ&&&& &&&&&& PARENT& 1&&&&&&&&& 17-FEB-:35
2&&&&&& 2&&&&&& HNZZ&&&& &&&&&& PARENT& 464631&&&& 21-MAR-:29
3&&&&&& 3&&&&&& HNZZ&&&& &&&&&& PARENT& 532131&&&& 23-MAR-:23
4&&&&&& 4&&&&&& HNZZ&&&& &&&&&& CURRENT 573401&&&& 23-MAR-:23
RMAN> RESET DATABASE TO INCARNATION 2;
database reset to incarnation 2
RMAN> run{
2> allocate channel t1
3> allocate channel t2
4> allocate channel t3
5> allocate channel t4
6> set newname for datafile 1 to '+ORADATA/hnzz/DATAFILE/system01.dbf';
7> set newname for datafile 2 to '+ORADATA/hnzz/DATAFILE/undotbs01.dbf';
8> set newname for datafile 3 to '+ORADATA/hnzz/DATAFILE/sysaux01.dbf';
9> set newname for datafile 4 to '+ORADATA/hnzz/DATAFILE/users01.dbf';
10> set newname for datafile 5 to '+ORADATA/hnzz/DATAFILE/example01.dbf';
11> set newname for datafile 6 to '+ORADATA/hnzz/DATAFILE/tbs_f1.dbf';
12> restore database until sequence 8;
13> release channel t1;
14> release channel t2;
15> release channel t3;
16> release channel t4;
allocated channel: t1
channel t1: SID=31 device type=DISK
allocated channel: t2
channel t2: SID=34 device type=DISK
allocated channel: t3
channel t3: SID=35 device type=DISK
allocated channel: t4
channel t4: SID=36 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 24-MAR-:45
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 00002 to +ORADATA/hnzz/DATAFILE/undotbs01.dbf
channel t1: restoring datafile 00005 to +ORADATA/hnzz/DATAFILE/example01.dbf
channel t1: reading from backup piece /oracle/app/rmanbackup/hnzz_level0__ar181cd_1_1.dbf
channel t2: starting datafile backup set restore
channel t2: specifying datafile(s) to restore from backup set
channel t2: restoring datafile 00001 to +ORADATA/hnzz/DATAFILE/system01.dbf
channel t2: restoring datafile 00004 to +ORADATA/hnzz/DATAFILE/users01.dbf
channel t2: reading from backup piece /oracle/app/rmanbackup/hnzz_level0__r181cc_1_1.dbf
channel t3: starting datafile backup set restore
channel t3: specifying datafile(s) to restore from backup set
channel t3: restoring datafile 00003 to +ORADATA/hnzz/DATAFILE/sysaux01.dbf
channel t3: restoring datafile 00006 to +ORADATA/hnzz/DATAFILE/tbs_f1.dbf
channel t3: reading from backup piece /oracle/app/rmanbackup/hnzz_level0__r181cd_1_1.dbf
channel t1: piece handle=/oracle/app/rmanbackup/hnzz_level0__ar181cd_1_1.dbf tag=TAG324
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:01:15
channel t3: piece handle=/oracle/app/rmanbackup/hnzz_level0__r181cd_1_1.dbf tag=TAG324
channel t3: restored backup piece 1
channel t3: restore complete, elapsed time: 00:02:17
channel t2: piece handle=/oracle/app/rmanbackup/hnzz_level0__r181cc_1_1.dbf tag=TAG324
channel t2: restored backup piece 1
channel t2: restore complete, elapsed time: 00:02:57
Finished restore at 24-MAR-:43
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN> recover database until sequence 8;
Starting recover at 24-MAR-:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/24/:59
RMAN-06094: datafile 1 must be restored
datafile 1 switched to datafile copy "+ORADATA/hnzz/datafile/system01.dbf"
datafile 2 switched to datafile copy "+ORADATA/hnzz/datafile/undotbs01.dbf"
datafile 3 switched to datafile copy "+ORADATA/hnzz/datafile/sysaux01.dbf"
datafile 4 switched to datafile copy "+ORADATA/hnzz/datafile/users01.dbf"
datafile 5 switched to datafile copy "+ORADATA/hnzz/datafile/example01.dbf"
datafile 6 switched to datafile copy "+ORADATA/hnzz/datafile/tbs_f1.dbf"
RMAN> run{
2> allocate channel t1
3> allocate channel t2
4> allocate channel t3
5> allocate channel t4
6> recover database until sequence 8;
7> release channel t1;
8> release channel t2;
9> release channel t3;
10> release channel t4;
allocated channel: t1
channel t1: SID=31 device type=DISK
allocated channel: t2
channel t2: SID=34 device type=DISK
allocated channel: t3
channel t3: SID=35 device type=DISK
allocated channel: t4
channel t4: SID=36 device type=DISK
Starting recover at 24-MAR-:45
starting media recovery
channel t1: starting archived log restore to default destination
channel t1: restoring archived log
archived log thread=1 sequence=7
channel t1: reading from backup piece /oracle/app/rmanbackup/archive_level0__fr181fl_1_1.dbf
channel t1: piece handle=/oracle/app/rmanbackup/archive_level0__fr181fl_1_1.dbf tag=TAG509
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:00:15
archived log file name=+FRA/hnzz/archivelog//thread_1_seq_7.263. thread=1 sequence=7
channel default: deleting archived log(s)
archived log file name=+FRA/hnzz/archivelog//thread_1_seq_7.263. RECID=9 STAMP=
media recovery complete, elapsed time: 00:00:02
Finished recover at 24-MAR-:10
released channel: t1
released channel: t2
released channel: t3
released channel: t4
阅读(531) | 评论(0) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
请登录后评论。