Problem Description:
---------------------------
Whenever you try to restore a datafile or restore database it failed with following message,
SQL> !rman TARGET /
Recovery Manager: Release 10.2.0.1.0 - Production on Sat May 17 06:06:34 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DBASE (DBID=1509380669)
RMAN> RUN{
2> SET UNTIL SCN 1364008;
3> RESTORE DATABASE;
4> RECOVER DATABASE;
5> }
.
.
.
ORA-19573: cannot obtain exclusive enqueue for datafile 1
Cause of The problem:
---------------------------
If you try to Restore database then your target database must be in mounted stage but not open. If the database is in open state then whenever you give restore then restore operation is attempting to overwrite the currently active version of the datafile and hence the error comes. Alternatively , whenever a datafile is online and you attempt to restore that datafile the error will come.
Solution of The problem:
------------------------------
Check the status of database or the datafile which you want to restore.
In case of database,
SQL> SELECT STATUS FROM V$INSTANCE;
STATUS
--------
OPEN
In case of Datafile,
SQL> select FILE# , STATUS from V$DATAFILE;
If you want to restore database then mount the database like,
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
If you want to restore a datafile make the datafile offline Like,
SQL>ALTER DATABASE DATAFILE 4 OFFLINE;
And then perform
RMAN>RESTORE DATAFILE 4;
Saturday, May 17, 2008
ORA-19573: cannot obtain exclusive enqueue for datafile 1
| Reactions: |
Subscribe to:
Post Comments (Atom)
Tag Cloud
10.2g
10g
11g
11gR2
Abasa
About Oracle
Administration
Adsense
Alerts
Archival
ASM
ASP.Net
Audit
Audit Vault
Backup
Bangladesh
Block Corruption
Blogger
Browser
Bug
Business
Clone
Clusterware
Comments
Concepts
Connection
Controlfiles
Crime
CSS
Data Block
Data Dictionary
Data Guard
Data Mining
Data Pump
Data Type
Database Administration
Database Vault
DBConsole
Developer
Economics
EM
Excel
Exercise
Explain plan
Export
External Table
Facebook
Firefox
Firmware
Flashback
Forum
Functions
Games
Globalization Support
Grid Control
Hardware
History
HTML
IE
Import
Indexes
initializaion parameter
initialization parameter
Installation
Internals
Internet
Interview
isql*plus
Java
JavaScript
Job
Joins
Joke
Limitation
Linux
Listener
Logminer
Magento
Mail
Materialized View
Medical
Memory
Mobile
Money
Multimedia
MySQL
Net Services
Network
OCP
Operators
Oracle
Oracle Concepts
Oracle Recovery
OS
Others
OUI
Package
Packages
Parameters
Partitioning
Patchset
Performance
Perl
Pfile
Photos
PHP
PL/SQL
Profile
Pseudocolumns
Puzzle
Quiz
Quota
RAC
RAC Installation
Recovery
Recovery Problems
Redo Log
Reports
RMAN
Scripts
Security
SEO
Server Administration
SGA
Shell Script
Smarty
Social Marketing
Solaris
Spfile
SQL
SQL Tuning
SQL*Loader
Sql*Plus
Startup Problem
Streams
SwingBench
System Analysis
Tablespaces
Technology
Temp
TNS Error
Tools
Troubleshooting
Tuning
Undo
UNIX
Upgradation
Utilities
Version
Views
Vmware
Windows
Wordpress
XML
8 comments:
Thanx dear
Hi buddy...just small mistake in the second last statement...
It should be OFFLINE and not ONLINE.
SQL>ALTER DATABASE DATAFILE 4 OFFLINE;
Cheers..!!
read properly... you are restoring the datafile and it should be offline.
great...problem solved by ur tips
Спасибо
Спасибо
Thnx dear
hi can we roll forward a flashbaked database? if yes please send me the primary steps please mail me on satishbabu56@gmail.com
thanks in advancee
Post a Comment