Some times we need to know about what backups we have taken till date in terms of datafiles, tablespaces, time and so on. Here are some usefull RMAN LIST commands .
1. Following command will show entire database backup taken till now.
RMAN> list backup of database;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
61 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 196 Status: AVAILABLE Compressed: NO Tag: TAG20120108T103332
Piece Name: H:\RMAN2\2GN087NS_1_1.BKP
List of Datafiles in backup set 61
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1294477 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1294477 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
62 Full 359.86M DISK 00:01:12 08-JAN-12
List of Datafiles in backup set 62
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294475 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1294475 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
Backup Set Copy #1 of backup set 62
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:12 08-JAN-12 NO TAG20120108T103332
List of Backup Pieces for backup set 62 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
197 1 AVAILABLE H:\RMAN\2FN087NS_1_1.BKP
198 2 AVAILABLE H:\RMAN\2FN087NS_2_1.BKP
199 3 AVAILABLE H:\RMAN\2FN087NS_3_1.BKP
200 4 AVAILABLE H:\RMAN\2FN087NS_4_1.BKP
201 5 AVAILABLE H:\RMAN\2FN087NS_5_1.BKP
202 6 AVAILABLE H:\RMAN\2FN087NS_6_1.BKP
203 7 AVAILABLE H:\RMAN\2FN087NS_7_1.BKP
204 8 AVAILABLE H:\RMAN\2FN087NS_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64 Full 359.70M DISK 00:00:56 08-JAN-12
BP Key: 206 Status: AVAILABLE Compressed: NO Tag: TAG20120108T104152
Piece Name: H:\RMAN2\2JN0887G_1_1.BKP
List of Datafiles in backup set 64
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294673 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1294673 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65 Full 217.08M DISK 00:00:58 08-JAN-12
List of Datafiles in backup set 65
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1294670 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1294670 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
Backup Set Copy #1 of backup set 65
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:58 08-JAN-12 NO TAG20120108T104152
List of Backup Pieces for backup set 65 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
207 1 AVAILABLE H:\RMAN\2IN0887G_1_1.BKP
208 2 AVAILABLE H:\RMAN\2IN0887G_2_1.BKP
209 3 AVAILABLE H:\RMAN\2IN0887G_3_1.BKP
210 4 AVAILABLE H:\RMAN\2IN0887G_4_1.BKP
211 5 AVAILABLE H:\RMAN\2IN0887G_5_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 213 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105510
Piece Name: H:\RMAN2\2MN0890E_1_1.BKP
List of Datafiles in backup set 67
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295303 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295303 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 214 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105639
Piece Name: H:\RMAN2\2ON08938_1_1.BKP
List of Datafiles in backup set 68
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295337 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295337 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69 Full 359.90M DISK 00:01:09 08-JAN-12
List of Datafiles in backup set 69
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295335 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295335 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
Backup Set Copy #1 of backup set 69
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:09 08-JAN-12 NO TAG20120108T105639
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
215 1 AVAILABLE H:\RMAN\2NN08937_1_1.BKP
216 2 AVAILABLE H:\RMAN\2NN08937_2_1.BKP
217 3 AVAILABLE H:\RMAN\2NN08937_3_1.BKP
218 4 AVAILABLE H:\RMAN\2NN08937_4_1.BKP
219 5 AVAILABLE H:\RMAN\2NN08937_5_1.BKP
220 6 AVAILABLE H:\RMAN\2NN08937_6_1.BKP
221 7 AVAILABLE H:\RMAN\2NN08937_7_1.BKP
222 8 AVAILABLE H:\RMAN\2NN08937_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71 Full 359.73M DISK 00:00:59 08-JAN-12
BP Key: 224 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105813
Piece Name: H:\RMAN2\2RN08965_1_1.BKP
List of Datafiles in backup set 71
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295384 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295384 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
72 Full 217.08M DISK 00:00:59 08-JAN-12
List of Datafiles in backup set 72
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295381 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295381 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
Backup Set Copy #1 of backup set 72
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:59 08-JAN-12 NO TAG20120108T105813
List of Backup Pieces for backup set 72 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
225 1 AVAILABLE H:\RMAN\2QN08965_1_1.BKP
226 2 AVAILABLE H:\RMAN\2QN08965_2_1.BKP
227 3 AVAILABLE H:\RMAN\2QN08965_3_1.BKP
228 4 AVAILABLE H:\RMAN\2QN08965_4_1.BKP
229 5 AVAILABLE H:\RMAN\2QN08965_5_1.BKP
2. We can also search the database backup by specifying backupset number.
RMAN> list backupset 71;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71 Full 359.73M DISK 00:00:59 08-JAN-12
BP Key: 224 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105813
Piece Name: H:\RMAN2\2RN08965_1_1.BKP
List of Datafiles in backup set 71
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295384 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295384 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
3. If we know the backup set tag name then following command is useful.
RMAN> list backupset tag 'TAG20120108T105639';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 214 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105639
Piece Name: H:\RMAN2\2ON08938_1_1.BKP
List of Datafiles in backup set 68
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295337 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295337 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69 Full 359.90M DISK 00:01:09 08-JAN-12
List of Datafiles in backup set 69
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295335 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295335 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS_FNO-4_1IMVMG63.BKP
Backup Set Copy #1 of backup set 69
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:09 08-JAN-12 NO TAG20120108T105639
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
215 1 AVAILABLE H:\RMAN\2NN08937_1_1.BKP
216 2 AVAILABLE H:\RMAN\2NN08937_2_1.BKP
217 3 AVAILABLE H:\RMAN\2NN08937_3_1.BKP
218 4 AVAILABLE H:\RMAN\2NN08937_4_1.BKP
219 5 AVAILABLE H:\RMAN\2NN08937_5_1.BKP
220 6 AVAILABLE H:\RMAN\2NN08937_6_1.BKP
221 7 AVAILABLE H:\RMAN\2NN08937_7_1.BKP
222 8 AVAILABLE H:\RMAN\2NN08937_8_1.BKP
4. We can search particular datafile in backup copy set using follwing command.
RMAN> list copy of datafile 'h:\finance\system01.dbf';
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
2 1 A 08-JAN-12 1298637 08-JAN-12 H:\RMAN2\DATA_D-FINANCE_I-2590818756_TS-SY
STEM_FNO-1_32N08GGJ.BKP
5. Following command will list backup of datafile 1 if it has been backed up atleast once in between to specified dates.
RMAN> list backup of datafile 1 completed between '07-jan-2012' and 'sysdate';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
62 Full 359.86M DISK 00:01:12 08-JAN-12
List of Datafiles in backup set 62
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294475 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
Backup Set Copy #1 of backup set 62
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:12 08-JAN-12 NO TAG20120108T103332
List of Backup Pieces for backup set 62 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
197 1 AVAILABLE H:\RMAN\2FN087NS_1_1.BKP
198 2 AVAILABLE H:\RMAN\2FN087NS_2_1.BKP
199 3 AVAILABLE H:\RMAN\2FN087NS_3_1.BKP
200 4 AVAILABLE H:\RMAN\2FN087NS_4_1.BKP
201 5 AVAILABLE H:\RMAN\2FN087NS_5_1.BKP
202 6 AVAILABLE H:\RMAN\2FN087NS_6_1.BKP
203 7 AVAILABLE H:\RMAN\2FN087NS_7_1.BKP
204 8 AVAILABLE H:\RMAN\2FN087NS_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64 Full 359.70M DISK 00:00:56 08-JAN-12
BP Key: 206 Status: AVAILABLE Compressed: NO Tag: TAG20120108T104152
Piece Name: H:\RMAN2\2JN0887G_1_1.BKP
List of Datafiles in backup set 64
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294673 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69 Full 359.90M DISK 00:01:09 08-JAN-12
List of Datafiles in backup set 69
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295335 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
Backup Set Copy #1 of backup set 69
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:09 08-JAN-12 NO TAG20120108T105639
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
215 1 AVAILABLE H:\RMAN\2NN08937_1_1.BKP
216 2 AVAILABLE H:\RMAN\2NN08937_2_1.BKP
217 3 AVAILABLE H:\RMAN\2NN08937_3_1.BKP
218 4 AVAILABLE H:\RMAN\2NN08937_4_1.BKP
219 5 AVAILABLE H:\RMAN\2NN08937_5_1.BKP
220 6 AVAILABLE H:\RMAN\2NN08937_6_1.BKP
221 7 AVAILABLE H:\RMAN\2NN08937_7_1.BKP
222 8 AVAILABLE H:\RMAN\2NN08937_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71 Full 359.73M DISK 00:00:59 08-JAN-12
BP Key: 224 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105813
Piece Name: H:\RMAN2\2RN08965_1_1.BKP
List of Datafiles in backup set 71
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295384 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
RMAN> list archivelog all backed up 1 times to disk;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 8 A 29-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2011_12_30
\O1_MF_1_8_7HVVHLTV_.ARC
2 1 9 A 30-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2011_12_31
\O1_MF_1_9_7HX2XNFO_.ARC
3 1 10 A 31-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2011_12_31
\O1_MF_1_10_7HY178WB_.ARC
4 1 11 A 31-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_11_7HYTDWTC_.ARC
5 1 12 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_12_7HZVFGKL_.ARC
6 1 13 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_13_7J02VNXS_.ARC
7 1 14 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_14_7J0JD298_.ARC
8 1 15 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_02
\O1_MF_1_15_7J2CJVC7_.ARC
9 1 16 A 02-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_02
\O1_MF_1_16_7J3HK6H4_.ARC
10 1 27 A 06-JAN-12 H:\FINANCE\ARCH\ARC00027_0770941832.001
11 1 28 A 06-JAN-12 H:\FINANCE\ARCH\ARC00028_0770941832.001
12 1 29 A 06-JAN-12 H:\FINANCE\ARCH\ARC00029_0770941832.001
13 1 30 A 06-JAN-12 H:\FINANCE\ARCH\ARC00030_0770941832.001
14 1 31 A 07-JAN-12 H:\FINANCE\ARCH\ARC00031_0770941832.001
15 1 32 A 07-JAN-12 H:\FINANCE\ARCH\ARC00032_0770941832.001
16 1 33 A 08-JAN-12 H:\FINANCE\ARCH\ARC00033_0770941832.001
17 1 34 A 08-JAN-12 H:\FINANCE\ARCH\ARC00034_0770941832.001
7. Following command is going to show you backup of archivelog files taken anytime.
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
74 54.32M DISK 00:00:11 08-JAN-12
List of Archived Logs in backup set 74
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 16 934669 02-JAN-12 957090 02-JAN-12
1 27 1195959 06-JAN-12 1207064 06-JAN-12
1 28 1207064 06-JAN-12 1207066 06-JAN-12
1 29 1207066 06-JAN-12 1207151 06-JAN-12
1 30 1207151 06-JAN-12 1235904 07-JAN-12
1 31 1235904 07-JAN-12 1260227 07-JAN-12
1 32 1260227 07-JAN-12 1292271 08-JAN-12
Backup Set Copy #1 of backup set 74
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:11 08-JAN-12 NO TAG20120108T115845
List of Backup Pieces for backup set 74 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
231 1 AVAILABLE H:\RMAN\2TN08CNM_1_1.BKP
232 2 AVAILABLE H:\RMAN\2TN08CNM_2_1.BKP
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75 39.26M DISK 00:00:13 08-JAN-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN2\2UN08CNM_1_1.BKP
List of Archived Logs in backup set 75
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 8 723728 29-DEC-11 750991 30-DEC-11
1 9 750991 30-DEC-11 778009 31-DEC-11
1 10 778009 31-DEC-11 801454 31-DEC-11
1 11 801454 31-DEC-11 833254 01-JAN-12
1 12 833254 01-JAN-12 855003 01-JAN-12
1 13 855003 01-JAN-12 878802 01-JAN-12
1 14 878802 01-JAN-12 901427 01-JAN-12
1 15 901427 01-JAN-12 934669 02-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76 3.02M DISK 00:00:00 08-JAN-12
BP Key: 234 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN\2VN08CO6_1_1.BKP
List of Archived Logs in backup set 76
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 33 1292271 08-JAN-12 1296996 08-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
79 685.50K DISK 00:00:01 08-JAN-12
BP Key: 237 Status: AVAILABLE Compressed: NO Tag: TAG20120108T131318
Piece Name: H:\RMAN2\34N08H3G_1_1.BKP
List of Archived Logs in backup set 79
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 34 1296996 08-JAN-12 1298930 08-JAN-12
RMAN> list backup of archivelog from scn 901427;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
74 54.32M DISK 00:00:11 08-JAN-12
List of Archived Logs in backup set 74
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 16 934669 02-JAN-12 957090 02-JAN-12
1 27 1195959 06-JAN-12 1207064 06-JAN-12
1 28 1207064 06-JAN-12 1207066 06-JAN-12
1 29 1207066 06-JAN-12 1207151 06-JAN-12
1 30 1207151 06-JAN-12 1235904 07-JAN-12
1 31 1235904 07-JAN-12 1260227 07-JAN-12
1 32 1260227 07-JAN-12 1292271 08-JAN-12
Backup Set Copy #1 of backup set 74
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:11 08-JAN-12 NO TAG20120108T115845
List of Backup Pieces for backup set 74 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
231 1 AVAILABLE H:\RMAN\2TN08CNM_1_1.BKP
232 2 AVAILABLE H:\RMAN\2TN08CNM_2_1.BKP
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75 39.26M DISK 00:00:13 08-JAN-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN2\2UN08CNM_1_1.BKP
List of Archived Logs in backup set 75
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 15 901427 01-JAN-12 934669 02-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76 3.02M DISK 00:00:00 08-JAN-12
BP Key: 234 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN\2VN08CO6_1_1.BKP
List of Archived Logs in backup set 76
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 33 1292271 08-JAN-12 1296996 08-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
79 685.50K DISK 00:00:01 08-JAN-12
BP Key: 237 Status: AVAILABLE Compressed: NO Tag: TAG20120108T131318
Piece Name: H:\RMAN2\34N08H3G_1_1.BKP
List of Archived Logs in backup set 79
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 34 1296996 08-JAN-12 1298930 08-JAN-12
RMAN> list backup of archivelog from scn 901427 until scn 901456;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75 39.26M DISK 00:00:13 08-JAN-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN2\2UN08CNM_1_1.BKP
List of Archived Logs in backup set 75
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 15 901427 01-JAN-12 934669 02-JAN-12
10. Following command will show current incarnation as well past incarnation numbers of database.
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 FINANCE 2590818756 PARENT 1 30-AUG-05
2 2 FINANCE 2590818756 CURRENT 534907 26-DEC-11
RMAN> list incarnation of database finance;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 FINANCE 2590818756 PARENT 1 30-AUG-05
2 2 FINANCE 2590818756 CURRENT 534907 26-DEC-11
1. Following command will show entire database backup taken till now.
RMAN> list backup of database;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
61 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 196 Status: AVAILABLE Compressed: NO Tag: TAG20120108T103332
Piece Name: H:\RMAN2\2GN087NS_1_1.BKP
List of Datafiles in backup set 61
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1294477 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1294477 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
62 Full 359.86M DISK 00:01:12 08-JAN-12
List of Datafiles in backup set 62
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294475 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1294475 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
Backup Set Copy #1 of backup set 62
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:12 08-JAN-12 NO TAG20120108T103332
List of Backup Pieces for backup set 62 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
197 1 AVAILABLE H:\RMAN\2FN087NS_1_1.BKP
198 2 AVAILABLE H:\RMAN\2FN087NS_2_1.BKP
199 3 AVAILABLE H:\RMAN\2FN087NS_3_1.BKP
200 4 AVAILABLE H:\RMAN\2FN087NS_4_1.BKP
201 5 AVAILABLE H:\RMAN\2FN087NS_5_1.BKP
202 6 AVAILABLE H:\RMAN\2FN087NS_6_1.BKP
203 7 AVAILABLE H:\RMAN\2FN087NS_7_1.BKP
204 8 AVAILABLE H:\RMAN\2FN087NS_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64 Full 359.70M DISK 00:00:56 08-JAN-12
BP Key: 206 Status: AVAILABLE Compressed: NO Tag: TAG20120108T104152
Piece Name: H:\RMAN2\2JN0887G_1_1.BKP
List of Datafiles in backup set 64
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294673 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1294673 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65 Full 217.08M DISK 00:00:58 08-JAN-12
List of Datafiles in backup set 65
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1294670 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1294670 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
Backup Set Copy #1 of backup set 65
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:58 08-JAN-12 NO TAG20120108T104152
List of Backup Pieces for backup set 65 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
207 1 AVAILABLE H:\RMAN\2IN0887G_1_1.BKP
208 2 AVAILABLE H:\RMAN\2IN0887G_2_1.BKP
209 3 AVAILABLE H:\RMAN\2IN0887G_3_1.BKP
210 4 AVAILABLE H:\RMAN\2IN0887G_4_1.BKP
211 5 AVAILABLE H:\RMAN\2IN0887G_5_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 213 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105510
Piece Name: H:\RMAN2\2MN0890E_1_1.BKP
List of Datafiles in backup set 67
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295303 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295303 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 214 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105639
Piece Name: H:\RMAN2\2ON08938_1_1.BKP
List of Datafiles in backup set 68
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295337 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295337 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69 Full 359.90M DISK 00:01:09 08-JAN-12
List of Datafiles in backup set 69
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295335 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295335 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
Backup Set Copy #1 of backup set 69
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:09 08-JAN-12 NO TAG20120108T105639
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
215 1 AVAILABLE H:\RMAN\2NN08937_1_1.BKP
216 2 AVAILABLE H:\RMAN\2NN08937_2_1.BKP
217 3 AVAILABLE H:\RMAN\2NN08937_3_1.BKP
218 4 AVAILABLE H:\RMAN\2NN08937_4_1.BKP
219 5 AVAILABLE H:\RMAN\2NN08937_5_1.BKP
220 6 AVAILABLE H:\RMAN\2NN08937_6_1.BKP
221 7 AVAILABLE H:\RMAN\2NN08937_7_1.BKP
222 8 AVAILABLE H:\RMAN\2NN08937_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71 Full 359.73M DISK 00:00:59 08-JAN-12
BP Key: 224 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105813
Piece Name: H:\RMAN2\2RN08965_1_1.BKP
List of Datafiles in backup set 71
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295384 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295384 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
72 Full 217.08M DISK 00:00:59 08-JAN-12
List of Datafiles in backup set 72
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295381 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295381 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
Backup Set Copy #1 of backup set 72
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:59 08-JAN-12 NO TAG20120108T105813
List of Backup Pieces for backup set 72 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
225 1 AVAILABLE H:\RMAN\2QN08965_1_1.BKP
226 2 AVAILABLE H:\RMAN\2QN08965_2_1.BKP
227 3 AVAILABLE H:\RMAN\2QN08965_3_1.BKP
228 4 AVAILABLE H:\RMAN\2QN08965_4_1.BKP
229 5 AVAILABLE H:\RMAN\2QN08965_5_1.BKP
2. We can also search the database backup by specifying backupset number.
RMAN> list backupset 71;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71 Full 359.73M DISK 00:00:59 08-JAN-12
BP Key: 224 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105813
Piece Name: H:\RMAN2\2RN08965_1_1.BKP
List of Datafiles in backup set 71
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295384 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295384 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS
_FNO-4_1IMVMG63.BKP
3. If we know the backup set tag name then following command is useful.
RMAN> list backupset tag 'TAG20120108T105639';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68 Full 216.98M DISK 00:00:38 08-JAN-12
BP Key: 214 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105639
Piece Name: H:\RMAN2\2ON08938_1_1.BKP
List of Datafiles in backup set 68
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1295337 08-JAN-12 H:\FINANCE\UNDOTBS01.DBF
3 Full 1295337 08-JAN-12 H:\FINANCE\SYSAUX01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69 Full 359.90M DISK 00:01:09 08-JAN-12
List of Datafiles in backup set 69
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295335 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
4 Full 1295335 08-JAN-12 H:\RMAN\DATA_D-FINANCE_I-2590818756_TS-USERS_FNO-4_1IMVMG63.BKP
Backup Set Copy #1 of backup set 69
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:09 08-JAN-12 NO TAG20120108T105639
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
215 1 AVAILABLE H:\RMAN\2NN08937_1_1.BKP
216 2 AVAILABLE H:\RMAN\2NN08937_2_1.BKP
217 3 AVAILABLE H:\RMAN\2NN08937_3_1.BKP
218 4 AVAILABLE H:\RMAN\2NN08937_4_1.BKP
219 5 AVAILABLE H:\RMAN\2NN08937_5_1.BKP
220 6 AVAILABLE H:\RMAN\2NN08937_6_1.BKP
221 7 AVAILABLE H:\RMAN\2NN08937_7_1.BKP
222 8 AVAILABLE H:\RMAN\2NN08937_8_1.BKP
4. We can search particular datafile in backup copy set using follwing command.
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
2 1 A 08-JAN-12 1298637 08-JAN-12 H:\RMAN2\DATA_D-FINANCE_I-2590818756_TS-SY
STEM_FNO-1_32N08GGJ.BKP
5. Following command will list backup of datafile 1 if it has been backed up atleast once in between to specified dates.
RMAN> list backup of datafile 1 completed between '07-jan-2012' and 'sysdate';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
62 Full 359.86M DISK 00:01:12 08-JAN-12
List of Datafiles in backup set 62
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294475 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
Backup Set Copy #1 of backup set 62
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:12 08-JAN-12 NO TAG20120108T103332
List of Backup Pieces for backup set 62 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
197 1 AVAILABLE H:\RMAN\2FN087NS_1_1.BKP
198 2 AVAILABLE H:\RMAN\2FN087NS_2_1.BKP
199 3 AVAILABLE H:\RMAN\2FN087NS_3_1.BKP
200 4 AVAILABLE H:\RMAN\2FN087NS_4_1.BKP
201 5 AVAILABLE H:\RMAN\2FN087NS_5_1.BKP
202 6 AVAILABLE H:\RMAN\2FN087NS_6_1.BKP
203 7 AVAILABLE H:\RMAN\2FN087NS_7_1.BKP
204 8 AVAILABLE H:\RMAN\2FN087NS_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64 Full 359.70M DISK 00:00:56 08-JAN-12
BP Key: 206 Status: AVAILABLE Compressed: NO Tag: TAG20120108T104152
Piece Name: H:\RMAN2\2JN0887G_1_1.BKP
List of Datafiles in backup set 64
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294673 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69 Full 359.90M DISK 00:01:09 08-JAN-12
List of Datafiles in backup set 69
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295335 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
Backup Set Copy #1 of backup set 69
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:09 08-JAN-12 NO TAG20120108T105639
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
215 1 AVAILABLE H:\RMAN\2NN08937_1_1.BKP
216 2 AVAILABLE H:\RMAN\2NN08937_2_1.BKP
217 3 AVAILABLE H:\RMAN\2NN08937_3_1.BKP
218 4 AVAILABLE H:\RMAN\2NN08937_4_1.BKP
219 5 AVAILABLE H:\RMAN\2NN08937_5_1.BKP
220 6 AVAILABLE H:\RMAN\2NN08937_6_1.BKP
221 7 AVAILABLE H:\RMAN\2NN08937_7_1.BKP
222 8 AVAILABLE H:\RMAN\2NN08937_8_1.BKP
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71 Full 359.73M DISK 00:00:59 08-JAN-12
BP Key: 224 Status: AVAILABLE Compressed: NO Tag: TAG20120108T105813
Piece Name: H:\RMAN2\2RN08965_1_1.BKP
List of Datafiles in backup set 71
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1295384 08-JAN-12 H:\FINANCE\SYSTEM01.DBF
6. Using following command we can see the list of archivelog files backed up atleast once to disk.
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 8 A 29-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2011_12_30
\O1_MF_1_8_7HVVHLTV_.ARC
2 1 9 A 30-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2011_12_31
\O1_MF_1_9_7HX2XNFO_.ARC
3 1 10 A 31-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2011_12_31
\O1_MF_1_10_7HY178WB_.ARC
4 1 11 A 31-DEC-11 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_11_7HYTDWTC_.ARC
5 1 12 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_12_7HZVFGKL_.ARC
6 1 13 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_13_7J02VNXS_.ARC
7 1 14 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_01
\O1_MF_1_14_7J0JD298_.ARC
8 1 15 A 01-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_02
\O1_MF_1_15_7J2CJVC7_.ARC
9 1 16 A 02-JAN-12 H:\ORACLE\PRODUCT\FLASH_RECOVERY_AREA\FINANCE\ARCHIVELOG\2012_01_02
\O1_MF_1_16_7J3HK6H4_.ARC
10 1 27 A 06-JAN-12 H:\FINANCE\ARCH\ARC00027_0770941832.001
11 1 28 A 06-JAN-12 H:\FINANCE\ARCH\ARC00028_0770941832.001
12 1 29 A 06-JAN-12 H:\FINANCE\ARCH\ARC00029_0770941832.001
13 1 30 A 06-JAN-12 H:\FINANCE\ARCH\ARC00030_0770941832.001
14 1 31 A 07-JAN-12 H:\FINANCE\ARCH\ARC00031_0770941832.001
15 1 32 A 07-JAN-12 H:\FINANCE\ARCH\ARC00032_0770941832.001
16 1 33 A 08-JAN-12 H:\FINANCE\ARCH\ARC00033_0770941832.001
17 1 34 A 08-JAN-12 H:\FINANCE\ARCH\ARC00034_0770941832.001
7. Following command is going to show you backup of archivelog files taken anytime.
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
74 54.32M DISK 00:00:11 08-JAN-12
List of Archived Logs in backup set 74
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 16 934669 02-JAN-12 957090 02-JAN-12
1 27 1195959 06-JAN-12 1207064 06-JAN-12
1 28 1207064 06-JAN-12 1207066 06-JAN-12
1 29 1207066 06-JAN-12 1207151 06-JAN-12
1 30 1207151 06-JAN-12 1235904 07-JAN-12
1 31 1235904 07-JAN-12 1260227 07-JAN-12
1 32 1260227 07-JAN-12 1292271 08-JAN-12
Backup Set Copy #1 of backup set 74
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:11 08-JAN-12 NO TAG20120108T115845
List of Backup Pieces for backup set 74 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
231 1 AVAILABLE H:\RMAN\2TN08CNM_1_1.BKP
232 2 AVAILABLE H:\RMAN\2TN08CNM_2_1.BKP
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75 39.26M DISK 00:00:13 08-JAN-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN2\2UN08CNM_1_1.BKP
List of Archived Logs in backup set 75
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 8 723728 29-DEC-11 750991 30-DEC-11
1 9 750991 30-DEC-11 778009 31-DEC-11
1 10 778009 31-DEC-11 801454 31-DEC-11
1 11 801454 31-DEC-11 833254 01-JAN-12
1 12 833254 01-JAN-12 855003 01-JAN-12
1 13 855003 01-JAN-12 878802 01-JAN-12
1 14 878802 01-JAN-12 901427 01-JAN-12
1 15 901427 01-JAN-12 934669 02-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76 3.02M DISK 00:00:00 08-JAN-12
BP Key: 234 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN\2VN08CO6_1_1.BKP
List of Archived Logs in backup set 76
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 33 1292271 08-JAN-12 1296996 08-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
79 685.50K DISK 00:00:01 08-JAN-12
BP Key: 237 Status: AVAILABLE Compressed: NO Tag: TAG20120108T131318
Piece Name: H:\RMAN2\34N08H3G_1_1.BKP
List of Archived Logs in backup set 79
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 34 1296996 08-JAN-12 1298930 08-JAN-12
8. Following command will search in the backup for archivelogs which were generated after a particular SCN.
RMAN> list backup of archivelog from scn 901427;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
74 54.32M DISK 00:00:11 08-JAN-12
List of Archived Logs in backup set 74
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 16 934669 02-JAN-12 957090 02-JAN-12
1 27 1195959 06-JAN-12 1207064 06-JAN-12
1 28 1207064 06-JAN-12 1207066 06-JAN-12
1 29 1207066 06-JAN-12 1207151 06-JAN-12
1 30 1207151 06-JAN-12 1235904 07-JAN-12
1 31 1235904 07-JAN-12 1260227 07-JAN-12
1 32 1260227 07-JAN-12 1292271 08-JAN-12
Backup Set Copy #1 of backup set 74
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:11 08-JAN-12 NO TAG20120108T115845
List of Backup Pieces for backup set 74 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
231 1 AVAILABLE H:\RMAN\2TN08CNM_1_1.BKP
232 2 AVAILABLE H:\RMAN\2TN08CNM_2_1.BKP
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75 39.26M DISK 00:00:13 08-JAN-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN2\2UN08CNM_1_1.BKP
List of Archived Logs in backup set 75
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 15 901427 01-JAN-12 934669 02-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76 3.02M DISK 00:00:00 08-JAN-12
BP Key: 234 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN\2VN08CO6_1_1.BKP
List of Archived Logs in backup set 76
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 33 1292271 08-JAN-12 1296996 08-JAN-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
79 685.50K DISK 00:00:01 08-JAN-12
BP Key: 237 Status: AVAILABLE Compressed: NO Tag: TAG20120108T131318
Piece Name: H:\RMAN2\34N08H3G_1_1.BKP
List of Archived Logs in backup set 79
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 34 1296996 08-JAN-12 1298930 08-JAN-12
9. Following command will search in the backup for archivelogs which were generated between two particular SCN.
RMAN> list backup of archivelog from scn 901427 until scn 901456;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75 39.26M DISK 00:00:13 08-JAN-12
BP Key: 233 Status: AVAILABLE Compressed: NO Tag: TAG20120108T115845
Piece Name: H:\RMAN2\2UN08CNM_1_1.BKP
List of Archived Logs in backup set 75
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 15 901427 01-JAN-12 934669 02-JAN-12
10. Following command will show current incarnation as well past incarnation numbers of database.
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 FINANCE 2590818756 PARENT 1 30-AUG-05
2 2 FINANCE 2590818756 CURRENT 534907 26-DEC-11
RMAN> list incarnation of database finance;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 FINANCE 2590818756 PARENT 1 30-AUG-05
2 2 FINANCE 2590818756 CURRENT 534907 26-DEC-11
http://apdba.blogspot.in/
ReplyDeleteHi Wonderful RMAN List commands Thanks
ReplyDeleteThanks for sharing nice info on RMAN Commands . It would be good if you could share recovery scenarios .
ReplyDelete