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 commandsYou must have the right to query and display information about devices to use the lspiece command.
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 ]...
Displays data in long form.
Displays data in short form.
Does not display header row.
Includes information about backup sections used by the backup pieces.
Specifies one or more backup piece object identifiers. Refer to "oid-list" for a description of the oid-list placeholder.
Specifies the name of the host machine to which the listing applies.
Specifies the names of the databases whose backup pieces you want to list.
Specifies the DBIDs of the databases whose backup pieces you want to list.
Specifies the types of backup information contained by the backup piece. Refer to "content" for a description of the content placeholder.
Specifies the names of the backup pieces to which the listing applies.
Table 2-13 describes the output of the lspiece command.
| 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 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