ORA-01194: file 1 needs more recovery to be consistent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

Hybrid View

  1. #1
    Join Date
    Jan 2009
    Posts
    2

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

    Db works archievelogs mode.
    I try to test server for oracle tests.
    when i use "alter databse open resetlogs" command, i take some erros.
    try to recover database or datafile from archievelogs and redo logs, cant do it
    Please help me about

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

    C:\Documents and Settings\Administrator.MIOROS>rem oradIm -SHUTDOWN -SID TEST -
    USRPWD manager -SHUTTYPE SRVC,INST

    C:\Documents and Settings\Administrator.MIOROS>oradIm -delete -sId TEST

    C:\Documents and Settings\Administrator.MIOROS>pIng localhost -n 5 > nul

    C:\Documents and Settings\Administrator.MIOROS>del G:\TEST\control*

    C:\Documents and Settings\Administrator.MIOROS>del G:\TEST\TEMP01.DBF
    Could Not Find G:\TEST\TEMP01.DBF

    C:\Documents and Settings\Administrator.MIOROS>echo control_fIles=(G:\TEST\CONTR
    OL01.CTL,G:\TEST\CONTROL02.CTL,G:\TEST\CONTROL03.CTL)>> G:\TEST\InIt.ora

    C:\Documents and Settings\Administrator.MIOROS>echo db_name = TEST>> G:\TEST\InI
    t.ora

    C:\Documents and Settings\Administrator.MIOROS>oradIm -new -Intpwd manager -sId
    TEST -startmode auto -pfIle G:\TEST\InIt.ora

    C:\Documents and Settings\Administrator.MIOROS>pIng localhost -n 10 > nul

    C:\Documents and Settings\Administrator.MIOROS>set oracle_sId=TEST

    C:\Documents and Settings\Administrator.MIOROS>sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 14 10:43:46 2009

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> connect sys/manager as sysdba
    Connected to an idle instance.
    SQL> startup nomount pfIle=G:\TEST\InIt.ora
    ORACLE instance started.

    Total System Global Area 1594959832 bytes
    Fixed Size 456664 bytes
    Variable Size 754974720 bytes
    Database Buffers 838860800 bytes
    Redo Buffers 667648 bytes
    SQL> create controlfIle set database "TEST" resetlogs
    2 logfIle
    3 group 1 'G:\TEST\REDO11.LOG' sIze 10M,
    4 group 2 'G:\TEST\REDO12.LOG' sIze 10M,
    5 group 3 'G:\TEST\REDO13.LOG' sIze 10M,
    6 group 4 'G:\TEST\REDO21.LOG' sIze 10M,
    7 group 5 'G:\TEST\REDO22.LOG' sIze 10M,
    8 group 6 'G:\TEST\REDO23.LOG' sIze 10M,
    9 group 7 'G:\TEST\REDO31.LOG' sIze 10M,
    10 group 8 'G:\TEST\REDO32.LOG' sIze 10M,
    11 group 9 'G:\TEST\REDO33.LOG' sIze 10M
    12 datafIle
    13 'G:\TEST\IFSAPP_ARCHIVE_DATA.DBF',
    14 'G:\TEST\IFSAPP_ARCHIVE_INDEX.DBF',
    15 'G:\TEST\IFSAPP_DATA.DBF',
    16 'G:\TEST\IFSAPP_DATA2.DBF',
    17 'G:\TEST\IFSAPP_DATA3.DBF',
    18 'G:\TEST\IFSAPP_INDEX.DBF',
    19 'G:\TEST\IFSAPP_INDEX2.DBF',
    20 'G:\TEST\IFSAPP_INDEX3.DBF',
    21 'G:\TEST\IFSAPP_REPORT_DATA.DBF',
    22 'G:\TEST\IFSAPP_REPORT_INDEX.DBF',
    23 'G:\TEST\SYSTEM01.DBF',
    24 'G:\TEST\UNDOTBS01.DBF',
    25 'G:\TEST\USERS01.DBF',
    26 'G:\TEST\TOOLS01.DBF';

    Control file created.

    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: 'G:\TEST\SYSTEM01.DBF'

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    You need to do recovery to recover with whatever archive logs that you have, then you need to cancel the recovery.

    recover database until cancel USING BACKUP CONTROLFILE;
    AUTO
    recover database until cancel USING BACKUP CONTROLFILE;
    CANCEL
    alter database open resetlogs;
    this space intentionally left blank

  3. #3
    Join Date
    Jan 2009
    Posts
    2
    ORA-01547: warning: RECOVER succeeded but OPEN
    ORA-01194: file 1 needs more recovery to be con
    ORA-01110: data file 1: 'G:\TEST\SYSTEM01.DBF'

    i will take these messages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width