Database Backup and Recovery (MOSC)

MOSC Banner

delete obsolete backupsets;

edited Dec 5, 2009 5:34AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
This was posted by user4445 in the documents area:

My Prod DB v10.2.0.3 .0  on linux.
I'm using a centrale catalog in EM Grid 10g. 10.2.0.3.0 

Rman target rmandba@emrep
Rman connect target .


RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 14 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           69047  07-SEP-08        
  Backup Piece       69483  07-SEP-08          EIGS-OracleFullBackupDB<EIGS_3345:664806494:1>.dbf
Backup Set           69049  07-SEP-08        
  Backup Piece       69485  07-SEP-08          EIGS-OracleFullBackupDB<EIGS_3347:664806557:1>.dbf
Backup Set           69050  07-SEP-08        
  Backup Piece       69486  07-SEP-08          EIGS-OracleFullBackupDB<EIGS_3348:664807113:1>.dbf
Backup Set           69051  07-SEP-08        
  Backup Piece       69487  07-SEP-08          EIGS-OracleFullBackupDB<EIGS_3349:664807509:1>.dbf

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center