DM (4) offline backup recovery

DM's offline backup mechanism should be simple, but it actually consumes a lot of time. Alas. Are Chinese software companies short of money and short of people? No one updates the document or makes some examples on the Forum, and does not do well in promotion. How can no one start the market? However, the only thing that is commendable is that their customer QQ group is still very powerful. I got it on Sunday, met

DM's offline backup mechanism should be simple, but it actually consumes a lot of time. Alas. Are Chinese software companies short of money and short of people? No one updates the document or makes some examples on the Forum, and does not do well in promotion. How can no one start the market? However, the only thing that is commendable is that their customer QQ group is still very powerful. I got it on Sunday, met

DM's offline backup mechanism should be simple, but it actually consumes a lot of time. Alas. Are Chinese software companies short of money and short of people?
No one updates the document or makes some examples on the Forum, and does not do well in promotion. How can no one start the market?
However, the only thing that is commendable is that their customer QQ group is still very powerful. I got it on Sunday and asked a question. Someone will answer it immediately.

In fact, DM offline backup design is very simple, in the document < > 275 page of this pdf file. It provides an example.
Dmbackup type = FULL INI_PATH = c: \ dmdata \ dameng \ dm. ini NAME = test

You follow the steps it says,
1. Stop the service,
In Windows: DM Service viewer-> stop the corresponding instance service.
In Linux: Stop./dmserver.

2. perform backup
DMBACKUP INI_PATH = C: \ dmdbms \ data \ DAMENG \ dm. ini NAME = DMSERVER
The first time is successful,
However, an error is reported during the second execution. You can restart the service and then stop and try again.
The reason is that the parameter "NAME" is actually equivalent to the backup set NAME in Oracle RMAN. DM database regards this
The unique identifier of a backup set. Therefore, when you perform the second operation, the database determines that the backup name already exists.
I mistakenly believe that this name is the database name.
Okay, I admit it's because I understand it wrong, but the second question is none of my business.


I tried to use the "BAKFILE_PATH" parameter to save the backup to a specified file.
The command is as follows:
DMBACKUP INI_PATH = C: \ dmdbms \ data \ DAMENG \ dm. ini NAME = DMSERVER8 BAKFILE_PATH = 'C: \ dmtest \ xcl. bak ';


The error "-8018" is always reported.
C: \ dmdbms \ bin> DMBACKUP INI_PATH = C: \ dmdbms \ data \ DAMENG \ dm. ini NAME = DMSERVER8 BAKFILE_PATH = 'C: \ dmtest \ xcl. bak ';
Backup V7.1.2.215-Build (2013.11.08-36626 trunc)
Global parameter value of HA_OTHER_INST_PORT is illegal, use max value!
Invalid backup path, backup error code:-8018
Backup time used: 2967.504 (MS)


Solution:
Put the NAME parameter after BAKFILE_PATH.
C: \ dmdbms \ bin \ dmbackup.exe INI_PATH = C: \ dmdbms \ data \ DAMENG \ dm. ini BAKFILE_PATH = C: \ dmtest \ xcl. bak NAME = DMSERVER8
This problem is because I have been wondering if the BAKFILE_PATH parameter is incorrect and I have tried many methods. No instructions are found on the document and the Web. Finally, DM customer base
. It is said that because the code is updated quickly and there are many customization tasks that cannot be done, the document update is not immediate. Although speechless, I still feel that Chinese databases have had a good time. List this

It is said that it has been sold abroad.

C:\Users\XCL>C:\dmdbms\bin\dmbackup.exe INI_PATH=C:\dmdbms\data\DAMENG\dm.ini BAKFILE_PATH=C:\dmtest\xcl.bak NAME=DMSERVER8backup V7.1.2.215-Build(2013.11.08-36626trunc)Global parameter value of HA_OTHER_INST_PORT is illegal, use max value!start backup tablespace: SYSTEM.start backup file: C:\dmdbms\data\DAMENG\SYSTEM.DBF, pages: 1280end backup file: C:\dmdbms\data\DAMENG\SYSTEM.DBFend backup tablespace: SYSTEM.start backup tablespace: ROLL.start backup file: C:\dmdbms\data\DAMENG\ROLL.DBF, pages: 0end backup file: C:\dmdbms\data\DAMENG\ROLL.DBFend backup tablespace: ROLL.start backup tablespace: MAIN.start backup file: C:\dmdbms\data\DAMENG\MAIN.DBF, pages: 0end backup file: C:\dmdbms\data\DAMENG\MAIN.DBFend backup tablespace: MAIN.start backup tablespace: BOOKSHOP.start backup file: C:\dmdbms\data\DAMENG\BOOKSHOP.DBF, pages: 0end backup file: C:\dmdbms\data\DAMENG\BOOKSHOP.DBFend backup tablespace: BOOKSHOP.backup fun end time used: 1928.889(ms)backup successfully!backup time used: 3797.014(ms)C:\Users\XCL>

Restore

First, check the parameters:


C: \ Users \ XCL> C: \ dmdbms \ bin \ dmrestore.exe help
Format: dmrestore keyword = value or KEYWORD = (value1, value2,..., valueN)


