oracle 9i catalog 怎么备份集,oracle 9i rman catalog 指南

oracle 9i rman catalog 指南

rman的简单使用: catalog的建立，全备份，保留备份策略，删除过期备份。

1. 查看当前数据库的数据文件

SQL> select name from V$datafile;

NAME

--------------------------------------------------------------------------------

/Oracle/oracle9i/oradata/testmysiteok/system01.dbf

/oracle/oracle9i/oradata/testmysiteok/undotbs01.dbf

/oracle/oracle9i/oradata/testmysiteok/cwmlite01.dbf

/oracle/oracle9i/oradata/testmysiteok/drsys01.dbf

/oracle/oracle9i/oradata/testmysiteok/example01.dbf

/oracle/oracle9i/oradata/testmysiteok/indx01.dbf

/oracle/oracle9i/oradata/testmysiteok/odm01.dbf

/oracle/oracle9i/oradata/testmysiteok/tools01.dbf

/oracle/oracle9i/oradata/testmysiteok/users01.dbf

/oracle/oracle9i/oradata/testmysiteok/xdb01.dbf

/oracle/oradata/webdb_file1.dbf

NAME

--------------------------------------------------------------------------------

/oracle/oradata/webdb_file2.dbf

/oracle/oradata/webdb_file3.dbf

/oracle/oradata/webdb_file4.dbf

14 rows selected.

2. 建立catalog表空间为back_up

SQL> create tablespace back_up datafile '/oracle/oradata/catalog.dbf' size 50m;

Tablespace created.

3. 建立rman用户密码为rman,rman默认的表空间为back_up,使用临时表空间temp

SQL> create user rman identified by rman default tablespace back_up temporary tablespace temp;

User created.