background image

Chapter 6    Operations of NEC Storage ReplicationControl SQL Option 

87

 

 

 

 

Figure 6-26    Performing Snapshot Backup 

Procedure 8.  Reconfigure the drive name for the search target disk (Search Server) 

Reconfigure the removed drive name for the search target disk on the search server side by executing 

the MOUNTVOL command. 

MOUNTVOL d: \\?\Volume{d9ea193d-9d59-11d6-ab08-806d6172696f}\ 

MOUNTVOL e: \\?\Volume{d9ea193e-9d59-11d6-ab08-806d6172696f}\ 

 

Procedure 9.  Mount the search target disk (Search Server) 

Mount the target disk on the RV side. When using a service to monitor the disk state, start the service 

after executing the mounting. 

iSMrc_mount -drv d: 

iSMrc_mount -drv e: 

 

Procedure 10.  Execute snapshot restoration (Search Server) 

Execute snapshot restoration with the search server. 

The data copied as a backup through snapshot backup is restored as the standby database in the search 

server’s Microsoft SQL Server 2000. 

 

iSMsql_snapshotrst -db snap -metafile f:\snap.dat -norestore -remod standby 

           -refile g:\db_undo.dat 

 

6

6

6

.

.

.

3

3

3

.

.

.

2

2

2

 

 

 

L

L

L

o

o

o

g

g

g

 

 

 

D

D

D

i

i

i

s

s

s

t

t

t

r

r

r

i

i

i

b

b

b

u

u

u

t

t

t

i

i

i

o

o

o

n

n

n

 

 

 

By copying the transaction log as a backup using the business server and applying the transaction log 

backup to the search server, the contents of the search server’s database can be made to be equivalent to the 

transaction log backup status. 

For details, refer to the Microsoft SQL Server 2000 Books Online. 

Use the file specified with the -refile option during the snapshot restoration operation as an undo file 

required for recovery in standby mode. 

 

Содержание Storage ReplicationControl SQL Option

Страница 1: ...NEC Storage ReplicationControl SQL Option User s Manual ...

Страница 2: ...poration 2001 2003 No part of the contents of this book may be reproduced or transmitted in any form without permission of NEC Corporation The contents of this book may be modified without notice in the future ...

Страница 3: ...rmation related to Microsoft SQL Server 2000 refer to the Microsoft SQL Server 2000 Books Online Refer to the NEC Storage Manager Manual Guide IS901 for the overview of NEC Storage Manager and the related manuals Remarks 1 This manual explains functions implemented by the following program products NEC Storage Manager and NEC Storage BaseProduct NEC Storage ReplicationControl NEC Storage Replicati...

Страница 4: ...marks of Microsoft Corporation in the United States and other countries VERITAS Backup Exec VERITAS Backup Exec NetBackup and VERITAS NetBackup are registered trademarks or trademarks of VERITAS Software Corporation in the United States and other countries ARCserve is a registered trademark of Computer Associates International Inc in the United States Other product names and company names etc are ...

Страница 5: ...r 17 3 4 2 Log Distribution 17 3 4 3 Server Accompanied by Update 17 3 4 4 Files Operated in Parallel 17 3 5 Operation Automatization 18 Chapter 4 Functions of NEC Storage ReplicationControl SQL Option 19 4 1 Snapshot Backup 19 4 1 1 Snapshot Backup Operations 20 4 1 2 Snapshot Restore Operations 21 4 2 Commands 22 4 2 1 Snapshot Backup Command 22 4 2 2 Snapshot Restore Command 30 4 3 Metafile Han...

Страница 6: ...overy 71 6 3 Parallel Operation on Another Node 75 6 3 1 Operation as Standby Database 75 6 3 2 Log Distribution 78 6 3 3 Operation for Server Accompanied by Update 79 Chapter 7 Measures for Errors 82 7 1 Error Detection Method 82 7 2 Errors Related to Database Configurations 82 7 3 Errors Related to Metafile Configurations 83 Appendix A Notes 84 Index 86 ...

Страница 7: ...e RV for a Business Volume MV Master Volume is stored in the disk array The RV can achieve synchronization and segregation from the MV at an arbitrary time When synchronized the MV and RV coincide with each other in terms of their contents thus update the MV is instantly reflected in the RV Through segregation at an arbitrary time the MV data can be kept in the RV By using this RV backup and searc...

Страница 8: ... RDR NEC Storage RemoteDataReplication Ver2 RDR Ver2 Creates an RV between different disk arrays Supported by the NEC Storage3000 4000 series The replication management function in NEC Storage Manager can be used by introducing NEC Storage DynamicDataReplication or NEC Storage RemoteDataReplication NEC Storage ReplicationControl Operates the replication function Provides the CLI Command Line Inter...

