|
本帖最后由 jeanron100 于 2013-1-12 10:03 编辑
然后做如下操作
SQL> alter system set log_archive_dest_2='';
System altered.
SQL> alter system set log_archive_dest_3='';
System altered.
SQL> alter system switch logfile;
System altered.
这样 LOG_ARCHIVE_MIN_SUCCEED_DEST =2的情况下,只有目录4是可用的了。
[oracle@oel1 test]$ tree
.
|-- 11_54_798117079.dbf
|-- 11_55_798117079.dbf
|-- 2
| |-- 1_47_798117079.dbf
| |-- 1_48_798117079.dbf
| |-- 1_49_798117079.dbf
| |-- 1_50_798117079.dbf
| |-- 1_51_798117079.dbf
| |-- 1_52_798117079.dbf
| |-- 1_53_798117079.dbf
| `-- 1_54_798117079.dbf
|-- 3
| |-- 1_47_798117079.dbf
| |-- 1_48_798117079.dbf
| |-- 1_49_798117079.dbf
| |-- 1_50_798117079.dbf
| |-- 1_51_798117079.dbf
| |-- 1_52_798117079.dbf
| |-- 1_53_798117079.dbf
| `-- 1_54_798117079.dbf
|-- 4
| |-- 1_47_798117079.dbf
| |-- 1_48_798117079.dbf
| |-- 1_49_798117079.dbf
| |-- 1_50_798117079.dbf
| |-- 1_51_798117079.dbf
| |-- 1_52_798117079.dbf
| |-- 1_53_798117079.dbf
| |-- 1_54_798117079.dbf
| `-- 1_55_798117079.dbf
`-- 5
|-- 1_47_798117079.dbf
|-- 1_48_798117079.dbf
|-- 1_49_798117079.dbf
|-- 1_50_798117079.dbf
|-- 1_51_798117079.dbf
|-- 1_52_798117079.dbf
`-- 1_53_798117079.dbf
4 directories, 34 files
在test下和目录4下都生成了文件,其实你仔细观察一下就能发现
[oracle@oel1 test]$ ll
total 2252
-rw-r----- 1 oracle dba 23040 Jan 12 09:43 11_54_798117079.dbf
-rw-r----- 1 oracle dba 2259968 Jan 12 09:48 11_55_798117079.dbf
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:43 2
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:43 3
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:48 4
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:39 5
生成的归档文件相当大,这应该是你所说的switch hang住的原因,产生了大量的Io.
我用logmnr分析,发现里面产生了7000多条undo sql,
[oracle@oel1 test]$ ll
total 4388
-rw-r----- 1 oracle dba 23040 Jan 12 09:43 11_54_798117079.dbf
-rw-r----- 1 oracle dba 2259968 Jan 12 09:48 11_55_798117079.dbf
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:43 2
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:43 3
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:48 4
drwxr-xr-x 2 oracle dba 4096 Jan 12 09:39 5
-rw-r--r-- 1 oracle dba 2180276 Jan 12 10:00 test.log
语句类似:
insert into "UNKNOWN"."OBJ# 9199"("COL 1","COL 2","COL 3","COL 4","COL 5","COL 6
","COL 7","COL 8","COL 9","COL 10","COL 11","COL 12") values (HEXTORAW('c111'),H
EXTORAW('c5030a603710'),HEXTORAW('c102'),HEXTORAW('78700c0c183817'),HEXTORAW('78
710103130202171126c0'),HEXTORAW('787101031401361a67a4c0'),HEXTORAW('800000003c3c
3da3c34600'),HEXTORAW('c102'),HEXTORAW('c103'),HEXTORAW('80'),HEXTORAW('80'),HEX
TORAW('80'));
insert into "UNKNOWN"."OBJ# 9199"("COL 1","COL 2","COL 3","COL 4","COL 5","COL 6
","COL 7","COL 8","COL 9","COL 10","COL 11","COL 12") values (HEXTORAW('c112'),H
EXTORAW('c5030a603710'),HEXTORAW('c102'),HEXTORAW('78700c0c183817'),HEXTORAW('78
7101031401361a67a4c0'),HEXTORAW('787101031501281ad27480'),HEXTORAW('800000003c3c
3da3c34600'),HEXTORAW('c102'),HEXTORAW('c103'),HEXTORAW('80'),HEXTORAW('80'),HEX
TORAW('80'));
|
|