rman全备份

--1.备份
run{
2> allocate channel d1 type disk format 'C:\BACKUP\%U';
3> allocate channel d2 type disk format 'E:\BACKUP\%U';
4> backup database filesperset 3;
5> release channel d1;
6> release channel d2;}

run{
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> backup database filesperset 3 format 'c:\aa%u_%s_%p';
5> release channel d1;
6> release channel d2;}

RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> backup full tag 'dbfull' format 'c:\pb9\lsf%u_%s_%p' database
5> include current controlfile;
6> sql 'alter system archive log current';
7> release channel c1;
8> release channel c2;
9> }

--2.恢复
c:\>rman
rman>connect target sys/pwd@server
RMAN> run{
2> allocate


channel c1 type disk;
3> restore database;
4> recover database;
5> sql 'alter database open';
6> release channel c1;
7> }

rman全备份相关文档

最新文档

返回顶部