ORA-01092: ORACLE instance terminated. Disconnection forced. - Page 4
DBAsupport.com Forums - Powered by vBulletin
Page 4 of 5 FirstFirst ... 2345 LastLast
Results 31 to 40 of 48

Thread: ORA-01092: ORACLE instance terminated. Disconnection forced.

  1. #31
    Join Date
    Jul 2000
    Location
    India
    Posts
    60

    Smile

    hi,

    i gave the foll command

    CREATE CONTROLFILE REUSE DATABASE FINSATI NOARCHIVELOG
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 50
    MAXINSTANCES 1
    MAXLOGHISTORY 112
    datafile
    'D:\Oracle\oradata\finsati\temp01.dbf' ,
    'D:\Oracle\oradata\finsati\rbs01.dbf',
    'D:\Oracle\oradata\finsati\indx01.dbf',
    'D:\Oracle\oradata\finsati\tools01.dbf',
    'D:\Oracle\oradata\finsati\dr01.dbf',
    'D:\Oracle\oradata\finsati\System01.dbf',
    'D:\Oracle\oradata\finsati\users01.dbf'
    logfile 'D:\Oracle\oradata\finsati\redo01.log' size 1M,
    'D:\Oracle\oradata\finsati\redo02.log' size 1M,
    'D:\Oracle\oradata\finsati\redo03.log' size 1M resetlogs

    it says control file created. now do i start the instance using
    startup force
    or should it be something else ? waiting for ur reply.
    thanks a lot.

    satish

  2. #32
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    There is smth wrong with your syntaxis, it should looks smth like follows

    CREATE CONTROLFILE REUSE DATABASE FINSATI NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 50
    MAXINSTANCES 1
    MAXLOGHISTORY 112
    datafile
    'D:\Oracle\oradata\finsati\temp01.dbf' ,
    'D:\Oracle\oradata\finsati\rbs01.dbf',
    'D:\Oracle\oradata\finsati\indx01.dbf',
    'D:\Oracle\oradata\finsati\tools01.dbf',
    'D:\Oracle\oradata\finsati\dr01.dbf',
    'D:\Oracle\oradata\finsati\System01.dbf',
    'D:\Oracle\oradata\finsati\users01.dbf'
    logfile
    'D:\Oracle\oradata\finsati\redo01.log' size 1M,
    'D:\Oracle\oradata\finsati\redo02.log' size 1M,
    'D:\Oracle\oradata\finsati\redo03.log' size 1M;

    after this is done

    alter database open;

  3. #33
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi,

    when i say alter database open, i get the foll error

    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\FINSATI\SYSTEM01.DBF'

    what do i do ?

    satish

  4. #34
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ops, try this although I am not sure if it would work

    shutdown the database
    startup mount
    recover database;
    alter database open;

    are you in archive log or no archive log

  5. #35
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi pando,

    thanks a lot. it works great. a few more questions to triuble u. i had a few tablespaces which had 2-3 more datafiles. i can add these tablespaces and datafiles now, right ? second, what diff does it make whether i am in archive or nonarchive mode ? thanks a lot for u r help. i did learn a lot today.

    satish

  6. #36
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hm what do you mean you have a few more files to add...? You didnt include all datafiles in your create control file statement? Well it is too late now to add because the file headers have been updated with new SCNs. You will get errors if you wanna add.
    Archive log allows you to recover until point of failure (as long as you keep the archived logs)
    With no archive log you can only recover until last cold backup, if your last cold backup is from 1 week ago then you would lose 1 week work.

  7. #37
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi ,

    i had mentioned all the datafiles but it seems there was a datafile in d:\oracle\ora81\database. but i couldnt fond any datafile there. now in the dba studo, it is showing me that this datafile is missing but i am not getting the name of the file. just the path. whenever i am querying most of my tables, i am getting this error

    ORA-00376: file 9 cannot be read at this time
    ORA-01111: name for data file 9 is unknown - rename to correct file
    ORA-01110: data file 9: 'D:\ORACLE\ORA81\DATABASE\MISSING00009'

    what is the way out ? can i delete this datafile ?

    satishpc

  8. #38
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Well I think this is a bit trouble. You said most of your tables cant be queried then seems like itīs the main datafile that is missing and you said itīs not anywhere, so it was deleted accidently? If it was deleted then you will have to do a recovery, it can be a few situations, I doubt I can help remotely.
    Do you have backups at all?
    Your company should hire a DBA, really. Oracle is pretty complex since it offers so many options, features, and depending on situation you do a specific thing.
    If the boss doesnt want to hire a DBA I would suggest using SQL Server.

  9. #39
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi pando,

    thanks a lot. i guess i will manage from here onwards. actually my co. wants me to be the dba so i gues i woill have to start studying very hard. :D . i did learn a lot as this is the first time my comapny has encountered a serious database problem. earlier, they simply used to reinstall oracle and import the dump. but i guess i will have to put systems in place. for the time being my database working properly(hopefully). i will just have to import a few tables and process them.can u just tell me how to delete that datafile. right now it is offline. thanks once again. bye and have a nice time.

    satishpc

  10. #40
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    try this

    shutdown the database
    startup mount
    alter database datafile 'MISSINGwhatever' offline drop;
    select * from v$datafile;
    check the status column, see if itīs offline
    alter database open;
    drop tablespace XXXXX including contents;

    where XXXX the tablespace that owns that datafile.

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