Error: ORA-00354 – (Oracle Hidden Parameter : _allow_resetlogs_corruption)

NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support. You are trying to start your DATABASE, you found the aforementioned error i.e. ORA-00354.
.

Required Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but not including, the corrupted redo log file.

What will happen, if you don’t have Valid Backup? There is a Workaround via which you can at least recover your Database to some extent:

SQL> select * from v$log;

SQL> alter system set “_allow_resetlogs_corruption”=true scope=spfile;

SQL> shutdown immediate;

SQL> startup mount;

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 897612315 generated at 10/19/2005 16:54:18 needed for thread 1 ORA-00289:
suggestion : /opt/oracle/oradata/conner/archive/1_160.dbf
ORA-00280: change 897612315 for thread 1 is in sequence #160
Specify log: {=suggested | filename | AUTO | CANCEL} cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:’/opt/oracle/oradata/conner/system01.dbf’
ORA-01112: media recovery not started

SQL> alter database open resetlogs;

SQL> shutdown immediate;

SQL> startup

Fri Jun 10 16:30:25 2005
alter database open resetlogs
Fri Jun 10 16:30:25 2005

RESETLOGS is being done without consistency checks. This may result in a corrupted database.

The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 240677200 Resetting resetlogs

activation ID 3171937922 (0xbd0fee82)

NOTE : I would strongly recommend to immediately take Logical Backup

(either Using Data Pump in 10g or Import/Export, the conventional one) and Create New Database

About the Author Muhammad Rawish Siddiqui

Master in Computer Science and Post-Graduation in MIS. EDRP (EC-Council Disaster Recovery Professional), Security+, OCP 7.3, 10, 11g, 12c, 11i, R12, OCE 11i System Administration, Linux and RAC 10g, 11g, and OCS in Performance Tuning. More than 18 years’ Information Technology consecutive hands-on experience, possess diversified business and technical background on a wide variety platforms, hardware and operating systems, in the Capacity of Sr. Team Lead Consultant, Sr. Database Administrator, Sr. Applications DBA, Sr. Resident Consultant and Manager Systems. Extensive experience in managing ERP environments and large Databases including Space Management, Backup and Recover, Performance Tuning, Routine Tasks Automation and Database/Applications Health Checks. Started Oracle related Career from Oracle 6. Worked on 7, 8, 9i, 10g, 11g, 12c & e-Business 11.0.3, 11.5.9, 11.5.10.2, R12 and R12.2. Distinct Technical Jobs such as installation, migration, implementation, upgrade, cloning, and maintenance were performed hundreds number of times. Database and Applications (Security & Performance) related Health Checks, RAC & Data Guard Implementation/Troubleshooting Switchover/Failover were also made during the tenure on the basis of As-When-Needed. Contact Me for Database/Applications Installation, Upgrade, Migration, Disaster Recovery, Troubleshooting and Health Checks.

Leave a Comment:

3 comments
Laurent Schneider says November 18, 2008

Hey, you rule, I like the way you add the disclaimers,
– DO NOT use it until and unless instructed by Oracle Support
– take Logical Backup

Probably it will save one guy from googling for the error message and blind-trying the trick !

🙂

Reply
Johny Vaelens says June 4, 2010

Worked for me !
– manually created controlfiles
– added “_allow_restlogs_corruption = true” (without quotes) to the INI file
– alter database open resetlogs
– shutdown immediate
– removing parameter as per above
– DB startup

Reply
Hervé says December 8, 2014

worked for me too !

Reply
Add Your Reply

Not found