ORA-00205 error in identifying controlfile

[Oracle problem set 4] ORA-00205 error in identifying controlfile Description: [oracle problem set] is the problem encountered by the master usually operate the database and solution. Statement execution: Indicates An error occurred while operating the database. Cause: indicates the cause of the Error. Solution: indicates the solution to the error. Related Knowledge: indicates the knowledge related to this topic ============================================ ================================ execute the statement: start Database: startup error phenomenon: ORA-00205 error in identifying controlfile error cause: Control File loss, loss of control files for control02.ctl and control03.ctl solution: solution A1: replace CONTROL01.CTL in 2 copies, change the name to CONTROL02.CTL and CONTROL03.CTL respectively. After the restart, the problem is solved. Solution A2: first view the/home/oracle/app/oracle/oradata/orcl/directory. If only CONTROL01.CTL is found and none of the other two are found, modify spfileorcl. ora. Refer to [related knowledge: Create pfile and spfile], and then restart the database solution A3: re-create the control file. First, delete the remaining control files. Refer to [related knowledge: create control file: A. Create pfile and spfilea. Check whether the system starts Select isspecified by pfile or spfile. count (*) from v $ spparameter group by isspecified; if true exists in isspecified, it indicates that all configurations are specified with spfile. If all configurations are false, it indicates that pfile is used to start B and SPfile. The advantages of Spfile are that spfile has corrected the confusion of pfile management, in a multi-node environment, pfile will have multiple images that need to be tracked for the latest image at startup. This is a cumbersome process. After spfile is used, all parameter changes are written to spfile (as long as scope = spfile or both is defined). The parameter configuration has an authoritative source. C. View spfile position spfile_location show parameter spfile d. Obtain pfile Create pfile = 'ur _ pfile_location 'from spfile; create pfile = 'your _ pfile_location 'from spfile = 'spfile _ location '; e. Obtain the spfile Create spfile from pfile = 'your _ pfile_location 'Create spfile = 'spfile _ location' from pfile = 'your _ pfile_location' f. Modify the parameter alter system set dynamically. parameter = Value scope = spfile | both | read when memory Startup nomount Spfile or pfile coexist. spfile takes precedence over g. Use pfile or spfile to start SQL> startup pfile = 'ur _ Pfile. ora 'B. Create a control file Step 1: generate the trace file alter database backup controlfile to trace Step 2: Execute the statement in the trace file section Set #1. NORESETLOGS case to End of tempfile additions. or Set #2. RESETLOGS case to End of tempfile additions .) Step 3: execute the following statement SQL> ALTER DATABASE OPEN RESETLOGS;