[oracle@huang ~]$ sed -i 's/^ //' /tmp/luo2.txt
[oracle@huang ~]$ sed -i 's/^ //' /tmp/luo2.txt
[oracle@huang ~]$ vim /tmp/luo2.txt
确定时候空格和--开头的行就删除了。
SQL> shutdown abort;
ORACLE instance shut down.
SQL> @/tmp/luo2.txt 我们运行刚才的那个脚本就可以重新的建立起控制文件
ORACLE instance started.
Total System Global Area 1090519040 bytes
Fixed Size 1267020 bytes
Variable Size 704645812 bytes
Database Buffers 369098752 bytes
Redo Buffers 15507456 bytes
Control file created.
Media recovery complete.
Database altered.
Tablespace altered.
SQL> ho ls /sof/oracle/oradata/orcl/
control01.ctl example01.dbf redo03.log temp01.dbf
control02.ctl redo01.log sysaux01.dbf undotbs01.dbf
control03.ctl redo02.log system01.dbf users01.dbf
上面就是控制文件的几种恢复方法。