Crosscheck backup ORA-19554

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.