1.创建表空间
SQL> create tablespace cata datafile '/u01/app/oracle/oradata/demo1/catalog_01.dbf' size 360M;
2.创建用户并赋予权限
SQL> create user cata identified by cata default tablespace cata;
SQL> grant connect,resource to cata;
SQL> grant recovery_catalog_owner to cata;
3.创建catalog
C:\Documents and Settings\una>rman catalog cata/cata@demo1
RMAN> create catalog tablespace cata;
4.连接到catalog
C:\Documents and Settings\una>rman target sys/sysdba@demo1
RMAN> connect catalog cata/cata@demo1
或
C:\Documents and Settings\una>rman target sys/sysdba@demo1 catalogcata/cata@demo1
5.注册
RMAN> register database;
6.验证
RMAN> list incarnation;
7.同步数据库控制文件和catalog
RMAN> resync catalog;
8.将数据库重置为incarnation 5
RMAN> reset database to incarnation 5;
9.完全备份数据库
RMAN> run {
allocate channel d1 device type disk;
backup as compressed backupset
format='/u01/rmanbackup/full_%d_%U'
tag='fullbak'
channel=d1
database plus archivelog delete input;
}
10.0级备份
RMAN> run {
allocate channel d1 device type disk;
backup as compressed backupset
incremental level=0
tag='inc0'
channel=d1
database plus archivelog;
}
11. 1级差异增量备份
RMAN> run {
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> incremental level=1
5>
6> format='/u01/rmanbackup/inc1_%d_%U'
7> tag='inc1'
8> channel=d1
9> database;
10> release channel d1;
11> }
12. 累计性1级增量备份
RMAN> run {
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> incremental level=1 cumulative
5> format='/u01/rmanbackup/cum1_%d_%U'
6> tag='cum1'
7> channel=d1
8> database;
9> release channel d1;
10> }
13.备份表空间
RMAN> run {
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> format='/u01/rmanbackup/tbs_%d_%U'
5> tag='tbs'
6> channel=d1
7> tablespace users,app1,system;
8> release channel d1;
9> }
14.备份数据文件
RMAN> run {
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> format='/u01/rmanbackup/tbs_%d_%U'
5> tag='tbs'
6> channel=d1
7>datafile 1;
8> release channel d1;
9> }