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

Question

请教各位oracle8.1.7 rman恢复问题麻烦问一下大家  我的数据库现在备份都有 请问谁有恢复的文档或者脚本麻烦发给我一下   感激不禁了啊弄了好几天了 有的9i的命令到8这里用不了   希望大家能发个8的恢复过程 最好详细一点的    
e-mail:[email protected]

Answer 1

建议lz去www.itpub.net的oracle版下载,很多rman的资料

Answer 2

看看RMAN的官方文档，应该可以搞定的，我手头没有817环境，爱莫能助

Answer 3

继续寻找答案   去itpub没找到  继续求助啊

Answer 4

恢复还是有错误  各位帮忙看看 急死我了 弄好几天了 谢谢啊
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=DISKRMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev2
RMAN-08500: channel dev2: sid=14 devtype=DISKRMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev3
RMAN-08500: channel dev3: sid=15 devtype=DISKRMAN-03022: compiling command: restoreRMAN-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