新建controlfile 脚本如下:
create controlfile reuse database orcl archivelog noresetlogs
maxlogfiles 16
maxinstances 8
maxlogmembers 3
maxloghistory 1
datafile
'/oracle/oradata/orcl/example01.dbf',
'/oracle/oradata/orcl/system01.dbf',
'/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/oradata/orcl/users01.dbf',
'/oracle/oradata/orcl/undotbs01.dbf'
character set utf8
提示错误如下:
SQL> @/oracle/ctctl.sql
create controlfile reuse database orcl archivelog noresetlogs
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/log1@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
create controlfile reuse database orcl archivelog noresetlogs
maxlogfiles 16
maxinstances 8
maxlogmembers 3
maxloghistory 1
datafile
'/oracle/oradata/orcl/example01.dbf',
'/oracle/oradata/orcl/system01.dbf',
'/oracle/oradata/orcl/sysaux01.dbf',
'/oracle/oradata/orcl/users01.dbf',
'/oracle/oradata/orcl/undotbs01.dbf'
character set utf8
提示错误如下:
SQL> @/oracle/ctctl.sql
create controlfile reuse database orcl archivelog noresetlogs
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/log1@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3