SQL> CREATE SMALLFILE TABLESPACE “RMAN” DATAFILE ‘/opt/app/oracle/oradata/EMREP/datafile/rman01.dbf’ SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 500M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman; 2 3 4
User created.
SQL> GRANT connect, resource, recovery_catalog_owner TO rman;
Grant succeeded.
SQL> exit
oracle@huluokafa:/opt/app/oracle/product/11.2.0/dbhome_1/network/admin> rman catalog=rman/rman@emrep
Recovery Manager: Release 11.2.0.1.0 – Production on Tue Jul 5 08:54:15 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create catalog tablespace “RMAN”;
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete