Shulou(Shulou.com)05/31 Report--

This article mainly shows you "what to do when there is an ORA-01157 problem in oracle 11g rac". It is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "what to do when there is an ORA-01157 problem in oracle 11g rac".

I. Environment

11g rac

Rhel 6.8

Second, error information

SQL > select file_name from dba_data_files

ERROR:

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

ORA-01110: data file 6:

Third, the processing process

It took a few minutes to clean up the train of thought, write the script and begin to do it.

1. SQL > archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination + DATA/archOldest online log sequence 20Next log sequence to archive 22Current log sequence 22SQL > SQL > 2 and offline tablespace SQL > alter tablespace FINANCE offline are opened by default. Tablespace altered.3, cp data files ASMCMD [+ data/FSCZRAC/datafile] > cp / u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF + data/fsczrac/datafile/DATAfsczracdatafilefinance.DBFcopying / u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF-> + data/fsczrac/datafile/DATAfsczracdatafilefinance.DBFASMCMD [+ data/FSCZRAC/datafile] > 4, Modify the data file path in the control file, SQL > alter database rename file'/ u01 name, oracleproduce, 11.2.0, dbhome, 1, dbAfzracdatafilefinance.DBF'to'+ data/fsczrac/datafile/DATAfsczracdatafilefinance.DBF' Database altered.5, restore tablespace SQL > recover tablespace finance;Media recovery complete.6, tablespace onlineSQL > alter tablespace finance online;Tablespace altered.7, verify SQL > col file_name for a60SQL > select file_name, file_id, online_status from dba_data_files FILE_NAME FILE_ID ONLINE_----+ DATA/fsczrac/datafile/ Users.259.967475641 4 ONLINE+DATA/fsczrac/datafile/undotbs1.258.967475641 3 ONLINE+DATA/fsczrac/datafile/sysaux.257.967475641 2 ONLINE+DATA/fsczrac/datafile/system.256.967475641 1 SYSTEM+DATA/fsczrac/datafile/undotbs2.269.967475831 5 ONLINE+DATA/fsczrac / datafile/datafsczracdatafilefinance.dbf 6 ONLINE6 rows selected.SQL > above is all the content of the article "what to do if there is an ORA-01157 problem in oracle 11g rac" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.