NEC Storage ReplicationControl SQL Option, User Manual

Page 1: ...NEC Storage ReplicationControl SQL Option User s Manual ...

Page 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 ...

Page 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...

Page 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 ...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 54: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 48 ...

Page 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...

Page 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 ...

Page 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 ...

Page 58: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 52 Figure 6 5 Snapshot Backup ...

Page 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 ...

Page 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 ...

Page 61: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 55 ...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 70: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 64 ...

Page 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...

Page 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 ...

Page 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 ...

Page 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 ...

Page 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...

Page 76: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 70 ...

Page 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...

Page 78: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 72 Type MV Type RV 0 mvsnap 0 rvsnap3 ...

Page 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 ...

Page 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 ...

Page 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...

Page 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...

Page 83: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 77 ...

Page 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 ...

Page 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...

Page 86: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 80 Figure 6 21 Performing Recovery from Disk Backup ...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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...

Page 96: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 90 Figure 6 28 Performing Replication ...

Page 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...

Page 98: ...Chapter 6 Operations of NEC Storage ReplicationControl SQL Option 92 data for the business server can be used by the replication server ...

Page 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...

Page 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...

Page 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...

Page 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 ...

Page 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 ...

Page 104: ...87 U uninstallation 42 update 42 W worker thread 44 ...