rman 的crosscheck命令问题！

tonykorn97 · 发表于 2007-10-31 18:08

执行的时候报：

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=115 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=135 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=76 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=64 devtype=DISK
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 10/31/2007 18:05:56
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

RMAN>

tonykorn97 · 发表于 2007-10-31 18:09

怎么才能分配的时候不分配磁带通道？

bluemoon0083 · 发表于 2007-10-31 18:36

最初由 tonykorn97 发布
[B]怎么才能分配的时候不分配磁带通道？ [/B]

这个估计就是你在configure里面设置的了
show all看一下，特别是带device选项的

bluemoon0083 · 发表于 2007-10-31 18:38

用ALLOCATE CHANNEL也可以手工分配的

tonykorn97 · 发表于 2007-10-31 18:39

RMAN> show all;

using target database control file instead of recovery catalog
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 ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

tonykorn97 · 发表于 2007-10-31 18:39

想把磁带的去掉，可是一直去不掉！

tonykorn97 · 发表于 2007-10-31 18:40

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE clear;

RMAN configuration parameters are successfully reset to default value

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 ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

清掉后有出来了！

stronghearted · 发表于 2007-10-31 18:48

最初由 tonykorn97 发布
[B]RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE clear;

RMAN configuration parameters are successfully reset to default value

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 ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

清掉后有出来了！ [/B]

弄错了吧 CONFIGURE CONTROLFILE.......

估计你用的10g,遇到过相同的问题。
这样试试
run
{
allocate channel ch1 type disk;
crosscheck backup;
}

tonykorn97 · 发表于 2007-10-31 18:51

是10G

tonykorn97 · 发表于 2007-10-31 18:55

最初由 stronghearted 发布
[B]

弄错了吧 CONFIGURE CONTROLFILE.......

估计你用的10g,遇到过相同的问题。
这样试试
run
{
allocate channel ch1 type disk;
crosscheck backup;
} [/B]

我运行一下命令可以，感谢stronghearted
run {
allocate channel ch1 type disk;
CROSSCHECK BACKUPSET;
CROSSCHECK COPY;
}

请问有没有命令可以删除默认的磁带设置的？