You need to be sure Oracle reads where your dd owerwrote its data. While Oracle doesn't read, it won't crash. Even if it reads, it depends on what have been recovered. You might just have errors in alert.log file telling you you have corrupted blocks, but the databse may not crash. The more efficient would be to make sure dd writes over the system tablespace. Regards, On Thu, 01 May 2003 12:02:20 -0700, Steven Dake <sdake@mvista.com> told us : > you could try kill -9 ? :) > > HERUR,CHANNABASAPPA (HP-India,ex2) wrote: > > >Hi , > > I am basically trying to crash the oracle database which has been > >created using raw logical volumes . When I use 'dd' command to crash the > >oracle database I find that the database is actually not crashing . > > > > I used the following steps to create Oracle database on raw logical > >volumes . > > > > > >1. Created Physical Volumes's using pvcreate command > ># pvcreate /dev/sdp > >pvcreate -- physical volume "/dev/sdp" successfully created > > > ># pvcreate /dev/sdq > >pvcreate -- physical volume "/dev/sdq" successfully created > > > >2. Created Volume Groups's > ># vgcreate vg06 /dev/sdp > >vgcreate -- INFO: using default physical extent size 4.00 MB > >vgcreate -- INFO: maximum logical volume size is 255.99 Gigabyte > >vgcreate -- doing automatic backup of volume group "vg06" > >vgcreate -- volume group "vg06" successfully created and activated > > > ># vgcreate vg07 /dev/sdq > >vgcreate -- INFO: using default physical extent size 4.00 MB > >vgcreate -- INFO: maximum logical volume size is 255.99 Gigabyte > >vgcreate -- doing automatic backup of volume group "vg07" > >vgcreate -- volume group "vg07" successfully created and activated > > > >3. Created Logical Volume's > > > ># lvcreate -l 25 -n control01.ctl /dev/vg06 > >lvcreate -- doing automatic backup of "vg06" > >lvcreate -- logical volume "/dev/vg06/control01.ctl" successfully created > > > ># lvcreate -l 25 -n control02.ctl /dev/vg06 > >lvcreate -- doing automatic backup of "vg06" > >lvcreate -- logical volume "/dev/vg06/control02.ctl" successfully created > > > ># lvcreate -l 100 -n system01.dbf /dev/vg06 > >lvcreate -- doing automatic backup of "vg06" > >lvcreate -- logical volume "/dev/vg06/system01.dbf" successfully created > > > ># lvcreate -l 100 -n log01.log /dev/vg07 > >lvcreate -- doing automatic backup of "vg07" > >lvcreate -- logical volume "/dev/vg07/log01.log" successfully created > > > ># lvcreate -l 100 -n log02.log /dev/vg07 > >lvcreate -- doing automatic backup of "vg07" > >lvcreate -- logical volume "/dev/vg07/log02.log" successfully created > > > >4. Removed the existing raw devices > > > >[root@LNXSRVZ /dev]# rm /dev/raw/raw41 > >rm: remove `/dev/raw/raw41'? y > >[root@LNXSRVZ /dev]# rm /dev/raw/raw42 > >rm: remove `/dev/raw/raw42'? y > >[root@LNXSRVZ /dev]# rm /dev/raw/raw43 > >rm: remove `/dev/raw/raw43'? y > >[root@LNXSRVZ /dev]# rm /dev/raw/raw44 > >rm: remove `/dev/raw/raw44'? y > >[root@LNXSRVZ /dev]# rm /dev/raw/raw45 > >rm: remove `/dev/raw/raw45'? y > > > >5.Recreate raw devices using 'mknod' command > > > ># mknod /dev/vg06/rsystem01.dbf c 162 41 > ># mknod /dev/vg06/rcontrol01.ctl c 162 42 > ># mknod /dev/vg06/rcontrol02.ctl c 162 43 > ># mknod /dev/vg07/rlog01.log c 162 44 > ># mknod /dev/vg07/rlog02.log c 162 45 > > > > > >6. Used 'raw' command to bind raw device to block device > > > ># raw /dev/vg06/rsystem01.dbf /dev/vg06/system01.dbf > >/dev/raw/raw41: bound to major 58, minor 19 > ># raw /dev/vg06/rcontrol01.ctl /dev/vg06/control01.ctl > >/dev/raw/raw42: bound to major 58, minor 17 > ># raw /dev/vg06/rcontrol02.ctl /dev/vg06/control02.ctl > >/dev/raw/raw43: bound to major 58, minor 18 > ># raw /dev/vg07/rlog01.log /dev/vg07/log01.log > >/dev/raw/raw44: bound to major 58, minor 20 > ># raw /dev/vg07/rlog02.log /dev/vg07/log02.log > >/dev/raw/raw45: bound to major 58, minor 21 > > > > > >7. CHANGED THE FILE PERMISSIONS > ># chmod 766 /dev/vg06 > ># chmod 766 /dev/vg06/* > ># chmod 766 -R /dev/vg07 > ># chmod 766 -R /dev/vg07/* > ># chown oracle:oinstall -R /dev/vg07 > > > ># ll /dev/vg06/* > >brwxrw-rw- 1 oracle oinstall 58, 17 Apr 29 14:06 > >/dev/vg06/control01.ctl > >brwxrw-rw- 1 oracle oinstall 58, 18 Apr 29 14:06 > >/dev/vg06/control02.ctl > >crwxrw-rw- 1 oracle oinstall 109, 6 Apr 29 14:05 /dev/vg06/group > >crwxrw-rw- 1 oracle oinstall 162, 42 Apr 29 14:10 > >/dev/vg06/rcontrol01.ctl > >crwxrw-rw- 1 oracle oinstall 162, 43 Apr 29 14:10 > >/dev/vg06/rcontrol02.ctl > >crwxrw-rw- 1 oracle oinstall 162, 41 Apr 29 14:10 > >/dev/vg06/rsystem01.dbf > >brwxrw-rw- 1 oracle oinstall 58, 19 Apr 29 14:06 > >/dev/vg06/system01.dbf > > > ># ll /dev/vg07/* > >crwxrw-rw- 1 oracle oinstall 109, 7 Apr 29 14:05 /dev/vg07/group > >brwxrw-rw- 1 oracle oinstall 58, 20 Apr 29 14:06 /dev/vg07/log01.log > >brwxrw-rw- 1 oracle oinstall 58, 21 Apr 29 14:07 /dev/vg07/log02.log > >crwxrw-rw- 1 oracle oinstall 162, 44 Apr 29 14:10 /dev/vg07/rlog01.log > >crwxrw-rw- 1 oracle oinstall 162, 45 Apr 29 14:10 /dev/vg07/rlog02.log > > > >9. init$ORACLE_SID.ora file had the following contents > > > >db_name = rawlvm1 > > > >db_files = 400 > > > >db_file_multiblock_read_count = 16 > > > >db_block_buffers = 550 > > > >shared_pool_size = 5000000 > > > >log_checkpoint_interval = 10000 > > > >processes = 100 > > > >parallel_max_servers = 8 > > > >log_buffer = 32768 > > > >global_names = TRUE > > > >control_files = (/dev/raw/raw42, /dev/raw/raw43) > > > >db_block_checksum = true > > > >db_block_size = 4096 > > > >background_dump_dest = /u00/app/oracle/admin/hard/rawlvm/bdump > > > >core_dump_dest = /u00/app/oracle/admin/hard/rawlvm/cdump > > > >user_dump_dest = /u00/app/oracle/admin/hard/rawlvm/udump > > > >10. Created oracle database > > > >SQL> startup nomount; > >ORACLE instance started. > > > >Total System Global Area 53178448 bytes > >Fixed Size 450640 bytes > >Variable Size 50331648 bytes > >Database Buffers 2252800 bytes > >Redo Buffers 143360 bytes > >SQL> > >SQL> create database "rawlvm1" > > 2 controlfile reuse > > 3 maxinstances 8 > > 4 maxlogfiles 32 > > 5 datafile > > 6 '/dev/raw/raw41' size 40M reuse > > 7 logfile > > 8 '/dev/raw/raw44' size 20M , > > 9 '/dev/raw/raw45' size 20M ; > > > >Database created. > > > > Please let me know if there is something fundamentally wrong in the > >above steps used for creating Oracle database . After creating the database > >I used the following 'dd' command to crash the database > > > > dd if=/boot/vmlinux-2.4.2-2 of=/dev/sdp > > > > Strangely this command does'nt seem to crash the database . Can > >anybody help me out to crash the Oracle database ? > > > > > > > >_______________________________________________ > >linux-lvm mailing list > >linux-lvm@sistina.com > >http://lists.sistina.com/mailman/listinfo/linux-lvm > >read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/ > > > > > > > > > > > > > _______________________________________________ > linux-lvm mailing list > linux-lvm@sistina.com > http://lists.sistina.com/mailman/listinfo/linux-lvm > read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/ -- Fred Ruffet - fred.ruffet@free.fr "When people say nothing, they don't necessarily mean nothing." _______________________________________________ linux-lvm mailing list linux-lvm@sistina.com http://lists.sistina.com/mailman/listinfo/linux-lvm read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/