Страница 9: ...Manager Displays the components of the disk array monitors its state and notifies of its failure NEC Storage PerformanceMonitor Monitors the performance of the disk array collects its performance information and displays its performance on a real time basis Figure 1 2 Functions by Product NEC Storage ReplicationControl NEC Storage DynamicDataReplication NEC Storage RemoteDataReplication NEC Storag...

Страница 10: ...ing reliability the RAID configuration is adopted for replications as well It is also possible to set a RAID type that differs from the original volume Integrated control by NEC Storage Manager GUI MV RV Disconnects replications at an arbitrary time to use for another purpose MV RV Reflects the update information successively Copying Disconnect Creates replications instantly Resynchronized in a sh...

Страница 11: ...of data replications by using NEC Storage Manager Can display and set the operational states of data replications through graphical interfaces Figure 1 4 Data Replication operation Display Business Link Can perform automatic operations based on linkage between backup software and job scheduling software by using the CLI for NEC Storage ReplicationControl ...

Страница 12: ...ations are created in the disk array they do not affect the online system Backup in parallel with online service Saving to tapes etc can be done from RVs in parallel with MVs thus making it unnecessary to worry about online responses during saving Parallel processing Executes the online and the search work simultaneously By making the RV data independent for the search work the update work and the...

Страница 13: ...s Also the snapshot is available in backup or parallel processing 2 2 2 2 2 2 A A Ad d dv v va a an n nt t ta a ag g ge e es s s o o of f f N N NE E EC C C S S St t to o or r ra a ag g ge e e R R Re e ep p pl l li i ic c ca a at t ti i io o on n nC C Co o on n nt t tr r ro o ol l l S S SQ Q QL L L O O Op p pt t ti i io o on n n NEC Storage ReplicationControl SQL Option enables round the clock unin...

Страница 14: ...n To install and use the data replication the following hardware devices are required 1 Disk array NEC Storage Series The NEC Storage3000 4000 series disk array the Replication Director is required separately equipped with a data replication NEC Storage DynamicDataReplication NEC Storage RemoteDataReplication or the NEC Storage 2000 series disk array applies 2 Management Server Manages the data re...

Страница 15: ...namicDataReplication and NEC Storage RemoteDataReplication and the pair volume settings Installing NEC Storage DynamicDataReplication and NEC Storage RemoteDataReplication makes it possible to use the replication management function incorporated in the NEC Storage Manager 4 NEC Storage DynamicDataReplication A function that facilitates data replication between the same disk arrays 5 NEC Storage Re...

Страница 16: ...to a magnetic tape medium By synchronizing and separating the MV and the RV during the time period when the load on the business operations that use the Microsoft SQL Server 2000 is lower it is possible to back up copies onto magnetic tape media without suspending the operations Since backup copies are made from RVs MVs are not affected Figure 2 2 Backup from RVs a During operation keep the MV and...

Страница 17: ...the event that the data to access is not restored to the MV restoration is realized through data access to the RV thus making it unnecessary for the user to think about whether to use the MV or the RV This makes it becomes possible to substantially reduce the data recovery time Figure 2 3 Use of RV as Backup a During operation keep all MVs and RVs separate b If the load is lowered synchronize and ...

Страница 18: ...ate work The NEC Storage ReplicationControl SQL Option must be installed on the server performing the search work The search work uses the standby database function on the Microsoft SQL Server 2000 Figure 2 4 Parallel processing of Search Work a When starting search work the MV and the RV are synchronized and separated b Hereafter is applying the transaction log backup reflects the updated part of...

Страница 19: ...replications of the database can be made without suspending operations using the Microsoft SQL Server 2000 When the business operations load is lower the MV and the RV are synchronized and separated Figure 2 5 Parallel processing of Operations Accompanied by Update a During the daytime keep the MV and the RV separate b During the nighttime stop parallel operation synchronize and separate the MV an...

Страница 20: ...ile One database always has one primary data file As the starting point of the database the primary data file points to the locations of the secondary data and log files File1 mdf in the diagram above The file name extension for the primary data file is mdf Secondary data file As a data file the secondary data file sometimes does not exist and sometimes multiple secondary data files exist File2 nd...

Страница 21: ...he parameters of snapshot backup restore commands specify the MV RV of all the files included in the database The data replication function operates in logical disk units Therefore when different database files exist in a logical disk all of the databases in the logical disk must be operated at the same time Furthermore the Microsoft SQL Server 2000 controls the connections of users for each insta...

