Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Question Unanswered: Problem w/ recoveriy of missing datafile

    I am running Oracle 10g on a RH Linux system, and trying to figure out how make sure my backup and recovery routines work.
    I have a tablespace with the datafile /oracle/oradata/testud/kaj2.dbf, which I deleted while online. The DB runs in archivelog mode.
    Then I shut the DB down and "startup mount"'ed it, and tried to do automatic recovery with the following:
    Code:
    [oracle@mobilix oracle]$ sqlplus "/ as sysdba"
    SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 22 15:55:52 2004
    Copyright (c) 1982, 2004, Oracle.  All rights reserved.
    Connected to an idle instance.
    
    SQL> startup mount;
    ORACLE instance started.
    
    Total System Global Area  603979776 bytes
    Fixed Size                   780024 bytes
    Variable Size             170137864 bytes
    Database Buffers          432013312 bytes
    Redo Buffers                1048576 bytes
    Database mounted.
    SQL> set autorecovery on
    SQL> select FILE# from v$recover_file;
    
         FILE#
    ----------
             6
    
    SQL> recover automatic datafile 6;
    ORA-00283: recovery session canceled due to errors
    ORA-01110: data file 6: '/oracle/oradata/testud/kaj2.dbf'
    ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
    ORA-01110: data file 6: '/oracle/oradata/testud/kaj2.dbf'
    
    SQL>
    Ok, so it can't "identify/lock" the missing file - no wonder, but I thought the restore procedure would create the file and make the contents correct? Am I missing a key point here?
    If I try and "touch" the file first, the error message is something about the file not being the correct size, not matching the block size of the filesystem.

    The content in the tracefile is this:
    Code:
    /oracle/app/oracle/admin/testud/bdump/testud_dbw0_9631.trc
    Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /oracle/app/oracle/product/10.1.0/db_1
    System name:    Linux
    Node name:      mobilix
    Release:        2.4.22-1.2138.nptlsmp
    Version:        #1 SMP Mon Jan 5 11:02:24 EST 2004
    Machine:        i686
    Instance name: testud
    Redo thread mounted by this instance: 1
    Oracle process number: 4
    Unix process pid: 9631, image: oracle@mobilix (DBW0)
    
    *** 2004-03-22 15:57:08.833
    *** SERVICE NAME: () 2004-03-22 15:57:08.832
    *** SESSION ID: (278.1) 2004-03-22 15:57:08.832
    ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
    ORA-01110: data file 6: '/oracle/oradata/testud/kaj2.dbf'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    *** 2004-03-22 15:57:28.162
    ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
    ORA-01110: data file 6: '/oracle/oradata/testud/kaj2.dbf'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    Does anybody have a clue as to how to get this restore procedure to work? Any hints, help or advice will be greatly appreciated.
    Thanks in advance.
    Best regards
    Kenneth

  2. #2
    Join Date
    Mar 2004
    Posts
    3

    SOLVED

    Hmmm the following webpage gave the answer:
    http://www.csee.umbc.edu/help/oracle...ormi.htm#19041

    Best regards
    Kenneth

Posting Permissions

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