急,数据库无法mount

[复制链接]
查看11 | 回复2 | 2006-4-17 13:46:34 | 显示全部楼层 |阅读模式
数据库原来运行的很好,shutdown abort 重新启动后
一直停留在数据库mount状态,没反应,也没有报什么错误!
(环境为tru64oracle817)
回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层
贴alert
回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层
Current log# 3 seq# 82614 mem# 0: /sybdata/oratest/redo03.log
Thread 1 advanced to log sequence 82615
Current log# 1 seq# 82615 mem# 0: /sybdata/oratest/redo01.log
Thread 1 advanced to log sequence 82616
Current log# 2 seq# 82616 mem# 0: /sybdata/oratest/redo02.log
Thread 1 advanced to log sequence 82617
Current log# 3 seq# 82617 mem# 0: /sybdata/oratest/redo03.log
Sat Oct 18 15:11:50 2003
Thread 1 advanced to log sequence 82618
Current log# 1 seq# 82618 mem# 0: /sybdata/oratest/redo01.log
Mon Oct 20 14:59:14 2003
Shutting down instance (abort)
License high water mark = 37
Instance terminated by USER, pid = 23501
Mon Oct 20 15:09:43 2003
Starting ORACLE instance (normal)
Mon Oct 20 15:09:44 2003
DLM Resources = 64
DLM Locks = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 159934668
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /home/oracle/app/oracle/oradata/test/control01.ctl, /home/oracle/app/oracle/oradata/test/control02.ctl, /home/oracle/app/oracle/oradata/test/control03.ctl
db_block_buffers = 58569
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= test
service_names
= test
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= test
open_cursors
= 300
os_authent_prefix=
background_dump_dest = /home/oracle/app/oracle/admin/test/bdump
user_dump_dest = /home/oracle/app/oracle/admin/test/udump
core_dump_dest = /home/oracle/app/oracle/admin/test/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
Mon Oct 20 15:09:54 2003
alter databasemount
Mon Oct 20 15:15:11 2003
Shutting down instance (abort)
License high water mark = 2
Instance terminated by USER, pid = 2865
Mon Oct 20 15:15:22 2003
Starting ORACLE instance (normal)
Mon Oct 20 15:15:22 2003
DLM Resources = 64
DLM Locks = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 159934668
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /home/oracle/app/oracle/oradata/test/control01.ctl, /home/oracle/app/oracle/oradata/test/control02.ctl, /home/oracle/app/oracle/oradata/test/control03.ctl
db_block_buffers = 58569
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= test
service_names
= test
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= test
open_cursors
= 300
os_authent_prefix=
background_dump_dest = /home/oracle/app/oracle/admin/test/bdump
user_dump_dest = /home/oracle/app/oracle/admin/test/udump
core_dump_dest = /home/oracle/app/oracle/admin/test/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
Mon Oct 20 15:15:26 2003
alter databasemount
Mon Oct 20 15:18:09 2003
Shutting down instance (normal)
License high water mark = 2
Shutting down instance (abort)
License high water mark = 2
Instance terminated by USER, pid = 2927
Mon Oct 20 15:18:47 2003
Starting ORACLE instance (normal)
Mon Oct 20 15:18:47 2003
DLM Resources = 64
DLM Locks = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 159934668
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /home/oracle/app/oracle/oradata/test/control01.ctl, /home/oracle/app/oracle/oradata/test/control02.ctl, /home/oracle/app/oracle/oradata/test/control03.ctl
db_block_buffers = 58569
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= test
service_names
= test
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= test
open_cursors
= 300
os_authent_prefix=
background_dump_dest = /home/oracle/app/oracle/admin/test/bdump
user_dump_dest = /home/oracle/app/oracle/admin/test/udump
core_dump_dest = /home/oracle/app/oracle/admin/test/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
Mon Oct 20 15:19:00 2003
alter database mount
Mon Oct 20 15:33:28 2003
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 3044
Mon Oct 20 15:40:25 2003
Starting ORACLE instance (normal)
Mon Oct 20 15:40:25 2003
DLM Resources = 64
DLM Locks = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 159934668
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /home/oracle/app/oracle/oradata/test/control01.ctl, /home/oracle/app/oracle/oradata/test/control02.ctl, /home/oracle/app/oracle/oradata/test/control03.ctl
db_block_buffers = 58569
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= test
service_names
= test
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= test
open_cursors
= 300
os_authent_prefix=
background_dump_dest = /home/oracle/app/oracle/admin/test/bdump
user_dump_dest = /home/oracle/app/oracle/admin/test/udump
core_dump_dest = /home/oracle/app/oracle/admin/test/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
Mon Oct 20 15:40:35 2003
alter databasemount
Mon Oct 20 16:03:06 2003
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 2855
Mon Oct 20 18:16:37 2003
Starting ORACLE instance (normal)
Mon Oct 20 18:16:37 2003
DLM Resources = 64
DLM Locks = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 159934668
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /home/oracle/app/oracle/oradata/test/control01.ctl, /home/oracle/app/oracle/oradata/test/control02.ctl, /home/oracle/app/oracle/oradata/test/control03.ctl
db_block_buffers = 58569
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= test
service_names
= test
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= test
open_cursors
= 300
os_authent_prefix=
background_dump_dest = /home/oracle/app/oracle/admin/test/bdump
user_dump_dest = /home/oracle/app/oracle/admin/test/udump
core_dump_dest = /home/oracle/app/oracle/admin/test/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
Mon Oct 20 18:16:47 2003
alter databasemount
Tue Oct 21 14:56:57 2003
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 8654
Tue Oct 21 15:09:55 2003
Starting ORACLE instance (normal)
Tue Oct 21 15:09:55 2003
DLM Resources = 64
DLM Locks = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes
= 150
shared_pool_size = 159934668
large_pool_size
= 614400
java_pool_size = 32768
control_files
= /home/oracle/app/oracle/oradata/test/control01.ctl, /home/oracle/app/oracle/oradata/test/control02.ctl, /home/oracle/app/oracle/oradata/test/control03.ctl
db_block_buffers = 58569
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 163840
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
instance_name
= test
service_names
= test
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= test
open_cursors
= 300
os_authent_prefix=
background_dump_dest = /home/oracle/app/oracle/admin/test/bdump
user_dump_dest = /home/oracle/app/oracle/admin/test/udump
core_dump_dest = /home/oracle/app/oracle/admin/test/cdump
PMON started with pid=2
LMON started with pid=3
LMD0 started with pid=4
DBW0 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
Tue Oct 21 15:10:16 2003
alter database mount
会一只停留在这儿,什么反应也没有,也没有提示
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行