更改tbm 10G undo表空间出现ora-00604 ora-00376 ora-01110错误(二)

启动后运行一阵，显示如下信息，这才是我所做的操作：

Thread 1 cannot allocate new log, sequence 577936
Checkpoint not complete
  Current log# 2 seq# 577935 mem# 0: /oradata/qyp/qyp/redo02.log
Wed Mar 17 16:20:13 2010
alter database datafile '/oradata/qyp/qyp/undotbs1_2.dbf' offline drop
Wed Mar 17 16:20:13 2010
ORA-1516 signalled during: alter database datafile '/oradata/qyp/qyp/undotbs1_2.dbf' offline drop...
Wed Mar 17 16:20:15 2010
Thread 1 advanced to log sequence 577936
  Current log# 3 seq# 577936 mem# 0: /oradata/qyp/qyp/redo03.log
Thread 1 advanced to log sequence 577937
  Current log# 1 seq# 577937 mem# 0: /oradata/qyp/qyp/redo01.log
Wed Mar 17 16:21:06 2010
alter database datafile '/oradata/qyp/qyp/UNDOTBS1_2.dbf' offline drop
Wed Mar 17 16:21:06 2010
ORA-1516 signalled during: alter database datafile '/oradata/qyp/qyp/UNDOTBS1_2.dbf' offline drop...
Wed Mar 17 16:22:02 2010
Thread 1 cannot allocate new log, sequence 577938

     发现项目人员似乎没说实话。有点后悔帮助他来做这个事情。这是和我们公司合作的一个项目，奇怪的是这么大的系统竟然没有专门的DBA，而是给操作系统和数据库都不怎么懂的人员无穷的权限！查看alert发现出现大量信息：

Wed Mar 17 16:24:05 2010
Errors in file /oracle/app/admin/qyp/udump/qyp_ora_8056916.trc:
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/oradata/qyp/qyp/UNDOTBS1_2'
ORA-00372: file 13 cannot be modified at this time
ORA-01110: data file 13: '/oradata/qyp/qyp/UNDOTBS1_2'
Wed Mar 17 16:24:06 2010
ORA-376 signalled during: alter database datafile '/oradata/qyp/qyp/UNDOTBS1_2' offline drop...
Wed Mar 17 16:24:07 2010
Errors in file /oracle/app/admin/qyp/udump/qyp_ora_8056916.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/oradata/qyp/qyp/UNDOTBS1_2'
ORA-00372: file 13 cannot be modified at this time
ORA-01110: data file 13: '/oradata/qyp/qyp/UNDOTBS1_2'
Wed Mar 17 16:25:09 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_pmon_7917972.trc:
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
Wed Mar 17 16:26:40 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_7561550.trc:
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
.........此处有大量上述提示UNDOTBS1_2的信息

Wed Mar 17 16:28:28 2010
Starting background process EMN0
EMN0 started with pid=16, OS id=7991600
Wed Mar 17 16:28:28 2010
Shutting down instance: further logons disabled

ORACLE Instance qyp (pid = 8) - Error 376 encountered while recovering transaction (10, 35).
Wed Mar 17 16:28:30 2010

Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_7561550.trc:
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
Wed Mar 17 16:28:31 2010
Stopping background process MMON
Wed Mar 17 16:28:31 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_7561550.trc:
ORA-00604: Message 604 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
Wed Mar 17 16:28:32 2010
Shutting down instance (immediate)

启动后又出现大量信息：

ALTER DATABASE CLOSE NORMAL
Wed Mar 17 16:29:04 2010
ORA-376 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Mar 17 16:30:10 2010
alter database datafile '/oradata/qyp/qyp/UNDOTBS1_2' offline drop
Wed Mar 17 16:30:10 2010
ORA-376 signalled during: alter database datafile '/oradata/qyp/qyp/UNDOTBS1_2' offline drop...
Wed Mar 17 16:32:35 2010
ERROR: Emon failed to start.
Shutting down instance: further logons disabled
Wed Mar 17 16:32:35 2010
Shutting down instance (immediate)
License high water mark = 26
All dispatchers and shared servers shutdown
Wed Mar 17 16:32:35 2010
ORACLE Instance qyp (pid = 8) - Error 376 encountered while recovering transaction (10, 35).
Wed Mar 17 16:32:35 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_7561550.trc:
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
Wed Mar 17 16:32:35 2010
ALTER DATABASE CLOSE NORMAL
Wed Mar 17 16:32:35 2010
ORA-376 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Mar 17 16:32:36 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_7561550.trc:
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]

    Database Characterset is ZHS16GBK
Wed Mar 17 16:44:16 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_397700.trc:
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
ORA-376 signalled during: ALTER DATABASE OPEN...
Wed Mar 17 16:44:20 2010
Errors in file /oracle/app/admin/qyp/bdump/qyp_smon_397700.trc:
ORA-01595: Message 1595 not found; No message file for product=RDBMS, facility=ORA; arguments: [8] [1]
ORA-00376: Message 376 not found; No message file for product=RDBMS, facility=ORA; arguments: [13]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [13] [/oradata/qyp/qyp/UNDOTBS1_2]
Wed Mar 17 16:44:21 2010
db_recovery_file_dest_size of 2048 MB is 56.02% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
ORA-376 encountered when generating server alert SMG-4120
ORA-376 encountered when generating server alert SMG-4121
ORA-376 encountered when generating server alert SMG-4121
Wed Mar 17 16:45:04 2010
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Wed Mar 17 16:45:04 2010
Starting ORACLE instance (normal)

(未完待续)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7177735/viewspace-676986/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7177735/viewspace-676986/