网站关键词密度,抖音采用了哪些网络营销方式,可信赖的常州网站建设,建设银行网站预约取款客户在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:…客户在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 pid20, OS id4264 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工具,一键恢复 然后直接recover 数据文件成功 对于这类缺少归档数据文件offline的故障Oracle Recovery Tools可以快速傻瓜式恢复 软件下载:OraRecovery下载 使用说明:使用说明
