Oracle/admin

rman catalog 생성

소마후니 2015. 9. 14. 19:04

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>