Страница 22: ...y yp p pe e es s s 1 Snapshot backup Refers to the type of backup used on the NEC Storage ReplicationControl SQL Option Functionally the same as the conventional database s complete backup and file backup etc this type is capable of roll forwarding by using the transaction log backup In the same manner as other backups the snapshot backup and recovery are traced with MSDB 2 Database backup Since t...

Страница 23: ...stored as the search database through snapshot restoration can apply backup of transaction logs updated with the business server in the same manner as the database for the normal standard mode Through this work data from the search database can be changed to data at the time when the transaction log was copied as a backup 3 3 3 4 4 4 3 3 3 S S Se e er r rv v ve e er r r A A Ac c cc c co o om m mp ...

Страница 24: ... za a at t ti i io o on n n The tape backup system which used data replication requires a linkage operation between the business operation side and the backup server side NetBackup is available the backup software provided with the linkage function between servers When using ARCserve and BackupExec job scheduling software programs are required ...

Страница 25: ... s resource for backup purposes The snapshot backup is conducted by the following functions I O freeze function Freezes the update I O of Microsoft SQL Server 2000 to specify the static point of the database during the snapshot backup Creation of metafile Refers to the file for storing Microsoft SQL Server 2000 s file configuration and transaction log state information etc The file is created duri...

Страница 26: ... n ns s s The snapshot backup operation includes 1 stopping the update I O of Microsoft SQL Server 2000 2 creating metafile 3 flushing MV 4 separating MV RV Figure 4 1 Operation to Execute Snapshot Backup Business Server Metafile 1 Stopping the database I O 2 Creating metafile 3 Flushing MV 4 Separating MV RV Backup Server Master Volume MV Replication Volume RV Data file Data file Log file Log fil...

Страница 27: ...re operation includes 1 acquiring the MV information from the metafile 2 unmounting MV 3 restoring from RV to MV 4 mounting MV 5 restoring database Figure 4 2 Operation to Execute Snapshot Restoration 1 Acquiring the MV information from the metafile 2 Unmounting MV 3 Restoring RV MV 4 Mounting MV 5 Restoring database Business Server Metafile Backup Server Master Volume MV Replication Volume RV Dat...

Страница 28: ...eezes the update I O creates the metafile for the specified path and records the database configuration and the transaction log state Thereafter it separates the MV and the RV where the specified database is stored After the separation is completed the command sends the completion instruction to Microsoft SQL Server 2000 which in turn creates the history in the MSDB The following options can be sp...

Страница 29: ...ume Specify the MV volume and the RV volume Specifying the MV mv volume mvflg mv_flg Specifies the MV volume and volume type Specifying the RV rv volume rvflg rv_flg Specifies the RV volume and volume type When specifying multiple pair volumes describe the specification file file_name in the replication operation file For information on the volume type and replication operation file refer to the N...

Страница 30: ...by the iSMrc_query command 6 Canceling the MV RV state check nocheck Performs snapshot backup without checking the MV RV state Normally the snapshot backup command is not operated unless synchronization between MV and RV is completed Specifying nocheck makes it possible to perform snapshot backup even when MV RV synchronization is not completed This is specified when the MV RV synchronization time...

Страница 31: ...ctively enter a user ID and password by using a keyboard User ID Enter a user ID Password Enter a password Those specifications can be described in the database operation file For details of the database operation file refer to the NEC Storage Manager Data Replication Command Reference 9 Specifying the instance name server instance_name The computer name and the instance name when connecting to a ...

Страница 32: ...Starting flush operation Flush Start YYYY MM DD hh mm ss Ending flush operation Flush Normal End YYYY MM DD hh mm ss Starting separation operation Separate Start YYYY MM DD hh mm ss Ending separation operation Separate Normal End YYYY MM DD hh mm ss Description of message YYYY MM DD hh mm ss Start End time YY MM DD hh mm ss physical disk no PD number Path Drive name NTFS folder name Volume_name Mo...

Страница 33: ...airs in the background copy state it is necessary to perform the copy restart operation to place the pairs in the foreground copy status 4 The disk array in which the specified MV and RV are stored should not be in the freeze state 5 The MV targeted for operation should be registered in the volume correspondence table 6 The volume of MVs and RVs targeted for operation should be a basic volume Spec...

Страница 34: ...red in the volume correspondence table 6 Should be the basic volume 7 MVs should be a disk array under the own host control 8 The data and log files of the database should be in MV 9 When specifying a database name with the db option only one database must exist in the target MV 10 When specifying a database name with the dbfile option all databases that exist in the target MV must be specified MV...

