09-08-2016
The creation of snapshot is usually with
lvconvert for Linux systems. Others use a variety of other LVM commands.
Does the database not include the hot-backup functionality itself? It would be better to use that if you can. Have a look at
Backup and Restore Overview - MariaDB Knowledge Base to see if that provides a better plan.
The problem you will have with LVM snapshots is being sure you have the correct definition of your process. The phrasing can be confusing in what it delivers and how. If you have a high-rate update database then some snapshots can expire before your backup completes.
Do you want to really make a copy of the LV, mount that elsewhere and backup from there? You might have a problem in ensuring that the snapshot is a true reflection of a point in time if there are multiple LVs in use for the DB.
Is this the only way?
Robin
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
Hi all!
Working on Oracle v8.1.7.0.0 with OS as Suse v8.0 Linux.
I had created LVM,linked raw devices to LVM as below:
# for binding raw devices
raw /dev/raw/raw1 /dev/oracle/sam_raw_system_251m
raw /dev/raw/raw2 /dev/oracle/sam_raw_users_26m
raw /dev/raw/raw3... (2 Replies)
Discussion started by: Amitstora
2 Replies
2. Solaris
Hi guys,
i am intrested to learn about snapshots. I was a bit confused about snapshot i know using fssnap -F ufs -o bs (i dont understand the exact what to give the path after this ) if any one know the proper syntax..pls help me. (2 Replies)
Discussion started by: kurva
2 Replies
3. HP-UX
Hi,
I'm new to HP-UX.
I have LVM on /var with 92Gig. I would like to reduce it to create another LVM for Oracle client with 800 meg or so. How to do it. I'm running 11.iv3
Thanks (4 Replies)
Discussion started by: lamoul
4 Replies
4. Shell Programming and Scripting
Hi
i have a user "SYSTEM"
i want to set the below command in his .profile for an alias:
who | awk '{print $1}'| sed '/SYSTEM/d' | sed '/root/d' |xargs -i pkill -u {}
i tried as below:
alias stop = " who | awk '{print $1}'| sed '/SYSTEM/d' | sed '/root/d' |xargs -i pkill -u {}"
... (3 Replies)
Discussion started by: joycesolomon
3 Replies
5. UNIX for Dummies Questions & Answers
I have a script with:
mplayer tv:// -tv driver=v4l2:device=/dev/video0:width=320:height=240:norm=NTSC:fps=30:noaudio:input=0 -vf screenshot -aspect 4:3 -vo xv
to take .png screenshots.
It now works but am not getting what the webcam sees displayed in the frame -- just snow noise.
Does someone... (1 Reply)
Discussion started by: slak0
1 Replies
6. Emergency UNIX and Linux Support
Hi guys.
I'm confused how LVM snapshots work. Here is what i understood:
1. we have a Logical Volume holding our data.
2. we make a snap shot of it with this command:
lvcreate -L 1000M -s -n backup /dev/vg01/lv013. mount the snap shot
4. take your backup
5. remove the snapshot --> in this... (3 Replies)
Discussion started by: majid.merkava
3 Replies
7. UNIX for Advanced & Expert Users
0 down vote favorite share share share
Let's solve my case please, it's urgent I have installed ubuntu server 11.04 on a machine with size 4GB. As, the ubuntu server 11.04 does not support real time kernel by default, I ... (0 Replies)
Discussion started by: dr_mabuse
0 Replies
8. UNIX for Dummies Questions & Answers
Hi Guys,
I m using redhat 6, I have installed root partition as non-LVM .
Is there any way i can convert it to LVM? (1 Reply)
Discussion started by: pinga123
1 Replies
9. UNIX for Dummies Questions & Answers
I am trying to install timbl- memory based learner tools in ubuntu. it after unpacking the tar file it brings the following msg
No package 'ticcutils' found
Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.
Alternatively, you... (1 Reply)
Discussion started by: gbdaw
1 Replies
10. UNIX for Dummies Questions & Answers
Please suggest me how do I create LVM snapshots in linux.
Best regards,
Vishal (5 Replies)
Discussion started by: admin_db
5 Replies
LEARN ABOUT OPENSOLARIS
vgcfgrestore
VGCFGRESTORE(8) System Manager's Manual VGCFGRESTORE(8)
NAME
vgcfgrestore - restore volume group descriptor area
SYNOPSIS
vgcfgrestore [-d|--debug] [-f|--file filename] [-l[l]|--list] [-h|--help] [-M|--Metadatatype1|2] [-t|--test] [-v|--verbose] VolumeGroupName
DESCRIPTION
vgcfgrestore allows you to restore the metadata of VolumeGroupName from a text backup file produced by vgcfgbackup. You can specify a
backup file with --file. If no backup file is specified, the most recent one is used. Use --list for a list of the available backup and
archive files of VolumeGroupName.
OPTIONS
-l | --list -- List files pertaining to VolumeGroupName
List metadata backup and archive files pertaining to VolumeGroupName. May be used with the -f option. Does not restore Vol-
umeGroupName.
-f | --file filename -- Name of LVM metadata backup file
Specifies a metadata backup or archive file to be used for restoring VolumeGroupName. Often this file has been created with vgcfg-
backup.
See lvm for common options.
REPLACING PHYSICAL VOLUMES
vgdisplay --partial --verbose will show you the UUIDs and sizes of any PVs that are no longer present. If a PV in the VG is lost and you
wish to substitute another of the same size, use pvcreate --restorefile filename --uuid uuid (plus additional arguments as appropriate) to
initialise it with the same UUID as the missing PV. Repeat for all other missing PVs in the VG. Then use vgcfgrestore --file filename to
restore the volume group's metadata.
SEE ALSO
lvm(8), vgcreate(8)
Sistina Software UK LVM TOOLS 2.02.95(2) (2012-03-06) VGCFGRESTORE(8)