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

Write in the front: Contact the environment, when the previous operation changed storage backup, all files have been migrated to the new disk, and the files in the original directory have been deleted. Start the database again today, and an error is reported.

SQL> startup

ORACLE instance started.

Total System Global Area 413372416 bytes

Fixed Size 2253784 bytes

Variable Size 327158824 bytes

Database Buffers 79691776 bytes

Redo Buffers 4268032 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database open RESETLOGS;

alter database open RESETLOGS

*

ERROR at line 1:

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

ORA-01110: data file 1: '/ooradata/test1/system01.dbf'

What's wrong with this? Start up and always go to the original location to find, check where the data file is.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/ooradata/test1/system01.dbf

/ooradata/test1/sysaux01.dbf

/ooradata/test1/undotbs01.dbf

/ooradata/test1/users01.dbf

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/ooradata/test1/control01.ctl

/u01/app/oracle/fast_recovery_area/test1/control02.ctl

The data file is in place, the control file is also in place, it must be a problem with the parameter file,

Sir, look at the control file location into a pfile.

SQL> create pfile='/home/oracle/cs/qq.txt' from spfile;

create pfile='/home/oracle/cs/qq.txt' from spfile

*

ERROR at line 1:

ORA-01565: error in identifying file '?/ dbs/spfile@.ora'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

This means that the database is not started with a new spfile. Specify spfile.

SQL> create pfile='/home/oracle/cs/qq.txt' from spfile='/u01/app/oracle/product/11.2/db_1/dbs/spfiletest1.ora';

File created.

View qq.txt

vi qq.txt

The control file is already a new directory. So when it starts, just make a new pfile

SQL> shutdown immediate

SQL> create spfile from pfile='/home/oracle/cs/qq.txt';

File created.

SQL> startup

ORACLE instance started.

Total System Global Area 413372416 bytes

Fixed Size 2253784 bytes

Variable Size 327158824 bytes

Database Buffers 79691776 bytes

Redo Buffers 4268032 bytes

Database mounted.

Database opened.

solve

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.