Страница 35: ...29e8 Flush Start YYYY MM DD hh mm ss Flush Normal End YYYY MM DD hh mm ss Separate Start YYYY MM DD hh mm ss Separating Separate Normal End YYYY MM DD hh mm ss SnapshotBackup Normal End YYYY MM DD hh mm ss DataBase snap MV 4 dev001 WN Volume 3a78b50b 0f0b 11d5 9c71 00004c7929e8 D RV 5 dev002 WN Volume 2213cadd 24e9 11d5 bf42 00004c7929e8 C Explanation Database snap is in the d drive The d drive s ...

Страница 36: ...torage Manager Data Replication Command Reference 2 Specifying the metafile metafile metafilename or metafolder metafolder_name For the metafile a metafile name incorporated during snapshot restoration can be specified The metafile specified during snapshot backup must be specified When simultaneously performing snapshot restorations on multiple databases specify the name of the folder that stores...

Страница 37: ...rvacc The access to RV restriction during snapshot restoration execution and in the snapshot complete state can be specified Not Ready rvacc nr Placed in the Not Ready state thus making it impossible for the host to operate the volume Read Only rvacc ro Enables the host to only read the volume Unless well versed in OS and file system operations for Windows Read Only rvacc ro should not be specifie...

Страница 38: ...er2 or the NEC Storage RemoteDataReplication Ver2 is installed in the disk array For details about this function refer to the NEC Storage Manager Data Replication User s Manual Function Guide and NEC Storage Manager Data Replication Command Reference 9 Specifying the user ID password The user ID password to be connected to Microsoft SQL Server 2000 can be specified When omitted the user name and p...

Страница 39: ...ackup The database cannot be used until transaction log is applied Recovering the database as the database for search remod standby refile refilename Restores the database as the database for search The undo file must be specified as well Those specifications can be described in the database operation file For details of the database operation file refer to the NEC Storage Manager Data Replication...

Страница 40: ...ormal End YYYY MM DD hh mm ss DataBase db_name MV physical disk no ld_name type Volume_name Path RV physical disk no ld_name type Volume_name Path Restore start message Restore Start YYYY MM DD hh mm ss Restore end message Restore Normal End YYYY MM DD hh mm ss Description of message YYYY MM DD hh mm ss Start end time yyyy mm dd hh mm ss physical disk no PD number Path Drive name NTFS folder name ...

Страница 41: ...de it should be for the pair set between disk arrays 4 The disk array in which the specified MV and RV are stored should not be in the freeze status 5 The operation target MV is registered in the volume correspondence table 6 The volume of the operation target MV and RV is a basic volume Specifying a volume using dynamic volume function is not allowed 7 MV must exist in the disk array under its ow...

Страница 42: ...a file and the log file for the database exist 13 The RV must have been unmounted from the host 5 Registered in the volume correspondence table 6 Should be a basic volume 7 MV must be a disk array under its own host s control 8 Other applications should not use the target MV 10 When specifying a database name with the db option only one database must exist in the target MV 11 When specifying a dat...

Страница 43: ...ume 3a78b50b 0f0b 11d5 9c71 00004c7929e8 D RV 5 dev002 WN Volume 2213cadd 24e9 11d5 bf42 00004c7929e8 Restore Start YYYY MM DD hh mm ss SnapshotRestore Normal End YYYY MM DD hh mm ss DataBase snap MV 4 dev001 WN Volume 3a78b50b 0f0b 11d5 9c71 00004c7929e8 D RV 5 dev002 WN Volume 2213cadd 24e9 11d5 bf42 00004c7929e8 C Explanation Database snap is in the d drive The d drive s LD logical disk is dev0...

Страница 44: ...al End YYYY MM DD hh mm ss SnapshotRestore Normal End YYYY MM DD hh mm ss DataBase snap MV 4 dev001 WN Volume 3a78b50b 0f0b 11d5 9c71 00004c7929e8 D RV 5 dev002 WN Volume 2213cadd 24e9 11d5 bf42 00004c7929e8 C Explanation Database snap is in the d drive The d drive s LD logical disk is dev001 and a pair is set with dev002 Snapshot backup is performed on the dev001 and dev002 pair Waits for command...

Страница 45: ...r the backup server can be used as a shared disk MV Used when the shared disk format cannot be used due to network reasons such as when using an RV from a remote distance with RDR Since metafile information is used during recovery it is necessary to restore before recovery At backup unmount and separate the metafile MV after snapshot backup Local disk Can be used when saving metafile directly from...

Страница 46: ...e same name as the specified file name the command fails to create metafiles which result in an abnormal end 4 4 4 4 4 4 A A Ac c cc c ce e es s ss s s R R Re e es s st t tr r ri i ic c ct t ti i io o on n n A user belonging to the Administrators group must execute the ReplicationControl command Therefore A user belonging to the Administrator group also must be executed the NEC Storage Replication...

