Unable to startup database

[Former Member]

Hi all,

when I am trying to sartup database, it showing the following error....

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'O:\ORACLE\AKP\SAPDATA3\SYSTEM_1\SYSTEM.DATA1'...

Then when I am trying to recover the file, with recover datafile as well as recover database, again it showing the same error...

Please help me to sort out the problem...

Thanks & Regards,

AR

[Former Member]

Hi All,

Thank you for all your responses. We tried to recover the databse from tapes. And we succeded.

Thanking you all.

AR.

[Former Member]

Just to add...

I tried with

recover data file 'O:\ORACLE\AKP\SAPDATA3\SYSTEM_1\SYSTEM.DATA1';

and

recover databse;

[Former Member]

ok U try to recover after recovery what is the error

it is ORA-01194 ??

If yes u need to check V$DATABASE.CONTROLFILE_TYPE depends in this u need to recover like

current=>recover database until cancel;

backup=>recover database using backup controlfile until cancel;

query v$log And check for datafile status,

Vinod

[Former Member]

Hi Eric,

I was changed the all oracle passwords. after changing the passwords, I shutdown the database and tried to start. Then I got this error.

Pls suggest me 9in that regard.

AR.

[former_member204746]

AR, please answer my question:

what commands have you tried to do the recovery?

[Former Member]

hello,

Often this error is for that there is some datafile in begin backup, can you check?

Mount the database

startup mount;

check that never datafile are with backup active

select files,status from v$backup;

If you have some file,

alter database datafile '/oracle/SID/sapdata1/glpcad_3/glpcad.data3' end backup;

Regards

[Former Member]

Hi Eric

I tried with

recover data file 'O:\ORACLE\AKP\SAPDATA3\SYSTEM_1\SYSTEM.DATA1';

and

recover databse;

AR.

[Former Member]

AR,

You should try below command in order to get exact situation

SQL> select * from v$recover_file;

The output should be ' no rows selected ' or else you might need recovery.

Best Regards,

AjitR

[Former Member]

hi,

also check this link will help u

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3204a72f-0d01-0010-db84-e2335f93...

regards

ajai

[Former Member]

hi

recreate the missed tablespace and create all missed index.

then u can try

regards

ajai

[former_member204746]

ajai? Recreate missed tablespace?

what are you talking about. his SYSTEM tablesapce is out of sync (and probably all opther tablespaces too)

so, AR, what did you do to the database.

1. server shutdown

2. database refresh/copy

3. upgrade

what commands have you tried to do the recovery?