rman入门实践！

rman入门实践！

rman入门实践！ 环境：win2k server; oracle 817

1 将target数据库置于归档模式

更改init.ora

2 建catalog库

3 在target,catalog上分别建表空间，用户，分配权限

SQL> create tablespace rman_ts datafile d:\oracle\oradata\rman\rman_ts.dbf" size 20M;

SQL> create user rman identified by rman default tablespace rman_ts temporary tablespace temp quota unlimited on rman_ts;

SQL> grant recovery_catalog_owner to rman;

SQL> grant connect, resource to rman;

4 在catalog端创建恢复目录

C:\>rman catalog rman/rman

RMAN>create catalog tablespace rman_ts;

5 在恢复目录中注册

C:\>rman target internal/oracle@his catalog rman/rman@rman

RMAN> register database;

6 全备脚本

RMAN> run {

2> # backup the complete database to disk

3> allocate channel dev1 type disk;

4> backup

5> full

6> tag full_db_backup

7> format "/oracle/backups/db_t%t_s%s_p%p"

8> (database);

9> release channel dev1;

10> }

引用：http://oraasp.vicp.net/article/article.aspx?ID=107