cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01113: file 1 needs media recovery

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member209962
Participant
0 Kudos

Hi Sunil,

When system is asking for recovery please use below command and provide required archive logs.

recover database using backup controlfile until cancel;

then system will ask path for archive log kindly provide the path

once recovery is completed (all the archive log applied)


alter database open resetlogs;


Thanks

Tabrayz

Former Member
0 Kudos

Hi Tabrayz,

thanks for your reply.

i tried but not able to make it.

SQL> select status from v$instance;

STATUS

------------

MOUNTED

SQL> alter database open;

alter database open

*

ERROR at line 1:

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

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

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

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

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

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile;

ORA-00279: change 335225391 generated at 05/15/2016 07:57:39 needed for thread

1

ORA-00289: suggestion : /oracle/PDR/oraarch/PDRarch1_1_911894250.dbf

ORA-00280: change 335225391 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

cancel

Media recovery cancelled.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

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

SQL>

please advise. or is there any way to bypass this error and open the database.

Regards

Sunil

former_member209962
Participant
0 Kudos

Hi Sunil,

SQL> recover database using backup controlfile;

ORA-00279: change 335225391 generated at 05/15/2016 07:57:39 needed for thread

1

ORA-00289: suggestion : /oracle/PDR/oraarch/PDRarch1_1_911894250.dbf

ORA-00280: change 335225391 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

(HERE PROVIDE THE PATH FOR FILE PDRarch1_1_911894250.dbf)

I can see its working when you hit recover database using backup controlfile until cancel; system is asking you for archive log suggestion : /oracle/PDR/oraarch/PDRarch1_1_911894250.dbf

do you have this file at this location?? if yes provide the path like I mention d:/oracle/PDR/oraarch/PDRarch1_1_911894250.dbf then it will ask for more archive if needed keep providing path once all archive log provided type cancel and then hit alter database open;

Thanks

Tabrayz

Former Member
0 Kudos

Hi Tabrayz,

actually i do not have the archive log. please advise how can i bypass this error and open the database.

Regards'

Sunil

former_member209962
Participant
0 Kudos

OK .

Why are you facing this issue?

Are you building as new system with backup (system copy) ??

or existing system crashed and when you are trying to start its asking for recovery?

If this is a restore with a online backup then you must have archive logs to open the system.

answer above questions then we can think of next action.

Thanks

Tabrayz

Former Member
0 Kudos

Hi Tabrayz,

i am building a new system from production copy.

i have take file system database copy (after keeping database/application off).

i do not required consistency in this system. can i by pass this a start the system.

Regards

Sunil

former_member209962
Participant
0 Kudos

You cannot bypass this error when ever you try to open database it will ask for recovery and you need to archive logs to open the database.

Copy the required archive log from production system and apply here.

Best practice is take backup of database using brtools and also take backup of archivelogs (offline redologs) then us the same in restore.

Thanks

Tabrayz

0 Kudos

Hi,

If "everythign" was properly closed, you should not get the mentioned error.

If you are getting the mentioned error then the copy was done while the database was still running.

You have to take a proper "OFFLINE" backup of the database or a "consistent" ONLINE backup and roll forward/recover it until it can be opened.

Fidel