1、现有控制文件已删除 2、参数文件中指定的控制文件路径正确 3、数据文件所需目录存在且有写入权限 4、创建语句中的路径指定正确
对于CREATE CONTROLFILE命令,我们必须确保所有数据文件都来自同一数据库。要检验这一点,我们记下CREATE CONTROLFILEs数据文件子句中第一个文件的文件头中的DB_NAME。然后,我们确认所有后续文件在它们的头中有相同DB名称,如果没有,Oracle会发出这个错误。 所以在这种情况下,错误信息中的’given name’ 是第一个文件头的...
SYS>@new_controlfile.sql CREATE CONTROLFILE REUSE SET DATABASE "HRMS" RESETLOGS * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/home/oracle/database/HRMS/system01.dbf' ORA-27037: unable to obtain file status ...
总结:最初的db_name是orcl,重建控制文件,想把db_name修改为orclK,如果重建控制文件使用REUSE,会提示ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name ORCL in file header does not match given name of ORCLK ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf' 最初...
CREATE CONTROLFILE SET/reuse DATABASE “billy” RESETLOGS/NOresetlogs NOARCHIVELOG 2 MAXLOGFILES 64 3 MAXLOGMEMBERS 2 4 MAXDATAFILES 254 5 MAXINSTANCES 32 6 MAXLOGHISTORY 113 7 LOGFILE 8 GROUP 1 ‘E:"Oracle"ORADATA"BILLY"REDO01.LOG’ SIZE 1048576 , ...
CREATE CONTROLFILE CREATE DATABASE CREATE DATABASE LINK CREATE DIMENSION CREATE DIRECTORY CREATE DISKGROUP CREATE EDITION CREATE FLASHBACK ARCHIVE CREATE FUNCTION CREATE HIERARCHY CREATE INDEX CREATE INDEXTYPE CREATE INMEMORY JOIN GROUP CREATE JAVA 14 SQL Statements: CREATE LIBRARY to CREATE SCHEMA 15 SQL...
CREATE CONTROLFILE SET DATABASE "SID" RESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/oracle/SID/sapdata1/el731d_6/el731d.data6' ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such fi...
When you create a database for the first time, Oracle Database creates a control file in the default destination, which is dependent on the value or several initialization parameters. See CREATE CONTROLFILE, "Semantics". You cannot use this clause if you also specify a parameter value that ...
ORA-01565: error in identifying file '/home/oracle/database/NEWDBNAME/system01.dbf' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 To create the new controlfile for the new database you must use the word ‘SET’ ...
The control file was just created with RESETLOGS.CauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account? Click to get started!In this DocumentSymptomsChangesCause...