DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: end-of-file communication error

  1. #1
    Join Date
    Apr 2002
    Posts
    34
    Hi

    I am trying to perform recovery of no-system datafile with rollback segments.

    The steps I performed are:

    sql> set transaction use rbseg1;
    sql> create table test (num number) tablespace data1_ts;

    - then inserted some values in the table.

    - i shutdown the database using shutdown abort without performing commit on the above transaction to make the rollback segment have active transaction when shutting down the instance.

    - then i deleted the datafile containing the rbseg1 rollback segment using os command

    -removed rbseg1 entry in rollback_segments parameter in init.ora file

    - then mounted the database..

    - took the datafile containing rbseg1 offline..

    - then tried to open the database using alter database open..

    - then i got this error--"end-of-file- communication"..

    Can somebody explain what is this error and how to perform recovery in this scenario.

    Thanks in advance..

    VVS Raju
    8i DBA OCP

  2. #2
    Join Date
    Apr 2002
    Posts
    34

    Recovery problem

    Somebody pl. help with my above problem..

    Regards

    Raju
    VVS Raju
    8i DBA OCP

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