Moving Oracle database Post: 302588194

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Moving data from one database to other

Dear All, I have 2 databases, There is a lot of data in both the databases, i would like to move some data from one database to the other. I would like to accept 2 parameters from the user, i.e. emplyee id & dept, on entering the 2 i will unload all the data from the tables to the flat files....

2. Shell Programming and Scripting

Moving a database from one server to another

I hope I'm posting this in the correct section. I'm trying to move a database from one server to another. This is the code I'm using... tar czf - vbdatabase.sql | ssh username@full.domain.com 'cat > /home/cpanelusername/vbdatabase.tar.gz ... but all I'm getting is a ">" and then nothing...

3. Programming

Oracle Database Query

How can i modify the below to search for the things i'm looking for during a certain time frame? select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc; In this particular case, this query is...

4. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

5. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT LINUX

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)