/*
 * create RMAN CATALOG
 *
 * Backup and Recovery Advanced User's Guide 10.2
 */

sqlplus /nolog
connect / as sysdba

create tablespace tbs_rman datafile 'D:/oradata/dbs/rmanrep/RMAN01.dbf'
size 50M autoextend on
maxsize 150M;

set pages 999
col tablespace_name for a40
col file_name for a40
select tablespace_name, file_name from dba_data_files;

/*
TABLESPACE_NAME                          FILE_NAME
---------------------------------------- ----------------------------------------
SYSTEM                                   D:\ORADATA\DBS\RMANREP\SYSTEM01.DBF
UNDOTBS1                                 D:\ORADATA\DBS\RMANREP\UNDOTBS01.DBF
SYSAUX                                   D:\ORADATA\DBS\RMANREP\SYSAUX01.DBF
USERS                                    D:\ORADATA\DBS\RMANREP\USERS01.DBF
TBS_RMAN                                 D:\ORADATA\DBS\RMANREP\RMAN01.DBF
/*


CREATE USER rman IDENTIFIED BY rman;

ALTER USER rman 
  temporary tablespace temp
  default tablespace tbs_rman
  quota unlimited on tbs_rman;


GRANT RECOVERY_CATALOG_OWNER TO rman;

exit

-- rman
rman 
CONNECT catalog rman/rman@rmanrep
CREATE CATALOG tablespace tbs_rman;
exit

-- sqlplus
connect rman/rman@rmanrep

/*
 * REGISTER DATABASE into RC
 */
rman
connect target 
connect catalog rman/rman@rmanrep
register database;
report schema;