Oracle 10.2.0.4 , db_block_size = 16K ,
Linux AS 5.3
在学习测试RMAN备份集的时候, 有文章写道:datafile 和controlfile 能在同一个备份集中, 归档日志文件不能和他们是一个备份集 。
1. 查询也发现 datafile和controlfile 的block_size 是oracle block 即 16K , 但是查询v$archived_log发现block_size 是512,
这个就是归档日志不能和数据文件控制文件放在同一个备份集的原因 ?
2. 归档日志文件来自于redo log file , 原来在学习redo log 的时候, redo log file的块大小一般设置为等于os block ,但是通过
Linux系统命令查看os block = 4096 , 并不是 512, Oracle在redo log file 或归档日志的block_size上有哪些方面的考虑 ?
[root@pldfmsqcdb ~]# tune2fs -l /dev/sda8
tune2fs 1.39 (29-May-2006)
Filesystem volume name: /home
Last mounted on:
Filesystem UUID: 8ad5bbe4-e067-45cd-a986-42e1a7bba3a3
Filesystem magic number: 0xEF53
Filesystem revision #: 1 (dynamic)
Filesystem features: has_journal ext_attr resize_inode dir_index filetype needs_recovery
sparse_super large_file
Default mount options: user_xattr acl
Filesystem state: clean
Errors behavior.: Continue
Filesystem OS type: Linux
Inode count: 1048576
Block count: 1048233
Reserved block count: 52411
Free blocks: 996393
Free inodes: 1048457
First block: 0
Block size: 4096
Fragment size: 4096
Reserved GDT blocks: 255
Blocks per group: 32768
Fragments per group: 32768
Inodes per group: 32768
Inode blocks per group: 1024
Filesystem created: Thu Sep 2 04:57:22 2010
Last mount time: Tue Oct 12 11:04:03 2010
Last write time: Tue Oct 12 11:04:03 2010
Mount count: 21
Maximum mount count: -1
Last checked: Thu Sep 2 04:57:22 2010
Check interval: 0 (
Reserved blocks uid: 0 (user root)
Reserved blocks gid: 0 (group root)
First inode: 11
Inode size: 128
Journal inode: 8
Default directory hash: tea
Directory Hash Seed: c945cfc8-8fb8-4def-b96a-c10cdc59d452
Journal backup: inode blocks
[root@pldfmsqcdb ~]#
Linux AS 5.3
在学习测试RMAN备份集的时候, 有文章写道:datafile 和controlfile 能在同一个备份集中, 归档日志文件不能和他们是一个备份集 。
1. 查询也发现 datafile和controlfile 的block_size 是oracle block 即 16K , 但是查询v$archived_log发现block_size 是512,
这个就是归档日志不能和数据文件控制文件放在同一个备份集的原因 ?
2. 归档日志文件来自于redo log file , 原来在学习redo log 的时候, redo log file的块大小一般设置为等于os block ,但是通过
Linux系统命令查看os block = 4096 , 并不是 512, Oracle在redo log file 或归档日志的block_size上有哪些方面的考虑 ?
[root@pldfmsqcdb ~]# tune2fs -l /dev/sda8
tune2fs 1.39 (29-May-2006)
Filesystem volume name: /home
Last mounted on:
Filesystem UUID: 8ad5bbe4-e067-45cd-a986-42e1a7bba3a3
Filesystem magic number: 0xEF53
Filesystem revision #: 1 (dynamic)
Filesystem features: has_journal ext_attr resize_inode dir_index filetype needs_recovery
sparse_super large_file
Default mount options: user_xattr acl
Filesystem state: clean
Errors behavior.: Continue
Filesystem OS type: Linux
Inode count: 1048576
Block count: 1048233
Reserved block count: 52411
Free blocks: 996393
Free inodes: 1048457
First block: 0
Block size: 4096
Fragment size: 4096
Reserved GDT blocks: 255
Blocks per group: 32768
Fragments per group: 32768
Inodes per group: 32768
Inode blocks per group: 1024
Filesystem created: Thu Sep 2 04:57:22 2010
Last mount time: Tue Oct 12 11:04:03 2010
Last write time: Tue Oct 12 11:04:03 2010
Mount count: 21
Maximum mount count: -1
Last checked: Thu Sep 2 04:57:22 2010
Check interval: 0 (
Reserved blocks uid: 0 (user root)
Reserved blocks gid: 0 (group root)
First inode: 11
Inode size: 128
Journal inode: 8
Default directory hash: tea
Directory Hash Seed: c945cfc8-8fb8-4def-b96a-c10cdc59d452
Journal backup: inode blocks
[root@pldfmsqcdb ~]#
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-695144/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-695144/