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; TABLE http://www.qingdao2000.com SPACE_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  http://www.wuhan2000.com 
posted @ 2013-04-22 05:35  chinadiy197601  阅读(290)  评论(0编辑  收藏  举报