database not open
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: database not open

  1. #1
    Join Date
    Jan 2002
    Posts
    3

    Dear Sirs,

    Problem : Database is not opened.

    After entering the 'startup' command the following errors are showing.

    ORA-01157: cannot identify data file 6 - file not found
    ORA-01110: data file6: '/home/decsrv1/usr4/people/oracle/u01/app/oracle/product/8.0.4/dbs/datafile_mtech99'

    The data file 'datafile_mtech99' is missing. Please, suggest me how to open the databse.

    Thanks,

    Atanu Basu.



  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    It looks like you will have to restore the file from backup first and recover.


  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What backup strategy do you follow for the database? The recovery will depend on what kind of backup do you have and whether you are running in ARCHIVELOG OR NOARCHIVELOG mode?

    Sanjay

  4. #4
    Join Date
    Jan 2002
    Posts
    3
    Originally posted by julian
    It looks like you will have to restore the file from backup first and recover.

    We have just started to use Oracle. No backup of the data file has been taken. We want only to run the database server with the existing data files.




  5. #5
    Join Date
    Jan 2002
    Posts
    3
    Originally posted by SANJAY_G
    What backup strategy do you follow for the database? The recovery will depend on what kind of backup do you have and whether you are running in ARCHIVELOG OR NOARCHIVELOG mode?

    Sanjay
    We have just started to use Oracle. No backup of the data file has been taken. We want only to run the database server with the existing data files.

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If you are not worried about the lost data then do a offline drop on that datafile and you should be able to open the database.

    Sanjay

  7. #7
    Join Date
    Jan 2002
    Posts
    8

    offline the datafile

    if you dont't have a backup then
    from server manager:

    startup mount;
    alter database datafile '/home/decsrv1/usr4/people/oracle/u01/app/oracle/product/8.0.4/dbs/datafile_mtech99' offline drop;
    alter database open;

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