Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 253

10 B A A DISK 18-OCT-13 1 1 YES
TAG20131018T031922
12 B A A DISK 18-OCT-13 1 1 YES
TAG20131018T032513
14 B A A DISK 18-OCT-13 1 1 YES
TAG20131018T134136
16 B A A DISK 18-OCT-13 1 1 YES
TAG20131018T134839
In Exercise 6.2, you will get to experiment with the LIST command.
exeRCiSe 6.2
Using the liST Command
1. Log into RMAN, connecting to your recovery catalog:
C:\>rman target=/ catalog=rcat_user/rcat_user@rcat
Recovery Manager: Release 12.1.0.1.0 -
Production on Sat Jan 4 20:01:34 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1195614221)
connected to recovery catalog database
2. You can see what backups are available by calling the LIST BACKUP OF DATABASE
SUMMARY command:
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
---- -- -- - ----------- --------------- ------- ------- ---------- ---
1253 B F A DISK 18-OCT-13 1 1 YES
TAG20131018T152908
1342 B F A DISK 18-OCT-13 1 1 YES
TAG20131018T163034
3. To look at both of these backups in more detail, call the LIST BACKUP command:
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------