ITPub博客

首页 > Linux操作系统 > Linux操作系统 > shutdown abort要慎重

shutdown abort要慎重

原创 Linux操作系统 作者:aaqwsh 时间:2011-05-06 13:36:51 0 删除 编辑

以前一直没有仔细观察shutdown abort后启动数据库会有什么处理过程:
在内存中修改过的、尚未写入数据文件的数据将会丢失。在下一次数据库启动后,oracle可以通过重做(redo)日志进行事物重演(也就是进行前滚),将数据库恢复到崩溃之前的状态,然后数据库可以打开提供使用,之后oracle可以将未提交的事物进行回滚。参考《深入解析oracle》

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              62916852 bytes
Database Buffers          100663296 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> alter session set events 'immediate trace name controlf level 12';

Session altered.

SQL> alter database open
  2  ;

Database altered.

 

 

alter database open
Mon May  2 08:44:35 2011
Beginning crash recovery of 1 threads
Mon May  2 08:44:36 2011
Started redo scan
Mon May  2 08:44:36 2011
Completed redo scan
 95 redo blocks read, 46 data blocks need recovery
Mon May  2 08:44:36 2011
Started redo application at
 Thread 1: logseq 23, block 3
Mon May  2 08:44:36 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 23 Reading mem 0
  Mem# 0 errs 0: /data/ora10g/RACDBSTD/group_1.257.727735489
Mon May  2 08:44:36 2011
Completed redo application
Mon May  2 08:44:36 2011
Completed crash recovery at
 Thread 1: logseq 23, block 98, scn 1098131
 46 data blocks read, 46 data blocks written, 95 redo blocks read
Mon May  2 08:44:36 2011
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=3944
Mon May  2 08:44:37 2011
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
LNS1 started with pid=18, OS id=3948
ARC1 started with pid=17, OS id=3946
Mon May  2 08:44:40 2011
Thread 1 advanced to log sequence 24
Mon May  2 08:44:40 2011
ARC0: STARTING ARCH PROCESSES
Mon May  2 08:44:40 2011
Thread 1 opened at log sequence 24
  Current log# 2 seq# 24 mem# 0: /data/ora10g/RACDBSTD/group_2.258.727735493
Successful open of redo thread 1
Mon May  2 08:44:40 2011
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon May  2 08:44:40 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May  2 08:44:40 2011
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Mon May  2 08:44:41 2011
Successfully onlined Undo Tablespace 1.
Mon May  2 08:44:41 2011
SMON: enabling cache recovery
SMON: enabling tx recovery
ARC2 started with pid=19, OS id=3951
Mon May  2 08:44:41 2011
Database Characterset is ZHS16GBK
Mon May  2 08:44:41 2011
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Error 12560 received logging on to the standby
Mon May  2 08:44:46 2011
Errors in file /data/ora10g/admin/RACDBSTD/bdump/racdbstd_lns1_3948.trc:
ORA-12560: TNS:protocol adapter error
LGWR: Error 12560 creating archivelog file 'RACDB'
LNS: Failed to archive log 2 thread 1 sequence 24 (12560)
Mon May  2 08:44:46 2011
Error 12560 received logging on to the standby
Mon May  2 08:44:46 2011
Errors in file /data/ora10g/admin/RACDBSTD/bdump/racdbstd_arc0_3944.trc:
ORA-12560: TNS:protocol adapter error
FAL[server, ARC0]: Error 12560 creating remote archivelog file 'RACDB'
FAL[server, ARC0]: FAL archive failed, see trace file.
Mon May  2 08:44:46 2011
Errors in file /data/ora10g/admin/RACDBSTD/bdump/racdbstd_arc0_3944.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Mon May  2 08:44:46 2011
ORACLE Instance RACDBSTD - Archival Error. Archiver continuing.
Mon May  2 08:44:46 2011
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=3953
Mon May  2 08:44:48 2011
Completed: alter database open

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

请登录后发表评论 登录
全部评论

注册时间:2010-11-24

  • 博文量
    132
  • 访问量
    265284