bkp文件oracle,I had the Control file and .bkp file and .ALG file(i don't know what is .alg file) i got...

actually i tried restore using

run {

set newname for datafile 1 to "C:\oradata\RSGTN4DB\SYSTEM01.DBF";

set newname for datafile 2 to "C:\oradata\RSGTN4DB\SYSAUX01.DBF";

set newname for datafile 3 to "C:\oradata\RSGTN4DB\UNDOTBS01.DBF";

set newname for datafile 4 to "C:\oradata\RSGTN4DB\USERS01.DBF";

set newname for datafile 5 to "C:\oradata\RSGTN4DB\N4_DATA1.DBF";

set newname for datafile 6 to "C:\oradata\RSGTN4DB\N4_DATA2.DBF";

set newname for datafile 7 to "C:\oradata\RSGTN4DB\N4_DATA3.DBF";

set newname for datafile 8 to "C:\oradata\RSGTN4DB\N4_DATA4.DBF";

set newname for datafile 9 to "C:\oradata\RSGTN4DB\N4_DATA5.DBF";

set newname for datafile 10 to "C:\oradata\RSGTN4DB\N4_DATA6.DBF";

set newname for datafile 11 to "C:\oradata\RSGTN4DB\N4_DATA7.DBF";

set newname for datafile 12 to "C:\oradata\RSGTN4DB\N4_DATA8.DBF";

}

it got created .but

rman>restore database;

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 00006 to

965af934f6bf1c0efcc29a425d1a696a.png\APP\ADMINISTRATOR\ORADATA\RSG

TN4DB\N4_DATA2.DBF

channel ORA_DISK_1: restoring datafile 00008 to

965af934f6bf1c0efcc29a425d1a696a.png\APP\ADMINISTRATOR\ORADATA\RSG

TN4DB\N4_DATA4.DBF

channel ORA_DISK_1: restoring datafile 00011 to

965af934f6bf1c0efcc29a425d1a696a.png\APP\ADMINISTRATOR\ORADATA\RSG

TN4DB\N4_DATA7.DBF

channel ORA_DISK_1: restoring datafile 00012 to

965af934f6bf1c0efcc29a425d1a696a.png\APP\ADMINISTRATOR\ORADATA\RSG

TN4DB\N4_DATA8.DBF

channel ORA_DISK_1: reading from backup piece E:\BACKUP\DB\RMANBK\RSGTN4DB_86P0R

68Q.BKP

channel ORA_DISK_1: ORA-19870: error while restoring backup piece E:\BACKUP\DB\R

MANBK\RSGTN4DB_86P0R68Q.BKP

ORA-19505: failed to identify file "E:\BACKUP\DB\RMANBK\RSGTN4DB_86P0R68Q.BKP"

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 21) The device is not ready.

failover to previous backup

thank you

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值