Thanks,
I thought it was not so complicated..
I red the 6.5 administrator's guide and in page 721, there is the chapter :"
Moving the NetBackup database from one host to another".
I will try this for moving the 6.5.3 EMM database from a Solaris to a Linux
redhat.
If someone else has experience about that, their ideas are welcomed.
Gilles.
-----Message d'origine-----
De : veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu]De la part de
backupgirl
Envoyé : lundi 8 juin 2009 18:59
À : VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Objet : [Veritas-bu] Move EMM Database to another host?
Can you give us more details on the process of moving the EMM database ( the
command associated ) ??
Sure... We migrated from an AIX to Windows Master and the DBA discovered it was
not as simple as unloading and loading the media tables. The database schema
was different between the two versions. Some of the commands used to create
tables and load tables are listed below.
SYBASE:
Unix:
. /usr/openv/db/vxdbms_env.sh
dbisqlc -q -c "CS=utf8;UID=dba;PWD=xxxxxx;ENG=NB_servername;DBN=NBDB" xyz.sql
interactive use esc+F -->File menu
dbisqlc -c "CS=utf8;UID=dba;PWD=xxxxxx;ENG=NB_servername;DBN=NBDB"
Windows:
Go to:
D:\Program Files\Veritas\NetBackupDB\WIN64
Execute dbisqlc.exe
Login tab:
User id: dba
Password:xxxxxx
Database tab:
Server name: NB_servername
Database name: NBDB
Uncheck stop database
unload table EMM_MAIN.EMM_Media to '/tmp/ EMM_Media.unl';
unload table EMM_MAIN.EMM_MediaGroup to '/tmp/ EMM_MediaGroup.unl';
dbunload -n -c "CS=utf8;UID=dba;PWD=xxxxxx;ENG=NB_servername;DBN=NBDB"
vi reload.sql
EMM_Media
EMM_AllocationStatus
EMM_Allocations
EMM_DeletedMedia
EMM_Media_MediaAffinityGroup
RB_MDS_Allocation
RB_MDS_Reservation
load table EMM_MAIN.EMM_Media (MediaKey, DriveKey, MediaGuid, MediaId,
PartnerKey, PartnerId, LegacyMediaType, MediaTypeName, MediaGroupName,
DensityName, DensityCode, VerificationFlag, AssignedAppType, MediaFlags,
MediaTypeFlags, MediaDescription, Barcode, PartnerBarcode, LastWriteHostKey,
AssignedDateTime, FirstMountDateTime, LastMountDateTime, ExpireDateTime,
ImageExpireDateTime, AllocatedDateTime, LastWriteDateTime, LastRestoreDateTime,
LibraryNumber, LegacyRobotType, LibraryGroupName, SlotNumber, OpticalSide,
ControlHostName, CleaningsLeft, TotalMounts, MaxMounts, MediaRunTimeStatus,
TotalWriteKBytes, NumberOfImages, NumberOfValidImages, RetentionLevel,
NumberOfRestores, OpticalHeaderSizeBytes, OpticalSectorSizeBytes,
OpticalLastHeaderOffset, OpticalPartitionSizeBytes, AdammGuid, RsmGuid,
OriginHostKey, UpgradeConflictsFlag, PoolNumber, PoolName, PrevPoolName,
VltFlags, VltContainerID, VltOffsiteLocation, VltOffsiteSlotNumber,
VltOffsiteSessionID, VltOffsiteSentDateTime,
VltOffsiteReturnDateTime, AcsAcs, AcsLsm, AllocationState, ManufacturerName,
SerialNumber, CreatedDateTime, LastModifiedDateTime, MasterServerKey,
ServerGroupKey) from 'D:\Program Files\Veritas\NetBackupDB\WIN64\EMM_Media.unl'
ALTER TABLE "EMM_MAIN"."EMM_Media"
ADD FOREIGN KEY "FK_EMM_MEDI_R_MEDIAGR_EMM_MEDI"
("MediaGroupName")
REFERENCES "EMM_MAIN"."EMM_MediaGroup" ("MediaGroupName")
go
CREATE TABLE "EMM_MAIN"."EMM_AllocationStatus"
(
"AllocationStatusKey" unsigned int NOT NULL DEFAULT
autoincrement CONSTRAINT "CKC_ALLOCATIONSTATUSK_EMM_ALLO"
check(AllocationStatusKey >= 1),
"AllocationKey" unsigned int NOT
NULL DEFAULT 0 ,
"MediaKey" unsigned int NOT NULL DEFAULT
0 ,
"DriveKey" unsigned int NOT NULL
DEFAULT 0 ,
"JobId"
unsigned int NOT NULL DEFAULT 0 ,
"StatusCode" unsigned int NOT NULL DEFAULT
0 ,
"Operation" unsigned int NOT NULL DEFAULT
0 ,
"MediaServerKey" unsigned int NOT NULL DEFAULT 0 ,
"Data1" unsigned
int NOT NULL DEFAULT 0 ,
"Data2" unsigned
int NOT NULL DEFAULT 0 ,
"String1" varchar(128) NOT NULL
DEFAULT '' ,
"CreatedDateTime" timestamp NOT NULL DEFAULT current utc
timestamp ,
CONSTRAINT "PK_EMM_ALLOCATIONSTATUS" PRIMARY KEY
("AllocationStatusKey"),
) IN "EMM_DATA"
go
+----------------------------------------------------------------------
|This was sent by azenon AT yahoo DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
This mail has originated outside your organization, either from an external
partner or the Global Internet.
Keep this in mind if you answer this message.
The information in this e-mail is confidential. The contents may not be
disclosed or used by anyone other then the addressee. Access to this e-mail by
anyone else is unauthorised.
If you are not the intended recipient, please notify Airbus immediately and
delete this e-mail.
Airbus cannot accept any responsibility for the accuracy or completeness of
this e-mail as it has been sent over public networks. If you have any concerns
over the content of this message or its Accuracy or Integrity, please contact
Airbus immediately.
All outgoing e-mails from Airbus are checked using regularly updated virus
scanning software but you should take whatever measures you deem to be
appropriate to ensure that this message and any attachments are virus free.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|