oracle rman catalog目录数据库创建过程-Oracle

Oracle 21NN 4周前 (06-25) 4次浏览 未收录 0个评论 扫描二维码

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

 


21NN.CN , 版权所有丨如未注明 , 均为原创丨转载请注明原文链接:oracle rman catalog目录数据库创建过程-Oracle
喜欢 (0)
[1353713598@qq.com]
分享 (0)
关于作者:
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址