SQL>conn /as sysdba
SQL>create user rman identified by rman;
SQL>grant connect,resource to rman;
SQL>grant recovery_catalog_owner to rman;

c:>rman
#进入rman,并以rman用户登录
rman>connect catalog rman/rman
#创建恢复目录
rman>create catalog;

#或者
c:>rman target sys/sys@resorce_dtzx catalog rman/rman

#注册目标数据库
rman>register database

#将目标数据库与恢复目录进行同步化
#该操作保证目标库与恢复目录的控制文件的同步化。系统莫认7天左右同步一次.
rman>resync catalog;

2.RMAN命令分类
#启动关闭数据库
rman>shutdown immediate
rman>startup
rman>startup force
rman>startup mount force
rman>startup mount pfile=/$ORACLE_HOME/.../initora9i.ora
rman>alter database open

#数据库备份与恢复命令

rman>copy datefile 2 to 'd:backupundotbs.dbf'
rman>backup database;
rman>backup tablespace tools;
rman>restore database;
rman>recover database;
rman>restore tablespace tools;
rman>recover tablespace tools;

#恢复目录维护命令
rman>report schema;
rman>list copy;
rman>change datafilecopy 'd:backupundotbs.dbf' delete
rman>backup tablespace users;
rman>list backup;
rman>delete backup;

#
#使用copy命令备份数据库
#
#使用自动通道备份数据文件以及控制文件
RMAN> copy
2> DATAFILE 1 TO '/oracle/copy_data/datafile_1.dbf',
3> DATAFILE 2 TO '/oracle/copy_data/datafile_2.dbf',
4> DATAFILE 3 TO '/oracle/copy_data/datafile_3.dbf',
5> DATAFILE 4 TO '/oracle/copy_data/datafile_4.dbf',
6> CURRENT CONTROLFILE TO '/oracle/copy_data/control_cp.ctl';

#
#使用backup命令备份数据库
#
#备份数据库,忽略只读表空间
rman>backup database skip readnoly;

#备份数据库,而不备份所有离线表空间
rman>bakcup database skip offline

#备份数据库,忽略只读以及离线的表空间
rman>backup database skip offline skip readonly;

#制定备份文件格式
#默认情况下,数据库备份方式是全备份方式?
rman>backup database format '/oracle/bakcup/%U';

#backup增量备份
rman>backup incremental level= <0,1,2,3> DATABASE;
rman>backup incremental level =0 database;

#仅备份系统表空间system自最近一次1级增量备份以后改变的数据块
rman>backup incremental level =1 tablespace system;

#仅备份表空间sales自最近一次1级或0级以后改变的数据块
rman>backup incremental levle = 2 cumulative tablespace sales;

8.使用Rman恢复数据库
.RESTORE:将备份数据复制到指定目录
.RECOVER:对数据库实施同步恢复.

#语法格式
rman>restore