list backup

Syntax

list backup [-restorepoint restorepoint] [-controlfile]
              [-summary] [-catpwd password] [-shard shard_list]

Options

Table 2-52 GDSCTL list backup Options

Option	Description
`-restorepoint restorepoint`	An SDB global restore point. If specified, only backups that are usable to restore the specified shards to the specific restore point are listed. Otherwise, all backups for the specified shards are listed.
`-controlfile`	If specified, only backups usable to restore database control files to a specific restore point are listed.
`-summary`	If specified, the backups are listed in summary format.
`-catpwd password`	Password for user GSMCATUSER. Prompted if not specified. This password only needs to be specified once for this command in an entire GDSCTL session.
`-shard shard_list`	shard_list specifies a comma separated list of shard identifiers. They can be shard space, shard group or shard names. The default is `no shards`.

Examples

The following example shows how to list the backups of control files from the SDB catalog database in summary.

GDSCTL> list backup -shard catalog -controlfile -summary -catpwd gsm
 
Listing backups for database "v1908" ...

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1366    B  F  A DISK        13-APR-20       1       1       NO         TAG20200413T234608
1851    B  F  A DISK        14-APR-20       1       1       NO         TAG20200414T000333
1996    B  F  A DISK        14-APR-20       1       1       NO         TAG20200414T001446
2057    B  F  A DISK        14-APR-20       1       1       NO         TAG20200414T001519
2151    B  F  A DISK        14-APR-20       1       1       NO         TAG20200414T012934
3205    B  F  A DISK        14-APR-20       1       1       NO         TAG20200414T202822
 
Recovery Manager complete.

The next example shows the use of the command to list the backups from shard v1908b_cdb2_pdb1 recoverable to restore point backup_before_db_maintenance.

GGDSCTL> list backup -shard v1908b_cdb2_pdb1 -restorepoint BACKUP_BEFORE_DB_MAINTENANCE
"GSMCATUSER" password:
 
Listing backups for database "v1908b_cdb2_pdb1" ...
List of Backup Sets
=================== 
 
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2998    Incr 0  265.53M    DISK        00:00:06     14-APR-20      
        BP Key: 3009   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_BEFORE_DB_MAINTENANCE
        Piece Name: /tmp/rman/backups/2/0sutl6oa
  List of Datafiles in backup set 2998
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  11   0  Incr 2678401    14-APR-20              NO    /ade/b/3998875997/oracle/dbs/cdb2_pdb1_db.f
 
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2999    Incr 0  191.61M    DISK        00:00:04     14-APR-20      
        BP Key: 3010   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_BEFORE_DB_MAINTENANCE
        Piece Name: /tmp/rman/backups/1/0tutl6oh
  List of Datafiles in backup set 2999
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  12   0  Incr 2678425    14-APR-20              NO    /ade/b/3998875997/oracle/dbs/cdb2_pdb1_ax.f
  13   0  Incr 2678425    14-APR-20              NO    /ade/b/3998875997/oracle/dbs/cdb2_pdb1_xdb.f
 
Recovery Manager complete.