 Wrong REDO log file location [message #496202] |
Fri, 25 February 2011 04:03  |
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
|
Senior Member |
|
|
hi all,
I try to current redo log file location to multiplex redo log configuration. I did do this on the DB.
I import a backup file to DB when I made this change, but its too slow running import process from old configuration. Approximately it is 4 times slow.
when I recovery old configuration for redo log file, import process is normal running!
Why this changes hit to DB import process performance?
Someone tell me what is wrong I do?
The old redo log file location is below:
GROUP# MEMBER BYTES
4 "/crtest1/oradata/redo04a.log" 524288000
4 "/crtest1/oradata/redo04b.log" 524288000
3 "/crtest1/oradata/redo03a.log" 524288000
3 "/crtest1/oradata/redo03b.log" 524288000
2 "/crtest1/oradata/redo02a.log" 524288000
2 "/crtest1/oradata/redo02b.log" 524288000
1 "/crtest1/oradata/redo01a.log" 524288000
1 "/crtest1/oradata/redo01b.log" 524288000
The new multiplex redo log file location is below:
GROUP# MEMBER BYTES
4 "/crtest1/oradata/redo04a.log" 524288000
4 "/opt/redolog/redo04b.log" 524288000
3 "/opt/redolog/redo03a.log" 524288000
3 "/usr/redolog/redo03b.log" 524288000
2 "/usr/redolog/redo02a.log" 524288000
2 "/disk1/redolog/redo02b.log" 524288000
1 "/disk1/redolog/redo01a.log" 524288000
1 "/crtest1/oradata/redo01b.log" 524288000
I think that new configuration is better for old configuration at security issue.
Here is the disk partitions on the server:
-bash-3.00$ df -lh
Filesystem size used avail capacity Mounted on
/dev/dsk/c0t0d0s0 9.6G 2.2G 7.3G 23% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 6.6G 1.6M 6.5G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
sharefs 0K 0K 0K 0% /etc/dfs/sharetab
/dev/dsk/c0t0d0s6 9.6G 4.1G 5.4G 44% /usr
fd 0K 0K 0K 0% /dev/fd
/dev/dsk/c0t0d0s3 14G 13G 1.7G 88% /var
swap 6.5G 112K 6.5G 1% /tmp
swap 6.5G 88K 6.5G 1% /var/run
/dev/dsk/c1t203200A 100G 60G 20G 70% /crtest1
/dev/dsk/c0t1d0s6 67G 28G 39G 42% /disk1
/dev/dsk/c0t0d0s5 14G 1019M 13G 7% /opt
/dev/dsk/c0t0d0s7 12G 1.9G 9.9G 17% /export/home
/dev/dsk/c0t0d0s1 6.7G 522M 6.2G 8% /usr/openwi
|
|
|
|
| Re: Wrong REDO log file location [message #496208 is a reply to message #496202] |
Fri, 25 February 2011 04:29  |
wkk1020
Messages: 10
Registered: January 2008
Location: Singapore
|
Junior Member |
|
|
Hi there, in this case, maybe the I/O for following file systems
are much slower than the original location (/crtest1): -
- /opt
- /usr
- /disk1
Regards,
Mike Yeap
|
|
|
|
|
|
| Re: Wrong REDO log file location [message #496250 is a reply to message #496208] |
Fri, 25 February 2011 09:30 |
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
|
Senior Member |
|
|
hi Mike Yeap,
/crtest1 location is storage box disk.
/opt, /usr, /disk1 is internal hard disks in the Server.
The Server is connect to storage box via fiber optic cable.
I think that maybe internal hard disk in the Server and storage box hard disk I/O speed is different. it's impact the performance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