Страница 47: ...is software operates in liaison with the following software program NEC Storage ReplicationControl Ver2 1 or later NEC Storage ReplicationControl SQL Option cannot be installed in the environment where the NEC Storage ReplicationControl Ver2 1 or later has not been installed This software also operates in liaison with either of the following Microsoft software programs Microsoft SQL Server 2000 En...

Страница 48: ...the NEC Storage ReplicationControl SQL Option is started If it is started either make the end of processing wait or terminate the command for the NEC Storage ReplicationControl SQL Option by force 3 If the Event Viewer is open close it 4 Uninstall the following software by using Add Remove Programs in Control Panel NEC Storage ReplicationControl SQL Option 5 Follow the directions of the uninstalle...

Страница 49: ...t It is necessary to provide a metafile for each backup Metafiles are allocated to a different volume from the volume to which the database is allocated In accordance with the description in Section 4 3 the volume for metafiles is provided Depending on the allocation of metafiles the database is constructed as follows When allocating to a shared disk Set for a shared disk by setting the network co...

Страница 50: ...napshot backups are simultaneously performed on many databases beforehand it is necessary to make available the necessary maximum number of worker threads Indication of the maximum number of the worker threads Default 255 The number of databases on which snapshot backups are simultaneously performed 2 Although the default number of worker threads is 255 those worker threads are also consumed by ot...

Страница 51: ...he system configuration and the recovery requirements 6 6 6 1 1 1 T T Ta a ap p pe e e B B Ba a ac c ck k ku u up p p Describes operations to save from the snapshot backup to the tape medium using the backup server without suspending operations by using the NEC Storage ReplicationControl SQL Option Here the procedure is operated with MV RV in the separation state and with MV RV synchronized immedi...

Страница 52: ...e placed in a shared disk The shared disk where metafiles are placed shall be accessible from both the business server and the backup server In this example the data file and the log file are created in different volumes with the database name as snap Figure 6 1 Snapshot Backup Business Server Data file d e Tape Backup software such as ARCserve BackupExec and NetBackup snap f Data file Log file Lo...

Страница 53: ...l unwritten data in the file system buffer to the disk iSMrc_flush mvol Volume d9ea193d 9d59 11d6 ab08 806d6172696f iSMrc_flush mvol Volume d9ea193e 9d59 11d6 ab08 806d6172696f Procedure 3 Unmount backup target disk Backup Server Unmount the backup target disk on the backup server side and cancel the associations between the volume and the file system iSMrc_umount mvol Volume d9ea193d 9d59 11d6 ab...

Страница 54: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 48 ...

Страница 55: ...n to Execute Snapshot Backup Procedure 6 Reconfigure the drive name for the backup target disk Backup Server Reconfigure the removed drive name for the backup target disk on the backup server side by executing the MOUNTVOL command MOUNTVOL d Volume d9ea193d 9d59 11d6 ab08 806d6172696f MOUNTVOL e Volume d9ea193e 9d59 11d6 ab08 806d6172696f Procedure 7 Mount backup target disk Backup Server Mount th...

Страница 56: ... backup software Copy the metafiles of the shared disk to a tape After the snapshot backup is executed the backup files of the transaction log extracted before performing the snapshot backup are not used Deleting backup files of the transaction log is permitted Figure 6 4 Tape Backup Data file RV Log file RV Backup software such as ARCserve BackupExec and NetBackup Tape Metafile Shared disk ...

Страница 57: ... the operations running Metafiles are placed in a shared disk The shared disk where metafiles are placed shall be accessible from both the business server and the backup server In this example databases are named snap1 and snap2 Data files are created in the same volume however log files are created in different volumes snap1 f e d snap2 e g Business Server Tape Backup Server Backup software such ...

Страница 58: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 52 Figure 6 5 Snapshot Backup ...

Страница 59: ...e MOUNTVOL command to prevent new access When using a service to monitor the disk state it is necessary to stop the service before executing the MOUNTVOL command MOUNTVOL d D MOUNTVOL e D MOUNTVOL f D Procedure 3 Execute file system flush of the backup target disk Backup Server Flush the file system of the backup target disk on the backup server side and then write the still unwritten data in the ...

Страница 60: ... command MVs and RVs are synchronized iSMrc_replicate mv d mvflg drv wait iSMrc_replicate mv e mvflg drv wait iSMrc_replicate mv f mvflg drv wait d MV RV e f MV RV MV RV e Figure 6 6 Operation to Execute Replication Executing replication Normal operations Normal operations Log file Log file Data file Data file Log file Log file Data file Data file ...

Страница 61: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 55 ...

