HOW TO CREATE CATALOG

CREATE TABLESPACE "TBCAT"
LOGGING
DATAFILE '/opt/ora9/oradata/cat/TBCAT.dbf' SIZE 5M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

ALTER DATABASE
DATAFILE '/opt/ora9/oradata/cat/TBCAT.dbf' AUTOEXTEND
ON NEXT 1M;

CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE tbcat
QUOTA UNLIMITED ON tbcat;

GRANT RECOVERY_CATALOG_OWNER TO rman;

GRANT CONNECT, RESOURCE TO rman;

rman target sys/oracle@pro catalog pro/pro@rman

CREATE CATALOG;
#create catalog tablespace pippo;
  
--register target with catalog
rman target sys@al9.fadalti catalog rman@ora9i.fadalti
register database;
--test with
report schema;
CONFIGURE CONTROLFILE AUTOBACKUP on;

HOW TO UNCATALOG
--From catalog instance
sqlplus rman/rman@ora9i.fadalti
SELECT DB_KEY, DB_ID FROM DB WHERE DB_ID = 1237603294;
EXECUTE dbms_rcvcat.unregisterdatabase(db_key, db_id)