创建恢复目录
为恢复目录创建表空间:
SQL> CREATE TABLESPACE "RMANTABS" DATAFILE '/u01/app/oracle/oradata/test/rman01.dbf' SIZE 100M
创建用户:
SQL> create user rman identified by rman default tablespace rmantabs;
给用户赋予相应权限:
SQL> grant connect to rman;
SQL> alter user rman quota unlimited on rmantabs;
SQL> grant recovery_catalog_owner to rman;
用rman连接目录库:
[oracle@localhost ~]$ rman catalog rman/rman@test target /
RMAN> create catalog tablespace rmantabs;
RMAN> register database;
创建虚拟用户,并给虚拟用户 分配需要维护的 target 数据库:
SQL> create user ztp identified by ztp default tablespace rmantabs;
SQL> GRANT recovery_catalog_owner TO ztp;
RMAN> CONNECT CATALOG rman/rman@test;
RMAN> grant catalog for database "TEST" to ztp;
RMAN> CONNECT CATALOG ztp/ztp@test;
RMAN> CREATE VIRTUAL CATALOG;
为恢复目录创建表空间:
SQL> CREATE TABLESPACE "RMANTABS" DATAFILE '/u01/app/oracle/oradata/test/rman01.dbf' SIZE 100M
创建用户:
SQL> create user rman identified by rman default tablespace rmantabs;
给用户赋予相应权限:
SQL> grant connect to rman;
SQL> alter user rman quota unlimited on rmantabs;
SQL> grant recovery_catalog_owner to rman;
用rman连接目录库:
[oracle@localhost ~]$ rman catalog rman/rman@test target /
RMAN> create catalog tablespace rmantabs;
RMAN> register database;
创建虚拟用户,并给虚拟用户 分配需要维护的 target 数据库:
SQL> create user ztp identified by ztp default tablespace rmantabs;
SQL> GRANT recovery_catalog_owner TO ztp;
RMAN> CONNECT CATALOG rman/rman@test;
RMAN> grant catalog for database "TEST" to ztp;
RMAN> CONNECT CATALOG ztp/ztp@test;
RMAN> CREATE VIRTUAL CATALOG;