ADG加数据文件从库报ORA-01111,ORA-01110,ORA-01157处理
1、从库日志有如下报错
主库加数据文件因从库ASM DG空间不足报如下错:
1 2 3 4 5 | 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,报错
1 2 3 4 5 | 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)折中一下处理,在操作系统上把文件建上
1 | SQL> alter database create datafile '/oracle/app/oracle/product/11.2.0/dbs/UNNAMED00624' as '/oracle/oradata/tbs_trash_data.599.1018515191' ; |
3)把文件移回到ASM
1 2 3 | a、数据库重启到mount状态 b、rman target / c、RMAN> copy datafile '/oracle/oradata/tbs_trash_data.599.1018515191' to '+DATA' ; |
4)重命令数据文件
1 2 3 4 5 6 7 8 | 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 |
近期评论