上海网站建设一般多少钱,广西住房及城乡建设厅网站,网站建设文化方案,小猪导航1、检查磁盘空间
检查服务器磁盘空间使用情况#xff0c;确认磁盘有充足的空间存放物理备份。 查看磁盘空间使用情况#xff08;备份在端点0#xff0c;此处检查端点0#xff09; su - dmdba [dmdbacentos-04 ~]$ df -h 文件系统 容量 已用 可用 已用% …1、检查磁盘空间
检查服务器磁盘空间使用情况确认磁盘有充足的空间存放物理备份。 查看磁盘空间使用情况备份在端点0此处检查端点0 su - dmdba [dmdbacentos-04 ~]$ df -h 文件系统 容量 已用 可用 已用% 挂载点 /dev/mapper/centos-root 46G 18G 29G 38% / devtmpfs 1.9G 0 1.9G 0% /dev tmpfs 1.9G 0 1.9G 0% /dev/shm tmpfs 1.9G 9.3M 1.9G 1% /run tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup /dev/sda1 197M 149M 49M 76% /boot tmpfs 380M 12K 380M 1% /run/user/42 tmpfs 380M 0 380M 0% /run/user/0
2、检查dmap服务状态
检查数据库dmap服务运行状态确认管道服务dmap已正常开启。 1确定dmap服务状态 [dmdbacentos-04 ~]$ ps -ef|grep dmap|grep -v grep dmdba 960 1 0 23:39 ? 00:00:01 /dm/dmdbms/dm8/dm8/bin/dmap 注意未启动则执行步骤2命令手动开启 2开启dmap服务 su - dmdba cd /dm/dmdbms/dm8/bin ./DmAPService start
3、检查归档状态
检查数据库归档情况确认数据库归档已正常开启。 1检查归档是否已开启 SQL select * from v$dm_ini where para_name ARCH_INI; 行号 PARA_NAME PARA_VALUE MIN_VALUE MAX_VALUE MPP_CHK SESS_VALUE FILE_VALUE DESCRIPTION PARA_TYPE ---------- --------- ---------- --------- --------- ------- ---------- ---------- ----------- --------- 1 ARCH_INI 1 0 1 N 1 1 dmarch.ini SYS 2检查归档配置信息 SQL select * from V$DM_ARCH_INI; 行号 ARCH_NAME ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT ARCH_HANG_FLAG ---------- --------------- --------- -------------------------------------- -------------- ---------------- -------------- ARCH_TIMER_NAME ARCH_IS_VALID ARCH_WAIT_APPLY ARCH_INCOMING_PATH ARCH_CURR_DEST --------------- ------------- --------------- --------------------------------------- -------------------------------------- 1 ARCHIVE_LOCAL1 LOCAL /dm/dmarch/cbdsc/LOCAL_ARCH_cbdsc_DSC0 512 102400 1 NULL Y NULL NULL /dm/dmarch/cbdsc/LOCAL_ARCH_cbdsc_DSC0 2 ARCHIVE_REMOTE1 REMOTE CBDSC_DSC1 512 102400 1 NULL Y NULL /dm/dmarch/cbdsc/REMOTE_ARCH_cbdsc_DSC1 CBDSC_DSC1 3检查归档日志文件 SQLselect * from V$ARCHIVED_LOG;
4、做一次全备和增量备份 1模拟备份前写数据 #disql sysdba/dameng123 CREATE TABLE TAB_FOR_RECOVER(C1 INT,create_time datetime); BEGIN FOR I IN 1..100 LOOP INSERT INTO TAB_FOR_RECOVER VALUES(I,sysdate); COMMIT; END LOOP; END; / SQL select count(*) from TAB_FOR_RECOVER; 行号 COUNT(*) ---------- -------------------- 1 100 2做一次全备 BACKUP DATABASE TO WEEKLY_FULL_BAK BACKUPSET /dm/dmback/db_fullbak_01 DEVICE TYPE DISK BACKUPINFO db_fullbak MAXPIECESIZE 300 COMPRESSED LEVEL 1 PARALLEL 4; [dmdbacentos-04 cbdsc1_config]$ ls -rlt /dm/dmback/db_fullbak_01/ 总用量 260 drwxr-xr-x. 2 dmdba dinstall 61 7月 19 22:43 db_fullbak_01_0 drwxr-xr-x. 2 dmdba dinstall 61 7月 19 22:43 db_fullbak_01_2 drwxr-xr-x. 2 dmdba dinstall 61 7月 19 22:43 db_fullbak_01_1 -rw-r--r--. 1 dmdba dinstall 5632 7月 19 22:43 db_fullbak_01.bak -rw-r--r--. 1 dmdba dinstall 256000 7月 19 22:43 db_fullbak_01.meta 3模拟写入增量数据做增量备份 端点0 #disql sysdba/dameng123 BEGIN FOR I IN 101..200 LOOP INSERT INTO TAB_FOR_RECOVER VALUES(I,sysdate); COMMIT; END LOOP; END; / SQL alter system switch logfile; 操作已执行 SQL select checkpoint(100); 行号 CHECKPOINT(100) ---------- --------------- 1 0 端点1 #disql sysdba/dameng123 BEGIN FOR I IN 201..300 LOOP INSERT INTO TAB_FOR_RECOVER VALUES(I,sysdate); COMMIT; END LOOP; END; / SQL alter system switch logfile; 操作已执行 SQL select checkpoint(100); 行号 CHECKPOINT(100) ---------- --------------- 1 0 5、检查备份文件和归档有效性 1检查备份文件 [dmdbacentos-04 ~]$ cd /dm/dmback/db_fullbak_01 [dmdbacentos-04 db_fullbak_01]$ ls -rlt 总用量 260 drwxr-xr-x. 2 dmdba dinstall 61 7月 19 22:43 db_fullbak_01_0 drwxr-xr-x. 2 dmdba dinstall 61 7月 19 22:43 db_fullbak_01_2 drwxr-xr-x. 2 dmdba dinstall 61 7月 19 22:43 db_fullbak_01_1 -rw-r--r--. 1 dmdba dinstall 5632 7月 19 22:43 db_fullbak_01.bak -rw-r--r--. 1 dmdba dinstall 256000 7月 19 22:43 db_fullbak_01.meta 2检查备份文件有效性情况 su - dmdba cd /dm/dmdbms/dm8/bin/ ./dmrman dcr_ini/dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dmdcr0.ini #校验全备 RMAN check backupset /dm/dmback/db_fullbak_01; check backupset /dm/dmback/db_fullbak_01; CMD END.CODE:[0] check backupset successfully. #表示备份校验成功 time used: 295.941(ms) #校验增备 RMAN check backupset /dm/dmback/db_increment_bak_02; check backupset /dm/dmback/db_increment_bak_02; CMD END.CODE:[0] check backupset successfully. #表示备份校验成功 time used: 125.937(ms) 3校验归档有效性 [dmdbacentos-04 0719_arch]$ dmrachk ARCH_PATH/dm/dmarch/0719_arch rachk V8 the database pmnt_magic: 1661664700 the database db_magic: 429043589 /*******************************************************************/ ... 归档文件/dm/dmarch/0719_arch/ARCH_REMOTE1_0x1992AF85[1]_2023-07-19_23-54-25.log明细. version : 0x7006 status : INACTIVE enc_flag : FALSE n_rpkgs : 4 pmnt_magic : 1661664700 db_magic : 429043589 src_db_magic : 429043589 arch_lsn : 149651 arch_seq : 2848 clsn : 154729 next_seq : 2851 g_next_seq : 2851 file len : 521728 file free : 521728 dsc seqno : 1 dsc node : 2 create time : 2023-07-19 23:50:26.638211 close time : 2023-07-19 23:54:56.021349 /*******************************************************************/ 概要节点[1]: 总计: 11 个文件 正确: 11 个文件 错误: 0 个文件 重复: 0 个文件 the rachk tool running cost 122.962 ms #检查未出现错误或归档不连续问题
6、关闭数据库 su - dmdba cd /dm/dmdbms/dm8/bin #登录监视器关闭数据库服务 [dmdbacentos-04 bin]$ dmcssm ep stop GRP_DSC #检查数据库服务状态 ps –ef|grep dmserver
7、还原备份 su - dmdba cd /dm/dmdbms/dm8/bin ./dmrman dcr_ini/dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dmdcr0.ini #直接restore增量备份会自动去找全备还原 RMAN restore database /dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dm.ini from backupset /dm/dmback/db_increment_bak_02 TASK THREAD 2; restore database /dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dm.ini from backupset /dm/dmback/db_increment_bak_02 TASK THREAD 2; file dm.key not found, use default license! Read ini warning, default backup path [/dm/dmback/cbdsc_DSC0] does not exist. checking if the DSC database under system path [DMDATA/data/cbdsc_DSC] is running with vote disk.... EP [0] is checking.... EP [1] is checking.... RESTORE DATABASE CHECK...... RESTORE DATABASE,dbf collect...... RESTORE DATABASE,dbf refresh ...... RESTORE BACKUPSET [/dm/dmback/db_fullbak_01/db_fullbak_01_0] START...... total 1 packages processed... RESTORE BACKUPSET [/dm/dmback/db_fullbak_01/db_fullbak_01_2] START...... total 1 packages processed... RESTORE BACKUPSET [/dm/dmback/db_fullbak_01/db_fullbak_01_1] START...... total 1 packages processed... total 11 packages processed... RESTORE BACKUPSET [/dm/dmback/db_increment_bak_02] START...... total 19 packages processed... total 20 packages processed... RESTORE DATABASE,UPDATE ctl file...... RESTORE DATABASE,REBUILD key file...... RESTORE DATABASE,CHECK db info...... RESTORE DATABASE,UPDATE db info...... total 20 packages processed... total 20 packages processed! CMD END.CODE:[0] restore successfully. time used: 00:00:08.764 将端点0和端点1增量备份之后的归档都拷贝端点0的/dm/dmarch/0719_arch目录 #应用增量备份之后的归档日志 [dmdbacentos-04 0719_arch]$ RMAN recover database /dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dm.ini with archivedir /dm/dmarch/0719_arch; recover database /dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dm.ini with archivedir /dm/dmarch/0719_arch; file dm.key not found, use default license! Read ini warning, default backup path [/dm/dmback/cbdsc_DSC0] does not exist. checking if the DSC database under system path [DMDATA/data/cbdsc_DSC] is running with vote disk.... EP [0] is checking.... EP [1] is checking.... Database mode 0, oguid 0 EP[0]s cur_lsn[147407] EP[1]s cur_lsn[147407] EP[0] adjust cur_lsn from [147407] to [147407] EP:1 total 1 pkgs applied, percent: 11% EP:1 total 2 pkgs applied, percent: 22% EP:0 total 22 pkgs applied, percent: 10% EP:0 total 44 pkgs applied, percent: 20% EP:0 total 66 pkgs applied, percent: 30% EP:0 total 88 pkgs applied, percent: 40% EP:0 total 110 pkgs applied, percent: 50% EP:1 total 3 pkgs applied, percent: 33% EP:1 total 4 pkgs applied, percent: 44% EP:1 total 5 pkgs applied, percent: 55% EP:0 total 132 pkgs applied, percent: 60% EP:0 total 154 pkgs applied, percent: 70% EP:0 total 176 pkgs applied, percent: 80% EP:0 total 198 pkgs applied, percent: 90% EP:0 total 218 pkgs applied, percent: 100% EP:1 total 6 pkgs applied, percent: 66% EP:1 total 7 pkgs applied, percent: 77% EP:1 total 8 pkgs applied, percent: 88% EP:1 total 9 pkgs applied, percent: 100% Recover from archive log finished, time used:6.845s. EP(0) slot ctl page(1, 0, 16) trxid[35534], pseg_state[0] EP(1) slot ctl page(1, 0, 17) trxid[35111], pseg_state[0] EP[0]s apply_lsn[154729] end_lsn[147408] EP[1]s apply_lsn[154729] end_lsn[147407] recover successfully! time used: 00:00:13.314 #更新db_magic RMAN recover database /dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dm.ini update db_magic; recover database /dm/dmdbms/dm8/dsc_config/cbdsc_DSC0/dm.ini update db_magic; Read ini warning, default backup path [/dm/dmback/cbdsc_DSC0] does not exist. checking if the DSC database under system path [DMDATA/data/cbdsc_DSC] is running with vote disk.... EP [0] is checking.... EP [1] is checking.... Database mode 0, oguid 0 EP[0]s cur_lsn[154729] EP[1]s cur_lsn[154729] EP[0] adjust cur_lsn from [154729] to [154729] EP[0]s apply_lsn[154729] end_lsn[147408] EP[1]s apply_lsn[154729] end_lsn[147407] EP(0) slot ctl page(1, 0, 16) trxid[35534], pseg_state[0] EP(1) slot ctl page(1, 0, 17) trxid[35111], pseg_state[0] recover successfully! time used: 00:00:07.153
8、启动数据库 su - dmdba cd /dm/dmdbms/dm8/bin #进入监视器启动数据库服务 ./dmcssm ep startup GRP_DSC #查看集群和数据库相关状态 show [monitor] 2023-07-20 00:17:31: Wait CSS Control Node choosed succeed. monitor current time:2023-07-20 00:17:31, n_group:3 group[name GRP_CSS, seq 0, type CSS, Control Node 0] [CSS0] global info: [ASM0] auto restart TRUE [cbdsc_DSC0] auto restart FALSE [CSS1] global info: [ASM1] auto restart TRUE [cbdsc_DSC1] auto restart FALSE ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts 2023-07-20 00:17:30 CSS0 0 1286 Control Node OPEN WORKING OK TRUE 923599632 923601713 2023-07-20 00:17:30 CSS1 1 1286 Normal Node OPEN WORKING OK TRUE 923601282 923603361 group[name GRP_ASM, seq 1, type ASM, Control Node 0] n_ok_ep 2 ok_ep_arr(index, seqno): (0, 0) (1, 1) sta OPEN, sub_sta STARTUP break ep NULL recover ep NULL crash process over flag is TRUE ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts 2023-07-20 00:17:30 ASM0 0 1276 Control Node OPEN WORKING OK TRUE 923630562 923632562 2023-07-20 00:17:30 ASM1 1 1277 Normal Node OPEN WORKING OK TRUE 923631817 923633813 group[name GRP_DSC, seq 2, type DB, Control Node 0] n_ok_ep 2 ok_ep_arr(index, seqno): (0, 0) (1, 1) sta OPEN, sub_sta STARTUP break ep NULL recover ep NULL crash process over flag is TRUE ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts 2023-07-20 00:17:30 cbdsc_DSC0 0 1236 Control Node OPEN WORKING OK TRUE 406094557 406096517 2023-07-20 00:17:30 cbdsc_DSC1 1 1236 Normal Node OPEN WORKING OK TRUE 406095657 406097612 #检查数据库服务状态 ps –ef|grep dmserver #登录数据库验证连接正常 SQL select status$ from v$instance; 行号 STATUS$ ---------- ------- 1 OPEN
达梦在线服务平台https://eco.dameng.com
