Shulou(Shulou.com)06/01 Report--

There is a problem:

SQL > startup

ORACLE instance started.

Total System Global Area 2371719168 bytes

Fixed Size 2215624 bytes

Variable Size 1342177592 bytes

Database Buffers 1023410176 bytes

Redo Buffers 3915776 bytes

Database mounted.

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

ORA-01110: data file 6:'/ opt/oracle/oradata/orcl/srcmsg.dbf'

Solution:

1. Close the library

SQL > shutdown immediate

Alter database open

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

ORA-01110: data file 12:'/ oradata/orcldata/sacproduce02.dbf'

The error message is that the read and write operation cannot be carried out, and the mounted hard disk cannot read and write operation. To open the database, you can only take the file offline. SQL > archive log list; / / check the archiving mode of the database

Database log mode No Archive Mode / / non-archiving mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 4

Current log sequence 6

If you are in archive mode, then:

Alter database datafile'/ oradata/orcldata/sacproduce02.dbf' offline

In non-archived mode (current situation)

Alter database datafile'/ oradata/orcldata/sacproduce02.dbf'offline drop

SQL > alter database datafile'/ opt/oracle/oradata/orcl/srcmsg.dbf' offline drop

Database altered.

SQL > alter database datafile'/ opt/oracle/oradata/orcl/srcmsg.dbf' offline

Database altered.

Finally, just open the database.

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.