In order to configure database recoverability, I tried to modify the control file, alter system set control_files = '/u01/app/Oracle/oradata/$ ORACLE_SID/controlfile/o1_mf_7p5b2xty _. ctl ','/u01/app/oracle/flash_recovery_area/$ ORACLE_SID/controlfile/o1_mf_7p5b2y0c _. ctl 'scope = spfile;
The execution result is: the system has been changed.
Then restart the database.
However, an error is reported when the database is shut down,
ORA-01507 :........
Then start the database, it cannot start, report ORA-00205.
I found the control file on the Internet, and read the alter log bottom error at/u01/app/oracle/admin/$ ORACLE_SID/bdump, cannot be found
'/U01/app/oracle/oradata/$ ORACLE_SID/controlfile/o1_mf_7p5b2xty _. ctl' file or directory,
I thought it was a path problem. Then I copied the file into a copy and changed the name.
Then execute: startup nomount to enter the path of the modification control file,
Alter system set
Control_files = '/u01/app/oracle/oradata/$ ORACLE_SID/controlfile/control01.ctl ',
'/U01/app/oracle/oradata/$ ORACLE_SID/controlfile/control02.ctl ',
'/U01/app/oracle/oradata/$ ORACLE_SID/controlfile/control03.ctl' scope = spfile;
These three control files are copied based on the above two files, and then changed the name.
Run shutdown immediate.
Start the database again, and then OK.