- 浏览: 1003181 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (529)
- 服务器 (8)
- jsp (1)
- java (6)
- AIX (1)
- solaris (3)
- linux学习 (53)
- javaScript (2)
- hibernate (1)
- 数据库 (74)
- sql语句 (8)
- oracle 学习 (75)
- oracle 案例 (42)
- oracle 管理 (42)
- Oracle RAC (27)
- oracle data guard (12)
- oracle 参数讲解 (14)
- Oracle 字符集 (8)
- oracle性能调优 (24)
- oracle备份与恢复 (12)
- oracle Tablespace (9)
- oracle性能诊断艺术 (1)
- oracle 11g学习 (5)
- oracle streams (1)
- oracle upgrade and downgrade (4)
- db2学习 (13)
- db2命令学习 (2)
- mysql (28)
- sql server (30)
- sql server 2008 (0)
- 工具 (10)
- 操作系统 (3)
- c++ (1)
- stock (1)
- 生活 (5)
- HADOOP (2)
最新评论
-
massjcy:
...
如何将ubuntu文件夹中文名改为英文 -
skypiea:
谢谢。。。
终于解决了。。。
Oracle 10.2.0.4(5)EM不能启动的解决方案(Patch 8350262) -
qwe_rt:
引用vi /etc/sysconfig/network 请问 ...
Linux操作系统下配置静态IP上网 -
liuqiang:
sudo killall -9 apache2
ps 和 kill 命令详解 -
dazuiba:
引用*绝杀 kill -9 PID 当使用此命令时,一定要通过 ...
ps 和 kill 命令详解
环境:HP-UX , ORACLE 9I
这是电信的一个生产库。需要修改OS的时间。为了安全起见,需要重启DB。
登陆到数据库服务器之后,输入
sql>conn / as sysdba
sql>shutdown immediate
就卡在这里,等了约一个多小时,db都停不下来。
查看oracle log,显示
Thread 1 advanced to log sequence 220616
Current log# 2 seq# 220616 mem# 0: /dev/vgora/rlv_log2
Fri May 30 01:14:43 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 268
Fri May 30 01:19:55 2008
Active call for process 15693 user 'oracle' program 'oracle@BimsDB1 (J000)' -----这个job在运行
SHUTDOWN: waiting for active calls to complete.
Fri May 30 01:20:23 2008
Thread 1 advanced to log sequence 220617
Current log# 3 seq# 220617 mem# 0: /dev/vgora/rlv_log3
查看os top,发现一个进程号为15693的oracle job正在运行。
kill -9 15693
db还是停不下来。查看oracle log,还是和kill job之前一样。
已经折腾一个多小时了,只有使用最后一招:shutdown abort了
sql>conn / as sysdba
sql>shutdown abort
几秒的时间,db就停了下来。
调整了OS的时间之后,正常启动db,一切顺利。
启动时,oracle log
Fri May 30 01:53:38 2008
Shutting down instance (abort)
License high water mark = 268
Instance terminated by USER, pid = 19793
Fri May 30 02:40:08 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Fri May 30 02:40:33 2008
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes = 500
sessions = 555
timed_statistics = TRUE
shared_pool_size = 536870912
sga_max_size = 10739491216
large_pool_size = 117440512
java_pool_size = 117440512
control_files = /dev/vgora/rlv_ctrl1, /dev/vgora/rlv_ctrl2, /dev/vgora/rlv_ctrl3
db_block_size = 8192
db_writer_processes = 2
db_cache_size = 8589934592
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
transactions = 500
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 43200
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = BIMS
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /oracle/admin/BIMS/bdump
user_dump_dest = /oracle/admin/BIMS/udump
core_dump_dest = /oracle/admin/BIMS/cdump
open_links = 8
open_links_per_instance = 8
sort_area_size = 524288
db_name = BIMS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 2147483648
aq_tm_processes = 1
PMON started with pid=2, OS id=20212
DBW0 started with pid=3, OS id=20215
DBW1 started with pid=4, OS id=20218
LGWR started with pid=5, OS id=20220
CKPT started with pid=6, OS id=20224
SMON started with pid=7, OS id=20226
RECO started with pid=8, OS id=20230
CJQ0 started with pid=9, OS id=20232
QMN0 started with pid=10, OS id=20234
Fri May 30 02:40:34 2008
ALTER DATABASE MOUNT
Fri May 30 02:40:38 2008
Successful mount of redo thread 1, with mount id 2048087522
Fri May 30 02:40:38 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri May 30 02:40:38 2008
ALTER DATABASE OPEN
Fri May 30 02:40:39 2008
Beginning crash recovery of 1 threads --------oracle开始自动对REDO LOG进行恢复
Fri May 30 02:40:39 2008
Started redo scan
Fri May 30 02:40:41 2008
Completed redo scan
116710 redo blocks read, 18790 data blocks need recovery ------还好,需要恢复的data blocks不是很多
Fri May 30 02:41:06 2008
Started recovery at
Thread 1: logseq 220617, block 95794, scn 0.0
Fri May 30 02:41:06 2008
Recovery of Online Redo Log: Thread 1 Group 3 Seq 220617 Reading mem 0
Mem# 0 errs 0: /dev/vgora/rlv_log3
Fri May 30 02:41:07 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 220618 Reading mem 0
Mem# 0 errs 0: /dev/vgora/rlv_log1
Fri May 30 02:41:10 2008
Completed redo application
Fri May 30 02:41:11 2008
Ended recovery at
Thread 1: logseq 220618, block 82459, scn 4.938028078
18790 data blocks read, 18790 data blocks written, 116710 redo blocks read
Crash recovery completed successfully ---------完成REDO LOG恢复
Fri May 30 02:41:12 2008
Thread 1 advanced to log sequence 220619
Thread 1 opened at log sequence 220619
Current log# 2 seq# 220619 mem# 0: /dev/vgora/rlv_log2
Successful open of redo thread 1
Fri May 30 02:41:12 2008
SMON: enabling cache recovery
Fri May 30 02:41:12 2008
Successfully onlined Undo Tablespace 1.
Fri May 30 02:41:12 2008
SMON: enabling tx recovery
Fri May 30 02:41:12 2008
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN -------------数据库成功OPEN
Fri May 30 02:44:30 2008
Thread 1 advanced to log sequence 220620
总结:在生产库中,需要关闭oracle数据库的时候,首先使用的应该是shutdown immediate.
(根据相关的帖子介绍,可以先运行alter system archive all,alter system switch logfile ,alter system checkpoint。
不过不知道花费的时间长不长。那天晚上我手忙脚乱,都没有得试这几个命令)
shutdown immediate会对当前正在运行的事务进行回滚,从而保证数据库的安全关闭。
要是在等待了较长时间,shutdown immediate还是无法关闭数据库,可以使用shutdown abort.
因为shutdown abort不会对事务进行回滚,因此可以迅速的关闭oracle。但是,也是因为没有
对事务进行回滚,启动数据库的时候,oracle会自动对REDO LOG进行recover。
为了减少recover的时间,shutdown abort之前,可以先运行alter system archive all,alter system switch logfile ,alter system checkpoint。
PS:这个数据库的redo log设置得较小,大概200M这样。这大概也是这次可以迅速恢复的原因吧。
本贴来自ZDNetChina中文社区 http://bbs.zdnet.com.cn ,本贴地址:http://bbs.zdnet.com.cn/viewthread.php?tid=461527
发表评论
-
sys.dbms_transaction.local_transaction_id出现的问题
2012-07-20 11:54 3304何時會觸發DBMS_TRANSACTION.LOCAL_TRA ... -
ORACLE 11GR2 OEM配置出错解决
2012-07-14 19:21 5086错误描述如下: 2012-7-14 18:23:11 ... -
ORA11G ORA-00845 错误
2012-06-26 13:39 836Oracle 11g的Linux版本在修改了MEMORY_TA ... -
oracle.net.common.NetGetEnv.getDNSDomain
2012-06-07 01:48 1151今天安装LINUX AS 4和ORACLE 10.2,安装成功 ... -
emctl 提示 ora-28001 口令已经实效 解决办法
2011-10-24 00:41 1836What to do when Enterprise Mana ... -
Oracle 10.2.0.4(5)EM不能启动的解决方案(Patch 8350262)
2011-05-20 17:29 6961报错信息如下: 2011-03-09 11:06:10 Th ... -
Oracle HowTo:如何在Linux上扩展SGA超过1.7G
2011-03-24 01:28 923今天一台Linux服务器扩展了一下内存,达到4G,开发的人自己 ... -
error while loading shared libraries: libclntsh.so.10.1: cannot open shared 问题解决
2011-01-21 16:23 120011.运行csscan命令显示如下错误 [oracle@rac ... -
“Error in invoking target ‘client_sharedlib’ of makefile ‘/home/oracle/oracle/pr
2011-01-13 17:35 11903今天同事在安装oracle的时候总是报这个错误: &qu ... -
如何处理Oracle中的坏块[ZT]
2010-12-19 21:56 1224一. 什么是数据库的坏 ... -
bug 7716219 hash group by显示消耗大量的temp 表空间
2010-12-07 17:47 2149SQL> set autotrace traceonly ... -
ORA-08102: TRYING TO MANIPULATE A JOB IN DBA_JOBS [ID 1036858.6]
2010-12-03 23:52 1260***Checked for relevance on 17- ... -
ORA-14074: partition bound must collate higher than that of the last partition
2010-10-09 16:26 36501. 创建分区表 create table zhanglei ... -
ora-12560问题解决
2010-09-16 11:30 15931.监听服务没有起起来 ... -
ORA-20000故障排除手记
2010-09-02 01:43 23501、发现故障。 在Oracle10.2.0.1的aler ... -
ORA-17502 与 ORA-15173 错误解决
2010-05-21 17:27 3952用rman恢复spfile时,报错误如下: RM ... -
Dropping A Disk From ASM Diskgroup Does Not Remove It From v$ASM_DISK
2010-05-21 10:42 1493Applies to: Oracle Serv ... -
ORA-19599 When backing up an archivelog that is corrupt [ID 461239.1]
2010-05-13 13:56 2670Applies to: Oracle Server - E ... -
ASMCMD fails to start on module libnnz10.so, permission denied
2010-05-13 01:14 2532ASMCMD fails to start on modu ... -
Errors ORA-00600 [kclchkblk_4] and ORA-00600 [2662] After Recovery of Datab
2010-05-12 15:45 1732Applies to: Oracle Server - E ...
相关推荐
3、shutdown abort的情况,恢复全部控制文件和数据文件(不包括redo) 4、仅仅丢失一个普通用户数据文件的恢复B(脱机恢复) 5、shutdown abort后,丢失全部文件(除了archive log和init.ora)即,丢失了全部数据文件、...
oracle基础上课记录笔记 3/08 ...关闭数据库: (abort参数是强制关闭) shutdown (normal/transactional/abort) 启动数据库: conn /as sysdba startup (open/mount/read only只读打开) commit提交
1. 正常关闭 SVRMGR>shutdown normal; 这种方式下关闭数据库在关闭前检查所有的连接,并且发出命令后不允许再有...SVRMGR>shutdown abort; 这种方式下关闭数据库系统不做任何的检查与回退操作而直接将数据库现场撤消。
3、shutdown abort 直接关闭数据库 会造成数据库的不一致,再次启动数据库会自动执行恢复,会造成等待时间较长。正 在访问数据库的会话会被突然终止,如果数据库中有大量操作正在执行,这时执行shut down abort后,...
如果用户已经进入了数据库,使用SHUTDOWN IMMEDIATE 或SHUTDOWN ABORT命令来执行关闭数据库,则用户将失去连接,直到数据库重新启动。经常关闭和启动会对数据库性能造成一定的影响,当然也会影响到用户对数据库的...
Oracle数据库startup和shutdown方式
提示:数据库已经关闭 已经卸载数据库 ORACLE 例程已经关闭 SQL>startup mount 提示:ORACLE例程已经启动 Total System Global Area 118255568 bytes Fixed Size 282576 bytes Variable Size 82886080 bytes ...
考试复习内容,例如Oracle启动命令:(1)startup 启动数据库 (2) ①startup nomount 实例启动 ② alter databasenomount ③alter database open关闭数据库:shutdown (等待数据库中未完成时间完成后关闭) immediate...
处理exchange数据库装载不成功 exchange邮箱系统 确保邮箱数据不丢失
oracle连接后,用shutdown immediate关闭数据库,再startup mount,出现“监听程序当前无法识别连接描述符中请求的服务”
shutdown指令可以关闭所有程序,并依用户的需要,进行重新开机或关机的动作。 语法格式:shutdown [选项] [参数] 常用参数: -c 当执行“shutdown -h 11:50”指令时,只要按+键就可以中断关机的指令 -f ...
一、摘要 ...2. Oracle关闭的四种方式:Normal, Immediate, Transactional, Abort 3. 启动和关闭过程详解 二、数据库启动过程 1.NoMount 模式(启动实例不加载数据库) (1). 命令:startup nomo
Oracle数据库startup和shutdown方式[文].pdf
可能因为备库是读业务比较繁忙,在shutdown immediate关闭备库时等时间过长,于是使用了shutdown abort命令; 但后面在启动备库时发生报错,造成数据文件损坏,控制文件和数据文件的scn号不一致。 --启动备库时报错
在oracle数据库中,关于shutdown命令的详解。对于新手很有帮助
在关机,它可以清理回收站,临时文件,IE缓存,ie浏览器的Cookie,IE历史记录,IE自动完成的项目和最近的文档列表,以提高系统的性能,并保护您的隐私。 这个注册机完美注册PC Auto Shutdown V6.3版本
SHUTDOWN-定时开机关机 SHUTDOWN-定时开机关机 SHUTDOWN-定时开机关机 SHUTDOWN-定时开机关机 SHUTDOWN-定时开机关机
ShutDown Expert ShutDown Expert ShutDown Expert
2.shutdown how=SHUT_WR(关闭写端)可以保证对等方接收到一个EOF字符(FIN段),而不管是否有其他进程已经打开了套接字(shutdown并没采用引用计数)。 而close需要等待套接字引用计数减为0时才发送FIN段。也就是说...
shutdown自动关机很好用