Skip to Content
0
Former Member
May 15, 2016 at 03:12 AM

ORA-01113: file 1 needs media recovery

1091 Views

Hi All,

i have done file system backup restore process. while opening the database i am getting following error.

SQL> startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 7031889920 bytes

Fixed Size 2195936 bytes

Variable Size 3523218976 bytes

Database Buffers 3489660928 bytes

Redo Buffers 16814080 bytes

Database mounted.

ORA-01113: file 1 needs media recovery

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

SQL> alter database recover datafile '/oracle/PDR/sapdata1/system_1/system.data1';

alter database recover datafile '/oracle/PDR/sapdata1/system_1/system.data1'

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

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

Please advise

Regards

Sunil