Mon Apr 17 09:35:04 2023

ALTER DATABASE OPEN

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_10192.trc:

ORA-01113: 文件 1 需要介質(zhì)恢復(fù)

ORA-01110: 數(shù)據(jù)文件 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF'

ORA-1113 signalled during: ALTER DATABASE OPEN...

Mon Apr 17 09:35:05 2023

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_m000_9788.trc:

ORA-00322: 日志 6 (用于線程 1) 不是最新副本

ORA-00312: 聯(lián)機(jī)日志 6 線程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOG'

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_m000_9788.trc:

ORA-00314: 日志 7 (用于線程 1) 要求的 sequence# 15257 與 15248 不匹配

ORA-00312: 聯(lián)機(jī)日志 7 線程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO07.LOG'

Mon Apr 17 10:10:49 2023

alter database open resetlogs

RESETLOGS is being done without consistancy checks. This may result

in a corrupted database. The database should be recreated.

RESETLOGS after incomplete recovery UNTIL CHANGE 3159276957

Resetting resetlogs activation ID 1558785994 (0x5ce92fca)

Mon Apr 17 10:11:11 2023

Setting recovery target incarnation to 3

Mon Apr 17 10:11:11 2023

Assigning activation ID 1662170916 (0x6312b724)

Thread 1 opened at log sequence 1

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

Successful open of redo thread 1

Mon Apr 17 10:11:11 2023

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Apr 17 10:11:12 2023

SMON: enabling cache recovery

ORA-01555 caused by SQL statement below (SQL ID: 4krwuz0ctqxdt, SCN: 0x0000.bc4ebda4):

select ctime, mtime, stime from obj$ where obj# = :1

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_9324.trc:

ORA-00704: 引導(dǎo)程序進(jìn)程失敗

ORA-00704: 引導(dǎo)程序進(jìn)程失敗

ORA-00604: 遞歸 SQL 級別 1 出現(xiàn)錯(cuò)誤

ORA-01555: 快照過舊: 回退段號 10 (名稱為 "_SYSSMU10_3905543278$") 過小

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_9324.trc:

ORA-00704: 引導(dǎo)程序進(jìn)程失敗

ORA-00704: 引導(dǎo)程序進(jìn)程失敗

ORA-00604: 遞歸 SQL 級別 1 出現(xiàn)錯(cuò)誤

ORA-01555: 快照過舊: 回退段號 10 (名稱為 "_SYSSMU10_3905543278$") 過小

Error 704 happened during db open, shutting down database

USER (ospid: 9324): terminating the instance due to error 704

Instance terminated by USER, pid = 9324

ORA-1092 signalled during: alter database open resetlogs...

SQL> alter database open;

數(shù)據(jù)庫已更改。

SQL> shutdown immediate;

數(shù)據(jù)庫已經(jīng)關(guān)閉。

已經(jīng)卸載數(shù)據(jù)庫。

ORACLE 例程已經(jīng)關(guān)閉。

SQL> startup pfile='d:/pfile.txt' mount;

ORACLE 例程已經(jīng)啟動(dòng)。

Total System Global Area 1.7170E+10 bytes

Fixed Size????????????????? 2262088 bytes

Variable Size??????????? 1.3153E+10 bytes

Database Buffers???????? 3959422976 bytes

Redo Buffers?????????????? 54947840 bytes

數(shù)據(jù)庫裝載完畢。

SQL> select name from v$datafile where name like '%MISSING%';

NAME

--------------------------------------------------------------------------------

D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00012

D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00013

已選擇2行。

SQL> alter database rename file 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00012'

???2 to 'D:\oradata\XIFENFEI_04.DBF';

數(shù)據(jù)庫已更改。

SQL> alter database rename file 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00013'

???2 to 'D:\oradata\XIFENFEI_5.DBF';

數(shù)據(jù)庫已更改。

SQL> alter database datafile 12,13 online;

數(shù)據(jù)庫已更改。

SQL>

SQL>

SQL> alter database open ;

alter database open

*

第 1 行出現(xiàn)錯(cuò)誤:

ORA-01113: 文件 12 需要介質(zhì)恢復(fù)

ORA-01110: 數(shù)據(jù)文件 12: 'D:\ORADATA\XIFENFEI_04.DBF'

SQL> recover datafile 12;

完成介質(zhì)恢復(fù)。

SQL> recover datafile 13;

完成介質(zhì)恢復(fù)。

SQL> alter database open;

數(shù)據(jù)庫已更改。