RMAN catalog and uncatalog examples

--RMAN catalog and uncatalog examples
--Catalog
RMAN>CATALOG ARCHIVELOG '/oracle/oradata/dbname/a_1_1883.arc', '/oracle/oradata/dbname/a_1_1885.arc';

RMAN>CATALOG DATAFILECOPY '/oradata/backup/data01.dbf' LEVEL 0;

RMAN>CATALOG CONTROLFILECOPY '/oradata/backup/ctl01.ctl';

RMAN>CATALOG START WITH '/backups/bkp_db' NOPROMPT;

RMAN>CATALOG RECOVERY AREA NOPROMPT;
or
RMAN>CATALOG DB_RECOVERY_FILE_DEST;


RMAN>CATALOG BACKUPPIECE '/u02/oradata/dbname/bkp_piece_name';


--Uncatalog
RMAN>CHANGE ARCHIVELOG ALL UNCATALOG;

RMAN>CHANGE BACKUP OF TABLESPACE TBS_DATA01 UNCATALOG;

RMAN>CHANGE BACKUPPIECE '+DG_DATA/bakup/offr423' UNCATALOG;

ORA-30006: resource busy; acquire with WAIT timeout expired XA Conecction Oracle Retail

If you are facing erros like ORA-30006: resource busy; acquire with WAIT timeout expired when trying to connect to a a XA service, Kill inactive sessions on your database , restart XA service using (srvctl or crs_stop/crs_start) and reload database listeners.

It works for me!

Best Regards,
Paulo Portugal

Dropping Grid Control Repository

If you are reinstalling Grid Control you need to drop old repository using this command below:

./RepManager hostname 1526 ORACLESID -action drop -sys_password sys_password

Best Regards,
Paulo Portugal