ITPub博客

首页 > 数据库 > Oracle > ORA-01157: cannot identify/lock data file 201 - see DBWR trace file

ORA-01157: cannot identify/lock data file 201 - see DBWR trace file

Oracle 作者:season0891 时间:2016-01-27 17:17:47 0 删除 编辑

Dear Experts,

 

I have restored online backup and resetlogs to open the DB..everything went well however when I try to schedule offline backup I am getting below error. could you please let me know whet needs to be done? thanks in advance!!!

 

BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: bentnldh.afd 2014-05-02 15.05.45

BR0484I BRBACKUP log file: /oracle/<SID>/sapbackup/bentnldh.afd

BR0477I Oracle pfile /oracle/<SID>/112_64/dbs/init<SID>.ora created from spfile /oracle/<SID>/112_64/dbs/spfile<SID>.ora

BR0280I BRBACKUP time stamp: 2014-05-02 15.05.46

BR0301E SQL error -1157 at location BrDbfInfoGet-1, SQL statement:

'OPEN curs_8 CURSOR FOR'

'SELECT TS.TABLESPACE_NAME, TS.STATUS, TS.BLOCK_SIZE, TS.CONTENTS, TS.EXTENT_MANAGEMENT, DF.FILE_NAME, DF.FILE_ID, NVL(DF.STATUS, ' '), NVL(DF.BYTES, 0), NVL(DF.AUTOEXTENSIBLE,

'NO'), NVL(DF.MAXBYTES, 0), NVL(DF.INCREMENT_BY, 0) FROM DBA_TABLESPACES TS, DBA_DATA_FILES DF WHERE TS.TABLESPACE_NAME = DF.TABLESPACE_NAME UNION ALL SELECT TS.TABLESPACE_NAME,

TS.STATUS, TS.BLOCK_SIZE, TS.CONTENTS, TS.EXTENT_MANAGEMENT, TF.FILE_NAME, TF.FILE_ID * -1, NVL(TF.STATUS, ' '), NVL(TF.BYTES, 0), NVL(TF.AUTOEXTENSIBLE, 'NO'), NVL(TF.MAXBYTES

, 0), NVL(TF.INCREMENT_BY, 0) FROM DBA_TABLESPACES TS, DBA_TEMP_FILES TF WHERE TS.TABLESPACE_NAME = TF.TABLESPACE_NAME ORDER BY 1, 6'

ORA-01157: cannot identify/lock data file 201 - see DBWR trace file

ORA-01110: data file 201: '/oracle/<SID>/sapdata1/temp_1/temp.data1'

BR0314E Collection of information on database files failed

 

BR0056I End of database backup: bentnldh.afd 2014-05-02 15.05.46

BR0280I BRBACKUP time stamp: 2014-05-02 15.05.46

BR0054I BRBACKUP terminated with errors

 

Kind regards,

Pradeep

Gaurav Rana
正确答案 按照 Gaurav Rana  打开 May 2, 2014 7:30 PM

No folder exits like temp_1 in the system..

 

First you need to create the dir temp_1 with ora<sid>:dba ownership ,after that perform below queries

 

SQL>alter database tempfile '/oracle/<SID>/sapdata1/temp_1/temp.data1.dbf' drop  .


After drop just add tempfile with query

 

SQL>alter tablespace PSAPTEMP add tempfile '/oracle/<SID>/sapdata1/temp_1/temp.data1.dbf' size 10G;

 

Make sure you're with proper backup if you're performing these activities on Production env.

 

Also please consider SCN thread https://scn.sap.com/thread/3382583

 

 

Regards,

Gaurav

查看上下文中的回答
有用的答案 按照 Gaurav RanaGaurav RanaDeepak Kori 
平均用户评级
(0 评级)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-1983181/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-10

  • 博文量
    791
  • 访问量
    1933885