Skip Headers
Oracle® Secure Backup Reference
Release 10.1

Part Number B14236-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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