Home » RDBMS Server » Backup & Recovery » RMAN not removing backups (10g r2, RH linux)
RMAN not removing backups [message #565987] Mon, 10 September 2012 05:45 Go to next message
candi
Messages: 30
Registered: July 2012
Member
RMAN is not removing obsolete backups and now the backup directory is nearly full.
Retention policy is 1, however, there are backups more than 6 weeks old still in the backup directory.
crosscheck and delete obsolete commands run every night, and I have also run these manually, yet the backup files still remain.
It is like RMAN is not aware of their existance.
How can I confirm that RMAN does not need them and therefore delete them manually using OS commands.
Re: RMAN not removing backups [message #565996 is a reply to message #565987] Mon, 10 September 2012 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use RESTORE with one of the following option (http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta051.htm#sthref796)

Quote:
There are other uses of RESTORE that do not actually restore files from backup:
•RESTORE... VALIDATE causes RMAN to select existing backups that it would use to perform a RESTORE operation, and scan them all to ensure that they are present and free of corruption.
•RESTORE... PREVIEW identifies the backups which RMAN will use to perform any RESTORE operation. Output from a RESTORE... PREVIEW is in the same format as the output of the LIST command.
•RESTORE... PREVIEW RECALL is used to request the recall of backups needed for a RESTORE operation that are stored on remote storage.


Regards
Michel
Re: RMAN not removing backups [message #566003 is a reply to message #565996] Mon, 10 September 2012 06:42 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
Thank you very much Michel...is there any reason why RMAN would not remove these backups?
Re: RMAN not removing backups [message #566006 is a reply to message #566003] Mon, 10 September 2012 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a missing inc 0 backup for instance.

Regards
Michel
Re: RMAN not removing backups [message #566024 is a reply to message #566006] Mon, 10 September 2012 10:05 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
no missing backups at all, very strange, only started happening 6 weeks ago.
Re: RMAN not removing backups [message #566027 is a reply to message #566024] Mon, 10 September 2012 10:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you say so.
Execute a VALIDATE/PREVIEW and post the result.

Regards
Michel
Re: RMAN not removing backups [message #566030 is a reply to message #566027] Mon, 10 September 2012 10:34 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
RMAN>
Starting restore at 10-SEP-12
using channel ORA_DISK_1


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27486 Incr 0 2.75G DISK 00:15:07 08-SEP-12
BP Key: 27486 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793483205_87606_p1
List of Datafiles in backup set 27486
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 0 Incr 4411102479 08-SEP-12 /DB1/users01.dbf
72 0 Incr 4411102479 08-SEP-12 /DB1/sample.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27487 Incr 0 5.77G DISK 00:29:20 08-SEP-12
BP Key: 27487 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793483205_87608_p1
List of Datafiles in backup set 27487
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
58 0 Incr 4411102481 08-SEP-12 /DB1/sampletbs03.dbf
74 0 Incr 4411102481 08-SEP-12 /DB1/sampletbs09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27488 Incr 0 5.87G DISK 00:30:00 08-SEP-12
BP Key: 27488 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793483205_87607_p1
List of Datafiles in backup set 27488
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
59 0 Incr 4411102480 08-SEP-12 /DB1/sampletbs04.dbf
73 0 Incr 4411102480 08-SEP-12 /DB1/sampletbs08.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27489 Incr 0 6.06G DISK 00:32:45 08-SEP-12
BP Key: 27489 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793483205_87605_p1
List of Datafiles in backup set 27489
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
10 0 Incr 4411102478 08-SEP-12 /DB1/sampleidx03.dbf
68 0 Incr 4411102478 08-SEP-12 /DB1/sampletbs03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27490 Incr 0 5.52G DISK 00:32:55 08-SEP-12
BP Key: 27490 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793483205_87609_p1
List of Datafiles in backup set 27490
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
9 0 Incr 4411102482 08-SEP-12 /DB1/sampleidx02.dbf
71 0 Incr 4411102482 08-SEP-12 /DB1/sampletbs06.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27491 Incr 0 6.03G DISK 00:33:00 08-SEP-12
BP Key: 27491 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793483205_87604_p1
List of Datafiles in backup set 27491
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
8 0 Incr 4411102476 08-SEP-12 /DB1/sampleidx01.dbf
67 0 Incr 4411102476 08-SEP-12 /DB1/sampletbs02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27492 Incr 0 5.78G DISK 00:23:24 08-SEP-12
BP Key: 27492 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793484120_87610_p1
List of Datafiles in backup set 27492
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
60 0 Incr 4411106850 08-SEP-12 /DB1/sampletbs05.dbf
75 0 Incr 4411106850 08-SEP-12 /DB1/sampletbs10.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27493 Incr 0 3.96G DISK 00:15:37 08-SEP-12
BP Key: 27493 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793485186_87615_p1
List of Datafiles in backup set 27493
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
11 0 Incr 4411112065 08-SEP-12 /DB1/lobzz_tbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27494 Incr 0 5.77G DISK 00:21:39 08-SEP-12
BP Key: 27494 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793484966_87611_p1
List of Datafiles in backup set 27494
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
61 0 Incr 4411110751 08-SEP-12 /DB1/sampletbs06.dbf
77 0 Incr 4411110751 08-SEP-12 /DB1/sampletbs12.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27495 Incr 0 3.34G DISK 00:23:11 08-SEP-12
BP Key: 27495 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793485011_87612_p1
List of Datafiles in backup set 27495
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 0 Incr 4411110937 08-SEP-12 /DB1/dynamic01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27496 Incr 0 3.16G DISK 00:24:01 08-SEP-12
BP Key: 27496 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793485176_87613_p1
List of Datafiles in backup set 27496
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 0 Incr 4411111927 08-SEP-12 /DB1/dynamic02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27497 Incr 0 3.24G DISK 00:24:13 08-SEP-12
BP Key: 27497 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793485183_87614_p1
List of Datafiles in backup set 27497
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
7 0 Incr 4411111939 08-SEP-12 /DB1/dynamic03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27498 Incr 0 3.87G DISK 00:30:21 08-SEP-12
BP Key: 27498 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793485532_87616_p1
List of Datafiles in backup set 27498
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
12 0 Incr 4411114365 08-SEP-12 /DB1/lobzz_tbs02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27499 Incr 0 3.88G DISK 00:36:14 08-SEP-12
BP Key: 27499 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793486127_87617_p1
List of Datafiles in backup set 27499
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
13 0 Incr 4411119639 08-SEP-12 /DB1/lobzz_tbs03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27500 Incr 0 3.90G DISK 00:37:46 08-SEP-12
BP Key: 27500 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793486272_87618_p1
List of Datafiles in backup set 27500
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
14 0 Incr 4411121174 08-SEP-12 /DB1/lobzz_tbs04.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27501 Incr 0 3.86G DISK 00:37:35 08-SEP-12
BP Key: 27501 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793486407_87619_p1
List of Datafiles in backup set 27501
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
15 0 Incr 4411122090 08-SEP-12 /DB1/lobzz_tbs05.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27502 Incr 0 3.77G DISK 00:24:28 08-SEP-12
BP Key: 27502 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793487363_87622_p1
List of Datafiles in backup set 27502
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
18 0 Incr 4411129571 08-SEP-12 /DB1/lobzz_tbs08.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27503 Incr 0 3.87G DISK 00:42:59 08-SEP-12
BP Key: 27503 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793486622_87620_p1
List of Datafiles in backup set 27503
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
16 0 Incr 4411123292 08-SEP-12 /DB1/lobzz_tbs06.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27504 Incr 0 3.83G DISK 00:42:55 08-SEP-12
BP Key: 27504 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793486638_87621_p1
List of Datafiles in backup set 27504
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
17 0 Incr 4411123545 08-SEP-12 /DB1/lobzz_tbs07.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27505 Incr 0 4.30G DISK 00:16:39 08-SEP-12
BP Key: 27505 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793488669_87625_p1
List of Datafiles in backup set 27505
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
41 0 Incr 4411134823 08-SEP-12 /DB1/lobzz_tbs17.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27506 Incr 0 406.65M DISK 00:01:35 08-SEP-12
BP Key: 27506 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489672_87629_p1
List of Datafiles in backup set 27506
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
45 0 Incr 4411138549 08-SEP-12 /DB1/dynamic06.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27507 Incr 0 4.33G DISK 00:16:53 08-SEP-12
BP Key: 27507 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793488834_87626_p1
List of Datafiles in backup set 27507
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
42 0 Incr 4411135299 08-SEP-12 /DB1/lobzz_tbs18.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27508 Incr 0 331.71M DISK 00:01:22 08-SEP-12
BP Key: 27508 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489768_87630_p1
List of Datafiles in backup set 27508
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
46 0 Incr 4411138992 08-SEP-12 /DB1/dynamic07.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27509 Incr 0 3.80G DISK 00:26:07 08-SEP-12
BP Key: 27509 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793488309_87623_p1
List of Datafiles in backup set 27509
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
19 0 Incr 4411133353 08-SEP-12 /DB1/lobzz_tbs09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27510 Incr 0 3.88G DISK 00:23:39 08-SEP-12
BP Key: 27510 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793488544_87624_p1
List of Datafiles in backup set 27510
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
20 0 Incr 4411134242 08-SEP-12 /DB1/lobzz_tbs10.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27511 Incr 0 410.33M DISK 00:02:08 08-SEP-12
BP Key: 27511 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489853_87632_p1
List of Datafiles in backup set 27511
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
47 0 Incr 4411139249 08-SEP-12 /DB1/dynamic08.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27512 Incr 0 618.93M DISK 00:03:44 08-SEP-12
BP Key: 27512 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489853_87631_p1
List of Datafiles in backup set 27512
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
39 0 Incr 4411139248 08-SEP-12 /DB1/dynamic04.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27513 Incr 0 4.32G DISK 00:18:58 08-SEP-12
BP Key: 27513 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489217_87628_p1
List of Datafiles in backup set 27513
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
44 0 Incr 4411136899 08-SEP-12 /DB1/lobzz_tbs20.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27514 Incr 0 4.41G DISK 00:19:13 08-SEP-12
BP Key: 27514 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489210_87627_p1
List of Datafiles in backup set 27514
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
43 0 Incr 4411136894 08-SEP-12 /DB1/lobzz_tbs19.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27515 Incr 0 2.24G DISK 00:18:23 08-SEP-12
BP Key: 27515 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489988_87635_p1
List of Datafiles in backup set 27515
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
35 0 Incr 4411139896 08-SEP-12 /DB1/lobzz_tbs13.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27516 Incr 0 2.48G DISK 00:20:48 08-SEP-12
BP Key: 27516 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489878_87633_p1
List of Datafiles in backup set 27516
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
31 0 Incr 4411139461 08-SEP-12 /DB1/lobzz_tbs11.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27517 Incr 0 307.51M DISK 00:01:12 08-SEP-12
BP Key: 27517 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491136_87640_p1
List of Datafiles in backup set 27517
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
48 0 Incr 4411145290 08-SEP-12 /DB1/dynamic09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27518 Incr 0 490.59M DISK 00:02:14 08-SEP-12
BP Key: 27518 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491101_87639_p1
List of Datafiles in backup set 27518
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
40 0 Incr 4411145065 08-SEP-12 /DB1/dynamic05.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27519 Incr 0 2.42G DISK 00:21:41 08-SEP-12
BP Key: 27519 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793489973_87634_p1
List of Datafiles in backup set 27519
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
32 0 Incr 4411139734 08-SEP-12 /DB1/lobzz_tbs12.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27520 Incr 0 2.22G DISK 00:20:38 08-SEP-12
BP Key: 27520 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793490083_87636_p1
List of Datafiles in backup set 27520
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
36 0 Incr 4411140202 08-SEP-12 /DB1/lobzz_tbs14.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27521 Incr 0 2.16G DISK 00:09:58 08-SEP-12
BP Key: 27521 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491326_87644_p1
List of Datafiles in backup set 27521
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 0 Incr 4411146212 08-SEP-12 /DB1/sysaux01.dbf
34 0 Incr 4411146212 08-SEP-12 /DB1/objbackup_tbs01.dbf
51 0 Incr 4411146212 08-SEP-12 /DB1/lobzz_tbs21.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27522 Incr 0 3.70G DISK 00:30:09 08-SEP-12
BP Key: 27522 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793490358_87637_p1
List of Datafiles in backup set 27522
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
37 0 Incr 4411141480 08-SEP-12 /DB1/lobzz_tbs15.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27523 Incr 0 3.68G DISK 00:30:38 08-SEP-12
BP Key: 27523 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793490365_87638_p1
List of Datafiles in backup set 27523
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
38 0 Incr 4411141484 08-SEP-12 /DB1/lobzz_tbs16.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27524 Incr 0 3.96G DISK 00:16:31 08-SEP-12
BP Key: 27524 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491281_87643_p1
List of Datafiles in backup set 27524
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
49 0 Incr 4411145998 08-SEP-12 /DB1/dynamic10.dbf
56 0 Incr 4411145998 08-SEP-12 /DB1/sampletbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27525 Incr 0 5.65G DISK 00:23:10 08-SEP-12
BP Key: 27525 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491211_87641_p1
List of Datafiles in backup set 27525
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
57 0 Incr 4411145766 08-SEP-12 /DB1/sampletbs02.dbf
76 0 Incr 4411145766 08-SEP-12 /DB1/sampletbs11.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27526 Incr 0 6.07G DISK 00:25:31 08-SEP-12
BP Key: 27526 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491236_87642_p1
List of Datafiles in backup set 27526
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
69 0 Incr 4411145780 08-SEP-12 /DB1/sampletbs04.dbf
70 0 Incr 4411145780 08-SEP-12 /DB1/sampletbs05.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27527 Incr 0 4.74G DISK 00:21:25 08-SEP-12
BP Key: 27527 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793491932_87645_p1
List of Datafiles in backup set 27527
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
24 0 Incr 4411148505 08-SEP-12 /DB1/hot_idx01.dbf
26 0 Incr 4411148505 08-SEP-12 /DB1/tulz01.dbf
28 0 Incr 4411148505 08-SEP-12 /DB1/logmnrts01.dbf
52 0 Incr 4411148505 08-SEP-12 /DB1/lobzz_tbs22.dbf
54 0 Incr 4411148505 08-SEP-12 /DB1/lobzz_tbs24.dbf
64 0 Incr 4411148505 08-SEP-12 /DB1/sampletbs09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27528 Incr 0 2.84G DISK 00:13:19 08-SEP-12
BP Key: 27528 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793492603_87649_p1
List of Datafiles in backup set 27528
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
66 0 Incr 4411150929 08-SEP-12 /DB1/sampletbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27529 Incr 0 3.95G DISK 00:21:49 08-SEP-12
BP Key: 27529 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793492277_87648_p1
List of Datafiles in backup set 27529
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 0 Incr 4411149890 08-SEP-12 /DB1/undotbs01.dbf
21 0 Incr 4411149890 08-SEP-12 /DB1/cool01.dbf
25 0 Incr 4411149890 08-SEP-12 /DB1/drsys01.dbf
53 0 Incr 4411149890 08-SEP-12 /DB1/lobzz_tbs23.dbf
55 0 Incr 4411149890 08-SEP-12 /DB1/lobzz_tbs25.dbf
63 0 Incr 4411149890 08-SEP-12 /DB1/sampletbs08.dbf
78 0 Incr 4411149890 08-SEP-12 /DB1/dba_tbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27530 Incr 0 4.22G DISK 00:23:16 08-SEP-12
BP Key: 27530 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793492212_87647_p1
List of Datafiles in backup set 27530
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 4411149607 08-SEP-12 /DB1/syst.dbf
27 0 Incr 4411149607 08-SEP-12 /DB1/xdb01.dbf
29 0 Incr 4411149607 08-SEP-12 /DB1/formula_01.dbf
33 0 Incr 4411149607 08-SEP-12 /DB1/style01.dbf
50 0 Incr 4411149607 08-SEP-12 /DB1/dynamic11.dbf
62 0 Incr 4411149607 08-SEP-12 /DB1/sampletbs07.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27531 Incr 0 4.34G DISK 00:24:18 08-SEP-12
BP Key: 27531 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_0
Piece Name: /backups/DB1/bck_up_793492177_87646_p1
List of Datafiles in backup set 27531
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
22 0 Incr 4411149392 08-SEP-12 /DB1/cool_idx01.dbf
23 0 Incr 4411149392 08-SEP-12 /DB1/hot01.dbf
30 0 Incr 4411149392 08-SEP-12 /DB1/stag01.dbf
65 0 Incr 4411149392 08-SEP-12 /DB1/sampletbs10.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27541 Incr 1 10.16M DISK 00:11:13 09-SEP-12
BP Key: 27541 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793569605_87661_p1
List of Datafiles in backup set 27541
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 1 Incr 4412536880 09-SEP-12 /DB1/users01.dbf
72 1 Incr 4412536880 09-SEP-12 /DB1/sample.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27542 Incr 1 104.19M DISK 00:13:53 09-SEP-12
BP Key: 27542 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793569605_87662_p1
List of Datafiles in backup set 27542
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
59 1 Incr 4412536881 09-SEP-12 /DB1/sampletbs04.dbf
73 1 Incr 4412536881 09-SEP-12 /DB1/sampletbs08.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27543 Incr 1 103.68M DISK 00:13:54 09-SEP-12
BP Key: 27543 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793569605_87663_p1
List of Datafiles in backup set 27543
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
58 1 Incr 4412536882 09-SEP-12 /DB1/sampletbs03.dbf
74 1 Incr 4412536882 09-SEP-12 /DB1/sampletbs09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27544 Incr 1 88.04M DISK 00:17:39 09-SEP-12
BP Key: 27544 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793569605_87659_p1
List of Datafiles in backup set 27544
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
8 1 Incr 4412536878 09-SEP-12 /DB1/sampleidx01.dbf
67 1 Incr 4412536878 09-SEP-12 /DB1/sampletbs02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27545 Incr 1 120.59M DISK 00:18:55 09-SEP-12
BP Key: 27545 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793569605_87664_p1
List of Datafiles in backup set 27545
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
9 1 Incr 4412536883 09-SEP-12 /DB1/sampleidx02.dbf
71 1 Incr 4412536883 09-SEP-12 /DB1/sampletbs06.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27546 Incr 1 111.60M DISK 00:19:53 09-SEP-12
BP Key: 27546 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793569605_87660_p1
List of Datafiles in backup set 27546
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
10 1 Incr 4412536879 09-SEP-12 /DB1/sampleidx03.dbf
68 1 Incr 4412536879 09-SEP-12 /DB1/sampletbs03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27547 Incr 1 102.44M DISK 00:08:43 09-SEP-12
BP Key: 27547 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570281_87665_p1
List of Datafiles in backup set 27547
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
60 1 Incr 4412539551 09-SEP-12 /DB1/sampletbs05.dbf
75 1 Incr 4412539551 09-SEP-12 /DB1/sampletbs10.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27548 Incr 1 104.24M DISK 00:07:46 09-SEP-12
BP Key: 27548 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570446_87666_p1
List of Datafiles in backup set 27548
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
61 1 Incr 4412540262 09-SEP-12 /DB1/sampletbs06.dbf
77 1 Incr 4412540262 09-SEP-12 /DB1/sampletbs12.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27549 Incr 1 11.30M DISK 00:05:52 09-SEP-12
BP Key: 27549 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570802_87670_p1
List of Datafiles in backup set 27549
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
11 1 Incr 4412541591 09-SEP-12 /DB1/lobzz_tbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27550 Incr 1 3.30M DISK 00:14:47 09-SEP-12
BP Key: 27550 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570446_87667_p1
List of Datafiles in backup set 27550
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 1 Incr 4412540263 09-SEP-12 /DB1/dynamic01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27551 Incr 1 2.54M DISK 00:18:52 09-SEP-12
BP Key: 27551 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570671_87668_p1
List of Datafiles in backup set 27551
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 1 Incr 4412541125 09-SEP-12 /DB1/dynamic02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27552 Incr 1 3.05M DISK 00:19:03 09-SEP-12
BP Key: 27552 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570746_87669_p1
List of Datafiles in backup set 27552
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
7 1 Incr 4412541351 09-SEP-12 /DB1/dynamic03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27553 Incr 1 48.00K DISK 00:15:56 09-SEP-12
BP Key: 27553 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793571340_87674_p1
List of Datafiles in backup set 27553
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
15 1 Incr 4412543691 09-SEP-12 /DB1/lobzz_tbs05.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27554 Incr 1 11.30M DISK 00:29:13 09-SEP-12
BP Key: 27554 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570805_87671_p1
List of Datafiles in backup set 27554
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
12 1 Incr 4412541593 09-SEP-12 /DB1/lobzz_tbs02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27555 Incr 1 11.26M DISK 00:31:31 09-SEP-12
BP Key: 27555 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793570920_87672_p1
List of Datafiles in backup set 27555
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
13 1 Incr 4412542033 09-SEP-12 /DB1/lobzz_tbs03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27556 Incr 1 7.95M DISK 00:31:58 09-SEP-12
BP Key: 27556 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793571155_87673_p1
List of Datafiles in backup set 27556
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
14 1 Incr 4412543003 09-SEP-12 /DB1/lobzz_tbs04.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27557 Incr 1 32.00K DISK 00:14:49 09-SEP-12
BP Key: 27557 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793572297_87677_p1
List of Datafiles in backup set 27557
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
18 1 Incr 4412550189 09-SEP-12 /DB1/lobzz_tbs08.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27558 Incr 1 80.00K DISK 00:04:13 09-SEP-12
BP Key: 27558 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573074_87680_p1
List of Datafiles in backup set 27558
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
41 1 Incr 4412555384 09-SEP-12 /DB1/lobzz_tbs17.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27559 Incr 1 40.00K DISK 00:25:50 09-SEP-12
BP Key: 27559 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793571805_87675_p1
List of Datafiles in backup set 27559
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
16 1 Incr 4412546656 09-SEP-12 /DB1/lobzz_tbs06.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27560 Incr 1 32.00K DISK 00:04:40 09-SEP-12
BP Key: 27560 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573189_87681_p1
List of Datafiles in backup set 27560
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
42 1 Incr 4412556126 09-SEP-12 /DB1/lobzz_tbs18.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27561 Incr 1 40.00K DISK 00:27:00 09-SEP-12
BP Key: 27561 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793571891_87676_p1
List of Datafiles in backup set 27561
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
17 1 Incr 4412547155 09-SEP-12 /DB1/lobzz_tbs07.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27562 Incr 1 32.00K DISK 00:14:12 09-SEP-12
BP Key: 27562 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793572818_87679_p1
List of Datafiles in backup set 27562
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
20 1 Incr 4412553708 09-SEP-12 /DB1/lobzz_tbs10.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27563 Incr 1 32.00K DISK 00:06:31 09-SEP-12
BP Key: 27563 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573334_87682_p1
List of Datafiles in backup set 27563
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
43 1 Incr 4412557055 09-SEP-12 /DB1/lobzz_tbs19.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27564 Incr 1 80.00K DISK 00:08:04 09-SEP-12
BP Key: 27564 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573359_87683_p1
List of Datafiles in backup set 27564
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
44 1 Incr 4412557315 09-SEP-12 /DB1/lobzz_tbs20.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27565 Incr 1 32.00K DISK 00:21:23 09-SEP-12
BP Key: 27565 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793572563_87678_p1
List of Datafiles in backup set 27565
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
19 1 Incr 4412551903 09-SEP-12 /DB1/lobzz_tbs09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27566 Incr 1 3.42M DISK 00:13:00 09-SEP-12
BP Key: 27566 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573475_87684_p1
List of Datafiles in backup set 27566
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
45 1 Incr 4412558033 09-SEP-12 /DB1/dynamic06.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27567 Incr 1 4.63M DISK 00:12:32 09-SEP-12
BP Key: 27567 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573520_87685_p1
List of Datafiles in backup set 27567
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
46 1 Incr 4412558262 09-SEP-12 /DB1/dynamic07.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27568 Incr 1 1.84M DISK 00:09:37 09-SEP-12
BP Key: 27568 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573730_87687_p1
List of Datafiles in backup set 27568
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
47 1 Incr 4412559727 09-SEP-12 /DB1/dynamic08.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27569 Incr 1 1.89M DISK 00:15:48 09-SEP-12
BP Key: 27569 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573675_87686_p1
List of Datafiles in backup set 27569
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
39 1 Incr 4412559425 09-SEP-12 /DB1/dynamic04.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27570 Incr 1 32.00K DISK 00:27:43 09-SEP-12
BP Key: 27570 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573845_87688_p1
List of Datafiles in backup set 27570
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
31 1 Incr 4412560470 09-SEP-12 /DB1/lobzz_tbs11.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27571 Incr 1 56.00K DISK 00:28:01 09-SEP-12
BP Key: 27571 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793573846_87689_p1
List of Datafiles in backup set 27571
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
32 1 Incr 4412560471 09-SEP-12 /DB1/lobzz_tbs12.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27572 Incr 1 1.45M DISK 00:04:41 09-SEP-12
BP Key: 27572 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793575512_87694_p1
List of Datafiles in backup set 27572
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
40 1 Incr 4412571752 09-SEP-12 /DB1/dynamic05.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27573 Incr 1 1.38M DISK 00:05:07 09-SEP-12
BP Key: 27573 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793575537_87695_p1
List of Datafiles in backup set 27573
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
48 1 Incr 4412571998 09-SEP-12 /DB1/dynamic09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27574 Incr 1 103.81M DISK 00:05:11 09-SEP-12
BP Key: 27574 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793575802_87696_p1
List of Datafiles in backup set 27574
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
57 1 Incr 4412573427 09-SEP-12 /DB1/sampletbs02.dbf
76 1 Incr 4412573427 09-SEP-12 /DB1/sampletbs11.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27575 Incr 1 40.00K DISK 00:31:27 09-SEP-12
BP Key: 27575 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793574312_87692_p1
List of Datafiles in backup set 27575
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
37 1 Incr 4412563639 09-SEP-12 /DB1/lobzz_tbs15.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27576 Incr 1 4.40M DISK 00:06:33 09-SEP-12
BP Key: 27576 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793575848_87697_p1
List of Datafiles in backup set 27576
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
69 1 Incr 4412573709 09-SEP-12 /DB1/sampletbs04.dbf
70 1 Incr 4412573709 09-SEP-12 /DB1/sampletbs05.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27577 Incr 1 32.00K DISK 00:35:01 09-SEP-12
BP Key: 27577 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793574262_87690_p1
List of Datafiles in backup set 27577
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
35 1 Incr 4412563405 09-SEP-12 /DB1/lobzz_tbs13.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27578 Incr 1 32.00K DISK 00:34:54 09-SEP-12
BP Key: 27578 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793574277_87691_p1
List of Datafiles in backup set 27578
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
36 1 Incr 4412563465 09-SEP-12 /DB1/lobzz_tbs14.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27579 Incr 1 32.00K DISK 00:29:51 09-SEP-12
BP Key: 27579 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793574627_87693_p1
List of Datafiles in backup set 27579
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
38 1 Incr 4412566088 09-SEP-12 /DB1/lobzz_tbs16.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27580 Incr 1 109.94M DISK 00:04:55 09-SEP-12
BP Key: 27580 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576123_87698_p1
List of Datafiles in backup set 27580
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
49 1 Incr 4412575363 09-SEP-12 /DB1/dynamic10.dbf
56 1 Incr 4412575363 09-SEP-12 /DB1/sampletbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27581 Incr 1 1.09M DISK 00:03:06 09-SEP-12
BP Key: 27581 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576427_87704_p1
List of Datafiles in backup set 27581
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
66 1 Incr 4412577097 09-SEP-12 /DB1/sampletbs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27582 Incr 1 10.49M DISK 00:07:18 09-SEP-12
BP Key: 27582 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576208_87699_p1
List of Datafiles in backup set 27582
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 1 Incr 4412575744 09-SEP-12 /DB1/sysaux01.dbf
34 1 Incr 4412575744 09-SEP-12 /DB1/objbackup_tbs01.dbf
51 1 Incr 4412575744 09-SEP-12 /DB1/lobzz_tbs21.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27583 Incr 1 120.92M DISK 00:09:14 09-SEP-12
BP Key: 27583 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576243_87700_p1
List of Datafiles in backup set 27583
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
24 1 Incr 4412576001 09-SEP-12 /DB1/hot_idx01.dbf
26 1 Incr 4412576001 09-SEP-12 /DB1/tulz01.dbf
28 1 Incr 4412576001 09-SEP-12 /DB1/logmnrts01.dbf
52 1 Incr 4412576001 09-SEP-12 /DB1/lobzz_tbs22.dbf
54 1 Incr 4412576001 09-SEP-12 /DB1/lobzz_tbs24.dbf
64 1 Incr 4412576001 09-SEP-12 /DB1/sampletbs09.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27584 Incr 1 165.26M DISK 00:10:18 09-SEP-12
BP Key: 27584 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576368_87701_p1
List of Datafiles in backup set 27584
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
22 1 Incr 4412576672 09-SEP-12 /DB1/cool_idx01.dbf
23 1 Incr 4412576672 09-SEP-12 /DB1/hot01.dbf
30 1 Incr 4412576672 09-SEP-12 /DB1/stag01.dbf
65 1 Incr 4412576672 09-SEP-12 /DB1/sampletbs10.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27585 Incr 1 110.02M DISK 00:11:27 09-SEP-12
BP Key: 27585 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576372_87702_p1
List of Datafiles in backup set 27585
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 4412576697 09-SEP-12 /DB1/syst.dbf
27 1 Incr 4412576697 09-SEP-12 /DB1/xdb01.dbf
29 1 Incr 4412576697 09-SEP-12 /DB1/formula_01.dbf
33 1 Incr 4412576697 09-SEP-12 /DB1/style01.dbf
50 1 Incr 4412576697 09-SEP-12 /DB1/dynamic11.dbf
62 1 Incr 4412576697 09-SEP-12 /DB1/sampletbs07.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27586 Incr 1 375.13M DISK 00:10:52 09-SEP-12
BP Key: 27586 Status: AVAILABLE Compressed: YES Tag: FULL_DB_INCR_LEVEL_1
Piece Name: /backups/DB1/bck_up_793576427_87703_p1
List of Datafiles in backup set 27586
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 1 Incr 4412577096 09-SEP-12 /DB1/undotbs01.dbf
21 1 Incr 4412577096 09-SEP-12 /DB1/cool01.dbf
25 1 Incr 4412577096 09-SEP-12 /DB1/drsys01.dbf
53 1 Incr 4412577096 09-SEP-12 /DB1/lobzz_tbs23.dbf
55 1 Incr 4412577096 09-SEP-12 /DB1/lobzz_tbs25.dbf
63 1 Incr 4412577096 09-SEP-12 /DB1/sampletbs08.dbf
78 1 Incr 4412577096 09-SEP-12 /DB1/dba_tbs01.dbf


List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
125248 1 82559 A 09-SEP-12 /DB1/LOG/log_1_82559_970077020.arc
125249 1 82560 A 09-SEP-12 /DB1/LOG/log_1_82560_970077020.arc
125252 1 82561 A 09-SEP-12 /DB1/LOG/log_1_82561_970077020.arc
125254 1 82562 A 10-SEP-12 /DB1/LOG/log_1_82562_970077020.arc
125256 1 82563 A 10-SEP-12 /DB1/LOG/log_1_82563_970077020.arc
125258 1 82564 A 10-SEP-12 /DB1/LOG/log_1_82564_970077020.arc
125260 1 82565 A 10-SEP-12 /DB1/LOG/log_1_82565_970077020.arc
125262 1 82566 A 10-SEP-12 /DB1/LOG/log_1_82566_970077020.arc
125264 1 82567 A 10-SEP-12 /DB1/LOG/log_1_82567_970077020.arc
125266 1 82568 A 10-SEP-12 /DB1/LOG/log_1_82568_970077020.arc
125268 1 82569 A 10-SEP-12 /DB1/LOG/log_1_82569_970077020.arc
125270 1 82570 A 10-SEP-12 /DB1/LOG/log_1_82570_970077020.arc
125272 1 82571 A 10-SEP-12 /DB1/LOG/log_1_82571_970077020.arc
125274 1 82572 A 10-SEP-12 /DB1/LOG/log_1_82572_970077020.arc
125276 1 82573 A 10-SEP-12 /DB1/LOG/log_1_82573_970077020.arc
125278 1 82574 A 10-SEP-12 /DB1/LOG/log_1_82574_970077020.arc
125280 1 82575 A 10-SEP-12 /DB1/LOG/log_1_82575_970077020.arc
125282 1 82576 A 10-SEP-12 /DB1/LOG/log_1_82576_970077020.arc
125284 1 82577 A 10-SEP-12 /DB1/LOG/log_1_82577_970077020.arc
125286 1 82578 A 10-SEP-12 /DB1/LOG/log_1_82578_970077020.arc
125288 1 82579 A 10-SEP-12 /DB1/LOG/log_1_82579_970077020.arc
125290 1 82580 A 10-SEP-12 /DB1/LOG/log_1_82580_970077020.arc
125292 1 82581 A 10-SEP-12 /DB1/LOG/log_1_82581_970077020.arc
125294 1 82582 A 10-SEP-12 /DB1/LOG/log_1_82582_970077020.arc
125296 1 82583 A 10-SEP-12 /DB1/LOG/log_1_82583_970077020.arc
125298 1 82584 A 10-SEP-12 /DB1/LOG/log_1_82584_970077020.arc
125300 1 82585 A 10-SEP-12 /DB1/LOG/log_1_82585_970077020.arc
125302 1 82586 A 10-SEP-12 /DB1/LOG/log_1_82586_970077020.arc
125304 1 82587 A 10-SEP-12 /DB1/LOG/log_1_82587_970077020.arc
125306 1 82588 A 10-SEP-12 /DB1/LOG/log_1_82588_970077020.arc
125308 1 82589 A 10-SEP-12 /DB1/LOG/log_1_82589_970077020.arc
125310 1 82590 A 10-SEP-12 /DB1/LOG/log_1_82590_970077020.arc
125312 1 82591 A 10-SEP-12 /DB1/LOG/log_1_82591_970077020.arc
125314 1 82592 A 10-SEP-12 /DB1/LOG/log_1_82592_970077020.arc
125316 1 82593 A 10-SEP-12 /DB1/LOG/log_1_82593_970077020.arc
125318 1 82594 A 10-SEP-12 /DB1/LOG/log_1_82594_970077020.arc
125320 1 82595 A 10-SEP-12 /DB1/LOG/log_1_82595_970077020.arc
125322 1 82596 A 10-SEP-12 /DB1/LOG/log_1_82596_970077020.arc
125324 1 82597 A 10-SEP-12 /DB1/LOG/log_1_82597_970077020.arc
125326 1 82598 A 10-SEP-12 /DB1/LOG/log_1_82598_970077020.arc
125328 1 82599 A 10-SEP-12 /DB1/LOG/log_1_82599_970077020.arc
125330 1 82600 A 10-SEP-12 /DB1/LOG/log_1_82600_970077020.arc
125332 1 82601 A 10-SEP-12 /DB1/LOG/log_1_82601_970077020.arc
125334 1 82602 A 10-SEP-12 /DB1/LOG/log_1_82602_970077020.arc
125336 1 82603 A 10-SEP-12 /DB1/LOG/log_1_82603_970077020.arc
125338 1 82604 A 10-SEP-12 /DB1/LOG/log_1_82604_970077020.arc
125340 1 82605 A 10-SEP-12 /DB1/LOG/log_1_82605_970077020.arc
125342 1 82606 A 10-SEP-12 /DB1/LOG/log_1_82606_970077020.arc
125344 1 82607 A 10-SEP-12 /DB1/LOG/log_1_82607_970077020.arc
125346 1 82608 A 10-SEP-12 /DB1/LOG/log_1_82608_970077020.arc
125348 1 82609 A 10-SEP-12 /DB1/LOG/log_1_82609_970077020.arc
125350 1 82610 A 10-SEP-12 /DB1/LOG/log_1_82610_970077020.arc
125352 1 82611 A 10-SEP-12 /DB1/LOG/log_1_82611_970077020.arc
125354 1 82612 A 10-SEP-12 /DB1/LOG/log_1_82612_970077020.arc
125356 1 82613 A 10-SEP-12 /DB1/LOG/log_1_82613_970077020.arc
125358 1 82614 A 10-SEP-12 /DB1/LOG/log_1_82614_970077020.arc
125360 1 82615 A 10-SEP-12 /DB1/LOG/log_1_82615_970077020.arc
125362 1 82616 A 10-SEP-12 /DB1/LOG/log_1_82616_970077020.arc
125364 1 82617 A 10-SEP-12 /DB1/LOG/log_1_82617_970077020.arc
125366 1 82618 A 10-SEP-12 /DB1/LOG/log_1_82618_970077020.arc
125368 1 82619 A 10-SEP-12 /DB1/LOG/log_1_82619_970077020.arc
125370 1 82620 A 10-SEP-12 /DB1/LOG/log_1_82620_970077020.arc
125372 1 82621 A 10-SEP-12 /DB1/LOG/log_1_82621_970077020.arc
125374 1 82622 A 10-SEP-12 /DB1/LOG/log_1_82622_970077020.arc
125376 1 82623 A 10-SEP-12 /DB1/LOG/log_1_82623_970077020.arc
125378 1 82624 A 10-SEP-12 /DB1/LOG/log_1_82624_970077020.arc
125380 1 82625 A 10-SEP-12 /DB1/LOG/log_1_82625_970077020.arc
125382 1 82626 A 10-SEP-12 /DB1/LOG/log_1_82626_970077020.arc
125384 1 82627 A 10-SEP-12 /DB1/LOG/log_1_82627_970077020.arc
Media recovery start SCN is 4412536878
Recovery must be done beyond SCN 4412577097 to clear data files fuzziness
Finished restore at 10-SEP-12

RMAN>

[Updated on: Mon, 10 September 2012 10:37]

Report message to a moderator

Re: RMAN not removing backups [message #566084 is a reply to message #566030] Tue, 11 September 2012 06:15 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
anyone?? Confused
Re: RMAN not removing backups [message #566088 is a reply to message #566084] Tue, 11 September 2012 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute and post (INCLUDING the command itself that you hide here):
crosscheck backup of database;
list expired backup of database;
list obsolete backup of database;

And FORMAT your output.

Regards
Michel
Re: RMAN not removing backups [message #566145 is a reply to message #566088] Tue, 11 September 2012 08:39 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
Thanks Michel, here you go. (note not all of your commands above worked, I think they are 11g commands perhaps?)


RMAN> crosscheck backup of database;
RMAN> list expired backup;
RMAN> report obsolete;

Recovery Manager10.2.0.4.0

RMAN> 
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=637 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793483205_87606_p1 recid=87486 stamp=793483206
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793483205_87608_p1 recid=87487 stamp=793483206
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793483205_87607_p1 recid=87488 stamp=793483207
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793483205_87605_p1 recid=87489 stamp=793483207
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793483205_87609_p1 recid=87490 stamp=793483207
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793483205_87604_p1 recid=87491 stamp=793483206
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793484120_87610_p1 recid=87492 stamp=793484121
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793485186_87615_p1 recid=87493 stamp=793485186
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793484966_87611_p1 recid=87494 stamp=793484966
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793485011_87612_p1 recid=87495 stamp=793485011
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793485176_87613_p1 recid=87496 stamp=793485176
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793485183_87614_p1 recid=87497 stamp=793485183
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793485532_87616_p1 recid=87498 stamp=793485532
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793486187_87617_p1 recid=87499 stamp=793486187
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793486872_87618_p1 recid=87500 stamp=793486872
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793486407_87619_p1 recid=87501 stamp=793486407
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793487363_87622_p1 recid=87502 stamp=793487364
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793486622_87620_p1 recid=87503 stamp=793486623
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793486638_87621_p1 recid=87504 stamp=793486638
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793488669_87625_p1 recid=87505 stamp=793488669
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489672_87629_p1 recid=87506 stamp=793489672
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793488834_87626_p1 recid=87507 stamp=793488834
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489768_87630_p1 recid=87508 stamp=793489768
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793488309_87623_p1 recid=87509 stamp=793488310
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793488544_87624_p1 recid=87510 stamp=793488545
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489853_87632_p1 recid=87511 stamp=793489853
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489853_87631_p1 recid=87512 stamp=793489853
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489217_87628_p1 recid=87513 stamp=793489217
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489210_87687_p1 recid=87514 stamp=793489212
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489988_87635_p1 recid=87515 stamp=793489988
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489878_87633_p1 recid=87516 stamp=793489878
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491136_87640_p1 recid=87517 stamp=793491136
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491101_87639_p1 recid=87518 stamp=793491101
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793489973_87634_p1 recid=87519 stamp=793489973
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793490083_87636_p1 recid=87520 stamp=793490083
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491326_87644_p1 recid=87521 stamp=793491387
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793490358_87637_p1 recid=87522 stamp=793490359
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793490365_87638_p1 recid=87523 stamp=793490366
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491281_87643_p1 recid=87524 stamp=793491281
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491211_87641_p1 recid=87525 stamp=793491211
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491236_87642_p1 recid=87526 stamp=793491236
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793491932_87645_p1 recid=87587 stamp=793491932
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793492603_87649_p1 recid=87528 stamp=793492603
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793492877_87648_p1 recid=87529 stamp=793492878
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793492212_87647_p1 recid=87530 stamp=793492213
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793492177_87646_p1 recid=87531 stamp=793492178
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793569605_87661_p1 recid=87541 stamp=793569612
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793569605_87662_p1 recid=87542 stamp=793569612
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793569605_87663_p1 recid=87543 stamp=793569609
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793569605_87659_p1 recid=87544 stamp=793569692
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793569605_87664_p1 recid=87545 stamp=793569722
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793569605_87660_p1 recid=87546 stamp=793569716
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570281_87665_p1 recid=87547 stamp=793570281
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570446_87666_p1 recid=87548 stamp=793570446
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570802_87670_p1 recid=87549 stamp=793570802
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570446_87667_p1 recid=87550 stamp=793570446
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570671_87668_p1 recid=87551 stamp=793570671
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570746_87669_p1 recid=87552 stamp=793570747
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793571340_87674_p1 recid=87553 stamp=793571340
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570805_87671_p1 recid=87554 stamp=793570805
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793570920_87672_p1 recid=87555 stamp=793570920
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793571155_87673_p1 recid=87556 stamp=793571155
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793572297_87677_p1 recid=87557 stamp=793572301
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573074_87680_p1 recid=87558 stamp=793573075
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793571805_87675_p1 recid=87559 stamp=793571808
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573189_87681_p1 recid=87560 stamp=793573191
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793571891_87676_p1 recid=87561 stamp=793571893
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793572818_87679_p1 recid=87562 stamp=793572820
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573334_87682_p1 recid=87563 stamp=793573335
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573359_87683_p1 recid=87564 stamp=793573360
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793572563_87678_p1 recid=87565 stamp=793572564
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573475_87684_p1 recid=87566 stamp=793573475
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573520_87685_p1 recid=87567 stamp=793573531
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573730_87687_p1 recid=87568 stamp=793573730
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573675_87686_p1 recid=87569 stamp=793573676
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573845_87688_p1 recid=87570 stamp=793573845
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793573846_87689_p1 recid=87571 stamp=793573846
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793575512_87694_p1 recid=87572 stamp=793575512
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793575537_87695_p1 recid=87573 stamp=793575537
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793575802_87696_p1 recid=87574 stamp=793575803
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793574312_87692_p1 recid=87575 stamp=793574312
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793575848_87697_p1 recid=87576 stamp=793575848
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793574262_87690_p1 recid=87577 stamp=793574262
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793574877_87691_p1 recid=87578 stamp=793574877
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793574687_87693_p1 recid=87579 stamp=793574687
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576123_87698_p1 recid=87580 stamp=793576123
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576487_87704_p1 recid=87581 stamp=793576487
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576208_87699_p1 recid=87582 stamp=793576208
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576243_87700_p1 recid=87583 stamp=793576243
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576368_87701_p1 recid=87584 stamp=793576369
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576372_87702_p1 recid=87585 stamp=793576372
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793576487_87703_p1 recid=87586 stamp=793576487
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656005_87715_p1 recid=87595 stamp=793656011
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656005_87716_p1 recid=87596 stamp=793656011
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656005_87717_p1 recid=87597 stamp=793656010
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656005_87713_p1 recid=87598 stamp=793656011
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656005_87718_p1 recid=87599 stamp=793656012
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656750_87719_p1 recid=87600 stamp=793656751
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656005_87714_p1 recid=87601 stamp=793656012
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656946_87720_p1 recid=87602 stamp=793656946
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657216_87724_p1 recid=87603 stamp=793657216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793656961_87721_p1 recid=87604 stamp=793656961
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657076_87722_p1 recid=87605 stamp=793657076
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657181_87723_p1 recid=87606 stamp=793657181
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657947_87728_p1 recid=87607 stamp=793657947
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657871_87725_p1 recid=87608 stamp=793657871
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657366_87726_p1 recid=87609 stamp=793657367
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793657562_87787_p1 recid=87610 stamp=793657562
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793659540_87734_p1 recid=87611 stamp=793659540
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793658312_87729_p1 recid=87612 stamp=793658314
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793659103_87731_p1 recid=87613 stamp=793659106
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793658408_87730_p1 recid=87614 stamp=793658408
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793659895_87735_p1 recid=87615 stamp=793659897
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793659980_87736_p1 recid=87616 stamp=793659982
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660116_87737_p1 recid=87617 stamp=793660118
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793659434_87733_p1 recid=87618 stamp=793659437
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793659369_87732_p1 recid=87619 stamp=793659371
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660181_87738_p1 recid=87620 stamp=793660183
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660376_87739_p1 recid=87621 stamp=793660378
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660547_87741_p1 recid=87622 stamp=793660547
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660451_87740_p1 recid=87623 stamp=793660452
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660612_87742_p1 recid=87624 stamp=793660612
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793662573_87748_p1 recid=87625 stamp=793662573
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660787_87743_p1 recid=87626 stamp=793660787
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793660872_87744_p1 recid=87687 stamp=793660873
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793661212_87746_p1 recid=87628 stamp=793661213
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793662848_87749_p1 recid=87629 stamp=793662848
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793661007_87745_p1 recid=87630 stamp=793661008
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793661898_87747_p1 recid=87631 stamp=793661898
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663003_87750_p1 recid=87632 stamp=793663003
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663164_87752_p1 recid=87633 stamp=793663165
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663088_87751_p1 recid=87634 stamp=793663089
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663189_87753_p1 recid=87635 stamp=793663189
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663725_87758_p1 recid=87636 stamp=793663725
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663254_87754_p1 recid=87637 stamp=793663255
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663389_87755_p1 recid=87638 stamp=793663391
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663445_87756_p1 recid=87639 stamp=793663446
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/backups/DB1/DB1_bckup_793663700_87757_p1 recid=87640 stamp=793663705
Crosschecked 138 objects


RMAN> 

RMAN> 
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           87594  09-SEP-12         
  Backup Piece       87594  09-SEP-12          /backups/DB1/cf_c-1008206178-20120909-01
Backup Set           87641  10-SEP-12         
  Backup Piece       87641  10-SEP-12          /backups/DB1/cf_c-1008206178-20120910-00

RMAN> 

Recovery Manager complete.


Re: RMAN not removing backups [message #566148 is a reply to message #566145] Tue, 11 September 2012 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not the actual output.
Also do you use a catalog or not?
Copy and paste the WHOLE session.

Regards
Michel
Re: RMAN not removing backups [message #566152 is a reply to message #566148] Tue, 11 September 2012 09:03 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
This is the actual output, and no, catalog is not used.
I did copy and paste the whole session!
Re: RMAN not removing backups [message #566156 is a reply to message #566152] Tue, 11 September 2012 09:31 Go to previous messageGo to next message
John Watson
Messages: 4553
Registered: January 2010
Location: Global Village
Senior Member
I think Michel's commands show that RMAN is not aware these older backups going back 6 weeks exist. I would catalog the backups:
catalog start with '/backups';
and then try running the delete obsolete.
Re: RMAN not removing backups [message #566158 is a reply to message #566156] Tue, 11 September 2012 09:47 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
thanks John, RMAN wants to know do I want to catalog the files, do I agree?


RMAN> catalog start with '/backups/DB1';

searching for all files that match the pattern /orabackup/DB1/rman

List of Files Unknown to the Database
=====================================
File Name: /backups/DB1/db_cmp_791676201_86515_p1
File Name: /backups/DB1/db_cmp_791672130_86496_p1
File Name: /backups/DB1/db_cmp_791676391_86519_p1
File Name: /backups/DB1/db_cmp_791677913_86525_p1
File Name: /backups/DB1/db_cmp_791676376_86518_p1
File Name: /backups/DB1/db_cmp_792278719_86871_p1
File Name: /backups/DB1/db_cmp_792280984_86885_p1
File Name: /backups/DB1/db_cmp_791675000_86506_p1
File Name: /backups/DB1/db_cmp_791672173_86499_p1
File Name: /backups/DB1/db_cmp_792887409_87264_p1
File Name: /backups/DB1/db_cmp_792881159_87235_p1
File Name: /backups/DB1/db_cmp_792879240_87228_p1
File Name: /backups/DB1/db_cmp_792273605_86853_p1
File Name: /backups/DB1/db_cmp_792885399_87253_p1
File Name: /backups/DB1/db_cmp_791674867_86503_p1
File Name: /backups/DB1/db_cmp_792275897_86862_p1
File Name: /backups/DB1/db_cmp_791676266_86516_p1
File Name: /backups/DB1/orapwDB1
File Name: /backups/DB1/db_cmp_791673981_86502_p1
File Name: /backups/DB1/db_cmp_792275221_86857_p1
File Name: /backups/DB1/db_cmp_792878405_87223_p1
File Name: /backups/DB1/db_cmp_792275331_86859_p1
File Name: /backups/DB1/db_cmp_792885830_87257_p1
File Name: /backups/DB1/db_cmp_792887234_87263_p1
File Name: /backups/DB1/db_cmp_792887188_87262_p1
File Name: /backups/DB1/db_cmp_792276547_86864_p1
File Name: /backups/DB1/db_cmp_792885862_87259_p1
File Name: /backups/DB1/db_cmp_792880263_87232_p1
File Name: /backups/DB1/db_cmp_791674997_86505_p1
File Name: /backups/DB1/db_cmp_792880151_87230_p1
File Name: /backups/DB1/db_cmp_792279899_86880_p1
File Name: /backups/DB1/db_cmp_792884263_87245_p1
File Name: /backups/DB1/db_cmp_792885425_87254_p1
File Name: /backups/DB1/db_cmp_792878405_87227_p1
File Name: /backups/DB1/db_cmp_792281070_86886_p1
File Name: /backups/DB1/db_cmp_792281240_86890_p1
File Name: /backups/DB1/db_cmp_792884419_87246_p1
File Name: /backups/DB1/db_cmp_792275331_86860_p1
File Name: /backups/DB1/db_cmp_792275256_86858_p1
File Name: /backups/DB1/db_cmp_792878405_87224_p1
File Name: /backups/DB1/db_cmp_792278384_86870_p1
File Name: /backups/DB1/db_cmp_791676361_86517_p1
File Name: /backups/DB1/db_cmp_792880593_87234_p1
File Name: /backups/DB1/db_cmp_792280389_86884_p1
File Name: /backups/DB1/db_cmp_792887500_87266_p1
File Name: /backups/DB1/db_cmp_792882355_87240_p1
File Name: /backups/DB1/db_cmp_791675404_86512_p1
File Name: /backups/DB1/db_cmp_792885470_87255_p1
File Name: /backups/DB1/db_cmp_792886453_87261_p1
File Name: /backups/DB1/db_cmp_792281135_86889_p1
File Name: /backups/DB1/db_cmp_791670291_86488_p1
File Name: /backups/DB1/db_cmp_792275331_86861_p1
File Name: /backups/DB1/db_cmp_791671795_86495_p1
File Name: /backups/DB1/db_cmp_792887434_87265_p1
File Name: /backups/DB1/db_cmp_792881574_87238_p1
File Name: /backups/DB1/db_cmp_792280169_86882_p1
File Name: /backups/DB1/db_cmp_792881484_87236_p1
File Name: /backups/DB1/db_cmp_791668805_86484_p1
File Name: /backups/DB1/db_cmp_792884589_87248_p1
File Name: /backups/DB1/db_cmp_792882900_87241_p1
File Name: /backups/DB1/db_cmp_792885855_87258_p1
File Name: /backups/DB1/db_cmp_792279001_86874_p1
File Name: /backups/DB1/db_cmp_792884111_87243_p1
File Name: /backups/DB1/db_cmp_792282171_86892_p1
File Name: /backups/DB1/db_cmp_791676029_86513_p1
File Name: /backups/DB1/db_cmp_791671570_86494_p1
File Name: /backups/DB1/spfileDB1.ora
File Name: /backups/DB1/db_cmp_792878405_87225_p1
File Name: /backups/DB1/db_cmp_791668805_86486_p1
File Name: /backups/DB1/db_cmp_792281120_86888_p1
File Name: /backups/DB1/db_cmp_792282136_86891_p1
File Name: /backups/DB1/db_cmp_792276262_86863_p1
File Name: /backups/DB1/db_cmp_792279954_86881_p1
File Name: /backups/DB1/db_cmp_791668805_86487_p1
File Name: /backups/DB1/db_cmp_792884709_87251_p1
File Name: /backups/DB1/db_cmp_791673779_86500_p1
File Name: /backups/DB1/db_cmp_792880126_87229_p1
File Name: /backups/DB1/db_cmp_792273605_86854_p1
File Name: /backups/DB1/db_cmp_792279526_86875_p1
File Name: /backups/DB1/db_cmp_792884444_87247_p1
File Name: /backups/DB1/db_cmp_792884118_87244_p1
File Name: /backups/DB1/db_cmp_792883236_87242_p1
File Name: /backups/DB1/db_cmp_792279000_86873_p1
File Name: /backups/DB1/db_cmp_791675125_86507_p1
File Name: /backups/DB1/db_cmp_792276667_86866_p1
File Name: /backups/DB1/db_cmp_791675400_86511_p1
File Name: /backups/DB1/db_cmp_792273605_86851_p1
File Name: /backups/DB1/db_cmp_791670586_86489_p1
File Name: /backups/DB1/db_cmp_791676852_86521_p1
File Name: /backups/DB1/db_cmp_792278824_86872_p1
File Name: /backups/DB1/db_cmp_791672173_86498_p1
File Name: /backups/DB1/db_cmp_792884834_87252_p1
File Name: /backups/DB1/db_cmp_791675285_86510_p1
File Name: /backups/DB1/db_cmp_791673974_86501_p1
File Name: /backups/DB1/db_cmp_791670586_86491_p1
File Name: /backups/DB1/db_cmp_791670586_86490_p1
File Name: /backups/DB1/db_cmp_791668805_86483_p1
File Name: /backups/DB1/db_cmp_792887500_87267_p1
File Name: /backups/DB1/db_cmp_792276582_86865_p1
File Name: /backups/DB1/db_cmp_792884589_87249_p1
File Name: /backups/DB1/db_cmp_792279892_86879_p1
File Name: /backups/DB1/db_cmp_792885725_87256_p1
File Name: /backups/DB1/db_cmp_791677527_86522_p1
File Name: /backups/DB1/db_cmp_792878405_87222_p1
File Name: /backups/DB1/db_cmp_791674942_86504_p1
File Name: /backups/DB1/db_cmp_792881529_87237_p1
File Name: /backups/DB1/db_cmp_791676427_86520_p1
File Name: /backups/DB1/db_cmp_792278099_86869_p1
File Name: /backups/DB1/db_cmp_792273605_86850_p1
File Name: /backups/DB1/db_cmp_792273605_86852_p1
File Name: /backups/DB1/db_cmp_791675285_86509_p1
File Name: /backups/DB1/db_cmp_791677768_86524_p1
File Name: /backups/DB1/db_cmp_792880278_87233_p1
File Name: /backups/DB1/db_cmp_792884634_87250_p1
File Name: /backups/DB1/db_cmp_792279736_86877_p1
File Name: /backups/DB1/db_cmp_791675230_86508_p1
File Name: /backups/DB1/db_cmp_791668805_86482_p1
File Name: /backups/DB1/db_cmp_792880256_87231_p1
File Name: /backups/DB1/db_cmp_792885907_87260_p1
File Name: /backups/DB1/db_cmp_792273605_86849_p1
File Name: /backups/DB1/db_cmp_792279736_86878_p1
File Name: /backups/DB1/initDB1.ora
File Name: /backups/DB1/db_cmp_792276667_86867_p1
File Name: /backups/DB1/db_cmp_792881919_87239_p1
File Name: /backups/DB1/db_cmp_792279641_86876_p1
File Name: /backups/DB1/db_cmp_792281095_86887_p1
File Name: /backups/DB1/db_cmp_791676194_86514_p1
File Name: /backups/DB1/db_cmp_792878405_87226_p1
File Name: /backups/DB1/db_cmp_791670590_86492_p1
File Name: /backups/DB1/db_cmp_792277563_86868_p1
File Name: /backups/DB1/db_cmp_791677743_86523_p1
File Name: /backups/DB1/db_cmp_791670615_86493_p1
File Name: /backups/DB1/db_cmp_792273900_86855_p1
File Name: /backups/DB1/db_cmp_791672137_86497_p1
File Name: /backups/DB1/db_cmp_792274385_86856_p1
File Name: /backups/DB1/db_cmp_792280374_86883_p1
File Name: /backups/DB1/db_cmp_791668805_86485_p1

Do you really want to catalog the above files (enter YES or NO)?


Re: RMAN not removing backups [message #566162 is a reply to message #566158] Tue, 11 September 2012 10:00 Go to previous messageGo to next message
candi
Messages: 30
Registered: July 2012
Member
ok, I agreed and RMAN deleted the obsolete backups.
Still don't know why this happened though Sad
Re: RMAN not removing backups [message #566163 is a reply to message #566158] Tue, 11 September 2012 10:01 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enter YES (ignore the errors) and reexecute the crosscheck and delete commands.

Regards
Michel

[Updated on: Tue, 11 September 2012 10:01]

Report message to a moderator

Re: RMAN not removing backups [message #566164 is a reply to message #566162] Tue, 11 September 2012 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Still don't know why this happened though


Maybe you run out of control file space and Oracle deletes the older records (check control_file_record_keep_time) to prevent from increasing its size.

Regards
Michel
Re: RMAN not removing backups [message #566165 is a reply to message #566164] Tue, 11 September 2012 10:16 Go to previous message
candi
Messages: 30
Registered: July 2012
Member
great, thanks again for your help.
Previous Topic: RMAN tablespace backup and restore
Next Topic: configuration can't be chaned for BACKUP or STANDBY control file
Goto Forum:
  


Current Time: Tue Sep 16 16:58:36 CDT 2014

Total time taken to generate the page: 0.13581 seconds