lspiece

Purpose

Use the lspiece command to display information about RMAN backup pieces. Backup pieces are the physical members of backup sets. One RMAN backup piece corresponds to one Oracle Secure Backup backup image. Oracle Secure Backup stores and reports Oracle Database metadata about the contents of each backup piece.

See Also:

"Backup Piece Commands" for related commands

Prerequisites

You must have the right to query and display information about devices to use the lspiece command.

Syntax

lspiece::=

lspi•ece [ --long/-l | --short/-s ] [ --noheader/-H ] [ --section/-S ]
[ --oid/-o oid-list ]... [ --host/-h hostname[,hostname]... ]
[ --dbname/-d dbname[,dbname]... ]
[ --dbid/-i dbid[,dbid]... ]
[ --content/-c content[,content]... ]
[ piecename ]...

Semantics

--long/-l: Displays data in long form.
--short/-s: Displays data in short form.
--noheader/-H: Does not display header row.
--section/-S: Includes information about backup sections used by the backup pieces.
--oid/-o oid-list ...: Specifies one or more backup piece object identifiers. Refer to "oid-list" for a description of the oid-list placeholder.
--host/-h hostname ...: Specifies the name of the host machine to which the listing applies.
--dbname/-d dbname ...: Specifies the names of the databases whose backup pieces you want to list.
--dbid/-i dbid ...: Specifies the DBIDs of the databases whose backup pieces you want to list.
--content/-c content ...: Specifies the types of backup information contained by the backup piece. Refer to "content" for a description of the content placeholder.
piecename ...: Specifies the names of the backup pieces to which the listing applies.

Output

Table 2-13 describes the output of the lspiece command.

Table 2-13 lspiece Output

Label	Indicates
Backup piece OID	The backup piece object identifier
Database	The name of the database that was backed up
Database ID	The DBID of the database that was backed up
Content	The content of the backup (see "content")
Copy number	The backup piece copy number
Created	The creation date of the backup piece
Host	The database host
Piece name	The name of the backup piece

Example

Example 2-69 uses Recovery Manager to back up a datafile and all archived redo logs to tape by using the Oracle Secure Backup SBT interface. The example then displays information about the backup pieces on tape.

Example 2-69 Listing Backup Pieces

% rman TARGET /
RMAN> backup datafile 3;
 
Starting backup at 18-MAR-05
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=23 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00003 name=/home/oracle/dbs/data.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAR-05
channel ORA_SBT_TAPE_1: finished piece 1 at 18-MAR-05
piece handle=05gfkmq9_1_1 tag=TAG20050318T162441 comment=API Version 2.0,MMS
Version 10.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:26
Finished backup at 18-MAR-05
 
RMAN> backup archivelog all;
 
Starting backup at 18-MAR-05
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=33 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting archive log backupset
channel ORA_SBT_TAPE_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=1 stamp=553170151
input archive log thread=1 sequence=2 recid=2 stamp=553170267
input archive log thread=1 sequence=3 recid=3 stamp=553278730
channel ORA_SBT_TAPE_1: starting piece 1 at 18-MAR-05
channel ORA_SBT_TAPE_1: finished piece 1 at 18-MAR-05
piece handle=06gfkn8h_1_1 tag=TAG20050318T163215 comment=API Version 2.0,MMS
Version 10.2.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:08
Finished backup at 18-MAR-05
 
RMAN> EXIT;
% obtool
ob> lspiece --long
Backup piece OID:       104
    Database:               sample
    Database ID:            1557615826
    Content:                full
    Copy number:            0
    Created:                2005/03/18.16:25
    Host:                   stadv07
    Piece name:             05gfkmq9_1_1
Backup piece OID:       105
    Database:               sample
    Database ID:            1557615826
    Content:                archivelog
    Copy number:            0
    Created:                2005/03/18.16:32
    Host:                   stadv07
    Piece name:             06gfkn8h_1_1