请教：

xuejun74

回复 10# renxiao2003

看哪个文件在不在阿？


   

sinopec_付强

cntrlzxj_data.dbf
这个文件很奇怪！

renxiao2003

xuejun74 发表于 2012-01-18 04:53
回复 10# renxiao2003

看哪个文件在不在阿？

错误已经很明显了啊。一眼就看出来了。

xuejun74

是的，很明显。
请问正常的情况下，dbs下有cntrlzxj_data.dbf这个文件吗？

sinopec_付强

oracle不会无缘无故的去找某个文件的，还是先查看一下controlfile的内容。

xuejun74

controlfile,应该是那个参娄文件吧

xuejun74

数据库本身那个控制文件，不是文本文件，用cat打不开

sinopec_付强

回复 17# xuejun74


    你可以在alert里找到controlfile的内容

xuejun74

Mon Jan 16 23:58:02 2012
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Mon Jan 16 23:58:09 2012
Stopping background process CJQ0
Mon Jan 16 23:58:09 2012
Stopping background process MMNL
Mon Jan 16 23:58:10 2012
Stopping background process MMON
Mon Jan 16 23:58:11 2012
Shutting down instance (normal)
License high water mark = 1
Mon Jan 16 23:58:11 2012
Stopping Job queue slave processes
Mon Jan 16 23:58:11 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jan 16 23:58:13 2012
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Jan 17 00:01:43 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 50331648
  large_pool_size          = 4194304
  nls_date_language        = AMERICAN
  nls_date_format          = Mon DD YYYY HH24:MI:SS
  db_block_size            = 8192
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = /home/oracle/ora10/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = undotbs1
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=testXDB)
  job_queue_processes      = 10
  user_dump_dest           = /opt/oracle/admin/zxj_data/udump
  core_dump_dest           = /opt/zxj_data/admin/zxj_data/cdump
  db_name                  = zxj_data
  open_cursors             = 300
  pga_aggregate_target     = 12777216
PMON started with pid=2, OS id=3993
PSP0 started with pid=3, OS id=3995
MMAN started with pid=4, OS id=3997
DBW0 started with pid=5, OS id=3999
LGWR started with pid=6, OS id=4001
CKPT started with pid=7, OS id=4003
SMON started with pid=8, OS id=4005
RECO started with pid=9, OS id=4007
CJQ0 started with pid=10, OS id=4009
MMON started with pid=11, OS id=4011
Tue Jan 17 00:01:43 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4013
Tue Jan 17 00:01:43 2012
starting up 1 shared server(s) ...
Tue Jan 17 00:01:43 2012
ALTER DATABASE   MOUNT
Tue Jan 17 00:01:43 2012
ORA-00202: control file: '/home/oracle/ora10/product/10.1.10/db_1/dbs/cntrlzxj_data.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Tue Jan 17 00:01:43 2012
ORA-205 signalled during: ALTER DATABASE   MOUNT...

xuejun74

这就是alert的部分内容