The archive mode is also required for online backup of DM database. Rough looks very easy, as long as alterdatabasearchivelog. If you do this, you can't do online backup. You have to go to dmarch. in ini, restart the service. this dmarch. the ini content is empty by default, but in Windows, a dmarch_ex
The archive mode is also required for online backup of DM database. It seems very easy to be rough, As long as alter database archivelog. If you do this, you can't do online backup. You have to go to dmarch. in ini, restart the service. this dmarch. the ini content is empty by default, but in Windows, a dmarch_ex
The archive mode is also required for online backup of DM database. It seems very easy to be rough, As long as alter database archivelog. If you do this, you can't do online backup. You have to go to dmarch. in ini, restart the service. this dmarch. the ini content is empty by default, but in Windows, a dmarch_example.ini file is provided for example. There is no such thing in Linux, so it is wise to dream about Windows and then Linux. Windows is obviously better than Linux, but the performance is unclear.
To set the archive mode, follow these steps:
1. view the existing status
Connected to: DM 7.1.2.215SQL> select arch_mode from v$database;LINEID ARCH_MODE---------- ---------1 N used time: 1.709(ms). Execute id is 512.
2. generate an archive directory
Mkdir/opt/dmdbms/data/DMSERVER/arch
3. Go to the database directory and add these parameters in the blank dmarch. ini file.
[ARCHIVE_LOCAL1]ARCH_TYPE = LOCALARCH_DEST = /opt/dmdbms/data/DMSERVER/archARCH_FILE_SIZE = 128ARCH_SPACE_LIMIT = 0
4. Check dm. ini and let it know that dmarch. ini has taken effect.
A. cp dm. ini dm_bk.ini
B.
Method 1:
Vi dm. ini
You can change the parameter corresponding to ARCH_INI to 1 to enable
Method 2:
SQL>alter database mount;executed successfullyused time: 545.290(ms). Execute id is 0.SQL>alter database archivelog;executed successfullyused time: 2.191(ms). Execute id is 0.SQL>alter database open;executed successfullyused time: 523.332(ms). Execute id is 0.SQL>select arch_mode from v$database;LINEID ARCH_MODE---------- ---------1 Y used time: 1.360(ms). Execute id is 513.SQL>
# Configuration file MAL_INI = 0 # dmmal. ini ARCH_INI = 1 # dmarch. ini REP_INI = 0 # dmrep. ini LLOG_INI = 0 # dmllog. ini TIMER_INI = 0 # dmtimer. ini MPP_INI = 0 # DMMP p. ini5. Restart the serviceIf you do not restart, the existing running uses the parameters in the old dm. ini, that is, the archive directory and other related settings have not actually taken effect. Restart: in Linux: 1. If you use the following command to start, exit./dmserver/opt/dmdbms/data/DMSERVER/dm. ini or
./Dmserver/opt/dmdbms/data/DMSERVER/dm. ini-noconsole
Windows:
Restart here
6. Check whether the setting is successful.
Make an online backup to check whether the backup is successful.
Backup database full to dm_bak1 bakfile '/dmbak/dm_bak1 'backupinfo' xiongchuanliang ';
SQL>backup database full to dm_bak1 bakfile '/dmbak/dm_bak1' backupinfo 'xiongchuanliang'2 ;executed successfullyused time: 00:00:01.115. Execute id is 3.SQL>
To be honest, the DM documentation is really awesome. The above steps are difficult to find out after repeated information and attempts.