Страница 62: ...shared disk iSMsql_snapshotbkup dbfile snap_dbfile txt metafolder g metafolder wait d MV RV e g e MV RV f MV RV Figure 6 7 Operation to Execute Snapshot Backup Procedure 7 Reconfigure the drive name for the backup target disk Backup Server Reconfigure the removed drive name for the backup target disk on the backup server side by executing the MOUNTVOL command MOUNTVOL d Volume d9ea193d 9d59 11d6 a...

Страница 63: ...c_mount drv f Procedure 9 Tape backup Backup Server Copy the data files and log files copied in the RV to a tape as a backup by using the backup software Copy the metafiles of the shared disk to a tape After the snapshot backup has been executed the backup files of the transaction log extracted before the snapshot backup is performed are not used Deleting backup files of the transaction log is per...

Страница 64: ...ransaction log backup can be created with Microsoft SQL Server 2000 In this case recovery until immediately before the error is made possible by applying the transaction log when the error occurs in the log file disk In the event that transaction log backups have been made periodically recovery shall be possible until the latest transaction log backup copy is created if an error occurs in the log ...

Страница 65: ...k Procedure 2 Detach database Business Server Detach the database where the error occurred T SQL EXEC sp_detach_db snap Procedure 3 Initialize backup target disk Backup Server Initialize the RV by using Disk management of Windows2000 if the logical volume is recovered due to a hardware failure or if the file system is incorrect due to a procedural mistake during separation If the file system is in...

Страница 66: ...MOUNTVOL e D Procedure 6 Execute file system flush of the recovery target disk Backup Server Flush the file system of the recovery target disk on the backup server side and then write the still unwritten data in the file system buffer to the disk iSMrc_flush mvol Volume d9ea193d 9d59 11d6 ab08 806d6172696f iSMrc_flush mvol Volume d9ea193e 9d59 11d6 ab08 806d6172696f Procedure 7 Unmount recovery ta...

Страница 67: ...tomatically performed after synchronization has been completed as the result of the restoration Therefore it is not necessary to execute the separation operation iSMsql_snapshotrst db snap metafile f snap dat remod norecovery mode protect Figure 6 12 Execute Snapshot Restoration Procedure 9 Reconfigure the drive name for the recovery target disk Backup Server Reconfigure the removed drive name for...

Страница 68: ...bl dat WITH NORECOVERY Apply all the transaction logs Restore the database T SQL RESTORE DATABASE snap WITH RECOVERY Procedure 11 Start normal operations Business Server Start normal operations after making sure that Microsoft SQL Server 2000 operates normally Procedure 12 Backup extraction Backup Server The program can be made to wait for the completion of automatic separation after synchronizati...

Страница 69: ...or occurred in MV s data file and the backup and the metafile previously obtained through a snapshot backup are stored in the tape In this example databases are named snap1 and snap2 Data files exist in the same volume however log files exist in different volumes snap1 f e d snap2 e g Figure 6 13 Performing Snapshot Restoration Business Server Tape Backup Server Backup software such as ARCserve Ba...

Страница 70: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 64 ...

Страница 71: ...ference snap_dbfile txt db db_name remod restore_mode db snap1 remod norecovery db snap2 remod norecovery Procedure 2 Create a transaction log backup Business Server Create a transaction log backup when an error occurs in Microsoft SQL Server 2000 s data file disk T SQL BACKUP LOG snap1 TO DISK h sql backups_snap1 trbl dat WITH NO_TRUNCATE T SQL BACKUP LOG snap2 TO DISK h sql backups_snap2 trbl da...

Страница 72: ...e 6 Remove the drive name for the recovery target disk Backup Server Remove the drive name for the recovery target disk on the backup server side by executing the MOUNTVOL command to prevent new access When using a service to monitor the disk state it is necessary to stop the service before executing the MOUNTVOL command MOUNTVOL d D MOUNTVOL e D MOUNTVOL f D Procedure 7 Execute file system flush ...

Страница 73: ...a193d 9d59 11d6 ab08 806d6172696f iSMrc_umount mvol Volume d9ea193e 9d59 11d6 ab08 806d6172696f iSMrc_umount mvol Volume d9ea193c 9d59 11d6 ab08 806d6172696f Procedure 9 Execute snapshot restoration Business Server Execute a snapshot restoration by specifying the remod norecovery option and the RV protection When using a service to monitor the disk state it is necessary to stop the service before ...

Страница 74: ...licationControl SQL Option 68 d MV RV e g e MV RV f MV RV Figure 6 15 Operation to Execute Snapshot Restoration Performing snapshot restoration Log file Log file Data file Data file Data file Data file Log file Log file Metafile Shared disk ...

