Can't Restore - ORA-19554: error allocating device, device type: SBT_TAPE,
602669Nov 5 2008 — edited Nov 5 2008All: I am having problems restoring a disaster recovery database because Rman is looking for backup sets on tape rather than disk. Here is the situation:
1. I have a production database on one server.
2. I do a daily full backup to tape. The retention policy is 30 days.
3. I do a daily full backup to disk. The retention policy is 3 days.
4. The archive logs are multiplexed to the production server and to an NFS mounted disk that is readable by the both the production and DR servers.
5. The control file is backed up to the NFS disk every 1/2 hour.
Below is the script I use to restore. No matter what I do, it continues to look for backup pieces on tape even though the disk has everything it needs.
Any thoughts on how to proceed.
Thanks,
John
connect target /
restore controlfile from 'opt/drdump/oradata/dpsprod/DPSPROD_CONTROL_FILE_200811'/opt/drdump/oradata/dpsprod/DPSPROD_CONTROL_FILE_
startup nomount;
run
{
allocate channel c1 device type disk;
restore controlfile from '/opt/drdump/oradata/dpsprod/DPSPROD_CONTROL_FILE_20081104_cmjus4mb_1_1';
release channel c1;
alter database mount;
allocate channel c2 device type disk;
restore database;
recover database;
release channel c2;
}