一点一滴努力,满仓满谷收成

1、从库日志有如下报错
主库加数据文件因从库ASM DG空间不足报如下错：

Errors in file /oracle/app/oracle/diag/rdbms/stby/gxd/trace/gxd_dbw0_11795.trc:
ORA-01186: file 624 failed verification tests
ORA-01157: cannot identify/lock data file 624 - see DBWR trace file
ORA-01111: name for data file 624 is unknown - rename to correct file
ORA-01110: data file 624: '/oracle/app/oracle/product/11.2.0/dbs/UNNAMED00624'

2、处理
1)尝试加回到ASM,报错

SQL> alter database create datafile '/oracle/app/oracle/product/11.2.0/dbs/UNNAMED00624' as '+DATA/stby/datafile/tbs_trash_data.599.1018515191';

ERROR at line 1:
ORA-01276: Cannot add file +DATA/stby/datafile/tbs_trash_data.599.1018515191.
File has an Oracle Managed File name.

2)折中一下处理，在操作系统上把文件建上

SQL> alter database create datafile '/oracle/app/oracle/product/11.2.0/dbs/UNNAMED00624' as '/oracle/oradata/tbs_trash_data.599.1018515191';

3)把文件移回到ASM

a、数据库重启到mount状态
b、rman target /
c、RMAN> copy datafile  '/oracle/oradata/tbs_trash_data.599.1018515191' to '+DATA';

4)重命令数据文件

a.sqlplus / as sysdba
b.数据库在mount状态，重命名
SQL>alter system set standby_file_management=manual;
SQL>alter database rename file '/oracle/oradata/tbs_trash_data.599.1018515191' to '+DATA/stby/datafile/tbs_trash_data.953.1018536087';
SQL>alter system set standby_file_management=auto;
SQL>alter database open;
SQL>alter database recover managed standby database disconnect from session using current logfile;  --11G
SQL>alter database recover managed standby database disconnect from session; --10G