ORA-01092: ORACLE instance terminated. Disconnection forced
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

  1. #1
    Join Date
    Jun 2003
    Location
    australia
    Posts
    74

    ORA-01092: ORACLE instance terminated. Disconnection forced

    I created a DB with 1 undo TS and later added another one and took the first one offline. And when I tried to bring it back online it started to give me following errors—
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00376: file 2 cannot be read at this time
    ORA-01110: data file 2: ‘D:\RAJ\UNDOTBS01.DBF’

    Then I restarted the DB and got the following error—
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced

    So I decide to shut down the DB and change the initraj.ora parameter
    UNDO_TABLESPACE=undo2 (which is the name of the second undo TS). And now when I start the DB I get the same errors.

    What can I do to get my DB back? I don’t have any backup at all. I would be grateful if you can send me a solution asap.

    Kind regards,

    raj
    rajorcl

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    What does this have to do with feedback and questions regarding the forums?

  3. #3
    Join Date
    Aug 2005
    Location
    delhi
    Posts
    2

    Thumbs up

    Dear Raj

    do these steps.

    1.)Specify the undotablespace in init.ora.

    2.)startup DB in mount stage.

    3.)query the status of tablespace (recover)

    4.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ offline;

    5.)recover database datafile ‘D:\RAJ\UNDOTBS01.DBF’

    6.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ online

    7.)alter database open;

    I Think these steps are helpful for you.

  4. #4
    Join Date
    Aug 2005
    Location
    delhi
    Posts
    2

    Thumbs up

    Quote Originally Posted by kanthbethi
    I created a DB with 1 undo TS and later added another one and took the first one offline. And when I tried to bring it back online it started to give me following errors—
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00376: file 2 cannot be read at this time
    ORA-01110: data file 2: ‘D:\RAJ\UNDOTBS01.DBF’

    Then I restarted the DB and got the following error—
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced

    So I decide to shut down the DB and change the initraj.ora parameter
    UNDO_TABLESPACE=undo2 (which is the name of the second undo TS). And now when I start the DB I get the same errors.

    What can I do to get my DB back? I don’t have any backup at all. I would be grateful if you can send me a solution asap.

    Kind regards,

    raj

    Dear Raj

    do these steps.

    1.)Specify the undotablespace in init.ora.

    2.)startup DB in mount stage.

    3.)query the status of tablespace (recover)

    4.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ offline;

    5.)recover database datafile ‘D:\RAJ\UNDOTBS01.DBF’

    6.)alter database datafile ‘D:\RAJ\UNDOTBS01.DBF’ online

    7.)alter database open;

    I Think these steps are helpful for you.

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