今天一直在做数据的清理,结果量太大了,新建索引花去大部分时间,准备5点30准时下班的,收拾好一切,背上包已经快出办公室了,接到个北京全国中心电话,说是监控到我的一个数据库状态不对,郁闷,又是下班出问题。
检查这个数据库,日值如下:
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SVRMGR> Connected.
SVRMGR> ORACLE instance started.
Total System Global Area 1715622048 bytes
Fixed Size 73888 bytes
Variable Size 641286144 bytes
Database Buffers 1073741824 bytes
Redo Buffers 520192 bytes
Database mounted.
ORA-01113: file 75 needs media recovery
ORA-01110: data file 75: '/oracle/xxy/u02/oradata/xxy_archive1_inx_12'
SVRMGR> Server Manager complete.
10月08 17:55:10 oracle_xxy S30oracle[1026]: Starting Oracle listener
LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 08-OCT-2008 17:55:10
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /opt/oracle/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.1.7.0.0 - Production
System parameter file is /opt/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /opt/oracle/product/8.1.7/network/log/xxy.log
确实有问题,于是处理如下:
[oracle@ubs_2 pfile]$ export ORACLE_SID=xxy
[oracle@ubs_2 pfile]$ svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SVRMGR> connect internal
Connected.
SVRMGR> select * from tab;
select * from tab
*
ORA-01219: database not open: queries allowed on fixed tables/views only
SVRMGR> recover datafile 75
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 76 needs media recovery
ORA-01110: data file 76: '/oracle/xxy/u02/oradata/xxy_archive1_inx_13'
SVRMGR> recover datafile 76
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 77 needs media recovery
ORA-01110: data file 77: '/oracle/xxy/u02/oradata/xxy_archive1_inx_14'
SVRMGR> recover datafile 77
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 78 needs media recovery
ORA-01110: data file 78: '/oracle/xxy/u02/oradata/xxy_archive2_11'
SVRMGR> recover datafile 78
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 79 needs media recovery
ORA-01110: data file 79: '/oracle/xxy/u02/oradata/xxy_archive1_inx_15'
SVRMGR> recover datafile 79
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 80 needs media recovery
ORA-01110: data file 80: '/oracle/xxy/u02/oradata/xxy_archive2_23'
SVRMGR> recover datafile 80
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 81 needs media recovery
ORA-01110: data file 81: '/oracle/xxy/u02/oradata/xxy_archive2_12'
SVRMGR> recover datafile 81
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 82 needs media recovery
ORA-01110: data file 82: '/oracle/xxy/u02/oradata/xxy_archive2_13'
SVRMGR> recover datafile 82
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 83 needs media recovery
ORA-01110: data file 83: '/oracle/xxy/u02/oradata/xxy_archive2_14'
SVRMGR> recover datafile 83
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 84 needs media recovery
ORA-01110: data file 84: '/oracle/xxy/u02/oradata/xxy_archive2_15'
SVRMGR> recover datafile 84
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 85 needs media recovery
ORA-01110: data file 85: '/oracle/xxy/u02/oradata/xxy_archive2_16'
SVRMGR> recover datafile 85
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 87 needs media recovery
ORA-01110: data file 87: '/oracle/xxy/u02/oradata/xxy_archive1_inx_16'
SVRMGR> recover datafile 87
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 88 needs media recovery
ORA-01110: data file 88: '/oracle/xxy/u02/oradata/xxy_archive1_inx_17'
SVRMGR> recover datafile 88
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 89 needs media recovery
ORA-01110: data file 89: '/oracle/xxy/u02/oradata/xxy_archive2_17'
SVRMGR> recover datafile 89
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 90 needs media recovery
ORA-01110: data file 90: '/oracle/xxy/u02/oradata/xxy_archive2_18'
SVRMGR> recover datafile 90
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 91 needs media recovery
ORA-01110: data file 91: '/oracle/xxy/u02/oradata/xxy_archive2_19'
SVRMGR> recover datafile 91
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 92 needs media recovery
ORA-01110: data file 92: '/oracle/xxy/u02/oradata/xxy_archive2_20'
SVRMGR> recover datafile 92
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 93 needs media recovery
ORA-01110: data file 93: '/oracle/xxy/u02/oradata/xxy_archive2_21'
SVRMGR> recover datafile 93
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 94 needs media recovery
ORA-01110: data file 94: '/oracle/xxy/u02/oradata/xxy_archive1_inx_18'
SVRMGR> recover datafile
ORA-02236: invalid file name
SVRMGR> recover datafile 94
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 95 needs media recovery
ORA-01110: data file 95: '/oracle/xxy/u02/oradata/xxy_archive1_inx_19'
SVRMGR> recover datafile 95
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 96 needs media recovery
ORA-01110: data file 96: '/oracle/xxy/u02/oradata/xxy_archive1_inx_20'
SVRMGR> recover datafile 96
Media recovery complete.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 97 needs media recovery
ORA-01110: data file 97: '/oracle/xxy/u02/oradata/xxy_archive2_22'
SVRMGR> recover datafile 97
Media recovery complete.
SVRMGR> alter database open;
Statement processed.
SVRMGR>
也不知道这些个数据文件是怎么回事,一出问题全出,都要recover一次。
以为就好了哟
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SVRMGR> Connected.
SVRMGR> ORACLE instance started.
Total System Global Area 1715622048 bytes
Fixed Size 73888 bytes
Variable Size 641286144 bytes
Database Buffers 1073741824 bytes
Redo Buffers 520192 bytes
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/oracle/xxy/u01/oradata/xxy_control01.ctl'
ORA-27072: skgfdisp: I/O error
Linux Error: 9: Bad file descriptor
Additional information: 1
SVRMGR> Server Manager complete.
10月08 18:31:18 oracle_xxy S30oracle[3002]: Starting Oracle listener
LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 08-OCT-2008 18:31:18
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /opt/oracle/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.1.7.0.0 - Production
System parameter file is /opt/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /opt/oracle/product/8.1.7/network/log/xxy.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.252.36.4)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.252.36.4)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=G
IOP)(SESSION=RAW)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1.252.36.4)(PORT=1521)))
STATUS of the LISTENER
一看更吓人了,控制文件都不认识了,这些个错误真不是开玩笑的了。
经过一阵折腾,终于恢复完成,不过还是心有余悸。
10月08 18:47:34 oracle_xxy S20ext2[1008]: Re-exporting filesystems.
10月08 18:47:34 oracle_xxy S30oracle[1053]: Starting Oracle database
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SVRMGR> Connected.
SVRMGR> ORACLE instance started.
Total System Global Area 1715622048 bytes
Fixed Size 73888 bytes
Variable Size 641286144 bytes
Database Buffers 1073741824 bytes
Redo Buffers 520192 bytes
Database mounted.
Database opened.
SVRMGR> Server Manager complete.
10?? 08 18:47:43 oracle_xxy S30oracle[1053]: Starting Oracle listener
LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 08-OCT-2008 18:47:43
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /opt/oracle/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.1.7.0.0 - Production
System parameter file is /opt/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /opt/oracle/product/8.1.7/network/log/xxy.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.252.36.4)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.252.36.4)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=G
IOP)(SESSION=RAW)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1.252.36.4)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias xxy
Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Start Date 08-OCT-2008 18:47:43
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /opt/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File /opt/oracle/product/8.1.7/network/log/xxy.log
Services Summary...
PLSExtProc has 1 service handler(s)
xxy has 1 service handler(s)
The command completed successfully
10?? 08 18:47:43 oracle_xxy S90oramon[1128]: Started
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
10?? 08 18:47:43 oracle_xxy S99announce[1139]: Service startup completed
[833 Oct 8 18:47:46] Service oracle_xxy start scripts succeeded (pid 967 exit 0)
[833 Oct 8 18:47:46] NOTICE: Service oracle_xxy is now running on ubs_2 (was starting)
[2536 Oct 8 18:50:27] User _rsfadmin setting service oracle_xxy on ubs_2 to manual
[2538 Oct 8 18:50:27] User _rsfadmin setting service oracle_rt on ubs_2 to manual
阅读(1098) | 评论(0) | 转发(0) |