...
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info要是没有挂载却能查询到 dual呢?应该么?[oracle@oracle11g trace]$ vi alert_oradb.logThu Apr 07 15:12:28 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in client-side pfile /u01/admin/oradb/pfile/init.ora on machine oracle11g
System parameters with non-default values:
processes = 150
memory_target = 476M
control_files = "/u01/oradata/oradb/control01.ctl"
control_files = "/u01/flash_recovery_area/oradb/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/u01/flash_recovery_area"
db_recovery_file_dest_size= 3852M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oradbXDB)"
audit_file_dest = "/u01/admin/oradb/adump"
audit_trail = "DB"
db_name = "oradb"
open_cursors = 300
diagnostic_dest = "/u01"
Thu Apr 07 15:12:29 2011
PMON started with pid=2, OS id=12074
Thu Apr 07 15:12:29 2011
VKTM started with pid=3, OS id=12076 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Apr 07 15:12:29 2011
GEN0 started with pid=4, OS id=12080
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info要是没有挂载却能查询到 dual呢?应该么?[oracle@oracle11g trace]$ vi alert_oradb.logThu Apr 07 15:12:28 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in client-side pfile /u01/admin/oradb/pfile/init.ora on machine oracle11g
System parameters with non-default values:
processes = 150
memory_target = 476M
control_files = "/u01/oradata/oradb/control01.ctl"
control_files = "/u01/flash_recovery_area/oradb/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/u01/flash_recovery_area"
db_recovery_file_dest_size= 3852M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oradbXDB)"
audit_file_dest = "/u01/admin/oradb/adump"
audit_trail = "DB"
db_name = "oradb"
open_cursors = 300
diagnostic_dest = "/u01"
Thu Apr 07 15:12:29 2011
PMON started with pid=2, OS id=12074
Thu Apr 07 15:12:29 2011
VKTM started with pid=3, OS id=12076 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Apr 07 15:12:29 2011
GEN0 started with pid=4, OS id=12080
而且你的alert.log是当前的? 还是你没有翻页翻到最后?
后面也是跟后两行类似这样的,我没粘上面。
Thu Apr 07 15:12:29 2011
DIAG started with pid=5, OS id=12082
Thu Apr 07 15:12:29 2011
DBRM started with pid=6, OS id=12084
Thu Apr 07 15:12:29 2011
PSP0 started with pid=7, OS id=12086
Thu Apr 07 15:12:29 2011
DIA0 started with pid=8, OS id=12088
Thu Apr 07 15:12:29 2011
MMAN started with pid=9, OS id=12090
Thu Apr 07 15:12:30 2011
DBW0 started with pid=10, OS id=12092
Thu Apr 07 15:12:30 2011
LGWR started with pid=11, OS id=12094
Thu Apr 07 15:12:30 2011
CKPT started with pid=12, OS id=12096
Thu Apr 07 15:12:30 2011
SMON started with pid=13, OS id=12098
我是这么做的!挂载不上,然后
SQL> show parameter dump
找出background_dump_dest string /u01/diag/rdbms/oradb/oradb/trace
然后
[oracle@oracle11g ~]$ cd /u01/diag/rdbms/oradb/oradb/trace
[oracle@oracle11g trace]$ ls
这里有一个是alert_oradb.log
不道该从哪查呢...?
$tail -n30 alert_oradb.log控制文件指定有问题(找不到或打不开控制文件),
是否手动修改过控制文件参数,确认路径是否正确?