OraFAQ Forum: Backup & Recovery » ORA-01092: ORACLE instance terminated. Disconnection forced

Home » RDBMS Server » Backup & Recovery » ORA-01092: ORACLE instance terminated. Disconnection forced (Oracle 10g, Linux Redhat.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01092: ORACLE instance terminated. Disconnection forced [message #321291]

Mon, 19 May 2008 15:23

geeklol
Messages: 59
Registered: March 2005

Member

i believe here is what happened...

i have a 10g single instance database on linux.
I created a brand new instance on linux and populated it using datapump from another 10g instance on solaris.
All looked good.
The next morning, i tried to log into the database and it gave me the following error,

-------------
ORA-01172: recovery of thread 1 stuck at block 60883 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed
Fri May 16 10:09:40 2008
Errors in file /usr/local/oracle/admin/lcecdev2/bdump/lcecdev2_p004_1454.trc:
ORA-01172: recovery of thread 1 stuck at block 58499 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed
Fri May 16 10:09:40 2008
Aborting crash recovery due to slave death, attempting serial crash recovery
-------------

file 2 belonged to the undo tablespace.

so the first thing i did was,
ALTER DATABASE RECOVER datafile '/db2008051401/oradata/lcecdev2/data/undotbs02.dbf'

No luck.

Then, i tried to recover the undo tablespace by doing the following,

changed the follwing in the pfile,
#undo_management=AUTO
undo_tablespace=UNDOTBS1

then,
STARTUP RESTRICT MOUNT pfile=$ORACLE_HOME/dbs/initcrm_18.ora

drop TABLESPACE UNDOTBS2;

CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'K:\oradata\CRM\UNDOTBS01.DBF' SIZE 2000M reuse AUTOEXTEND ON ;

ALTER SYSTEM SET undo_tablespace = UNDOTBS1 ;

change pfile to,
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1

shutdown immediate;
and restart.

-------------------

now i can mount the db.

SQL> SHOW PARAMETER UNDO

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1

but when i try to open the db it gives me the following error,

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

----------

Is there a way i can save this db?

Thank you very much!!!!

Report message to a moderator