您的位置:首页 > 汽车 > 时评 > 企业开办全程网办_电器网站建设流程_广州中小企业seo推广运营_seo网址优化靠谱

企业开办全程网办_电器网站建设流程_广州中小企业seo推广运营_seo网址优化靠谱

2024/12/26 8:42:56 来源:https://blog.csdn.net/xifenfei/article/details/144318611  浏览:    关键词:企业开办全程网办_电器网站建设流程_广州中小企业seo推广运营_seo网址优化靠谱
企业开办全程网办_电器网站建设流程_广州中小企业seo推广运营_seo网址优化靠谱

客户在win上面迁移数据文件,由于原库非归档,结果导致有两个文件scn不一致,无法打开库,结果他们选择offline文件,然后打开数据库

Wed Dec 04 14:06:04 2024

alter database open

Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_6056.trc:

ORA-01113: 文件 10 需要介质恢复

ORA-01110: 数据文件 10: 'C:\PROGRAM FILES\ORACLE\XFF1.DBF'

ORA-1113 signalled during: alter database open...

Wed Dec 04 14:08:18 2024

alter database datafile 'c:\program files\oracle\XFF1.dbf' offline drop

Completed: alter database datafile 'c:\program files\oracle\XFF1.dbf' offline drop

Wed Dec 04 14:08:31 2024

alter database open

Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_6056.trc:

ORA-01113: 文件 26 需要介质恢复

ORA-01110: 数据文件 26: 'C:\PROGRAM FILES\ORACLE\XFF2.DBF'

ORA-1113 signalled during: alter database open...

Wed Dec 04 14:08:31 2024

Checker run found 1 new persistent data failures

Wed Dec 04 14:08:51 2024

alter database datafile 'c:\program files\oracle\XFF2.dbf' offline drop

Completed: alter database datafile 'c:\program files\oracle\XFF2.dbf' offline drop

alter database open

Wed Dec 04 14:08:57 2024

Thread 1 opened at log sequence 136210

  Current log# 1 seq# 136210 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Wed Dec 04 14:08:57 2024

SMON: enabling cache recovery

Successfully onlined Undo Tablespace 2.

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is AL32UTF8

No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Wed Dec 04 14:08:59 2024

QMNC started with pid=20, OS id=4264

Completed: alter database open

后面自行尝试recover 数据文件没有成功

Wed Dec 04 14:42:50 2024

ALTER DATABASE RECOVER  datafile 26 

Media Recovery Start

Serial Media Recovery started

ORA-279 signalled during: ALTER DATABASE RECOVER  datafile 26  ...

ALTER DATABASE RECOVER    CONTINUE DEFAULT 

Media Recovery Log D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2024_12_04\O1_MF_1_135983_%U_.ARC

Errors with log D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2024_12_04\O1_MF_1_135983_%U_.ARC

ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...

ALTER DATABASE RECOVER CANCEL

Media Recovery Canceled

Completed: ALTER DATABASE RECOVER CANCEL

由于这两个文件处于offline状态导致客户很多操作报ORA-00376 ORA-01110之类错

ORA-00376: file 10 cannot be read at this time

ORA-01110: data file 10: 'C:\PROGRAM FILES\ORACLE\XFF1.DBF'

对于这类故障使用Oracle Recovery Tools工具,一键恢复
 

225133


然后直接recover 数据文件成功
 

QQ20241207-185503


对于这类缺少归档数据文件offline的故障Oracle Recovery Tools可以快速傻瓜式恢复
软件下载:OraRecovery下载
使用说明:使用说明

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com