Hi!
How do I make RMAN delete all obsolete backups? We are using a recovery catalog.
Example:
RMAN> report obsolete;
RMAN-03022: compiling command: report
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 523573 29012003-16:19:33
Backup Piece 523575 29012003-16:19:33 03ee44q5_1_1
Backup Set 525544 31012003-03:47:24
Backup Piece 525546 31012003-03:47:24 06ee80te_1_1
Backup Set 525545 31012003-08:04:25
Backup Piece 525547 31012003-08:04:25 07ee8d2m_1_1
Backup Set 526282 01022003-03:34:14
Backup Piece 526284 01022003-03:34:14 0aeealdg_1_1
Backup Set 526283 01022003-07:55:02
Backup Piece 526285 01022003-07:55:02 0beeb0m0_1_1
Backup Set 527884 04022003-03:52:28
Backup Piece 527886 04022003-03:52:28 0eeeiiig_1_1
Backup Set 527885 04022003-08:12:52
Backup Piece 527887 04022003-08:12:52 0feeius4_1_1
Backup Set 528851 05022003-03:51:41
Backup Piece 528853 05022003-03:51:41 0ieel6sk_1_1
Backup Set 528852 05022003-08:13:00
Backup Piece 528854 05022003-08:13:00 0jeelj6h_1_1
Backup Set 529486 06022003-03:43:12
Backup Piece 529488 06022003-03:43:12 0meenrds_1_1
Backup Set 529487 06022003-08:00:57
Backup Piece 529489 06022003-08:00:57 0neeo72i_1_1
Now I want to delete those obsolete backups...
RMAN> delete obsolete;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "obsolete": expecting one of: "expired, script"
RMAN-01007: at line 1 column 9 file: standard input
What would be the correct syntax?
This is 8.1.7 on solaris.
Thanks,
Helmut