Cold backup oracle and Restore to new db


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cold backup oracle and Restore to new db
# 1  
Old 08-03-2012
Cold backup oracle and Restore to new db

Hello All,

I am very new to Linux i have assignment to take offline backup in linux and restore it to new database oracle 10g?

Help me out any script of it and steps i will be very thankful

Regards,
Sameer
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

I need perl script on cold backup in Oracle 10 g

Hi , I am new to Perl script.Can u please provide me perl scripts for the following: 1. Perl script on Cold backup in Oracle 10g 2.Perl script on Hot backup in Oracle 10g (0 Replies)
Discussion started by: Niharika Srivas
0 Replies

2. Shell Programming and Scripting

Cold Backup of Oracle database.

Hi i need a command to cut the last column from the location in a file and want write a gzip command like cat a.txt /data01/oracle/oradata/vas/data/system01.dbf /data01/oracle/oradata/vas/data/sysaux01.dbf /data01/oracle/oradata/vas/data/undotbs01.dbf... (3 Replies)
Discussion started by: javeedkaleem
3 Replies

3. Red Hat

Backup / Restore

Hi, I need to back up a RH file system (96G). The files are oracle .dbf format some of which are 5G in size. I know that tar has got a size restriction of 2G so I cannot use this. Can anyone recommend an alternative way of backuping up this FS? I have been looking at dump but this... (6 Replies)
Discussion started by: Duffs22
6 Replies

4. HP-UX

Can we restore omni oracle db backup

We have omni backup of oracle database about 40Gb, tablespaces are distributed over 2 partitions . But because of some reason both partition are not available more . Now we are in need to restore the entire data on new partitions .Can any guru's confirm if tried so earlier will this going to... (1 Reply)
Discussion started by: Shirishlnx
1 Replies

5. AIX

Backup and restore

Hi experts, i got a question. i have a production server with two Volume Group(VG) which are rootvg and datavg. Both of these VGs are 256 PP SIZE. On Disaster Recovery Server (DR server) contains two empty hardisks for restoring rootvg and datavg from production server. This two hardisks are... (7 Replies)
Discussion started by: polar
7 Replies

6. AIX

Cold backup

Hello, I am newbie IBM AIX.I am working on R12.1.1 O.S IBM AIX i want to take cold backup of 12.1.1 apps,db,inst folder with zip.Please tell me backup command with zip or any other utility.becauze i was using the tar -cvf command this command taking too much space for backup.please reply... (1 Reply)
Discussion started by: umair
1 Replies

7. AIX

AIX backup and restore

Hello, Some background so you can see what I'm trying to do on AIX: In Windows its possible to partition a single hard drive into 2 separate logical paritions which may appear as a C and a D drive. It is then possible to to use 3rd party software such as Power Quest Drive Image to create a... (3 Replies)
Discussion started by: quickfirststep
3 Replies

8. HP-UX

F-Backup restore

Hello! i have a blank harddrive and a complete tape backup of the workstation. the backup is made with F-Backup. Now my question is: how can i restore my workstation? thanks for every idea! paul tittel hup-si (3 Replies)
Discussion started by: paultittel
3 Replies

9. AIX

Backup and restore

I have several H80 machines, all with AIX 4.3.3. On these machines I have mksysb running for rootvg backups and savevg for non-rootvg backups. I'm trying to get a list of files on the tapes, but I can't seem to do it with tar for the mksysb images. I keep getting the directory checksum errors?... (3 Replies)
Discussion started by: uXion
3 Replies

10. Solaris

Backup / restore

Hi.... everyone could help me to understand how to do a backup of my servers .. operating systems is sun solaris 8 . I have some question about .... 1) Is better backup phisical disk or partition ??? i sow the command is ufsdump 0cfu /expbck/bcksunver/c0t0d0s5 dev/dsk/c0t0d0s5 to... (4 Replies)
Discussion started by: tt155
4 Replies
Login or Register to Ask a Question
VGCFGRESTORE(8) 					      System Manager's Manual						   VGCFGRESTORE(8)

NAME
vgcfgrestore - restore volume group descriptor area SYNOPSIS
vgcfgrestore [-b|--backup_number VolumeGroupBackupNumber] [-d|--debug] [-f|--file VGConfPath] [-l[l]|--list [--list]] [-h|--help] [-i|--ignore_size] [-n|--name VolumeGroupName] [-o|--oldpath OldPhysicalVolumePath] [-t|--test] [-v|--verbose] [PhysicalVolumePath] DESCRIPTION
vgcfgrestore allows you to restore the volume group descriptor area from backup files in /etc/lvmconf or from VGConfPath to the given Phys- icalVolumePath. The default backup file is /etc/lvmconf/VolumeGroupName.conf. This command DOES NOT restore data contained in logical volume(s), only the LVM configuration metadata! OPTIONS -b, --backup_numberVolumeGroupBackupNumber Restore from the specified backup number. Use together with option -n which gives the name of the volume group. See examples below. -d, --debug Enables additional debugging output (if compiled with DEBUG). -f, --file VGConfPath Restore from the specified path. Useful for selection of specific backups in the backup history or for copies of VGDA backups. -i, --ignore_size Restore though the size of the physical volume doesn't match the one in the backup. -l, --list Display volume group information contained in the backup file. If given twice, the physical and logical volume information con- tained in the backup file is also shown. -h, --help Print a usage message on standard output and exit successfully. -n, --name VolumeGroupName Do a restore for this volume group name. -o, --oldpath OldPhysicalVolumePath If the path to the physical volume has changed between backup time and restore time, this option enables you to choose the corre- sponding physical volume path in the backup file. -t, --test Do a test run reading the volume group backup WITHOUT trying to restore it -v, --verbose Give verbose runtime information about vgcfgrestore's activities. --version Output the version number and exit successfully. Examples To display information like with "vgdisplay vg00" stored in the backup file /etc/lvmconf/vg00.conf: vgcfgrestore -n vg00 -l To restore the VGDA of vg00 from the alternative backup file /tmp/vg00-old to physical volume /dev/sdn1: vgcfgrestore -f /tmp/vg00-old -n vg00 /dev/sdn1 To restore the VGDA of vg00 from the alternative backup file /etc/lvmconf/vg00.conf.5.old to physical volume /dev/sda5 : vgcfgrestore -n vg00 -b 5 /dev/sda5 DIAGNOSTICS
vgcfgrestore returns an exit code of 0 for success and > 0 for error: 1 no physical volume on command line 2 invalid physical volume name 3 volume group is active 4 error doing restore to physical volume 5 backup is invalid for this volume group 6 volume group is inconsistent 7 physical volume doesn't belong to volume group backup 8 error reading physical volume 9 error getting size of physical volume 10 error writing VGDA to physical volume(s) 11 error removing special files of volume group 12 error setting volume group into lvmtab 13 error doing backup 95 driver/module not in kernel 96 invalid I/O protocol version 97 error locking logical volume manager 98 invalid lvmtab (run vgscan(8)) 99 invalid command line SEE ALSO
lvm(8), vgcfgbackup(8), vgcreate(8) AUTHOR
Heinz Mauelshagen <Linux-LVM@Sistina.com> Heinz Mauelshagen LVM TOOLS VGCFGRESTORE(8)