Hi,
I am facing issue in restoring cold backup. I took cold backup of my DB. Then re-image my system and installed Oracle again. Immediately after installation, moved old data files, undo, control, spfile, init.ora, listener and tnsnames.ora files. But I am not able to start DB now. I performed below steps -
Shutdown Oracle XE DB - Release 11.2.0.2.0 (old o/s Windows 10 64-bit)
Taken complete folder as backup in external drive (C:\oraclexe\app\oracle\...)
Re-image system (same as earlier Windows 10 64-bit)
Installed Oracle (with same binary: Oracle XE 11.2.0.2.0) - Successful. Was able to login in.
Shutdown Oracle
Copy all below mentioned files from backup. (All default folders)
Datafile,Control File,undo files ...\app\oracle\oradata\XE
spfile,init.ora ...\app\oracle\product\11.2.0\server\dbs
tnsnames.ora,listener.ora ...\app\oracle\product\11.2.0\server\network\ADMIN
Open command prompt (as Administrator)
Startup
And getting below error -
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 738198448 bytes
Database Buffers 322961408 bytes
Redo Buffers 5517312 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 1296
Session ID: 130 Serial number: 5
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Can you please help me to solve the issue. Thanks.
Regards,
-Anand