Recovery from 10g Backup
Hi,
I use Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod on Windows XP Pro. For administration I use the Entrprise Manager which is deployed with the dataabase (not the separate enterprise manager tool). Every backup is build with the enterprise manager to c:\oracle_backup (device=disk). Enterprise manager genarte the following paramters and statements:
backup device type disk tag '%TAG' database;
backup device type disk tag '%TAG' archivelog all not backed up;
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;
and all backups work fine.
Now my problem:
If I try to recover parts or the full database. the generated statemens do not work. The following error is displayed:
RMAN>
Mit Ziel-Datenbank verbunden: ORPC1 (DBID=2796624186)
Kontrolldatei der Zieldatenbank wird anstelle des Recovery-Katalogs verwendet
RMAN>
Echo einstellen ein
RMAN> run {
2> sql 'alter database datafile 4 offline';
3> sql 'alter database datafile 5 offline';
4> restore datafile 4,5;
5> recover datafile 4,5;
6> sql 'alter database datafile 4 online';
7> sql 'alter database datafile 5 online';
8> }
SQL-Anweisung: alter database datafile 4 offline
SQL-Anweisung: alter database datafile 5 offline
Starten restore um 13.01.07
Zugewiesener Kanal: ORA_DISK_1
Kanal ORA_DISK_1: SID=143 Gerätetyp=DISK
Freigegebener Kanal: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: Fehler bei restore Befehl auf 01/13/2007 09:01:21
ORA-19554: Fehler beim Zuweisen von Gerät, Gerättyp: SBT_TAPE, Gerätname:
ORA-27211: Media Management Library konnte nicht geladen werden
RMAN> exit;
The channel should be Ddisk but RMAN tried to use SBT_TYPE
How can I fix the channel to disk so that enterprise manage does not use tape?
thank you for your help