Bo's Oracle Station

查看: 3193|回复: 1

10G 真实环境database库起不来总结

[复制链接]

2

主题

6

帖子

24

积分

新手上路

Rank: 1

积分
24
发表于 2017-5-22 14:13:39 | 显示全部楼层 |阅读模式
1、startup 提示如下错误:
SQL> startup   
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory (电话咨询老唐,LOG_ARCHIVE_DEST_1参数没指定问题导致)


2、alert_oss.log一直提示alter database open  与 shutting down(不知道为啥主备程序会不断自动切换UP database)
Successfully onlined Undo Tablespace 1.
Mon May 22 11:11:34 CST 2017
SMON: enabling tx recovery
Mon May 22 11:11:34 CST 2017
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
Starting background process QMNC
QMNC started with pid=19, OS id=14939
Mon May 22 11:11:38 CST 2017
Completed: ALTER DATABASE OPEN
Mon May 22 11:14:02 CST 2017
Shutting down instance (immediate)
Mon May 22 11:14:02 CST 2017
Shutting down instance: further logons disabled
Mon May 22 11:14:02 CST 2017
Stopping background process QMNC
Mon May 22 11:14:02 CST 2017
Stopping background process CJQ0
Mon May 22 11:14:04 CST 2017
Stopping background process MMNL
Mon May 22 11:14:05 CST 2017
Stopping background process MMON
License high water mark = 5
Mon May 22 11:14:06 CST 2017
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon May 22 11:14:08 CST 2017
ALTER DATABASE CLOSE NORMAL
Mon May 22 11:14:09 CST 2017
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 22 11:14:09 CST 2017
Shutting down archive processes
Archiving is disabled
Mon May 22 11:14:14 CST 2017
ARCH shutting down
ARC1: Archival stopped
Mon May 22 11:14:19 CST 2017
ARCH shutting down
ARC0: Archival stopped
Mon May 22 11:14:20 CST 2017
Thread 1 closed at log sequence 177137
Successful close of redo thread 1
Mon May 22 11:14:21 CST 2017
Completed: ALTER DATABASE CLOSE NORMAL
Mon May 22 11:14:21 CST 2017
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Mon May 22 11:14:23 CST 2017
Instance shutdown complete


解决方案:
1、通过ALERT 日志感觉不对劲,根本没有谁去手动启动数据库,同时检查存储挂载情况,发现数据库文件被挂载到备用服务器。难怪在主服务器启动时会起不来,最后通过重启系统后,数据库正常起来。


总结:
平时要多练习操作,缺乏实战与总结,有空时回去再重听老唐课。

回复

使用道具 举报

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-5-22 17:48:10 | 显示全部楼层
回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-28 22:18 , Processed in 0.136194 second(s), 24 queries .

快速回复 返回顶部 返回列表