联机备份

 

Rman target=sys/password

rman>run { allocate channel c1 device type disk format ‘c:/backup/ora_%U’;

                    backup database plus archivelog; }  --备份库

 

backup tablespace users include current controlfile plus archivelog;  --备份表空间

 

backup datafile 5;                                          --备份数据文件

backup datafile ‘d:/oracle10/oradata/users01.dbf’ plus archivelog;

 

backup archivelog all;                                       --备份日志文件

backup archivelog from time ‘sysdate -3’; from sequence 555;

backup archivelog all delete input;                                                               --删除备份过的日志

backup archivelog all delete input until time ‘sysdate -2’           --归档日志保留天数

 

backup spfile;

backup current controlfile;

 

差异备份

Backup incremental level=1 database; tablespace or datafile

 

积累备份

Backup incremental level-2 cumulative database; tablespace or datafile