环境:oracle 10.2.0.5 x64 linux
参数文件standby_file_management设的auto
在主库加数据文件,备库报错
ora-01110 datafile 5
ora-01157 cannot identify/lock dataf file 5
检查两边数据文件,发现文件名不一致
select file#,name from v$datafile;
备库:
alter system set standby_file_management=manual;
alter database create datafile '/opt/oracle/11.2.0/dbs//UNNAMED00108' as 'your correct filename ';
alter system set standby_file_management=auto;
alter database recover managed standby database using current logfile disconnect from session;