DBA Maestro - Helpful DBA tips

Flashback database and backup scenario: ------------------------------------------------ If you flashback a database to a GRP (Guaranteed Restore Point) that has been set in the database, all backups that were taken after the GRP was created can no longer be used.  You can however restore the database to a point in time prior to the GRP creation. SQL> shutdown immediate startup mount flashback database to restore point TEST; Total System Global Area  384143360 bytes Fixed Size                  2154016 bytes Variable Size             301990368 bytes Database Buffers           75497472 bytes Redo Buffers                4501504 bytes Database mounted. SQL> Flashback complete. SQL> alter database open resetlogs; Database altered. Now you can restore and recover the database from any backup taken BEFORE the GRP was created.  See below: Recovery Manager: Release 11.1.0.7.0 - Production on Thu Dec 2 11:03:52 2010 Copyright (c) 1982, 2007, Oracle.  All rig

Symptoms When attempting to delete obsolete backups from RMAN using the following command: RMAN> delete obsolete;  the following error occurs: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 05/07/2008 22:04:21 RMAN-06091: no channel allocated for maintenance (of an appropriate type) . Cause Tape channel had not being allocated when attempt to delete obsolete backup on tape or disk. Using the following command to verify that there are backup sets on tape. RMAN> list backup;   This will show you the backup details informing you which channel device type that needs to be allocated. Solution To implement the solution, please execute the following steps: Please run the following commands to delete obsolete backup sets on both disk an