处理ORA-10458,ORA-01111,ORA-01110报警

备库启动时出现以下异常:

SQL> startup

ORACLE instance started.

Total System Global Area 3206836224 bytes

Fixed Size                  2257520 bytes

Variable Size            1811942800 bytes

Database Buffers         1375731712 bytes

Redo Buffers               16904192 bytes

Database mounted.

ORA-10458: standby database requires recovery

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01111: name for data file 6 is unknown - rename to correct file

ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNN

AMED00006'

报警文件:

Managed Standby Recovery starting Real Time Apply

Standby Crash Recovery aborted due to error 1111.

Errors in file /u01/app/oracle/diag/rdbms/orcl151/orcl151/trace/orcl151_ora_3931.trc:

ORA-01111: name for data file 6 is unknown - rename to correct file

ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01111: name for data file 6 is unknown - rename to correct file

ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'

Completed Standby Crash Recovery.

Errors in file /u01/app/oracle/diag/rdbms/orcl151/orcl151/trace/orcl151_ora_3931.trc:

ORA-10458: standby database requires recovery

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01111: name for data file 6 is unknown - rename to correct file

ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00006'

ORA-10458 signalled during: ALTER DATABASE OPEN...

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

故障排除:

备库检查是否需要恢复文件

SQL> select * from v$recover_file where error like '%FILE%';

ORA-10458,ORA-01111,ORA-01110异常处理_ide

主库确认数据文件

ORA-10458,ORA-01111,ORA-01110异常处理_ide_02

识别在(备库)中创建的虚拟文件名

ORA-10458,ORA-01111,ORA-01110异常处理_sql_03