RMAN Point in Time Recovery: ORA-01194: file 1 needs more recovery to be consistent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN Point in Time Recovery: ORA-01194: file 1 needs more recovery to be consistent

Threaded View

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Question RMAN Point in Time Recovery: ORA-01194: file 1 needs more recovery to be consistent

    trace.txtHi,
    I am restring database to a point in time. I have all backup files, however I keep getting error:

    Command:

    run{
    ALLOCATE CHANNEL c1 DEVICE TYPE disk;
    ALLOCATE CHANNEL c2 DEVICE TYPE disk;
    ALLOCATE CHANNEL c3 DEVICE TYPE disk;
    ALLOCATE CHANNEL c4 DEVICE TYPE disk;
    set until time "to_date('01/01/2014 05:00:00' , 'dd/mm/yyyy hh24:mi:ss')";
    RESTORE DATAFILE 1;
    recover database SKIP TABLESPACE WORKBENCH_DATA;
    }

    Output:

    ………
    Executing: alter database datafile 4 offline
    Executing: alter database datafile 72 offline
    Executing: alter database datafile 73 offline
    Executing: alter database datafile 38 offline
    Executing: alter database datafile 74 offline
    Executing: alter database datafile 75 offline
    starting media recovery

    archived log for thread 1 with sequence 1813 is already on disk as file /u10/FPESSP01_SITE2/datafile/1_1813_829250679.arch
    archived log for thread 1 with sequence 1814 is already on disk as file /u10/FPESSP01_SITE2/datafile/1_1814_829250679.arch
    archived log file name=/u10/FPESSP01_SITE2/datafile/1_1813_829250679.arch thread=1 sequence=1813
    archived log file name=/u10/FPESSP01_SITE2/datafile/1_1814_829250679.arch thread=1 sequence=1814
    Oracle Error:
    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '/u10/FPESSP01_SITE2/datafile/1.dbf'

    media recovery complete, elapsed time: 00:00:10
    Finished recover at 02-JAN-14
    released channel: c1
    released channel: c2
    released channel: c3
    released channel: c4

    RMAN>

    Directory has the following ARCH files, but it does not use them:


    oracle@chzrhkorap04:/u10/FPESSP01_SITE2/datafile/ [SPHPRD1] ls *.arch
    1_1808_829250679.arch 1_1812_829250679.arch 1_1816_829250679.arch 1_1820_829250679.arch 1_1824_829250679.arch
    1_1809_829250679.arch 1_1813_829250679.arch 1_1817_829250679.arch 1_1821_829250679.arch 1_1825_829250679.arch
    1_1810_829250679.arch 1_1814_829250679.arch 1_1818_829250679.arch 1_1822_829250679.arch 1_1826_829250679.arch
    1_1811_829250679.arch 1_1815_829250679.arch 1_1819_829250679.arch 1_1823_829250679.arch


    The following arch file is not corrupted:

    RMAN> catalog start with '/u10/FPESSP01_SITE2/datafile/temp/';

    searching for all files that match the pattern /u10/FPESSP01_SITE2/datafile/temp/

    List of Files Unknown to the Database
    =====================================
    File Name: /u10/FPESSP01_SITE2/datafile/temp/1_1815_829250679.arch

    Do you really want to catalog the above files (enter YES or NO)? YES
    cataloging files...
    cataloging done

    List of Cataloged Files
    =======================
    File Name: /u10/FPESSP01_SITE2/datafile/temp/1_1815_829250679.arch



    Attached file has an some errors.
    Any advice will be very much appreciated.
    Last edited by kgb; 01-02-2014 at 10:26 AM.
    Best wishes!
    Dmitri

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