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;
T ablespace created.
3. 建立rman用户密码为rman,rman默认的表空间为back_up,使用临时表空间temp
SQL> create user rman identified by rman default tablespace back_up temmporary tablespace temp;
create user rman identified by rman default tablespace back_up temmporary tablespace temp
*
ERROR at line 1:
ORA-00922: missing or invalid option