Database Software

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!

recover of standby db with error: ORA-01157

877440Sep 13 2012 — edited Sep 14 2012

I have added two datafiles to primary database, and somehow the standby log apply kept fail with the following errors:
SQL> SQL> ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 613 is unknown - rename to correct file
ORA-01110: data file 613: '/u0/oracle/orahome/dbs/UNNAMED00613'
ORA-01157: cannot identify/lock data file 613 - see DBWR trace file
ORA-01111: name for data file 613 is unknown - rename to correct file
ORA-01110: data file 613: '/u01/oracle/orahome/dbs/UNNAMED00613'

THen I disabled standby_file_management , and try following with error:
alter database create datafile '/u01/oracle/orahome/dbs/UNNAMED00613' as '+PRD_DAT/prd/datafile/indx_02.891.793937499'
*
ERROR at line 1:
ORA-01276: Cannot add file
+PRD_DAT/prd/datafile/indx_02.891.793937499. File has an Oracle Managed Files file name.

How do I fix this problem?

This post has been answered by Shivananda Rao on Sep 14 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2012

Added on Sep 13 2012

#data-guard, #performance-availability

9 comments

3,143 views