List Backup Summary command output - RMAN [message #290208] |
Thu, 27 December 2007 23:54 |
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 |
Frank Naude
Messages: 4587 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;
|
|
|