数据泵备份目录: /u02/dmdir
dmrman备份目录: /u02/backup
归档目录: /u02/arch
#创建目录
mkdir -p /u02/backup
mkdir -p /u02/dmdir
mkdir -p /u02/arch
chown dmdba:dinstall /u02/backup
1. 数据泵备份
cd /home/opt/dmdbms/bin
--数据库备份
dexp USERID=sjj/db1234 FILE=sjj202140815.dmp DIRECTORY=/u02/dmdir LOG=sjj202140815e.log &
--数据库恢复
dimp sjj/db1234 FILE=sjj202140815.dmp DIRECTORY=/u02/dmdir LOG=sjj202140815i.log
2. dmrman备份恢复
--启动dmrman备份进程
cd /etc/rc.d/init.d
DmService+实例名 (例:DmServiceDMSERVER ) 。
./DmServiceDMSERVER start ( service DmServiceDMSERVER start)
--开启归档
alter database mount
alter database add archivelog 'type=local,dest=/u02/arch,file_size=64,space_limit=0';
alter database archivelog;
alter database open;
alter database archivelog current;
alter system archive log current
--查看
select name,arch_mode from v$database;
select * from v$dm_arch_ini;
--注册DAMP
[root@dm8 root]#./dm_service_installer.sh -t dmap
[dmdba@dm8 bak]$ DmAPService start
(如何没有注册DAMP 单开一个窗口启动dmap服务 [dmdba@localhost bin]$ ./dmap)
--开启备份服务
[dmdba@localhost bin]$ disql sysdba/dmdba
#全库备份
sql>backup database full backupset '/u02/backup/full.bak';
#增量备份
BACKUP DATABASE INCREMENT WITH BACKUPDIR '/u02/backup' BACKUPSET '/u02/backup/incre_bak';
--不提供在线还原
/etc/init.d/DmServiceDMSERVER stop
./bin/dmrestore INI_PATH=/home/dmdba/dmdbms/data/DAMENG/dm.ini FILE=/u02/backup/full.bak