itspace
- 浏览: 984270 次
- 性别:
- 来自: 杭州
-
文章分类
最新评论
-
孤星119：
好熟悉的数据库字段啊， 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace：
quxiaoyong 写道遇到个问题，网上一搜，全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong：
遇到个问题，网上一搜，全他妈这篇文章。你转来转去的有意思吗？
数据库连接错误ORA-28547 -
hctech：
关于version count过高的问题，不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace：
invalid 写道写的不错，我根据这个来安装，有点理解错误了 ...
AIX 配置vncserver
前面一篇文章，数据库处于归档模式。当设置隐含参数_disable_logging带来的后果是将redolog头损坏，当数据库处于非归档模式时，数据库会怎么样呢？用测试说明问题。由于时间关系，说明暂时省略。
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /ora10/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence 1
Current log sequence 2
SQL> alter system set "_disable_logging"=true scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> conn zhou/zhou
Connected.
SQL> select sid from v$mystat where rownum<2;
SID
----------
50
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 0
redo size 0
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo subscn max counts 0
16 rows selected.
SQL> delete from t;
210612 rows deleted.
SQL> conn zhou/zhou
Connected.
SQL> select sid from v$mystat where rownum<2;
SID
----------
50
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 0
redo size 0
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo subscn max counts 0
16 rows selected.
SQL> insert into t select * from sys.obj$;
52653 rows created.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 3376
redo size 5169132
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 28
16 rows selected.
SQL> rollback;
Rollback complete.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 1
redo synch time 0
redo blocks read for recovery 0
redo entries 5613
redo size 5563936
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 28
16 rows selected.
SQL> alter system set "_disable_logging"=false;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
Fri Jan 7 16:45:08 2011
ALTER DATABASE OPEN
Fri Jan 7 16:45:09 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Fri Jan 7 16:45:10 2011
Started redo scan
Fri Jan 7 16:45:12 2011
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Fri Jan 7 16:45:13 2011
Started redo application at
Thread 1: logseq 9, block 5506
Fri Jan 7 16:45:13 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 9 Reading mem 0
Mem# 0: /oradata/ldbra/redo03.log
Fri Jan 7 16:45:13 2011
Completed redo application
Fri Jan 7 16:45:13 2011
Completed crash recovery at
Thread 1: logseq 9, block 5506, scn 10783758926749
0 data blocks read, 0 data blocks written, 0 redo blocks read
Fri Jan 7 16:45:17 2011
Thread 1 advanced to log sequence 10 (thread open)
Thread 1 opened at log sequence 10
Current log# 1 seq# 10 mem# 0: /oradata/ldbra/redo01.log
Successful open of redo thread 1
Fri Jan 7 16:45:18 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 7 16:45:18 2011
SMON: enabling cache recovery
Fri Jan 7 16:45:30 2011
Successfully onlined Undo Tablespace 1.
Fri Jan 7 16:45:30 2011
SMON: enabling tx recovery
Fri Jan 7 16:45:31 2011
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
Fri Jan 7 16:45:38 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:45:38 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:45:51 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:45:54 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:45:54 2011
Doing block recovery for file 2 block 4408
Block recovery from logseq 10, block 57 to scn 10783758926947
Fri Jan 7 16:45:54 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /oradata/ldbra/redo01.log
Block recovery stopped at EOT rba 10.59.16
Block recovery completed at rba 10.59.16, scn 2510.3391013981
Doing block recovery for file 2 block 137
Block recovery from logseq 10, block 57 to scn 10783758926940
Fri Jan 7 16:45:54 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /oradata/ldbra/redo01.log
Block recovery completed at rba 10.59.16, scn 2510.3391013981
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jan 7 16:46:15 2011
Starting background process QMNC
QMNC started with pid=16, OS id=12650
SQL> shutdown immediate
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [],
[]
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
SQL> startup
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /ora10/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 50
sga_max_size = 327155712
__shared_pool_size = 180355072
shared_pool_size = 33554432
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 8388608
sga_target = 314572800
control_files = /oradata/ldbra/control01.ctl
__db_cache_size = 109051904
compatible = 10.2.0.3.0
log_checkpoint_interval = 10000
_disable_logging = FALSE
db_files = 80
db_file_multiblock_read_count= 2
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
global_names = TRUE
parallel_max_servers = 5
max_dump_file_size = UNLIMITED
sort_area_size = 49152
db_name = ldbra
pga_aggregate_target = 10485760
workarea_size_policy = MANUAL
_ash_enable = TRUE
PMON started with pid=2, OS id=19779
PSP0 started with pid=3, OS id=19781
MMAN started with pid=4, OS id=19783
DBW0 started with pid=5, OS id=19785
LGWR started with pid=6, OS id=19787
CKPT started with pid=7, OS id=19789
SMON started with pid=8, OS id=19791
RECO started with pid=9, OS id=19793
MMON started with pid=10, OS id=19797
MMNL started with pid=11, OS id=19799
Fri Jan 7 16:56:23 2011
ALTER DATABASE MOUNT
Fri Jan 7 16:56:28 2011
Setting recovery target incarnation to 3
Fri Jan 7 16:56:28 2011
Successful mount of redo thread 1, with mount id 1525474551
Fri Jan 7 16:56:28 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jan 7 16:56:28 2011
ALTER DATABASE OPEN
Fri Jan 7 16:56:29 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Fri Jan 7 16:56:30 2011
Started redo scan
Fri Jan 7 16:56:30 2011
Completed redo scan
14 redo blocks read, 13 data blocks need recovery
Fri Jan 7 16:56:30 2011
Started redo application at
Thread 1: logseq 10, block 136
Fri Jan 7 16:56:30 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /oradata/ldbra/redo01.log
Fri Jan 7 16:56:30 2011
Completed redo application
Fri Jan 7 16:56:31 2011
Completed crash recovery at
Thread 1: logseq 10, block 150, scn 10783758947090
13 data blocks read, 13 data blocks written, 14 redo blocks read
Fri Jan 7 16:56:31 2011
Thread 1 advanced to log sequence 11 (thread open)
Thread 1 opened at log sequence 11
Current log# 2 seq# 11 mem# 0: /oradata/ldbra/redo02.log
Successful open of redo thread 1
Fri Jan 7 16:56:31 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 7 16:56:31 2011
SMON: enabling cache recovery
Fri Jan 7 16:56:34 2011
Successfully onlined Undo Tablespace 1.
Fri Jan 7 16:56:34 2011
SMON: enabling tx recovery
Fri Jan 7 16:56:34 2011
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jan 7 16:56:39 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:56:39 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Fri Jan 7 16:56:42 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Fri Jan 7 16:56:43 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Doing block recovery for file 2 block 4974
Block recovery from logseq 11, block 70 to scn 10783758947919
Fri Jan 7 16:56:43 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery stopped at EOT rba 11.72.16
Block recovery completed at rba 11.72.16, scn 2510.3391034957
Doing block recovery for file 2 block 57
Block recovery from logseq 11, block 62 to scn 10783758947916
Fri Jan 7 16:56:43 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.72.16, scn 2510.3391034957
Error 600 occured during Bufq Startup Notifier
Fri Jan 7 16:56:43 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Starting background process QMNC
QMNC started with pid=16, OS id=20081
Fri Jan 7 16:57:06 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:09 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:09 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:10 2011
Completed: ALTER DATABASE OPEN
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:57:12 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:15 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:57:15 2011
Doing block recovery for file 2 block 4408
Block recovery from logseq 11, block 80 to scn 10783758947939
Fri Jan 7 16:57:15 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery stopped at EOT rba 11.82.16
Block recovery completed at rba 11.82.16, scn 2510.3391034978
Doing block recovery for file 2 block 137
Block recovery from logseq 11, block 62 to scn 10783758947937
Fri Jan 7 16:57:15 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.82.16, scn 2510.3391034978
ORA-600 encountered when generating server alert SMG-4120
Fri Jan 7 16:57:15 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00600: internal error code, arguments: [ktcpoptx_0], [0x072B975D8], [0x072BB1D18], [0], [], [], [], []
Fri Jan 7 16:57:17 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:57:17 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Fri Jan 7 16:57:17 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:19 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:19 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:20 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Doing block recovery for file 2 block 4974
Block recovery from logseq 11, block 70 to scn 10783758947919
Fri Jan 7 16:57:20 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.72.16, scn 2510.3391034960
Doing block recovery for file 2 block 57
Block recovery from logseq 11, block 62 to scn 10783758947940
Fri Jan 7 16:57:20 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.84.16, scn 2510.3391034981
Fri Jan 7 16:57:21 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:21 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:23 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:26 2011
Starting background process CJQ0
CJQ0 started with pid=20, OS id=20709
Fri Jan 7 16:57:28 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:29 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:29 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:31 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:31 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
SQL> alter system set UNDO_MANAGEMENT=Manual scope=spfile;
System altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL> Create rollback segment r01 ;
Rollback segment created.
SQL> Alter rollback segment r01 online ;
Rollback segment altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/ldbra/system01.dbf
/oradata/ldbra/undotbs01.dbf
/oradata/ldbra/sysaux01.dbf
/oradata/ldbra/users01.dbf
/oradata/ldbra/example01.dbf
/oradata/ldbra/streams01.dbf
/oradata/ldbra/company01.dbf
/oradata/ldbra/STRM_TBS.DBF
/oradata/ldbra/streams_01.dbf
/oradata/ldbra/users02.dbf
10 rows selected.
SQL> Create undo tablespace undotbs_new datafile '/oradata/ldbra/undonew01.dbf' size 50m;
Tablespace created.
SQL> Drop tablespace undotbs including contents and datafiles;
Drop tablespace undotbs including contents and datafiles
*
ERROR at line 1:
ORA-00959: tablespace 'UNDOTBS' does not exist
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
STREAMS
COMPANY
STRM_TBS
TEMP11
UNDOTBS_NEW
11 rows selected.
SQL> Drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
SQL> Shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Startup nomount ;
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
SQL> Alter system set undo_tablespace=undotbs_new scope=spfile;
System altered.
SQL> alter system set UNDO_MANAGEMENT=auto scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
QMNC started with pid=13, OS id=9678
Fri Jan 7 17:07:48 2011
Completed: ALTER DATABASE OPEN
Fri Jan 7 17:07:48 2011
Starting background process CJQ0
CJQ0 started with pid=14, OS id=9684
SQL> conn zhou/zhou
Connected.
SQL> select count(*) from t;
COUNT(*)
----------
657
SQL> conn zhou/zhou
Connected.
SQL> select sid from v$mystat where rownum<2;
SID
----------
50
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 0
redo size 0
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo subscn max counts 0
16 rows selected.
SQL> insert into t select * from sys.obj$;
52653 rows created.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 2853
redo size 5135160
redo buffer allocation retries 2
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 163
16 rows selected.
SQL> rollback
2 ;
Rollback complete.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 1
redo synch time 1
redo blocks read for recovery 0
redo entries 5050
redo size 5526868
redo buffer allocation retries 2
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 176
16 rows selected.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /ora10/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence 1
Current log sequence 2
SQL> alter system set "_disable_logging"=true scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> conn zhou/zhou
Connected.
SQL> select sid from v$mystat where rownum<2;
SID
----------
50
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 0
redo size 0
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo subscn max counts 0
16 rows selected.
SQL> delete from t;
210612 rows deleted.
SQL> conn zhou/zhou
Connected.
SQL> select sid from v$mystat where rownum<2;
SID
----------
50
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 0
redo size 0
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo subscn max counts 0
16 rows selected.
SQL> insert into t select * from sys.obj$;
52653 rows created.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 3376
redo size 5169132
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 28
16 rows selected.
SQL> rollback;
Rollback complete.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 1
redo synch time 0
redo blocks read for recovery 0
redo entries 5613
redo size 5563936
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 28
16 rows selected.
SQL> alter system set "_disable_logging"=false;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
Fri Jan 7 16:45:08 2011
ALTER DATABASE OPEN
Fri Jan 7 16:45:09 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Fri Jan 7 16:45:10 2011
Started redo scan
Fri Jan 7 16:45:12 2011
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Fri Jan 7 16:45:13 2011
Started redo application at
Thread 1: logseq 9, block 5506
Fri Jan 7 16:45:13 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 9 Reading mem 0
Mem# 0: /oradata/ldbra/redo03.log
Fri Jan 7 16:45:13 2011
Completed redo application
Fri Jan 7 16:45:13 2011
Completed crash recovery at
Thread 1: logseq 9, block 5506, scn 10783758926749
0 data blocks read, 0 data blocks written, 0 redo blocks read
Fri Jan 7 16:45:17 2011
Thread 1 advanced to log sequence 10 (thread open)
Thread 1 opened at log sequence 10
Current log# 1 seq# 10 mem# 0: /oradata/ldbra/redo01.log
Successful open of redo thread 1
Fri Jan 7 16:45:18 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 7 16:45:18 2011
SMON: enabling cache recovery
Fri Jan 7 16:45:30 2011
Successfully onlined Undo Tablespace 1.
Fri Jan 7 16:45:30 2011
SMON: enabling tx recovery
Fri Jan 7 16:45:31 2011
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
Fri Jan 7 16:45:38 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:45:38 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:45:51 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:45:54 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_12026.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:45:54 2011
Doing block recovery for file 2 block 4408
Block recovery from logseq 10, block 57 to scn 10783758926947
Fri Jan 7 16:45:54 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /oradata/ldbra/redo01.log
Block recovery stopped at EOT rba 10.59.16
Block recovery completed at rba 10.59.16, scn 2510.3391013981
Doing block recovery for file 2 block 137
Block recovery from logseq 10, block 57 to scn 10783758926940
Fri Jan 7 16:45:54 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /oradata/ldbra/redo01.log
Block recovery completed at rba 10.59.16, scn 2510.3391013981
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jan 7 16:46:15 2011
Starting background process QMNC
QMNC started with pid=16, OS id=12650
SQL> shutdown immediate
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [],
[]
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
SQL> startup
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /ora10/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 50
sga_max_size = 327155712
__shared_pool_size = 180355072
shared_pool_size = 33554432
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 8388608
sga_target = 314572800
control_files = /oradata/ldbra/control01.ctl
__db_cache_size = 109051904
compatible = 10.2.0.3.0
log_checkpoint_interval = 10000
_disable_logging = FALSE
db_files = 80
db_file_multiblock_read_count= 2
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
global_names = TRUE
parallel_max_servers = 5
max_dump_file_size = UNLIMITED
sort_area_size = 49152
db_name = ldbra
pga_aggregate_target = 10485760
workarea_size_policy = MANUAL
_ash_enable = TRUE
PMON started with pid=2, OS id=19779
PSP0 started with pid=3, OS id=19781
MMAN started with pid=4, OS id=19783
DBW0 started with pid=5, OS id=19785
LGWR started with pid=6, OS id=19787
CKPT started with pid=7, OS id=19789
SMON started with pid=8, OS id=19791
RECO started with pid=9, OS id=19793
MMON started with pid=10, OS id=19797
MMNL started with pid=11, OS id=19799
Fri Jan 7 16:56:23 2011
ALTER DATABASE MOUNT
Fri Jan 7 16:56:28 2011
Setting recovery target incarnation to 3
Fri Jan 7 16:56:28 2011
Successful mount of redo thread 1, with mount id 1525474551
Fri Jan 7 16:56:28 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jan 7 16:56:28 2011
ALTER DATABASE OPEN
Fri Jan 7 16:56:29 2011
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Fri Jan 7 16:56:30 2011
Started redo scan
Fri Jan 7 16:56:30 2011
Completed redo scan
14 redo blocks read, 13 data blocks need recovery
Fri Jan 7 16:56:30 2011
Started redo application at
Thread 1: logseq 10, block 136
Fri Jan 7 16:56:30 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0
Mem# 0: /oradata/ldbra/redo01.log
Fri Jan 7 16:56:30 2011
Completed redo application
Fri Jan 7 16:56:31 2011
Completed crash recovery at
Thread 1: logseq 10, block 150, scn 10783758947090
13 data blocks read, 13 data blocks written, 14 redo blocks read
Fri Jan 7 16:56:31 2011
Thread 1 advanced to log sequence 11 (thread open)
Thread 1 opened at log sequence 11
Current log# 2 seq# 11 mem# 0: /oradata/ldbra/redo02.log
Successful open of redo thread 1
Fri Jan 7 16:56:31 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 7 16:56:31 2011
SMON: enabling cache recovery
Fri Jan 7 16:56:34 2011
Successfully onlined Undo Tablespace 1.
Fri Jan 7 16:56:34 2011
SMON: enabling tx recovery
Fri Jan 7 16:56:34 2011
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Jan 7 16:56:39 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:56:39 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Fri Jan 7 16:56:42 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Fri Jan 7 16:56:43 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Doing block recovery for file 2 block 4974
Block recovery from logseq 11, block 70 to scn 10783758947919
Fri Jan 7 16:56:43 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery stopped at EOT rba 11.72.16
Block recovery completed at rba 11.72.16, scn 2510.3391034957
Doing block recovery for file 2 block 57
Block recovery from logseq 11, block 62 to scn 10783758947916
Fri Jan 7 16:56:43 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.72.16, scn 2510.3391034957
Error 600 occured during Bufq Startup Notifier
Fri Jan 7 16:56:43 2011
Errors in file /ora10/admin/ldbra/udump/ldbra_ora_19842.trc:
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Starting background process QMNC
QMNC started with pid=16, OS id=20081
Fri Jan 7 16:57:06 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:09 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:09 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:10 2011
Completed: ALTER DATABASE OPEN
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:57:11 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:57:12 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:15 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [9], [12], [], [], [], [], []
Fri Jan 7 16:57:15 2011
Doing block recovery for file 2 block 4408
Block recovery from logseq 11, block 80 to scn 10783758947939
Fri Jan 7 16:57:15 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery stopped at EOT rba 11.82.16
Block recovery completed at rba 11.82.16, scn 2510.3391034978
Doing block recovery for file 2 block 137
Block recovery from logseq 11, block 62 to scn 10783758947937
Fri Jan 7 16:57:15 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.82.16, scn 2510.3391034978
ORA-600 encountered when generating server alert SMG-4120
Fri Jan 7 16:57:15 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00600: internal error code, arguments: [ktcpoptx_0], [0x072B975D8], [0x072BB1D18], [0], [], [], [], []
Fri Jan 7 16:57:17 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
Fri Jan 7 16:57:17 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Fri Jan 7 16:57:17 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:19 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:19 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:20 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_mmon_19797.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2 change 10783758906748 time 01/07/2011 16:41:51
ORA-00334: archived log: '/oradata/ldbra/redo03.log'
ORA-00600: internal error code, arguments: [4194], [29], [28], [], [], [], [], []
Doing block recovery for file 2 block 4974
Block recovery from logseq 11, block 70 to scn 10783758947919
Fri Jan 7 16:57:20 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.72.16, scn 2510.3391034960
Doing block recovery for file 2 block 57
Block recovery from logseq 11, block 62 to scn 10783758947940
Fri Jan 7 16:57:20 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0: /oradata/ldbra/redo02.log
Block recovery completed at rba 11.84.16, scn 2510.3391034981
Fri Jan 7 16:57:21 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:21 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:23 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:26 2011
Starting background process CJQ0
CJQ0 started with pid=20, OS id=20709
Fri Jan 7 16:57:28 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:29 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:29 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:31 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
Fri Jan 7 16:57:31 2011
Errors in file /ora10/admin/ldbra/bdump/ldbra_q001_20216.trc:
ORA-00600: internal error code, arguments: [kwqbgqc: bad state], [1], [1], [], [], [], [], []
SQL> alter system set UNDO_MANAGEMENT=Manual scope=spfile;
System altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL> Create rollback segment r01 ;
Rollback segment created.
SQL> Alter rollback segment r01 online ;
Rollback segment altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/ldbra/system01.dbf
/oradata/ldbra/undotbs01.dbf
/oradata/ldbra/sysaux01.dbf
/oradata/ldbra/users01.dbf
/oradata/ldbra/example01.dbf
/oradata/ldbra/streams01.dbf
/oradata/ldbra/company01.dbf
/oradata/ldbra/STRM_TBS.DBF
/oradata/ldbra/streams_01.dbf
/oradata/ldbra/users02.dbf
10 rows selected.
SQL> Create undo tablespace undotbs_new datafile '/oradata/ldbra/undonew01.dbf' size 50m;
Tablespace created.
SQL> Drop tablespace undotbs including contents and datafiles;
Drop tablespace undotbs including contents and datafiles
*
ERROR at line 1:
ORA-00959: tablespace 'UNDOTBS' does not exist
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE
STREAMS
COMPANY
STRM_TBS
TEMP11
UNDOTBS_NEW
11 rows selected.
SQL> Drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
SQL> Shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Startup nomount ;
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
SQL> Alter system set undo_tablespace=undotbs_new scope=spfile;
System altered.
SQL> alter system set UNDO_MANAGEMENT=auto scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2083752 bytes
Variable Size 209716312 bytes
Database Buffers 109051904 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
QMNC started with pid=13, OS id=9678
Fri Jan 7 17:07:48 2011
Completed: ALTER DATABASE OPEN
Fri Jan 7 17:07:48 2011
Starting background process CJQ0
CJQ0 started with pid=14, OS id=9684
SQL> conn zhou/zhou
Connected.
SQL> select count(*) from t;
COUNT(*)
----------
657
SQL> conn zhou/zhou
Connected.
SQL> select sid from v$mystat where rownum<2;
SID
----------
50
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 0
redo size 0
redo buffer allocation retries 0
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo subscn max counts 0
16 rows selected.
SQL> insert into t select * from sys.obj$;
52653 rows created.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 0
redo synch time 0
redo blocks read for recovery 0
redo entries 2853
redo size 5135160
redo buffer allocation retries 2
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 163
16 rows selected.
SQL> rollback
2 ;
Rollback complete.
SQL> select t2.name,t1.value
2 from v$sesstat t1,v$statname t2
3 where t1.statistic#=t2.statistic# and t2.name like '%redo%' and t1.sid=50;
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 1
redo synch time 1
redo blocks read for recovery 0
redo entries 5050
redo size 5526868
redo buffer allocation retries 2
redo wastage 0
redo writer latching time 0
redo writes 0
redo blocks written 0
redo write time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 28
redo subscn max counts 176
16 rows selected.
分享到：
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 591BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 499Oracle管理云服务（OMC）的大数据平台，自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 5432019年7月22日，受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 836某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1481性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 531从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 2152数据库的启动是一个相当复杂的过程。比如，Oracle在启动之前 ... -
怎么样彻底删除数据库？
2018-09-18 11:10 616Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 876LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1245“一朝被蛇咬，十年怕井绳”。在没被“蛇”咬之前，很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1143在DTCC 2018发表《如何落地智能化运维》演讲，主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 589问题一：ping不通问题 在虚拟机上安装好linux系统后， ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 976即日起，不定期更新《OracleDBA实战攻略》一书电子版，请 ... -
Oracle 12c新特性
2018-05-11 10:33 911查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3994操作系统：RHEL6.5 数据库版本：11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 70911g rac安装在二节点跑脚本一般会报此错误： 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 810故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2682由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1783数据库中的log file sync等待事件指的是，当user ...
相关推荐
从Oracle的系统表中，我们知道Oracle存在一个隐含参数_disable_logging可以用于禁用日志生成，这个参数显然只能用于测试目的（可以极大提高Benchmark测试的性能），禁止日志生成必然导致事务的不可恢复性,而且会导致...
标题 "ulps_enable_disable.zip" 暗示了这是一个与启用或禁用ULPS相关的软件配置包。ULPS，全称Ultra Low Power State（超低功耗状态），是计算机硬件，特别是显卡中的一种节能技术。它允许设备在不活动时进入一种极...
WIN10R触摸屏驱动程序_1,JONES_Disable_Suspend,其中一个软件
### 如何关闭QC3.0 #### 背景与概述 QC3.0（Quick Charge 3.0）是高通公司推出的一种快速充电技术，旨在为移动设备提供更加快速、高效的充电体验。然而，在某些情况下，用户或制造商可能需要禁用这一功能，比如在...
标题“extrapoint_01_programma_heading1qr_andisable_elevator_disable_pe”暗示这是一个关于为残障人士设计电梯控制程序的大学项目。这个项目可能涉及到编程、无障碍设施设计以及电子工程领域，尤其是针对特殊群体...
标题中的"从ByteCTF到bypass_disable_function1"指的是在网络安全竞赛ByteCTF中涉及到的一个技术挑战，即如何绕过`disable_function`的安全限制。`disable_function`是PHP配置中的一个选项，用于禁用某些可能带来...
标题 "a_click_disable_verity_and_root.zip" 暗示了这个压缩包包含了一个用于禁用Android设备的verity功能和实现root权限的工具。在Android系统中，verity是一种安全特性，它验证系统分区的完整性，防止未经签名的...
标题中的“HwDetect_Disable 设备”指的是一个与硬件检测相关的程序，可能是用来禁用或管理计算机设备的工具，特别是针对USB设备。HwDetect.exe很可能是这个工具的执行文件，用户可以通过运行这个文件来操作设备的...
针对UE4的右键黑屏问题，我们有两个注册表文件：`mpo_disable.reg` 和 `mpo_restore.reg`。这两个文件用于修改或恢复特定的注册表项，以解决该问题。 `mpo_disable.reg` 文件通常包含了禁用可能导致黑屏的特定...
蚁剑的能绕过disable_functions的插件,插件无法下载问题
在Windows编程中，通常使用属性页控件（Property Sheet）来实现这一功能，而`disable_tab`则可能指的是禁用特定属性页的功能。`Tabú`在这里可能是指一个特殊的限制或特性，不过由于没有明确的上下文，我们主要从...
接口方面，EC20 R2.1配备了USB 2.0高速接口、数字语音接口（可选）、1.8V/3.0V (U)SIM接口、UART接口，以及各种控制和指示信号，如DTR（睡眠控制）、W_DISABLE#（飞行模式控制）、LED_WWAN#（网络状态指示）、PERST#...
Tensorflow和PyTorch实现视觉惯性里程计的无监督深度完成（RA-L2020年1月和ICRA2020）_Py.zip
PowerBuilder Global Function which sets datawindow fields as disabled (sets Tabs and appearance/greyout)
6. 重启并测试 完成上述步骤后，重启电脑，查看是否解决了黑屏问题。如果问题仍然存在，可能需要进一步排查其他可能的原因，例如硬件故障或操作系统其他方面的问题。 总的来说，解决由ULPS引起的Windows 10开机黑屏...
针对宝塔的RASP及其disable_functions的绕过 RASP（Runtime Application Self-Protection）是一种 Runtime 应用程序自我保护技术，旨在保护应用程序免受攻击和恶意活动的影响。在宝塔平台上，RASP 技术可以拦截基于...
该模块用于在Odoo环境中，指定Selection字段可选择的值。
opengl 代码#include #define GLUT_DISABLE_ATEXIT_HACK #ifdef __APPLE__ #include #else #include #endif #include #include <math.h>
FANUC机器人Config配置中各项参数的功能描述及设定 FANUC机器人Config配置中各项参数的功能描述及设定是机器人控制系统中的一个重要组件，负责配置机器人的各种参数，以便于机器人的正常运行。下面是FANUC机器人...