请教各位oracle8.1.7 rman恢复问题

hpym365 2007-04-19 10:01:19
请教各位oracle8.1.7 rman恢复问题

麻烦问一下大家 我的数据库现在备份都有 请问谁有恢复的文档或者脚本麻烦发给我一下 感激不禁了啊

弄了好几天了 有的9i的命令到8这里用不了 希望大家能发个8的恢复过程 最好详细一点的
e-mail:hpym365@163.com
...全文
252 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
nowait 2007-04-19
  • 打赏
  • 举报
回复
看看RMAN的官方文档,应该可以搞定的,我手头没有817环境,爱莫能助
CathySun118 2007-04-19
  • 打赏
  • 举报
回复
建议lz去www.itpub.net的oracle版下载,很多rman的资料
hpym365 2007-04-19
  • 打赏
  • 举报
回复
没人帮忙吗 自己顶一下
hpym365 2007-04-19
  • 打赏
  • 举报
回复
恢复还是有错误 各位帮忙看看 急死我了 弄好几天了 谢谢啊
RMAN> run {
2> allocate channel 'dev1' type disk;
3> allocate channel 'dev2' type disk;
4> allocate channel 'dev3' type disk;
5> restore database;
6> recover database;
7> release channel dev1;
8> release channel dev2;
9> release channel dev3;
10> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev1
RMAN-08500: channel dev1: sid=13 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev2
RMAN-08500: channel dev2: sid=14 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev3
RMAN-08500: channel dev3: sid=15 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel dev1: starting datafile backupset restore
RMAN-08502: set_count=5 set_stamp=620315287 creation_time=2007-04-19:13:48:07
RMAN-08089: channel dev1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to D:\ORACLE\ORADATA\CGXT\SYSTEM01.DBF
RMAN-08523: restoring datafile 00008 to D:\ORACLE\ORADATA\CGXT\VEH_INDEX.ORA
RMAN-08016: channel dev2: starting datafile backupset restore
RMAN-08502: set_count=6 set_stamp=620315287 creation_time=2007-04-19:13:48:07
RMAN-08089: channel dev2: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00003 to D:\ORACLE\ORADATA\CGXT\USERS01.DBF
RMAN-08523: restoring datafile 00004 to D:\ORACLE\ORADATA\CGXT\TEMP01.DBF
RMAN-08523: restoring datafile 00007 to D:\ORACLE\ORADATA\CGXT\VEH_DATA.ORA
RMAN-08016: channel dev3: starting datafile backupset restore
RMAN-08502: set_count=7 set_stamp=620315287 creation_time=2007-04-19:13:48:07
RMAN-08089: channel dev3: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00002 to D:\ORACLE\ORADATA\CGXT\RBS01.DBF
RMAN-08523: restoring datafile 00005 to D:\ORACLE\ORADATA\CGXT\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to D:\ORACLE\ORADATA\CGXT\INDX01.DBF
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: dev2
RMAN-08031: released channel: dev1
RMAN-08031: released channel: dev3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-10035: exception raised in RPC: O
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE
RMAN-10035: exception raised in RPC: O
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel dev1
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue
for datafile 1
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE
hpym365 2007-04-19
  • 打赏
  • 举报
回复
继续寻找答案 去itpub没找到 继续求助啊

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