-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|