Due to ORA-01033, I could not start my BW 3.5 instance

[Former Member]

Hello Friends,

I am not able to start up my BI 3.5 instance from SAP GUI.

Error in the SAP Manager console is

"Database: > ORA-01033: ORACLE initialization or shutdown in progress"

So I shutdown my oracle database,log on as sysdba and applied following commands.

-

---

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 219749116 bytes

Fixed Size 453372 bytes

Variable Size 134217728 bytes

Database Buffers 83886080 bytes

Redo Buffers 1191936 bytes

Database mounted.

-

---

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

What is this ORA-01589 error all about?

I am still not able to start my BW instance.

Please help me with this.

Thanks & Regards,

-Hardik

[Former Member · Accepted solution]

Hardik,

Try Starting DB with

alter database open resetlogs;

if that doesn't work try this

Stop db.

shutdown;

Now add this to init file

allowresetlogs_corruption = true

allowread_only_corruption = true

In sqlplus

startup mount

Do resetlogs again (and hope for success here)

alter database open resetlogs;

Regards,

Cherry

[Former Member · Accepted solution]

Buf:

Do you know that, if you use the mentioned parameters:

<b>_allow_resetlogs_corruption = true

allowread_only_corruption = true</b>

Oracle will not support your database?

Those parameters are very dangerous as they can cause logical inconsistency.

I would not use them unless directed by Oracle.

Usually they request a FULL DB recreation after using them.

[Former Member · Accepted solution]

Yup, I have used this parameters without any issues in certain critical conditions as mentioned above.I beileve these parameters can be used in abnormal situations like this.Otherwise you have to restore your database from a previous backup and apply logs.

Regards,

Cherry

[Former Member · Accepted solution]

Hi Cherry,

Sorry for the delay in responding to your suggestion. I gathered courage and tried adding below mentioned lines in my inits01.ora file and followed your instructions.

allowresetlogs_corruption = true

allowread_only_corruption = true

It gave me these recovery related errors.

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'E:\ORACLE\S01\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

Any Idea how to get rid of this problem?

Thanks & Regards,

-Hardik

[Former Member]

Hi Hardik,

This error normally comes due to the inconsistent data file and can be recovered if you are having the current archive files in your oraarch folder.

Shutdown the database first then startup the database as follows:

connect / as sysdba

SQL>startup mount

SQL> RECOVER DATAFILE 'E:\ORACLE\S01\SAPDATA1\SYSTEM_\SYSTEM.DATA1';

Then open the database as below:

SQL>ALTER DATABASE OPEN;

I hope this will solve the problem provided the required archive files are available.

Regards,

Vinayak

[Former Member]

Hi Hardik,

Is this Database a restore or system copy? The issue is with log files.

Regards,

Jeet

[Former Member]

Hi Jeet,

It is a System copy. How to handle this log files issue.

Regards,

-Hardik

[Former Member]

Hi Hardik,

Check your CNTRL files in all locations. They should be all same (modified date should be same). Try using SAPDBA or BRTOOLS and under option of Restore/ recovery, select Partial restore/complete recovery option. Run through this and if any files in backup mode should be set as off. Also make sure that archive logs are present on the logs directory.

How was the system copy done? Did you had to modifiy the CNTRL file? If so, you will need to open db using NORESETLOG or RESETLOG option.

Let me know how you go and I will dig more information for you as I remember getting these issues before.

Regards,

Jeet