Routine: DMRESTORE INI_PATH = c: \ dm7data \ dameng \ dm. ini FILE = c: \ dm7data \ backup \ test. bak


Required parameter: FILE


Keyword description (default)
--------------------------------------------------------------------------------
INI_PATH: INIFILE path of the server
FILE backup FILE
MAPPED_FIL: When res_type is specified as 4, The ing information of the backup file is output to this file.
TIME Point of recovery
ARCHIVE_DIR format of the archive directory during Backup (dir1, dir2, dir3 ,...)
BACKUP_DIR backup file storage path, used to search the backup file format (dir1, dir2, dir3 ,...)
Specify the file path (id1, path1, id2, path2, id3, path3 ,...)
Specify the image file path (id1, path1, id2, path2, id3, path3 ,...)
Complete Directory Name of the PARALLEL_DIR parallel ing File
RES_TYPE Restore Type (0, 1, 2, 4) 0: backup file restore, 1: backup file display, 2: archive file restore, 3: One-step incremental restore, 4: output the backup ing file.
The END_LSN is restored to the specified LSN.
LOG output file restored by LOG
HELP print HELP information

Then, we find that we need to keep the following files and run the recovery command to restore them. Otherwise, we always prompt that there are fewer files, which is really different from Oracle.
That is to say, only the BOOKSHOP. dbf dameng directory can be deleted. The trace directory is the arch directory.
What's the purpose?

Only these files are deleted, and an error will be reported when only one file is deleted for restoration. The document does not explain the error.

C: \ dmdbms \ data \ DAMENG> the volume in the dir drive C is the OS volume serial number is the C8C0-48C4 C: \ dmdbms \ data \ DAMENG directory
  
   
.
   
    
.. 67,108,864 DAMENG01.log2014/01/07 67,108,864 DAMENG02.log2014/01/03 5,632 dm. ctl2014/01/03 22,214 dm. ini2014/01/04 127 dmarch. ini2014/01/03 633 dm_service.prikey2014/01/07 10,485,760 SYSTEM. DBF 7 files, 144,732,094 bytes, 2 directories, 65,555,996,672 available bytes
   
  

Resume execution

C:\dmdbms\data\DAMENG>C:\dmdbms\bin\dmrestore.exe  INI_PATH=C:\dmdbms\data\DAMENG\dm.ini  file=C:\dmtest\dmcold.bakrestore V7.1.2.215-Build(2013.11.08-36626trunc)Global parameter value of HA_OTHER_INST_PORT is illegal, use max value!backup DMSERVER10 info:backup sig:            BAbackup tool version:   12595backup db name:        DAMENGbackup db magic:       1388717456backup name:           DMSERVER10backup type:           fullbackup level:          offlinebackup range:          databasebackup description:compressed level:      0rac node:              0page check:            0length in char:        0backup time:           2014-01-07 14:34:20page size:             8 KBextent size:           16case sensitive:        1log page size:         512 Bunicode flag:          0data version:          0x70008sys version:           V7.1.2.215-Build(2013.11.08-36626trunc)enable policy:         0parallel type:         0parallel info len:     0backup db fil num:     4archive flag:          1after backup LSN:      25337file_seq   file_path                                                size(KB)1          C:\dmtest\dmcold.bak                                     16384file_seq   file_path                         mirror_path1          C:\dmdbms\data\DAMENG\SYSTEM.DBF2          C:\dmdbms\data\DAMENG\ROLL.DBF3          C:\dmdbms\data\DAMENG\MAIN.DBF4          C:\dmdbms\data\DAMENG\BOOKSHOP.DBFContinue?[Y/N]:yrestore bak_file: C:\dmtest\dmcold.bak ...start restore database...start restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM), pages: 278end restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM)start restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL), pages: 617end restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL)start restore file: C:\dmdbms\data\DAMENG\MAIN.DBF(MAIN), pages: 4end restore file: C:\dmdbms\data\DAMENG\MAIN.DBF(MAIN)start restore file: C:\dmdbms\data\DAMENG\BOOKSHOP.DBF(BOOKSHOP), pages: 133end restore file: C:\dmdbms\data\DAMENG\BOOKSHOP.DBF(BOOKSHOP)end restore database data files.restore finished, code = 0!restore successfully!restore time used: 3654.514(ms)               

After successful recovery

C: \ dmdbms \ data \ DAMENG> the volume in the dir drive C is the OS volume serial number is the C8C0-48C4 C: \ dmdbms \ data \ DAMENG directory
  
   
.
   
    
.. 157,286,400 BOOKSHOP. DBF2014/01/07 67,108,864 DAMENG01.log2014/01/07 67,108,864 DAMENG02.log2014/01/07 5,632 dm. ctl2014/01/07 22,214 dm. ini2014/01/04 127 dmarch. ini2014/01/07 156 dminst. sys2014/01/07 2,131 dmrestore. log2014/01/07 633 dm_service.prikey2014/01/07 134,217,728 MAIN. DBF2014/01/07 134,217,728 ROLL. DBF2014/01/07 10,485,760 SYSTEM. DBF2014/01/07 10,485,760 TEMP. DBF 13 files, 580,941,997 bytes, 2 directories, 65,117,458,432 available bytes