Operation of millennium 32 database backup

Short Description

to lay down the procedure for operation of millennium32 database backup. 

sub category : Quality control  

Description

1.0    purpose:

1.1    to lay down the procedure for operation of millennium32 database backup.

2.0    scope:

2.1    this sop is applicable for quality control department.

3.0    responsibility:

3.1    administrator -  millennium

4.0    accountability:

4.1    manager – qc 

5.0    procedure:

5.1    hot backup procedure:

5.1.1    select start button located on the left bottom corner of the screen.  select the option “run…”.  run dialog box appears.
5.1.2    in the run dialog box, enter cmd and click ok.   the command prompt window appears.
5.1.3    enter the following command:

5.1.3.1    c:> d:millenniumscriptcs_hottape.bat tape

5.1.4    backup process initializes and continue until the backup is complete.  do not close the window while backup is in progress.

5.2    cold backup procedure:

5.2.1    select start button located on the left bottom corner of the screen.  select the option “run…”.  run dialog box appears.
5.2.2    in the run dialog box, enter cmd and lick ok.  the command prompt window appears.
5.2.3    enter the following command:

5.2.3.1    c:> d:millenniumscriptcs_coldtape.bat tape

5.2.4    backup process initializes and continue until the backup is complete.  do not close the window while backup is in progress.

note: all acquisitions will be shut down during the cold back, make sure that all instruments are closed during the cold backup.

5.3    hot backup schedule:

5.3.1    on each working day at between 3.00 pm to 5.00 pm, except thursday.

5.4    cold backup schedule:

5.4.1    on each thursday at 9.00 am to 11.00 am

 


6.0    rotating media procedure:

6.1    use 6 tapes for backup.  rotate the tapes in sequence.  for example monday through sunday between 9.00 am to 2.00 pm for hot backup and on thursday between 4.00 pm to 6.00 pm for cold backup as using the media listed in table-1.  make sure that backup process is not running during rotating the media.
6.2    backup should be logged in logbook by name, time and date.
6.3    containing media has label on it for backup period & authorized signatures.

7.0    glassory:

7.1    hot backup:

7.1.1    a backup in which the database remains running while the backup is performed.  this type of backup is essential for an environment that operates 24 hours, 7 days a week.  also known as online database backup.

7.2    cold backup:

7.2.1    a backup performed while the database is shutdown to ensure that no processes are active within the database.  also known as an offline database backup.

7.3    backup: 

7.3.1    the process of storing data offline to protect it from loss in case of mechanical failure.

 

Tags

database, millennium, coldtape

References

View / Download

Document

Related Articles