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.