Email: service@parnassusdata.com 7 x 24 online support!

Restart the Oracle database error

Restart the Oracle database error

Mon Jan 14 00:09:42 2015 
MMNL started with pid=16, OS id=14990 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... 
starting up 1 shared server(s) ... 
ORACLE_BASE from environment = /u01/app/oracle 
Mon Jan 14 00:09:42 2015 
ALTER DATABASE MOUNT 
Set as converted control file due to db_unique_name mismatch 
Changing di2dbun from to orcl 
Successful mount of redo thread 1, with mount id 1434172742 
Database mounted in Exclusive Mode 
Lost write protection disabled 
Create Relation IPS_PACKAGE_UNPACK_HISTORY 
Completed: ALTER DATABASE MOUNT 
Mon Jan 14 00:10:13 2015 
alter database open 
Errors in file /u01/app/oracle/oradata/orcl/diag/rdbms/orcl/orcl/trace/orcl_ora_15080.trc: 
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open 
ORA-1589 signalled during: alter database open... 
Mon Jan 14 00:10:26 2015 
ALTER DATABASE RECOVER database using backup controlfile until cancel 
Media Recovery Start 
Serial Media Recovery started 
WARNING! Recovering data file 1 from a fuzzy file. If not the current file 
it might be an online backup taken without entering the begin backup command. 
WARNING! Recovering data file 2 from a fuzzy file. If not the current file 
it might be an online backup taken without entering the begin backup command. 
WARNING! Recovering data file 3 from a fuzzy file. If not the current file 
it might be an online backup taken without entering the begin backup command. 
WARNING! Recovering data file 4 from a fuzzy file. If not the current file 
it might be an online backup taken without entering the begin backup command. 
WARNING! Recovering data file 5 from a fuzzy file. If not the current file 
it might be an online backup taken without entering the begin backup command. 
WARNING! Recovering data file 6 from a fuzzy file. If not the current file 
it might be an online backup taken without entering the begin backup command. 
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ... 
ALTER DATABASE RECOVER CONTINUE DEFAULT 
Media Recovery Log /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2015_03_14/o1_mf_1_2_%u_.arc 
Errors with log /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2015_03_14/o1_mf_1_2_%u_.arc 
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ... 
ALTER DATABASE RECOVER CANCEL 
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ... 
Mon Jan 14 00:10:29 2015 
Checker run found 7 new persistent data failures 
Mon Jan 14 00:10:47 2015 
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 67619908 
Online log /u01/app/oracle/soft/orcl/REDO03.LOG: Thread 1 Group 3 was previously cleared 
Mon Jan 14 00:10:53 2015 

... 

Hex dump of (file 1, block 3273) in trace file /u01/app/oracle/oradata/orcl/diag/rdbms/orcl/orcl/trace/orcl_ora_15080.trc 
Corrupt block relative dba: 0x00400cc9 (file 1, block 3273) 
Bad header found during buffer read 
Data in bad block: 
type: 255 format: 7 rdba: 0xffffffff 
last change scn: 0xffff.ffffffff seq: 0xff flg: 0xff 
spare1: 0xff spare2: 0xff spare3: 0xffff 
consistency value in tail: 0x43830601 
check value in block header: 0xffff 
computed block checksum: 0x446e 
Reading datafile '/u01/app/oracle/soft/orcl/SYSTEM01.DBF' for corruption at rdba: 0x00400cc9 (file 1, block 3273) 
Reread (file 1, block 3273) found same corrupt data 
Mon Jan 14 00:10:54 2015 
Hex dump of (file 2, block 72411) in trace file /u01/app/oracle/oradata/orcl/diag/rdbms/orcl/orcl/trace/orcl_p000_15112.trc 
Corrupt block relative dba: 0x00811adb (file 2, block 72411) 
Bad header found during buffer read 
Data in bad block: 
type: 255 format: 7 rdba: 0xffffffff 
last change scn: 0xffff.ffffffff seq: 0xff flg: 0xff 
spare1: 0xff spare2: 0xff spare3: 0xffff 
consistency value in tail: 0x3ce30608 
check value in block header: 0xffff 
computed block checksum: 0xfe3c 
Reading datafile '/u01/app/oracle/soft/orcl/SYSAUX01.DBF' for corruption at rdba: 0x00811adb (file 2, block 72411) 
Reread (file 2, block 72411) found same corrupt data 
Errors in file 

I have reviewed the alert log and I see the database is finding serious issues.

This is a physical corruption and considering we have it also in file 1, there are probably bootstrap objects.

Do you have any backup for this database? If yes, please proceed with restore/recovery operations.

Otherwise, the information in the blocks is lost and with the errors reported and previous actions of the database, I am not sure if any option to open it.

I have no any backup on this database.

With no backup, the last resort was to force open the database, which was already attempted.

This didn’t work as we have affected a bootstrap object.

Unless the database can be recreated from other source, PRM-DUL (Data recovery UnLoaderhttp://www.parnassusdata.com/en) might be used to scan a database file, recognize table header blocks, access extent information, and read all rows.

It places the unloaded data into a flat file to be subsequently loaded back into a database.

TRY PRM-DUL  http://www.parnassusdata.com/en