ORA-01172: recovery of thread 1 stuck at block 3024 of file 19


ERROR :

 SQL> startup

ORACLE instance started.

Total System Global Area 2.1475E+10 bytes

Fixed Size                 12170960 bytes

Variable Size            3019901232 bytes

Database Buffers         1.8388E+10 bytes

Redo Buffers               54935552 bytes

Database mounted.

ORA-01172: recovery of thread 1 stuck at block 3024 of file 19

ORA-01151: use media recovery to recover block, restore backup if needed

Cause: 

This error usually means that blocks of file 19 are corrupted, In this case we need to recover file 19.

Crash recovery or instance recovery could not apply a change to a block because it was not the next change. 
This can happen if the block was corrupted and then repaired during recovery.

SOLUTION :- 

We need to recover all of corrupted block by using data file recovery or Database recovery. 

In my case I have recover datafile 19.

SQL>  recover datafile 19;

Media recovery complete.

SQL> alter database open;

Database altered.

SQL> select name,OPEN_MODE from v$database;

NAME      OPEN_MODE

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

TEST    READ WRITE


ORA-19563: header validation failed for file

Encountered while restoring the server on test database.

Restore log file :-

Finished restore at 03-MAR-22

released channel: c1

released channel: c2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of switch command at 03/03/2022 22:58:55

ORA-19563:  header validation failed for file

RMAN>


CAUSE :-

Check alerts log in target and get the file number/name for which throwing this error .

SQL > SELECT FILE#, NAME FROM V$DATAFILE where  NAME like '%system%';

FILE#           NAME

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

 92            /u01/test/db/apps_st/data/system17.dbf

 139          /u01/test/db/apps_st/data/system17.dbf


Solution :-

Rename the file like (system17.dbf to system18.dbf)

SQL > SELECT FILE#, NAME FROM V$DATAFILE where  NAME like '%system%';

FILE#           NAME

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

 92            /u01/test/db/apps_st/data/system17.dbf

 139          /u01/test/db/apps_st/data/system18.dbf


NOW try to  restore again.

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...