Home » RDBMS Server » Backup & Recovery » List Backup Summary command output - RMAN (Oracle 9i Win2000)
icon5.gif  List Backup Summary command output - RMAN [message #290208] Thu, 27 December 2007 23:54 Go to next message
mm0073
Messages: 2
Registered: November 2007
Junior Member
Hi,
When I issue the following
RMAN> list backup summay
I get the following output(see below). What does an asterisk under the device type mean ? Previously under this heading the device type showed SBT_TAPE. I have also include the out of a SHOW ALL command further dowm

Thanx to those who respond

144523 B 0 A * 21-DEC-07 1 2 PROD INC LVL0 DAILY BACKUP
144524 B 0 A * 21-DEC-07 1 2 PROD INC LVL0 DAILY BACKUP
144546 B F A * 21-DEC-07 1 2 TAG20071221T231617
144553 B A A * 21-DEC-07 1 2 TAG20071221T231630
144554 B A A * 21-DEC-07 1 2 TAG20071221T231630
144613 B 0 A * 22-DEC-07 1 2 PROD INC LVL0 DAILY BACKUP
144614 B 0 A * 22-DEC-07 1 2 PROD INC LVL0 DAILY BACKUP
144636 B F A * 22-DEC-07 1 2 TAG20071222T231247
144643 B A A * 22-DEC-07 1 2 TAG20071222T231252
144644 B A A * 22-DEC-07 1 2 TAG20071222T231252
144696 B 0 A * 23-DEC-07 1 2 PROD INC LVL0 DAILY BACKUP
144697 B 0 A * 23-DEC-07 1 2 PROD INC LVL0 DAILY BACKUP
144719 B F A * 23-DEC-07 1 2 TAG20071223T231237
144726 B A A * 23-DEC-07 1 2 TAG20071223T231244

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'd:\oracle\backup\%d_t%t_s%s_p%p';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' FORMAT '%d_t%t_s%s_p%p' PARMS 'ENV=(DSMO_AVG_SIZE=265)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFPROD.ORA'; # default
RMAN configuration has no stored or default parameters
Re: List Backup Summary command output - RMAN [message #290233 is a reply to message #290208] Fri, 28 December 2007 02:33 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
I cannot explain it. According to the manual:

"Device Type:

The type of device on which the backup was made, for example, DISK or sbt."


Try to select from the RC_* views to see if the "*" values are coming from the RMAN catalog database. Example:

SELECT device_type, COUNT(*) FROM rc_backup_piece GROUP BY device_type;
Previous Topic: RMAN archive backup error
Next Topic: RMAN Recovery Catalog down for 4 days
Goto Forum:
  


Current Time: Sun Dec 04 14:53:49 CST 2016

Total time taken to generate the page: 0.05675 seconds