ORA-205 signalled during: ALTER DATABASE MOUNT...
Wed Oct 07 11:28:30 2009
Shutting down instance: further logons disabled
Wed Oct 07 11:28:30 2009
Stopping background process MMNL
Wed Oct 07 11:28:31 2009
Stopping background process CJQ0
Wed Oct 07 11:28:32 2009
Stopping background process MMON
Wed Oct 07 11:28:32 2009
Shutting down instance (immediate)
License high water = 2
Wed Oct 07 11:28:32 2009
Stopping Job queue slave processes
Wed Oct 07 11:28:32 2009
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Oct 07 11:28:34 2009
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Oct 07 11:56:57 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
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 = 1493172224
__large_pool_size = 0
__java_pool_size = 16777216
__streams_pool_size = 0
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 10435428352
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 8908701696
compatible = 10.2.0.1.0
log_archive_format = ARC%S_%R.%T
db_file_multiblock_read_count= 16
db_recovery_file_dest = e:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 4147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
job_queue_processes = 50
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 1073741824
PMON started with pid=2, OS id=4108
PSP0 started with pid=3, OS id=5380
MMAN started with pid=4, OS id=1656
DBW0 started with pid=5, OS id=5824
LGWR started with pid=6, OS id=5880
CKPT started with pid=7, OS id=3880
SMON started with pid=8, OS id=2548
RECO started with pid=9, OS id=5172
CJQ0 started with pid=10, OS id=5220
MMON started with pid=11, OS id=5160
Wed Oct 07 11:56:57 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1920
Wed Oct 07 11:56:57 2009
starting up 1 shared server(s) ...
Wed Oct 07 11:56:57 2009
ALTER DATABASE MOUNT
Wed Oct 07 11:56:57 2009
ORA-00202: ????: ''E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL''
ORA-27046: ??????????????
OSD-04012: 文件大小不匹配 (OS 7323680)Wed Oct 07 11:57:00 2009
ORA-205 signalled during: ALTER DATABASE MOUNT...
Wed Oct 07 11:28:30 2009
Shutting down instance: further logons disabled
Wed Oct 07 11:28:30 2009
Stopping background process MMNL
Wed Oct 07 11:28:31 2009
Stopping background process CJQ0
Wed Oct 07 11:28:32 2009
Stopping background process MMON
Wed Oct 07 11:28:32 2009
Shutting down instance (immediate)
License high water = 2
Wed Oct 07 11:28:32 2009
Stopping Job queue slave processes
Wed Oct 07 11:28:32 2009
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Oct 07 11:28:34 2009
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Oct 07 11:56:57 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
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 = 1493172224
__large_pool_size = 0
__java_pool_size = 16777216
__streams_pool_size = 0
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 10435428352
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 8908701696
compatible = 10.2.0.1.0
log_archive_format = ARC%S_%R.%T
db_file_multiblock_read_count= 16
db_recovery_file_dest = e:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 4147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
job_queue_processes = 50
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 1073741824
PMON started with pid=2, OS id=4108
PSP0 started with pid=3, OS id=5380
MMAN started with pid=4, OS id=1656
DBW0 started with pid=5, OS id=5824
LGWR started with pid=6, OS id=5880
CKPT started with pid=7, OS id=3880
SMON started with pid=8, OS id=2548
RECO started with pid=9, OS id=5172
CJQ0 started with pid=10, OS id=5220
MMON started with pid=11, OS id=5160
Wed Oct 07 11:56:57 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1920
Wed Oct 07 11:56:57 2009
starting up 1 shared server(s) ...
Wed Oct 07 11:56:57 2009
ALTER DATABASE MOUNT
Wed Oct 07 11:56:57 2009
ORA-00202: ????: ''E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL''
ORA-27046: ??????????????
OSD-04012: 文件大小不匹配 (OS 7323680)Wed Oct 07 11:57:00 2009
ORA-205 signalled during: ALTER DATABASE MOUNT...
我就是把orcal的服务停止了再启动,没做其他操作.机器也没有重启过
怎么做呢,sqlplus / as sysdba
startup nomount;
alter system set control_files=
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL' ,
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL' scope=spfile;
shutdown abort;
startup;
sqlplus / as sysdba
startup nomount;
alter system set control_files=
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL' ,
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL' scope=spfile;
shutdown abort;
startup;
ORA-01507: ??????
ORACLE 例程已经关闭。
SQL> startup nomount;
ORACLE 例程已经启动。Total System Global Area 1.0435E+10 bytes
Fixed Size 2021512 bytes
Variable Size 1526728568 bytes
Database Buffers 8891924480 bytes
Redo Buffers 14753792 bytes
SQL> alter system set control_files=
2 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTRO
3 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTRO
alter system set control_files=
*
第 1 行出现错误:
ORA-32001: ????? SPFILE, ????????? SPFILE
或者 startup nomount之后,create spfile from pfile
按照上面的样子像是系统或者是存储层面的问题,要是数据文件坏了就麻烦了.
看LZ的样子好像很不熟悉,找台机器练练手吧,在测试数据库里面
alter database backup controlfile to trace;
然后在user_dump里面找到最新的用户跟踪文件,里面有很详细的控制文件重建的步骤说明.
如果第三个控制文件也挂了,
那么只有恢复重建控制文件这条路了。
看这篇文章,http://blog.csdn.net/csucxcc/archive/2009/10/08/4641102.aspx
数据有前一天的热备份,不知道能否恢复.
我现在没有办法得到脚本,所以我想自己手动来写生成控制文件的代码,但是我不知道应该包含哪些数据文件?
group 1('E:\oracle\product\10.2.0\oradata\ORCL\redo01.log') size 100m,
group 2('E:\oracle\product\10.2.0\oradata\ORCL\redo02.log') size 100m,
group 3('E:\oracle\product\10.2.0\oradata\ORCL\redo03.log') size 100m,
noresetlogs
datafile
'E:\oracle\product\10.2.0\oradata\ORCL\SYSAUX01.DBF',
'E:\oracle\product\10.2.0\oradata\ORCL\SYSTEM01.DBF',
'E:\oracle\product\10.2.0\oradata\ORCL\TEMP01.DBF',
'E:\oracle\product\10.2.0\oradata\ORCL\UNDOTBS01.DBF',
'E:\oracle\product\10.2.0\oradata\ORCL\USERS01.DBF',
'F:\datafile\ECCHNFILE\ECCHNTS01.DBF',
'F:\datafile\ECCHNFILE\ECCHNTS02.DBF',
'F:\datafile\ECCHNFILE\ECCHNTS03.DBF',
'F:\datafile\TESTTS\TESTTS01.DBF'
CHARACTER SET ZHS32GB18030