error when database open

[Former Member]

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/HPP/sapdata1/system_1/system.data1'

thanks;

[former_member204080]

Hi,

Please go through this notes

Note 656363 - Composite SAP Note: ORA-01194/ORA-01195

[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=656363]

[Former Member]

Hi,

Check alert log for the redo log which needs to recover the database and apply the log.

Regards,

Venkata S Pagolu

[Former Member]

hi venkat,

please explain in detail

thanks in advance

murali

[Former Member]

Hello,

Could you please explain what was the issue and why did you try this 'database open' command ? What all you did before executing this one ?

This error may not be because of a single reason.

Thanks

[Former Member]

Dear,

when we performing the DB Refresh activity, we restore the data from production to quality

we create a cotrol file SQL>@CONTROL.SQL in niomount phase and the database is in mount.......

now i try to open the data base by using command

SQL> ALTER DATABSE OPEN;

open database by using resetlogs or no resetlogs

SQL>ALTER DATABASE OPEN RESETLOGS;

it was generated above message, please guide me hove to resolve

Thanks in Advince,

murali.

[richakhandelwal]

Hi Murali,

Looks like that you have restored an online back. Pls note that you need to apply archive logs too.

-Richa

[Former Member]

Please read any manual about backup/restore or system copy.

It's all there!

[Former Member]

This message was moderated.

[Former Member]

Hi Murali,

Please shutdown the oracle database then try to startup .

Thanks,

Manas

[Former Member]

Hi Murali,

What is your oracle version?

Regards,

Venkata S Pagolu

[Former Member]

Hi,

Please follow below steps

1.If your oracle version is 10g then go to the location "/oracle/<DBSID>/saptrace/background" and do tail for alert<DBSID>.log

2.Open another session and try to open database with resetlogs.

3. Switch to alert log session and check the result and paste it here.

Note : If your oracle version in 11g, you need to go to location "/oracle/<DBSID>/saptrace/diag/rdbms/<dbsid>/<DBSID>/trace" to check alert log.

Regards,

Venkata S Pagolu