oracle 9i 备份与恢复

rman 部分

1:建立catalog表空间为back_up

su - oracle

sqlplus /nolog

conn /as sysdba

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

2:建立rman密码。默认表空间为back_up，使用临时表空间temp

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

3:rman授权 

SQL> grant connect,resource,recovery_catalog_owner to rman;

4:创建catalog表空间到back_up

rman