본문 바로가기

Oracle/admin

rman catalog 생성

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 8 11:10:13 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_SID

orcl

ORACLE_HOME

/oracle/product/102/db_1

SQL> create tablespace cattbs datafile '/oracle/oradata/orcl/cat01.dbf' size 100m autoextend on;

Tablespace created.

SQL> create user rman identified by rman default tablespace cattbs quota unlimited on cattbs;

User created.

SQL> grant recovery_catalog_owner to rman;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost orcl]$ rman catalog rman/rman

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jul 8 11:12:28 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN>

'Oracle > admin' 카테고리의 다른 글

v$lock 뷰의 LMODE에 대해..  (0) 2015.09.14
Datafile rename  (0) 2015.09.14
LOB syntax  (0) 2015.09.14
Oracle8.1.0.7 -> Oracle9.2.0.1 Upgrade  (0) 2015.09.14
ORACLE11gR2 EM 설치  (0) 2015.09.14