Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01110: data file 201: '/bkp/oradata/orcl_raw_system01'

user00726Apr 24 2009 — edited Apr 24 2009
Hi all,


We are facing a problem in oracle 9.2 physical standby database.....

We are using SAN (sun box) ,actually earlier one of our disk got unmounted.and when we mount the disk again some of the files got corrupt,


so i have create another standby control file and specify the location of same in init file but

when i tried to open the standby database in read only mode it is throwing a message ie.
Errors in file /bkp/dump/bdump/icai11_dbw0_1425.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/bkp/oradata/orcl_raw_system01'
pls suggest me....what should be done to overcome the same....

Edited by: user00726 on Apr 23, 2009 10:29 PM

Edited by: user00726 on Apr 23, 2009 10:41 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2009
Added on Apr 24 2009
7 comments
2,504 views