oracle rman catalog目录数据库创建过程
oracle rman catalog目录数据库创建过程
一、创建catalog需要的表空间
SQL> create tablespace rman_wolf datafile '/oracle/ora10g/oradata/wolf/rmanwolf.dbf' size 20m;
Tablespace created.
查看表空间是否创建成功
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
RMAN_WOLF
6 rows selected.
SQL>
二、创建用户
SQL> create user rman identified by rman default tablespace rman_wolf quota unlimited on rman_wolf;
User created.
查看用户是否创建成功及状态
SQL> select username,account_status from dba_users
2 ;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
SCOTT OPEN
RMAN OPEN
OUTLN EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DMSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
TSMSYS EXPIRED & LOCKED
22 rows selected.
三、授权
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.
SQL> grant connect to rman;
Grant succeeded.
SQL> grant dba to rman;
Grant succeeded.
查看角色拥有的权限
SQL> select * from dba_sys_privs where grantee='RECOVERY_CATALOG_OWNER';
GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
ADMIN_OPT
---------
RECOVERY_CATALOG_OWNER CREATE SYNONYM
NO
RECOVERY_CATALOG_OWNER CREATE CLUSTER
NO
RECOVERY_CATALOG_OWNER ALTER SESSION
NO
GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
ADMIN_OPT
---------
RECOVERY_CATALOG_OWNER CREATE DATABASE LINK
NO
RECOVERY_CATALOG_OWNER CREATE PROCEDURE
NO
RECOVERY_CATALOG_OWNER CREATE SEQUENCE
NO
GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
ADMIN_OPT
---------
RECOVERY_CATALOG_OWNER CREATE TABLE
NO
RECOVERY_CATALOG_OWNER CREATE SESSION
NO
RECOVERY_CATALOG_OWNER CREATE TYPE
NO
GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
ADMIN_OPT
---------
RECOVERY_CATALOG_OWNER CREATE VIEW
NO
RECOVERY_CATALOG_OWNER CREATE TRIGGER
NO
11 rows selected.
四、创建恢复目录
[oracle@redhat ~]$ rman target / catalog rman/rman
Recovery Manager: Release 10.2.0.1.0 - Production on 星期五 4月 19 10:14:11 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: WOLF (DBID=3778783462)
connected to recovery catalog database
RMAN> create catalog tablespace rman_wolf;
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
