| Re: ORA-03113 end of file on communication channel [message #58723] |
Fri, 26 September 2003 23:50 |
Arvind Bhandari
Messages: 50
Registered: May 2003
|
Member |
|
|
Hello Mahesh first of all thanks for taking interest. i have tried and set ORACLE_SID= ORCL in the DOS Prompt and startup through SVRMGRL and again its gives same error.
anyway i have recreate all 3 control files through Create Control file command and refer all datafiles and Redolog files.then i gave command
SVRMGRL> Alter database backup control file to trace
and then gave command
SVRMGRL> Recover database using backup controlfile. this results to Complete recovery and gave command
SVRMRL> Alter database open resetlogs.
Now Databaase is open and i have recover all users and Data.
Arvind
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
