因为把control02.ctl文件移动到另一个位置导致出先以下错误:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2253784 bytes
Variable Size 1526729768 bytes
Database Buffers 117440512 bytes
Redo Buffers 7094272 bytes
ORA-00205: error in identifying control file, check alert log for more info
在这期间还把spfile文件给改了,感觉自己真的是在作死边缘疯狂试探,哈哈!SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/11.2.0/dbs/initdb01.ora'
解决LRM-00109:
将数据库中 $ORACLE_BASE/admin/(实例名) /pfile目录下的init.ora(.2132019131628)文件复制到
$ORACLE_HOME/dbs路径下即可
cp init.ora.21320191