next up previous contents
Next: Advanced Backup Up: Using RMAN Previous: Basic Recovery   Contents

Listing Backups

Lets spend just a minute looking alittle more at the history of backups using the "list" RMAN command. Using the "list backup" RMAN statement we can list the backups we've made.

[oracle@vixen oracle]$echo $ORACLE_SID
cuddle
[oracle@vixen oracle]$rman nocatalog
Recovery Manager: Release 10.1.0.2.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle.  All rights reserved.

RMAN> connect target /
connected to target database: CUDDLE (DBID=251015092)
using target database controlfile instead of recovery catalog

RMAN> list backup;

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    441M       DISK        00:01:23     15-OCT-04      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20041015T175207
        Piece Name: /export/rman/rman_CUDDLE_01g2k8m8_1_1.bus
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 396472     15-OCT-04 /u02/oradata/cuddle/system01.dbf
  2       Full 396472     15-OCT-04 /u02/oradata/cuddle/undotbs01.dbf
  3       Full 396472     15-OCT-04 /u02/oradata/cuddle/sysaux01.dbf
  4       Full 396472     15-OCT-04 /u02/oradata/cuddle/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    2M         DISK        00:00:02     15-OCT-04      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20041015T175207
        Piece Name: /export/rman/rman_CUDDLE_02g2k8ou_1_1.bus
  Controlfile Included: Ckp SCN: 396502       Ckp time: 15-OCT-04
  SPFILE Included: Modification time: 15-OCT-04

RMAN>

Here we can see 2 backup pieces, the first contains the datafiles for the "cuddle" database, is 441MB in side, was made to disk and took 1 minute and 23 seconds to make. We aslo see the peices tag (notice the tag is the same for both peices). Notice also that each datafile in the backup peice has a Checkpoint System Change Number (Ckp SCN) associated with it (SCNs were covered earlier). The second peice is 2MB in size, took 2 seconds to backup and was done to disk. Notice that the second peice lists the modification time for the SPFILE and the SCN for the Controlfile.

The list command has a number of argument that can allow you to tailor the output to just about any way you want to see it. A nice and consice output is seen using "list backup summary".

See a complete list of options to the RMAN list command in the Oracle Database Recovery Manager Reference manual:

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10770/toc.htm


next up previous contents
Next: Advanced Backup Up: Using RMAN Previous: Basic Recovery   Contents
2005-02-10