分类: Oracle
2008-08-04 18:18:58
RMAN> run{
2> set until scn=23176673837;
3> set newname for datafile 1 to 'E:\FSPDC\SYSTEM01.DBF';
4> set newname for datafile 38 to 'E:\FSPDC\UNDO.DBF';
5> set newname for datafile 3 to 'E:\FSPDC\INDX01.DBF';
6> set newname for datafile 4 to 'E:\FSPDC\TOOLS01.DBF';
7> set newname for datafile 5 to 'F:\FSPDC\USERS01.DBF';
8> set newname for datafile 6 to 'F:\FSPDC\SPODATA.DBF';
9> set newname for datafile 16 to 'G:\FSPDC\UNDO1.DBF';
10> set newname for datafile 27 to 'G:\FSPDC\TBS_IDX_SSCL_RESULT_DATA.DBF';
11> set newname for datafile 45 to 'G:\FSPDC\TBS_SMALL_4.DBF';
12> set newname for datafile 49 to 'G:\FSPDC\TBS_IDX_SMALL_4.DBF';
13> set newname for datafile 56 to 'G:\FSPDC\SPODATA_E1.DBF';
14> restore database;
15> switch datafile all;
16> recover database;
17> sql 'alter database open resetlogs';
18> }
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 13-JUN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=3293 devtype=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/13/2008 18:24:45
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27023: skgfqsbi: media manager protocol error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001003) The job failed because Backup Exec could not find the req
uired information in the Remote Agent Utility. Run the Remote Agent Utility and
check that the appropriate information has been entered.
show all;
配置里多了很多SBT_TAPE的设置,虽然default的配置仍然是Disk,可是这些参数可能是导致问题的罪魁祸首。
清除这些设置,清除后恢复正常。
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear;