Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › Linux › Linux Tech required to assist with setting up backup
camo786

155 posts

Master Geek

Lifetime subscriber

#16151 27-Sep-2007 09:22
Send private message

I need some help from someone who know Linux

To setup backup scripts to stop a database enginer backup to tape and start the database and setup schedule

I dont mind to pay for someones time if they can work with me soo I can learn about it too

Thanks

Camo

Create new topic
camo786

155 posts

Master Geek

Lifetime subscriber

  #88252 27-Sep-2007 09:24
Send private message

Sorry, please excuse my shocking typing skills



frup
12 posts

Geek


  #88309 27-Sep-2007 13:46
Send private message

>> ??? stop a database enginer??? backup to tape and start the database and setup schedule (I don't quite understand this)

If you know how to do this over command line already simply write a bash script with a list of the commands and add it to cron with the appropriate schedule. More information would be helpful, like which database you are using. You are aware that you can restart/stop and start applications often with the command eg for networking /etc/init.d/Networking restart (I'm not at home right now so that might be slightly wrong I don't need to do these kinds of things often).

Why don't you post any commands / ways you are already doing this (or if you don't know how to do any of this yet). Again which database and what kind of tape (I'm guessing you are talking about a modern kind of tape drive) and how large the data/frequently etc you need all this done.

barf
643 posts

Ultimate Geek


  #88310 27-Sep-2007 13:58

where are you located?
I can provide on-site support in Christchurch, PM me your contact details and I can probably help you.

sounds like you just need a shell script or two and some cron jobs?




Sniffing the glue holding the Internet together



camo786

155 posts

Master Geek

Lifetime subscriber

  #88311 27-Sep-2007 14:06
Send private message

Thanks, feedback is appreciated

I have script to stop that database

#!/bin/sh
# file: stop.tpl
# Script to stop database servers.

# tokens:
# &DLC = Progress Directory
# &LOOP-DB-START = start of database loop
# &LOOP-DB-END = end of database loop
# &STOP-SERVER = command line to shutdown current DB in database loop

DLC=/qad/dlc91e;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP

#loop-db-start
  $DLC/bin/_mprshut /dbs/live/mfglive -by
  $DLC/bin/_mprshut /dbs/live/hlplive -by
  $DLC/bin/_mprshut /dbs/live/admlive -by
  $DLC/bin/_mprshut /dbs/live/customlive -by
#loop-db-end

And start

#!/bin/sh
# file: start.tpl
# Script to start database servers.

# tokens:
# &DLC = Progress Directory
# &LOOP-DB-START = start of database loop
# &LOOP-DB-END = end of database loop
# &START-SERVER = command line to start current DB in database loop

DLC=/qad/dlc91e;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP

#loop-db-start
# $DLC/bin/_mprosrv /dbs/live/mfglive -L 8000 -c 350 -B 1000
  $DLC/bin/proserve /dbs/live/mfglive -L 8000 -c 350 -B 10000 -n 100 -N TCP -H eflinux01.emeraldfoods.local -S mfglive-srv
  $DLC/bin/_mprosrv /dbs/live/hlplive -L 8000 -c 350 -B 1000 -n 100
  $DLC/bin/_mprosrv /dbs/live/admlive -L 8000 -c 350 -B 1000 -n 100
  $DLC/bin/_mprosrv /dbs/live/customlive -L 8000 -c 350 -B 1000 -n 100
#loop-db-end

I dont know how to drive tar, to make it backup to SCSI tape drive
or how to schedule it

barf
643 posts

Ultimate Geek


  #88317 27-Sep-2007 14:43

what are the directories you need to backup?
what is the absolute path name to those scripts you have there? (ie /root/backup_scripts/stop.tpl ?)
what is the SCSI tape's device name? (ie, /dev/st0 /dev/ht0 ?)
if you don't know the tape's device name paste /var/log/dmesg here




Sniffing the glue holding the Internet together

camo786

155 posts

Master Geek

Lifetime subscriber

  #88342 27-Sep-2007 16:48
Send private message

from dmesg

Looks like st0


I want to back up everything, tape drive is lto 200Gb compress so have the capacity



 11 000 00  1    0    0   0   0    0    0    00
 12 000 00  1    0    0   0   0    0    0    00
 13 000 00  1    0    0   0   0    0    0    00
 14 000 00  1    0    0   0   0    0    0    00
 15 000 00  1    0    0   0   0    0    0    00
 16 000 00  1    0    0   0   0    0    0    00
 17 00F 0F  1    1    0   1   0    1    1    92
IRQ to pin mappings:
IRQ0 -> 0:2
IRQ1 -> 0:1
IRQ3 -> 0:3
IRQ4 -> 0:4
IRQ5 -> 0:5
IRQ6 -> 0:6
IRQ7 -> 0:7
IRQ8 -> 0:8
IRQ9 -> 0:9
IRQ10 -> 0:10
IRQ11 -> 0:11
IRQ12 -> 0:12
IRQ13 -> 0:13
IRQ14 -> 0:14
IRQ15 -> 0:15
IRQ16 -> 0:16
IRQ17 -> 0:17
IRQ18 -> 0:18
IRQ19 -> 0:19
IRQ23 -> 0:23
IRQ24 -> 1:0
IRQ25 -> 1:1
IRQ26 -> 1:2
IRQ48 -> 2:0
IRQ49 -> 2:1
IRQ50 -> 2:2
IRQ51 -> 2:3
IRQ71 -> 2:23
IRQ72 -> 3:0
IRQ73 -> 3:1
IRQ74 -> 3:2
IRQ75 -> 3:3
IRQ76 -> 3:4
IRQ77 -> 3:5
IRQ78 -> 3:6
IRQ79 -> 3:7
IRQ95 -> 3:23
.................................... done.
Using local APIC timer interrupts.
calibrating APIC timer ...
..... CPU clock speed is 3200.2687 MHz.
..... host bus clock speed is 200.0168 MHz.
cpu: 0, clocks: 2000168, slice: 400033
CPU0<T0:2000160,T1:1600112,D:15,S:400033,C:2000168>
cpu: 1, clocks: 2000168, slice: 400033
cpu: 3, clocks: 2000168, slice: 400033
cpu: 2, clocks: 2000168, slice: 400033
CPU1<T0:2000160,T1:1200080,D:14,S:400033,C:2000168>
CPU2<T0:2000160,T1:800032,D:29,S:400033,C:2000168>
CPU3<T0:2000160,T1:400016,D:12,S:400033,C:2000168>
cpu_sibling_map[0] = 1
cpu_sibling_map[1] = 0
cpu_sibling_map[2] = 3
cpu_sibling_map[3] = 2
mapping CPU#0's runqueue to CPU#1's runqueue.
mapping CPU#2's runqueue to CPU#3's runqueue.
zapping low mappings.
Process timing init...done.
Starting migration thread for cpu 0
Starting migration thread for cpu 1
Starting migration thread for cpu 2
Starting migration thread for cpu 3
mtrr: your CPUs had inconsistent fixed MTRR settings
mtrr: probably your BIOS does not setup all CPUs
PCI: PCI BIOS revision 2.10 entry at 0xf0096, last bus=18
PCI: Using configuration type 1
PCI: Probing PCI hardware
PCI: Ignoring BAR0-3 of IDE controller 00:1f.1
Transparent bridge - Intel Corp. 82801BA/CA/DB/EB PCI Bridge
PCI->APIC IRQ transform: (B0,I2,P0) -> 16
PCI->APIC IRQ transform: (B0,I4,P0) -> 16
PCI->APIC IRQ transform: (B0,I6,P0) -> 16
PCI->APIC IRQ transform: (B0,I29,P0) -> 16
PCI->APIC IRQ transform: (B0,I29,P1) -> 19
PCI->APIC IRQ transform: (B0,I29,P3) -> 23
PCI->APIC IRQ transform: (B9,I2,P0) -> 72
PCI->APIC IRQ transform: (B2,I3,P0) -> 24
PCI->APIC IRQ transform: (B2,I3,P1) -> 25
PCI->APIC IRQ transform: (B1,I2,P0) -> 17
PCI->APIC IRQ transform: (B1,I4,P0) -> 16
PCI: Device 00:00 not found by BIOS
isapnp: Scanning for PnP cards...
isapnp: No Plug & Play device found
Linux NET4.0 for Linux 2.4
Based upon Swansea University Computer Society NET3.039
Initializing RT netlink socket
apm: BIOS not found.
Total HugeTLB memory allocated, 0
Starting kswapd
allocated 32 pages and 32 bhs reserved for the highmem bounces
VFS: Disk quotas vdquot_6.5.1
aio_setup: num_physpages = 290815
aio_setup: sizeof(struct page) = 60
Hugetlbfs mounted.
pty: 2048 Unix98 ptys configured
Serial driver version 5.05c (2001-07-08) with MANY_PORTS MULTIPORT SHARE_IRQ SERIAL_PCI ISAPNP enabled
ttyS0 at 0x03f8 (irq = 4) is a 16550A
Real Time Clock Driver v1.10e
NET4: Frame Diverter 0.46
RAMDISK driver initialized: 256 RAM disks of 8192K size 1024 blocksize
Uniform Multi-Platform E-IDE driver Revision: 7.00beta4-2.4
ide: Assuming 33MHz system bus speed for PIO modes; override with idebus=xx
ICH5: IDE controller at PCI slot 00:1f.1
PCI: Enabling device 00:1f.1 (0005 -> 0007)
ICH5: chipset revision 2
ICH5: not 100% native mode: will probe irqs later
    ide0: BM-DMA at 0x0500-0x0507, BIOS settings: hda:pio, hdb:pio
    ide1: BM-DMA at 0x0508-0x050f, BIOS settings: hdc:DMA, hdd:pio
hdc: SAMSUNG CD-ROM SC-148A, ATAPI CD/DVD-ROM drive
ide1 at 0x170-0x177,0x376 on irq 15
ide-floppy driver 0.99.newide
ide-floppy driver 0.99.newide
md: md driver 0.90.0 MAX_MD_DEVS=256, MD_SB_DISKS=27
md: Autodetecting RAID arrays.
md: autorun ...
md: ... autorun DONE.
pci_hotplug: PCI Hot Plug PCI Core version: 0.5
Initializing Cryptographic API
NET4: Linux TCP/IP 1.0 for NET4.0
IP: routing cache hash table of 65536 buckets, 512Kbytes
TCP: Hash tables configured (established 524288 bind 65536)
Linux IP multicast router 0.06 plus PIM-SM
Initializing IPsec netlink socket
NET4: Unix domain sockets 1.0/SMP for Linux NET4.0.
RAMDISK: Compressed image found at block 0
Freeing initrd memory: 580k freed
VFS: Mounted root (ext2 filesystem).
SCSI subsystem driver Revision: 1.00
Fusion MPT base driver 2.06.16.01
Copyright (c) 1999-2005 LSI Logic
mptbase: Initiating ioc0 bringup
ioc0: 53C1030: Capabilities={Initiator,Target}
mptbase: Initiating ioc1 bringup
ioc1: 53C1030: Capabilities={Initiator,Target}
mptbase: 2 MPT adapters found, 2 installed.
Fusion MPT SCSI Host driver 2.06.16.01
scsi0 : ioc0: LSI53C1030, FwRev=01032700h, Ports=1, MaxQ=203, IRQ=24
scsi1 : ioc1: LSI53C1030, FwRev=01032700h, Ports=1, MaxQ=203, IRQ=25
blk: queue c8548018, I/O limit 4294967295Mb (mask 0xffffffffffffffff)
  Vendor: HP        Model: Ultrium 2-SCSI    Rev: S22D
  Type:   Sequential-Access                  ANSI SCSI revision: 03
blk: queue c8548218, I/O limit 4294967295Mb (mask 0xffffffffffffffff)
HP CISS Driver (v 2.4.58.RH1)
cciss: Device 0x46 has been found at bus 9 dev 2 func 0
      blocks= 142245120 block_size= 512
      heads= 255, sectors= 32, cylinders= 17432 RAID 1(0+1)

      blocks= 142253280 block_size= 512
      heads= 255, sectors= 32, cylinders= 17433 RAID 1(0+1)

blk: queue c0502020, I/O limit 4294967295Mb (mask 0xffffffffffffffff)
Partition check:
 cciss/c0d0: p1 p2
 cciss/c0d1: p1
LVM version 1.0.8-2(26/05/2004) module loaded
Journalled Block Device driver loaded
kjournald starting.  Commit interval 5 seconds
EXT3-fs: mounted filesystem with ordered data mode.
Freeing unused kernel memory: 232k freed
usb.c: registered new driver usbdevfs
usb.c: registered new driver hub
usb-uhci.c: $Revision: 1.275 $ time 18:50:52 Jan 11 2006
usb-uhci.c: High bandwidth mode enabled
PCI: Setting latency timer of device 00:1d.0 to 64
usb-uhci.c: USB UHCI at I/O 0x2000, IRQ 16
usb-uhci.c: Detected 2 ports
usb.c: new USB bus registered, assigned bus number 1
hub.c: USB hub found
hub.c: 2 ports detected
PCI: Setting latency timer of device 00:1d.1 to 64
usb-uhci.c: USB UHCI at I/O 0x2020, IRQ 19
usb-uhci.c: Detected 2 ports
usb.c: new USB bus registered, assigned bus number 2
hub.c: USB hub found
hub.c: 2 ports detected
usb-uhci.c: v1.275:USB Universal Host Controller Interface driver
PCI: Setting latency timer of device 00:1d.7 to 64
ehci-hcd 00:1d.7: PCI device 8086:25ad (Intel Corp.)
ehci-hcd 00:1d.7: irq 23, pci mem f8928000
usb.c: new USB bus registered, assigned bus number 3
ehci-hcd 00:1d.7: enabled 64bit PCI DMA
PCI: 00:1d.7 PCI cache line size set incorrectly (0 bytes) by BIOS/FW.
PCI: 00:1d.7 PCI cache line size corrected to 128.
ehci-hcd 00:1d.7: USB 2.0 enabled, EHCI 1.00, driver 2003-Jan-22
hub.c: USB hub found
hub.c: 4 ports detected
usb.c: registered new driver hiddev
usb.c: registered new driver hid
hid-core.c: v1.8.1 Andreas Gal, Vojtech Pavlik <vojtech@suse.cz>
hid-core.c: USB HID support drivers
mice: PS/2 mouse device common for all mice
EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,0), internal journal
loop: loaded (max 8 devices)
Adding Swap: 2097144k swap-space (priority -1)
kjournald starting.  Commit interval 5 seconds
EXT3 FS 2.4-0.9.19, 19 August 2002 on cciss0(104,1), internal journal
EXT3-fs: mounted filesystem with ordered data mode.
kjournald starting.  Commit interval 5 seconds
EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,6), internal journal
EXT3-fs: mounted filesystem with ordered data mode.
kjournald starting.  Commit interval 5 seconds
EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,2), internal journal
EXT3-fs: mounted filesystem with ordered data mode.
kjournald starting.  Commit interval 5 seconds
EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,3), internal journal
EXT3-fs: mounted filesystem with ordered data mode.
kjournald starting.  Commit interval 5 seconds
EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,4), internal journal
EXT3-fs: mounted filesystem with ordered data mode.
kjournald starting.  Commit interval 5 seconds
EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,1), internal journal
EXT3-fs: mounted filesystem with ordered data mode.
st: Version 20040102, bufsize 32768, max init. bufs 4, s/g segs 16
Attached scsi tape st0 at scsi1, channel 0, id 3, lun 0
[root@eflinux01 log]#

barf
643 posts

Ultimate Geek


  #89512 4-Oct-2007 16:55

well im writing a script for you, please check your PM and email me




Sniffing the glue holding the Internet together

Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00

eero Pro 7 Review
Posted 23-Jul-2025 12:07

BeeStation Plus Review
Posted 21-Jul-2025 14:21

eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01

WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32

RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26

Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24

Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05

Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01

Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01

Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22

Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46

Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42

D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34

Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.







RSS feeds
Main feed
Forums feed
Copyright
©2002-2025 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Affiliate links
Samsung
AliExpress
Wise
Sharesies
GoodSync
Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright