ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman备份基础

rman备份基础

原创 Linux操作系统 作者:zx285567221 时间:2012-01-20 10:58:14 0 删除 编辑

RMAN> show all;


配置controlfile为自动备份
RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored


还原默认模式
RMAN> configure controlfile autobackup clear;

RMAN configuration parameters are successfully reset to default value


备份数据文件
RMAN> backup datafile '/oracle/oradata/orclgg/users01.dbf' format '/oracle/backup/df_%U';


备份表空间
RMAN> backup tablespace users format  '/oracle/backup/ts_%U';


修改备份路径
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup/ctl_%F';

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE

DISK TO '/oracle/backup/ctl_%F';
new RMAN configuration parameters are successfully stored


单独备份控制文件
RMAN> backup current controlfile;

备份数据文件和当前控制文件
SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ----------------------------------------
         1 /oracle/oradata/orclgg/system01.dbf
         2 /oracle/oradata/orclgg/undotbs01.dbf
         3 /oracle/oradata/orclgg/sysaux01.dbf
         4 /oracle/oradata/orclgg/users01.dbf

RMAN> backup datafile 4 include current controlfile;


备份spfile
RMAN> backup spfile;


备份归档日志文件
RMAN> backup archivelog all format '/oracle/backup/ac_%U';

 

归档和数据一起备份
backup database plus archivelog format '/oracle/backup/db_%U';

并发备份

SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ----------------------------------------
         1 /oracle/oradata/orclgg/system01.dbf
         2 /oracle/oradata/orclgg/undotbs01.dbf
         3 /oracle/oradata/orclgg/sysaux01.dbf
         4 /oracle/oradata/orclgg/users01.dbf

RMAN> run {
2>      allocate channel c1 type disk;
3>      allocate channel c2 type disk;
4>      allocate channel c3 type disk;
5>      backup incremental level=0
6>      format '/oracle/backup/p_%U'
7>      (datafile 1 channel c1 tag='sys')
8>      (datafile 2 channel c2 tag='aux')
9>      (datafile 3,4 channel c3 tag='other');
10>     sql 'alter system archive log current';
11> }

released channel: ORA_DISK_1
allocated channel: c1
channel c1: sid=141 devtype=DISK

allocated channel: c2
channel c2: sid=146 devtype=DISK

allocated channel: c3
channel c3: sid=159 devtype=DISK

Starting backup at 01-SEP-11
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracle/oradata/orclgg/system01.dbf
channel c1: starting piece 1 at 01-SEP-11
channel c2: starting incremental level 0 datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00002 name=/oracle/oradata/orclgg/undotbs01.dbf
channel c2: starting piece 1 at 01-SEP-11
channel c3: starting incremental level 0 datafile backupset
channel c3: specifying datafile(s) in backupset
input datafile fno=00003 name=/oracle/oradata/orclgg/sysaux01.dbf
input datafile fno=00004 name=/oracle/oradata/orclgg/users01.dbf
channel c3: starting piece 1 at 01-SEP-11
channel c3: finished piece 1 at 01-SEP-11
piece handle=/oracle/backup/p_0imlg275_1_1 tag=OTHER comment=NONE
channel c3: backup set complete, elapsed time: 00:00:25
channel c1: finished piece 1 at 01-SEP-11
piece handle=/oracle/backup/p_0gmlg273_1_1 tag=SYS comment=NONE
channel c1: backup set complete, elapsed time: 00:00:34
channel c2: finished piece 1 at 01-SEP-11
piece handle=/oracle/backup/p_0hmlg273_1_1 tag=AUX comment=NONE
channel c2: backup set complete, elapsed time: 00:00:34
Finished backup at 01-SEP-11

Starting Control File and SPFILE Autobackup at 01-SEP-11
piece handle=/oracle/backup/ctl_c-2257414742-20110901-05 comment=NONE
Finished Control File and SPFILE Autobackup at 01-SEP-11

sql statement: alter system archive log current
released channel: c1
released channel: c2
released channel: c3

将并发改为三个
RMAN> configure device type disk parallelism 3 backup type to backupset;

增量备份
RMAN> run {
2>      allocate channel d1 type disk;
3>      backup incremental level 0 database format '/oracle/backup/l0_%U';
4> }

 

查看时间超过6秒的操作
SQL> desc v$session_longops;
SQL> select sid,sofar,totalwork from  v$session_longops;




 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25604225/viewspace-715129/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle恢复基础
请登录后发表评论 登录
全部评论

注册时间:2011-04-07

  • 博文量
    6
  • 访问量
    10232