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

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

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

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