Страница 75: ... WITH NORECOVERY T SQL RESTORE LOG snap2 FROM DISK h sql backups_snap2 backup01 dat WITH NORECOVERY T SQL RESTORE LOG snap1 FROM DISK h sql backups_snap1 trbl dat WITH NORECOVERY T SQL RESTORE LOG snap2 FROM DISK h sql backups_snap2 trbl dat WITH NORECOVERY Apply all the transaction logs Restore the database T SQL RESTORE DATABASE snap1 WITH RECOVERY T SQL RESTORE DATABASE snap2 WITH RECOVERY Proc...

Страница 76: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 70 ...

Страница 77: ...d The procedure for disk backup operation is described below 6 6 6 2 2 2 1 1 1 P P Pr r re e ep p pa a ar r ra a at t ti i io o on n n Procedure 1 Prepare three groups of two replication operation files For details about how to describe the replication operation file refer to the NEC Storage Manager Data Replication Command Reference disklist0 txt Type MV Type RV 0 mvdata 0 rvdata1 0 mvlog 0 rvlog...

Страница 78: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 72 Type MV Type RV 0 mvsnap 0 rvsnap3 ...

Страница 79: ...erforming snapshot backup is described below The backup target data file and log file have already been paired and are running business operations In this example the data file and the log file are created in different volumes with a database name of snap Figure 6 16 Performing Disk Backup Business Server Data file Log file Metafile Master Volume MV Replication Volume RV ...

Страница 80: ...ecute replication for the current volume iSMrc_replicate file disklist0 txt wait iSMrc_replicate file snaplist0 txt wait Figure 6 17 Performing Replication Replication execution Data file MV RV MV MV RV RV Log file Metafile Data file 1 Data file 2 Data file 3 Log file 1 Log file 2 Log file 3 Metafile 1 Metafile 2 Metafile 3 ...

Страница 81: ...iness Server Remove the drive name for the metafile disk by executing the MOUNTVOL command to prevent new access When using a service to monitor the disk state it is necessary to stop the service before executing the MOUNTVOL command MOUNTVOL f D Procedure 4 Unmounting metafile disk Business Server Unmount the metafile disk and cancel association between volume and file system iSMrc_umount mvol Vo...

Страница 82: ...for the metafile disk Business Server Reconfigure the removed drive name for the metafile disk by executing the MOUNTVOL command MOUNTVOL f Volume d9ea193c 9d59 11d6 ab08 806d6172696f Procedure 7 Circulate the replication operation file Business Server move disklist2 txt save txt move disklist1 txt disklist2 txt move disklist0 txt disklist1 txt move save txt disklist0 txt move snaplist2 txt save t...

Страница 83: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 77 ...

Страница 84: ...ate Separate Connect Separate Separate Connect When executing backup hereafter start it from Procedure 1 disklist0 txt and snaplist0 txt are always in the current RV Figure 6 20 Circulation of Replication Operation File Data MV Data MV Backup first time Use Data1 Data2 and Data3 alternately Data3 Data3 Backup second time Backup third time Data3 ...

Страница 85: ...In the event that the transaction log has been backed up periodically recovery up until the transaction log is created is now possible if an error occurs on the log file disk If the transaction log backup file is lost recovery up until the transaction log backup is created is now impossible Save the transaction log backup file onto a highly reliable disk An example of this is that when an error oc...

Страница 86: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 80 Figure 6 21 Performing Recovery from Disk Backup ...

Страница 87: ...Mrc_flush drv f Procedure 4 Unmount the metafile disk Business Server Unmount the metafile disk and cancel the associations between the volume and the file system When using a service to monitor the disk state stop the service before unmounting iSMrc_umount drv f Procedure 5 Execute restoration Business Server Restore the latest backup file from the RV to the MV When executing a snapshot restorati...

Страница 88: ...the separation operation iSMsql_snapshotrst db snap metafile f snap dat file disklist0 txt remod norecovery mode protect Figure 6 23 Performing Snapshot Restoration 1 Save latest backup data to data file1 and log file1 Procedure 7 Apply the transaction log Business Server Apply the transaction log with Microsoft SQL Server 2000 The transaction log is applied in the sequence of performing backup of...

Страница 89: ...siness operations after making sure that Microsoft SQL Server 2000 operates normally Procedure 9 Backup extraction Business Server The program can be made to wait for the completion of automatic separation after synchronization has been completed as the result of restoration by way of the RV protection specification After completing the separation extract the necessary backup iSMrc_wait file diskl...

Страница 90: ... 1 O O Op p pe e er r ra a at t ti i io o on n n a a as s s S S St t ta a an n nd d db b by y y D D Da a at t ta a ab b ba a as s se e e Data resulting from snapshot backup can be used as the search database Data once restored for reference purposes in Microsoft SQL Server 2000 cannot be used as the backup data The backup target data and log files will have already been paired and replication will...

