网站价格_南宁网页制作_营销百度app下载手机版_怎么弄属于自己的网站

环境准备

• 测试环境数据库服务器

还原恢复步骤

1.拷贝数据库备份到测试环境

• 包含增量备份文件，全量备份文件和归档日志文件。

scp -r /data_share/data_back/DB_PPDMDB_FULL_2024_05_01_02_00_46       dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_01_03_00_46  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_02_03_00_46  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_03_03_00_46  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_04_03_00_46  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_05_03_00_47  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_06_03_00_48  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_07_03_00_49  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_08_03_00_50  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_09_03_00_50  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_10_03_00_50  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_11_03_00_51  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_12_03_00_52  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_13_03_00_52  dmdba@172.16.7.91:/dmbak
scp -r /data_share/data_back/DB_PPDMDB_INCREMENT_2024_05_14_03_00_52  dmdba@172.16.7.91:/dmbak
scp -r /dm_data/dm5236/archdsc/ARCHIVE_LOCAL1_0x554C3D77[0]_2024-05-04_16-02-57.log dmdba@172.16.7.91:/dmarch
scp -r /dm_data/dm5236/archdsc/ARCHIVE_LOCAL1_0x554C3D77[0]_2024-05-09_12-05-55.log dmdba@172.16.7.91:/dmarch

2.初始化新的数据库实例

dminit path=/dmdata port_num=5237

3.指定时间还原恢复数据库

./dmrman
restore database '/dmdata/DAMENG/dm.ini' from backupset '/dmbak/DB_PPDMDB_INCREMENT_2024_05_14_03_00_52'
recover database '/dmdata/DAMENG/dm.ini' with archivedir '/dmarch' until time '2024-05-13 08:00:00'
recover database '/dmdata/DAMENG/dm.ini' update db_magic

4.启动数据库

dmserver /dmdata/DAMENG/dm.ini

5.注册数据库自启服务

cd /dm8/scripts
./dm_service_installer.sh -t dmserver -dm_ini /dmdata/DAMENG/dm.ini -p DAMENG

6.启动数据库

DmServiceDAMENG start

还原恢复到12号的备份，不指定具体时间

DmServiceDAMENG stop./dmrmanrestore database '/dmdata/DAMENG/dm.ini' from backupset '/dmbak/DB_PPDMDB_INCREMENT_2024_05_12_03_00_52'recover database '/dmdata/DAMENG/dm.ini' from backupset '/dmbak/DB_PPDMDB_INCREMENT_2024_05_12_03_00_52'
recover database '/dmdata/DAMENG/dm.ini' update db_magic退出dmrmanDmServiceDAMENG start