DBMS_BACKUP_RESTORE.resetCfileSection() package:
-- Note that you can execute the following PL/SQL to remove all entries from V$RMAN_STATUS:
-- The preceding function removes all job-related entries. No rows will be visible until new backup jobs are shown in V$RMAN_BACKUP_JOB_DETAILS.
sqlplus / as sysdba
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(28);
commit;
-- Removing entries in v$DATABASE_BLOCK_CORRUPTION view
-- Be aware that the corrupted blocks will remain corrupted until we fix the block corruption issue.
-- Error: Bug 13386807 : RMAN BACKUP FAILED ORA-03114 ORA-07445: [KRBINSERTBCR()+665]
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(35);
-- Issue: V$DATABASE_BLOCK_CORRUPTION has rows referring to a non-existing datafile.
-- Removing entries in v$backup_corruption view
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(17);
-- Removing entries in v$copy_corruption view
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(18);
-- Removing entries in v$deleted_object view on RMAN catalog
-- Issue: RMAN backup is suddenly running very slowly after having deleted a large number of backupsets from catalog.
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(19);
-- Removing entries in v$archived_log view
-- Issue: Removing entries in v$archived_log referencing a particluar DEST_ID
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(11);
-- Removing entries in v$backup_spfile on RMAN catalog
-- RMAN Error: ORA-01400: cannot insert NULL into ("RMAN"."BSF"."MODIFICATION_TIME")
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(21);
Thursday, October 11, 2012
Subscribe to:
Post Comments (Atom)
4 comments:
Vijay, great and very useful information- Prashant
Yes Vijay, that's really getting into the raw fecal matter :-) :-)
Nobody had a clue about that, even Oracle support.
Zozimos
Very helpful, thanks.
Thanks
Post a Comment