Oracle技术服务|系统集成|技术开发

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1436|回复: 1

rman恢复指定不了路径

[复制链接]

1

主题

0

好友

27

积分

新手上路

Rank: 1

发表于 2015-1-8 21:24:53 |显示全部楼层
本帖最后由 老丁 于 2015-1-8 21:26 编辑

我的rman恢复没有成功指定路径,例如我如下脚本,并成功执行:

RMAN> run {
set newname for datafile 45 to '+DATA/yz/datafile/yzzjdata.296.867444545';
restore datafile 45;
switch datafile all;
} 2> 3> 4> 5> 6> 7> 8> 9>
executing command: SET NEWNAME
Starting restore at 08-JAN-15
using channel ORA_DISK_1
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 00045 to +DATA/yz/datafile/yzzjdata.296.867444545
channel ORA_DISK_1: reading from backup piece /orabackup/fullzip/full_YZ_868410005_13101_1_20150108.dbf
channel ORA_DISK_1: piece handle=/orabackup/fullzip/full_YZ_868410005_13101_1_20150108.dbf tag=TAG20150108T010004
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:16:55
Finished restore at 08-JAN-15
但是相应目录下却没有这个文件,如下:
ASMCMD> pwd
+DATA/yz/datafile
ASMCMD> ls
ASMCMD>

请问各位大侠,这是怎么回事呀?
回复

使用道具 举报

15

主题

0

好友

207

积分

中级会员

Rank: 3Rank: 3

发表于 2015-2-2 14:52:56 |显示全部楼层
run{
crosscheck backup;
sql 'alter tablespace testdg offline immediate';
set newname for datafile 14 to'+DATA';
restore tablespace testdg;
switch datafile 14;
recover tablespace testdg;
sql 'alter tablespace testdg online';
}
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

QQ|手机版|DB Support 技术联盟 ( 粤ICP备13057501号-1 )

GMT+8, 2018-1-22 19:44 , Processed in 0.168388 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部