This discussion is archived
5 Replies Latest reply: Oct 10, 2013 5:31 AM by mseberg RSS

Dataguard Problem missing datafile

SENSEIYODA Newbie
Currently Being Moderated

problem alert in logfile as follow:

Errors in file $ORACLE_BASE/admin/dump/bdump/db_mrp0_647370.trc:
ORA-01111: name for data file 29 is unknown - rename to correct file
ORA-01110: data file 29: '/home/ora10g/10.2/dbs/UNNAMED00029'
ORA-01157: cannot identify/lock data file 29 - see DBWR trace file
ORA-01111: name for data file 29 is unknown - rename to correct file
ORA-01110: data file 29: '/home/ora10g/10.2/dbs/UNNAMED00029'

 

 

 

please help me .

  • 1. Re: Dataguard Problem missing datafile
    Anar Godjaev Expert
    Currently Being Moderated

    Hi

     

    check recovery process on dataguard 

     

    select sequence#,process,status from v$managed_standby;    ----send me result

     

     

    Thank you

  • 2. Re: Dataguard Problem missing datafile
    SENSEIYODA Newbie
    Currently Being Moderated

    SQL> select sequence#,process,status from v$managed_standby

      2  ;

     

    SEQUENCE# PROCESS   STATUS

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

         44287 ARCH      CLOSING

         44286 ARCH      CLOSING

             0 ARCH      CONNECTED

         41526 ARCH      CLOSING

         44288 MRP0 APPLYING_LOG

             0 RFS       IDLE

             0 RFS       IDLE

         44288 RFS       IDLE

         41527 RFS       IDLE

     

    9 rows selected.

  • 3. Re: Dataguard Problem missing datafile
    Anar Godjaev Expert
    Currently Being Moderated

    OK MRP exist, then cancel the recovery process with =======> alter database recover managed standby cancel;

     

    from alert.log check datafile with “unnamed” filename and change it to missing datafile filename as in the primary database.

     

    ALTER DATABASE CREATE DATAFILE '/home/ora10g/10.2/dbs/UNNAMED00029' as '/oradata/dbname/ts_name.dbf';

     

    if in the future we want every new datafile added in primary automatically created on standby dataguard then change the parameter standby_file_management to auto in primary and standby database =====>

    ===== > alter system set standby_file_management='AUTO';

     

    Then re-run recovery process again.

     

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION ;

     

    Thank you

  • 4. Re: Dataguard Problem missing datafile
    vivalavida Journeyer
    Currently Being Moderated

    Hi ,

    does the error occur on the primary or on the standby site?

    please execute ALTER SYSTEM CHECK DATAFILES as well...

    Checking ID 212053.1 might be helpfuil, too...

     

    HTH

    Jan

  • 5. Re: Dataguard Problem missing datafile
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    Errors in file $ORACLE_BASE/admin/dump/bdump/db_mrp0_647370.trc:

    ORA-01111: name for data file 29 is unknown - rename to correct file

    ORA-01110: data file 29: '/home/ora10g/10.2/dbs/UNNAMED00029'

    ORA-01157: cannot identify/lock data file 29 - see DBWR trace file

    ORA-01111: name for data file 29 is unknown - rename to correct file

    ORA-01110: data file 29: '/home/ora10g/10.2/dbs/UNNAMED00029'

     

     

     

    The issue is probably STANDBY_FILE_MANAGEMENT related, but could be a disk space or incorrect path issue too.

     

    On the Standby check for a missing file:

     

    SELECT * FROM V$RECOVER_FILE WHERE ERROR LIKE '%MISSING%';

     

    Then on the Primary find that file:

     

    SELECT FILE#,NAME FROM V$DATAFILE WHERE FILE#=29;

     

    Back on the Standby find the file:

     

    SELECT FILE#,NAME FROM V$DATAFILE WHERE FILE#=29;

     

     

    Set to STANDBY_FILE_MANAGEMENT to MANUAL:

     

    ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;

     

     

     

    ALTER DATABASE CREATE DATAFILE '/home/ora10g/10.2/dbs/UNNAMED00029' AS '<correct_path_and_filename>';

     

     

    Set to STANDBY_FILE_MANAGEMENT back to AUTO:

     

    ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO

     

    Check the alert log and monitor the apply.

     

    Best Regards

     

    mseberg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points