对于Oracle数据库的错误印象(1)_Oracle数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

对于Oracle的错误印象(1)

作者:黑客防线网安Oracle维护基地 来源:黑客防线网安Oracle维护基地 浏览次数:0

黑客防线网安网讯:  今天测试的时候纠正了一个错误的印象,一直认为如果当前控制文件被误删除,会导致实例关闭。而实际上,Oracle并不会结束当前的实例:   SQL> show parameter control_files   NAME TY...

  今天测试的时候纠正了一个错误的印象一直认为如果当前控制文件被误删除会导致实例关闭而实际上,Oracle并不会结束当前的实例:

  SQL> show parameter control_files
  NAME TYPE VALUE
  ------------------------------------ ----------- ------------------------------
  control_files string /u01/oracle/oradata/db01/contr
  ol01.ctl, /u01/oracle/oradata/
  db01/control02.ctl, /u01/oracl
  e/oradata/db01/control03.ctl
  SQL> select * from dual;
  D
  -
  X
  SQL> host
  oracle:/home/oracle> cd /u01/oracle/oradata/db01
  oracle:/u01/oracle/oradata/db01> ls -l *.ctl
  -rw-r----- 1 oracle dba 9748480 May 24 12:55 control01.ctl
  -rw-r----- 1 oracle dba 9748480 May 24 12:55 control02.ctl
  -rw-r----- 1 oracle dba 9748480 May 24 12:55 control03.ctl
  oracle:/u01/oracle/oradata/db01> rm control02.ctl
  oracle:/u01/oracle/oradata/db01> exit
  exit
  SQL> select * from dual;
  D
  -
  X
  SQL> select instance_name, status from v$instance;
  INSTANCE_NAME STATUS
  ---------------- ------------
  db01 OPEN
  SQL> alter system checkpoint;
  System altered.
  SQL> select instance_name, status from v$instance;
  INSTANCE_NAME STATUS
  ---------------- ------------
  db01 OPEN
  SQL> alter system switch logfile;
  System altered.
  SQL> select instance_name, status from v$instance;
  INSTANCE_NAME STATUS
  ---------------- ------------
  db01 OPEN
  SQL> col name format a50
  SQL> select * from v$controlfile;
  STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
  ------- -------------------------------------------------- --- ---------- --------------
  /u01/oracle/oradata/db01/control01.ctl NO 16384 594
  /u01/oracle/oradata/db01/control02.ctl NO 16384 594
  /u01/oracle/oradata/db01/control03.ctl NO 16384 594
  SQL> select * from v$controlfile_record_section;
  select * from v$controlfile_record_section
  *
  ERROR at line 1:
  ORA-00210: cannot open the specified control file
  ORA-00202: control file: '/u01/oracle/oradata/db01/control02.ctl'
  ORA-27041: unable to open file
  Linux Error: 2: No such file or directory
  Additional information: 3
  SQL> select * from v$controlfile;
  STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
  ------- -------------------------------------------------- --- ---------- --------------
  /u01/oracle/oradata/db01/control01.ctl NO 16384 594
  /u01/oracle/oradata/db01/control02.ctl NO 16384 594
  /u01/oracle/oradata/db01/control03.ctl NO 16384 594

 

    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-12895-1.html
网站维护教程更新时间:2012-03-23 00:48:09  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer