Skip to Content
avatar image
Former Member

Recover Database Probelm

Dear All

I take online whole database backup and when i restore

startup mount;

ORACLE instance started.

Total System Global Area 8925478912 bytes

Fixed Size 2085656 bytes

Variable Size 4445965544 bytes

Database Buffers 4462739456 bytes

Redo Buffers 14688256 bytes

Database mounted.

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/ARP/sapdata1/system_1/system.data1'

please say how i solved this problem

Nainesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 19, 2011 at 02:46 PM

    Hi Nainesh,

    You should import offline redologs, first. Then, execute "alter database open resetlogs".

    shutdown
    startup mount
    recover database using backup controlfile until cancel; <-- Apply offline redologs
    alter database open resetlogs;
    shutdown
    startup
    exit

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2011 at 01:44 PM

    I take online whole database backup and when i restore

    ERROR at line 1:

    ORA-01113: file 1 needs media recovery

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

    Did you apply archive logs after the restore ? Restore from the 'Online' backup needs full recovery by applying re-do logs as well.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2015 at 06:30 AM

    hiii Nainesh Suthar


    I have same the problem with you, but Im solve with this commands;

    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/BMP/sapdata1/system_1/system.data1'


    SQL> shutdown abort;

    ORACLE instance shut down.

    SQL> startup mount;

    ORACLE instance started.

    Total System Global Area 1.9462E+10 bytes

    Fixed Size                  2118584 bytes

    Variable Size            4596960328 bytes

    Database Buffers         1.4848E+10 bytes

    Redo Buffers               14655488 bytes

    Database mounted.


    SQL> recover database using backup controlfile until cancel;

    ORA-00279: change 8359859095 generated at 11/05/2015 21:52:22 needed for thread

    1

    ORA-00289: suggestion : /oracle/BMP/oraarch/BMParch1_292032_721882534.dbf

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

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

    cancel

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

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

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

    ORA-01112: media recovery not started


    SQL> ALTER SYSTEM SET "_allow_resetlogs_corruption"= TRUE SCOPE = SPFILE;

    System altered.


    SQL> alter database open resetlogs;


    Database altered.

    SQL> select status from v$instance;

    STATUS

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

    OPEN

    SQL> shutdown abort;

    ORACLE instance shut down.

    SQL> startup;

    ORACLE instance started.

    Total System Global Area 1.9462E+10 bytes

    Fixed Size                  2118584 bytes

    Variable Size            4596960328 bytes

    Database Buffers         1.4848E+10 bytes

    Redo Buffers               14655488 bytes

    Database mounted.

    Database opened.




    and the last, start your SAP.


    goodluck


    thank,

    ruhul

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi all,

      I am also facing same issue during restore.

      unable to fix.  need suggestion and help to fix the same.

      after command > recover database using backup controfile until cancel;

      I applied the logs. and it shows media recovery completed.

      But, when I execute > alter database open resetlogs;    I am getting below errors.

      Regards

      Ahmad.

  • avatar image
    Former Member
    Mar 01, 2016 at 09:11 AM

    Hello together ,

    First of all you have to be sure your min(change#) and max(change#) value is equal in v$recover_file

    It means that your DB is Consistent..

    You can check this with following SQL command ;

    select min(change#),max(change#) from v$recover_file;

    If this numbers are equal then you can use the following solution to open your database ;

    Add following line to INIT.ORA file


    _allow_resetlogs_corruption=true


    Then ;

    SQL> shutdown immediate


    SQL>alter database open resetlogs;


    Thats it....


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

    Add comment
    10|10000 characters needed characters exceeded