Crosscheck backup ORA-19554
A ORA-19554 error occurs when a friend executes crosscheck backup in rman.
RMAN> crosscheck backup;
Using channel ORA_DISK_1
Released channel: ORA_DISK_1
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of crosscheck command at 01/23/2015 17:23:19
The ORA-19554: error allocating device, device type: STB, device name:
ORA-27001: unsupported device type
Additional information: 1
The system prompts that STB cannot be found, and there is no such device. Execute the following command to display all configuration information:
RMAN> show all;
RMAN configuration parameters are:
Configure retention policy to redundancy 1; # default
Configure backup optimization off; # default
Configure default device type to disk; # default
Configure controlfile autobackup off;
Configure controlfile autobackup format for device type disk to '% F'; # default
Configure controlfile autobackup format for device type stb to '% F'; # default
Configure controlfile autobackup format for device type SBT_TAPE TO '% F'; # default
Configure device type disk backup type to backupset parallelism 1;
Configure device type 'stb' backup type to compressed backupset parallelism 1;
Configure device type 'sbt _ TAPE 'backup type to backupset parallelism 1;
Configure datafile backup copies for device type disk to 1; # default
Configure datafile backup copies for device type stb to 1; # default
Configure datafile backup copies for device type SBT_TAPE TO 1; # default
Configure archivelog backup copies for device type disk to 1; # default
Configure archivelog backup copies for device type stb to 1; # default
Configure archivelog backup copies for device type SBT_TAPE TO 1; # default
Configure channel device type disk format '/u02/test_df % t_s % s_s % P ';
Configure maxsetsize to unlimited; # default
Configure encryption for database off; # default
Configure encryption algorithm 'aes128 '; # default
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to '/u01/app/Oracle/10.2.0/db/dbs/snapcf_test.f'; # default
In the above information
Configure device type 'sbt _ TAPE 'backup type to backupset parallelism 1;
It indicates that someone has set the SBT_TAPE type device information. The following will restore it to the default value:
RMAN> configure device type 'sbt _ TAPE 'clear;
Old RMAN configuration parameters:
Configure device type 'sbt _ TAPE 'backup type to backupset parallelism 1;
RMAN configuration parameters are successfully reset to default value
RMAN> show all;
RMAN configuration parameters are:
Configure retention policy to redundancy 1;
Configure backup optimization off;
Configure default device type to disk;
Configure controlfile autobackup off;
Configure controlfile autobackup format for device type disk to '% F ';
Configure controlfile autobackup format for device type 'std' TO '% F ';
Configure controlfile autobackup format for device type 'sbt _ TAPE 'TO' % F ';
Configure device type disk backup type to backupset parallelism 1;
Configure device type 'stb' backup type to compressed backupset parallelism 1;
Configure datafile backup copies for device type disk to 1;
Configure datafile backup copies for device type 'std' TO 1;
Configure datafile backup copies for device type 'sbt _ TAPE 'TO 1;
Configure archivelog backup copies for device type disk to 1;
Configure archivelog backup copies for device type 'stb' TO 1;
Configure archivelog backup copies for device type 'sbt _ TAPE 'TO 1;
Configure channel device type disk format '/u02/test_df % t_s % s_s % P ';
Configure maxsetsize to unlimited;
Configure encryption for database off;
Configure encryption algorithm 'aes128 ';
Configure archivelog deletion policy to none;
Configure snapshot controlfile name to '/u01/app/oracle/10.2.0/db/dbs/snapcf_test.f ';
Then execute the crosscheck backup command:
RMAN> crosscheck backup;
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 145 devtype = DISKcrosschecked backup piece: found to be 'available'
Backup piece handle =/u02/test_df869734336_s15_s1 recid = 5 stamp = 869734336
Crosschecked backup piece: found to be 'available'
Backup piece handle =/u02/test_df86973446450s16_s1 recid = 6 stamp = 869734463
Crosschecked 2 objects