ORA-19573: cannot obtain exclusive enqueue for datafile 3

[复制链接]
查看11 | 回复8 | 2007-10-20 08:38:44 | 显示全部楼层 |阅读模式
遇到恢复问题:
RMAN> restore database;
Starting restore at 25-JUN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:ORACLEXEORADATAXESYSTEM.DBF
restoring datafile 00003 to C:ORACLEXEORADATAXESYSAUX.DBF
restoring datafile 00004 to C:ORACLEXEORADATAXEUSERSUSERS.DBF
channel ORA_DISK_1: reading from backup piece D:2008_06_25O1_MF_NNNDF_FABER_46
3CR3X9_.BKP
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00008 to C:ORACLEXEORADATAXEUNDO1.DBF
channel ORA_DISK_2: reading from backup piece D:2008_06_25O1_MF_NNNDF_FABER_46
3CR2XS_.BKP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/25/2008 16:57:45
ORA-19870: error reading backup piece D:2008_06_25O1_MF_NNNDF_FABER_463CR3X9_.
BKP
ORA-19573: cannot obtain exclusive enqueue for datafile 3
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
再次运行:
RMAN> restore database;
Starting restore at 25-JUN-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=23 devtype=DISK
RMAN-06908: WARNING: operation will not run in parallel on the allocated channel
s
RMAN-06909: WARNING: parallelism require Enterprise Edition
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=24 devtype=DISK
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00008 to C:ORACLEXEORADATAXEUNDO1.DBF
channel ORA_DISK_2: reading from backup piece D:2008_06_25O1_MF_NNNDF_FABER_46
3CR2XS_.BKP
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:ORACLEXEORADATAXESYSTEM.DBF
restoring datafile 00003 to C:ORACLEXEORADATAXESYSAUX.DBF
restoring datafile 00004 to C:ORACLEXEORADATAXEUSERSUSERS.DBF
channel ORA_DISK_1: reading from backup piece D:2008_06_25O1_MF_NNNDF_FABER_46
3CR3X9_.BKP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/25/2008 17:04:23
ORA-19870: error reading backup piece D:2008_06_25O1_MF_NNNDF_FABER_463CR2XS_.
BKP
ORA-19573: cannot obtain exclusive enqueue for datafile 8
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
shutdown immediate
startup 依旧
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
oerr ora 19573
19573, 00000, "cannot obtain %s enqueue for datafile %s"
// *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 cleanly.
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
RMAN> restore datafile 3;
Starting restore at 25-JUN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to C:ORACLEXEORADATAXESYSAUX.DBF
channel ORA_DISK_1: reading from backup piece D:2008_06_25O1_MF_NNNDF_FABER_46
3CR3X9_.BKP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/25/2008 17:14:07
ORA-19870: error reading backup piece D:2008_06_25O1_MF_NNNDF_FABER_463CR3X9_.
BKP
ORA-19573: cannot obtain exclusive enqueue for datafile 3
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
datafile 4 -->users
sql>alter tablespace users offline ;
RMAN> restore datafile 4;
Starting restore at 25-JUN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to C:ORACLEXEORADATAXEUSERSUSERS.DBF
channel ORA_DISK_1: reading from backup piece D:2008_06_25O1_MF_NNNDF_FABER_46
3CR3X9_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=D:2008_06_25O1_MF_NNNDF_FABER_463CR3X9_.BKP tag=FABER
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 25-JUN-08
RMAN> recover datafile 4;
Starting recover at 25-JUN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 25-JUN-08
SQL> alter tablespace users online;
至此恢复成功!
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
有ORACLE进程没关“干净”? 重起机器就应该没问题了
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
经查ORA-19573: 错误为oracle一个bug,可绕过直接恢复全库,按恢复数据文件方式恢复数据库
回复

使用道具 举报

千问 | 2007-10-20 08:38:44 | 显示全部楼层
你哩咋弄好哩,俺哩也这样了。
回复

使用道具 举报

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

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行