RMAN> restore database;
启动 restore 于 15-12月-05
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=13 devtype=DISK
通道 ORA_DISK_1: 正在开始恢复数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集恢复的数据文件
正将数据文件00001恢复到C:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
正将数据文件00002恢复到C:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF
正将数据文件00003恢复到C:\ORACLE\ORADATA\TEST\CWMLITE01.DBF
正将数据文件00004恢复到C:\ORACLE\ORADATA\TEST\DRSYS01.DBF
正将数据文件00005恢复到C:\ORACLE\ORADATA\TEST\EXAMPLE01.DBF
正将数据文件00006恢复到C:\ORACLE\ORADATA\TEST\INDX01.DBF
正将数据文件00007恢复到C:\ORACLE\ORADATA\TEST\ODM01.DBF
正将数据文件00008恢复到C:\ORACLE\ORADATA\TEST\TOOLS01.DBF
正将数据文件00009恢复到C:\ORACLE\ORADATA\TEST\USERS01.DBF
正将数据文件00010恢复到C:\ORACLE\ORADATA\TEST\XDB01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/15/2005 10:21:46
ORA-19573: 无法获得 exclusive 入队 (数据文件 1 的) 请问这个怎样解决啊?
启动 restore 于 15-12月-05
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=13 devtype=DISK
通道 ORA_DISK_1: 正在开始恢复数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集恢复的数据文件
正将数据文件00001恢复到C:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
正将数据文件00002恢复到C:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF
正将数据文件00003恢复到C:\ORACLE\ORADATA\TEST\CWMLITE01.DBF
正将数据文件00004恢复到C:\ORACLE\ORADATA\TEST\DRSYS01.DBF
正将数据文件00005恢复到C:\ORACLE\ORADATA\TEST\EXAMPLE01.DBF
正将数据文件00006恢复到C:\ORACLE\ORADATA\TEST\INDX01.DBF
正将数据文件00007恢复到C:\ORACLE\ORADATA\TEST\ODM01.DBF
正将数据文件00008恢复到C:\ORACLE\ORADATA\TEST\TOOLS01.DBF
正将数据文件00009恢复到C:\ORACLE\ORADATA\TEST\USERS01.DBF
正将数据文件00010恢复到C:\ORACLE\ORADATA\TEST\XDB01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/15/2005 10:21:46
ORA-19573: 无法获得 exclusive 入队 (数据文件 1 的) 请问这个怎样解决啊?
Cause: The file access enqueue could not be obtained for a file specified in a backup, copy or restore operation. If the enqueue type shown is SHARED, then the file is the input file for a backup or copy. If the type is EXCLUSIVE, then the file is the output file for a datafile copy or restore which is attempting to overwrite the currently active version of that file. In this case, the file must be offline or the database must be closed. If the type is read-only, then you are attempting to back up or copy this file while the database is in NOARCHIVELOG mode.Action: Wait until the conflicting operation is complete, then retry the copy or backup. If the database is in NOARCHIVELOG mode, then all files being backed up must be closed clealy.
按下面的步骤试下:
shutdown immediate;
startup pfile=d:/oracle/admin/crm/pfile/init.ora.918200713320 mount;
restore database;
recover database;
alter database open;
我的安装目录下的文件都是可写的。至于你所说的the file must be offline or the database must be closed,具体的操作是怎样的?还有如果数据库关闭了,应该连不上了,还可以还原的吗?
什么版本? 也不排除bug需要重新启动进程.