在自己的数据库上面做实验:重建控制文件;重建控制文件成功了,成功之后。
重启数据库;
发生
ORA-01206: 文件不是此数据库的一部分 - 数据库 ID 错误
Cause
Immediately after changing the DBID using NID, we need to shutdown the DB from mount stage.
NID updates the datafile headers with the new DBID. It doesnot do it for the DBID that is stored in SGA from the controlfile before running NID. A restart resolves that.
原因:是控制文件的scn和数据文件的不一致。scn和检查点不一致。数据库验证失败.
查看警告日志,没有发现有用信息.
数据库在:archive log list; 非归档模式下面。
Thu Mar 31 10:30:54 2011
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
没有备份。
现在是不是不可以恢复了啊?没有备份,所以不知道咋办啦?求教