oracle rman 目录,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

=========================================================================

四、删除catalog

SQL> drop user rman cascade;

User dropped.

RMAN> drop catalog;

recovery catalog owner is

enter DROP CATALOG command again to confirm catalog removal

SQL> drop tablespace rman_wolf including contents and datafiles;  Tablespace dropped.