Страница 91: ... a service to monitor the disk state it is necessary to stop the service before executing the MOUNTVOL command MOUNTVOL d D MOUNTVOL e D Procedure 4 Execute file system flush of the search target disk Search Server Flush the file system of the search target disk and then write the still unwritten data in the file system buffer to the disk iSMrc_flush mvol Volume d9ea193d 9d59 11d6 ab08 806d6172696...

Страница 92: ...e backup commands by specifying the nocheck and rvuse immediate options When using a service to monitor the disk state it is necessary to stop the service before executing the snapshot backup Start the service after executing the snapshot backup MVs and RVs are separated creating metafiles in the shared disk iSMsql_snapshotbkup db snap metafile f snap dat nocheck rvuse immediate Replication Execut...

Страница 93: ...ute snapshot restoration Search Server Execute snapshot restoration with the search server The data copied as a backup through snapshot backup is restored as the standby database in the search server s Microsoft SQL Server 2000 iSMsql_snapshotrst db snap metafile f snap dat norestore remod standby refile g db_undo dat 6 6 6 3 3 3 2 2 2 L L Lo o og g g D D Di i is s st t tr r ri i ib b bu u ut t ti...

Страница 94: ... i ie e ed d d b b by y y U U Up p pd d da a at t te e e By making RVs of the master database the database can be separated and used by other servers RVs are used to build test environments etc Figure 6 27 Running as a Replication Database Business Server d snap e f snap d e Replication Server Used as a replication database Data file Data file Log file Log file Master Volume MV Replication Volume ...

Страница 95: ...ush the file system of the replication target disk on the replication server side and then write the still unwritten data in the file system buffer to the disk iSMrc_flush mvol Volume d9ea193d 9d59 11d6 ab08 806d6172696f iSMrc_flush mvol Volume d9ea193e 9d59 11d6 ab08 806d6172696f Procedure 4 Unmount the replication target disk Replication Server Unmount the replication target disk on the replicat...

Страница 96: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 90 Figure 6 28 Performing Replication ...

Страница 97: ...me for the replication target disk on the replication server side by executing the MOUNTVOL command MOUNTVOL d Volume d9ea193d 9d59 11d6 ab08 806d6172696f MOUNTVOL e Volume d9ea193e 9d59 11d6 ab08 806d6172696f Procedure 8 Mount the replication target disk Replication Server Mount the target disk on the RV side When using a service to monitor the disk state start the service after executing the unm...

Страница 98: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 92 data for the business server can be used by the replication server ...

Страница 99: ...log file in etc trace folder within installation folder of NEC Storage ReplicationControl Check the contents by using the text editor etc When errors occur Microsoft SQL Server 2000 outputs the contents of errors to the error log For details refer to Microsoft SQL Server 2000 Books Online 7 7 7 2 2 2 E E Er r rr r ro o or r rs s s R R Re e el l la a at t te e ed d d t t to o o D D Da a at t ta a a...

Страница 100: ...red disk can be used with the user name and the password executing the NEC Storage ReplicationControl SQL Option When executing the NEC Storage ReplicationControl SQL Option from NetBackup check the setup of the user name and the password that execute the NEC Storage ReplicationControl SQL Option of NetBackup The database file on the RV created with the snapshot backup needs to be restored by usin...

Страница 101: ...a flat file cannot exist in the same MV Because it is impossible to specify the static point of the flat file data inconsistency may occur 6 A metafile cannot be created in the volume in which database files mdf ndf ldf are stored 7 To improve error resistibility it is recommended that the data files mdf ndf and the log file ldf be allocated in the different logical volumes 8 Users of the Replicat...

Страница 102: ... are deleted before the metafile is created 12 The data replication operates in logical disk units Therefore when different database files exist in the logical disk all databases in the logical disk should be simultaneously operated Accordingly specify all databases in the logical disk as the operation targets 13 The NEC Storage ReplicationControl SQL Option is able to process up to 500 databases ...

Страница 103: ...nagement server 8 metadata 23 metafile 19 39 MSDB 16 22 MV 39 N NEC Storage DynamicDataReplication 2 4 9 NEC Storage Manager 3 9 NEC Storage PerformanceMonitor 3 NEC Storage RemoteDataReplication 2 4 9 NEC Storage ReplicationControl 2 5 9 16 19 42 NEC Storage ReplicationControl SQL Option 2 7 9 10 19 41 42 O operating environment 41 P parallel processing 6 12 13 primary data file 14 R replication ...

Страница 104: ...87 U uninstallation 42 update 42 W worker thread 44 ...

Отзывы: