19624, 00000, "operation failed, retry possible" // *Cause: A backup, restore or image copy operation failed with an I/O // error. If the source of the I/O error can be corrected, then // the operation may be retried. // *Action: This message is used by recovery manager to decide whether or not // to retry the operation.DBCA创建数据库需要复制ORACLE DB模板里的数据文件,类似image copy操作。读取源文件发生I/O错误,检查存储设备,是否有问题,是否可以正常访问。
报错日志: old 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'&data_file_name'); new 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'/u01/app/oracle/oradata/oral/example01.dbf'); old 33: dbms_backup_restore.restoreBackupPiece('&data_file_backup', done); new 33: dbms_backup_restore.restoreBackupPiece('/u01/app/oracle/10.2.0/db_1/assistants/dbca/templates/example01.dfb', done); Allocating device.... Specifying datafiles... Specifing datafiles... Restoring ... declare * ERROR at line 1: ORA-19624: operation failed, retry possible ORA-19870: error reading backup piece /u01/app/oracle/10.2.0/db_1/assistants/dbca/templates/example01.dfb LRM-00116: syntax error at 'tablespaces' following '='楼上说检查存储设备 是指?
// *Cause: A backup, restore or image copy operation failed with an I/O
// error. If the source of the I/O error can be corrected, then
// the operation may be retried.
// *Action: This message is used by recovery manager to decide whether or not
// to retry the operation.DBCA创建数据库需要复制ORACLE DB模板里的数据文件,类似image copy操作。读取源文件发生I/O错误,检查存储设备,是否有问题,是否可以正常访问。
old 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'&data_file_name');
new 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'/u01/app/oracle/oradata/oral/example01.dbf');
old 33: dbms_backup_restore.restoreBackupPiece('&data_file_backup', done);
new 33: dbms_backup_restore.restoreBackupPiece('/u01/app/oracle/10.2.0/db_1/assistants/dbca/templates/example01.dfb', done);
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error reading backup piece
/u01/app/oracle/10.2.0/db_1/assistants/dbca/templates/example01.dfb
LRM-00116: syntax error at 'tablespaces' following '='楼上说检查存储设备 是指?
我用的是虚拟机安装的RedHat 并在上面 安装 oracle