/* * enable debuging in rman */ $ rman target catalog debug trace=rman.trc log=rman.log RMAN> allocate channel for maintenance device type sbt_tape ; DELETE FORCE BACKUPSET 1436093 ; /* * checking RMAN CATALOG views */ set pagesize 2000 set markup html on alter session set NLS_DATE_FORMAT='DD-MM-YY HH24:MI:SS'; spool rman.html select sysdate from dual; select * from bs where bs_key=1436093; select * from bp where bs_key=1436093; select * from brl where bs_key=1436093; spool off set markup html off exit