创建catalog

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> }