Home » RDBMS Server » Backup & Recovery » How i can startup database without undo tablespace, without backup and noarchivlog (oracle 10g OLE 6.2)
How i can startup database without undo tablespace, without backup and noarchivlog [message #656665] Thu, 13 October 2016 15:40 Go to next message
kilani.ayari
Messages: 1
Registered: October 2016
Location: tunis
Junior Member
Hello
I have a base of Oracle 10g on OLE 6.2 64-bit; I accidentally lost the UNDOTBS file and I have no backup;
I changed the parameter UNDO_MANAGEMENT = 'MANUAL' and undo file is OFFLINE and I have the following error:

Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>
alert file:

Errors in file /oradata/data/admin/DBARAB/udump/dbarab_ora_2436.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/oradata/data/oradata/DBARAB/undotbs01.dbf'
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 2436
ORA-1092 signalled during: ALTER DATABASE OPEN...


trace file :
Thread 1 checkpoint: logseq 7, block 2, scn 118950628
on-disk rba: logseq 4, block 3, scn 118890617
start recovery at logseq 7, block 2, scn 118950628
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.04s => 0.01 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.07170ae5 (118950629)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2016-10-13 20:02:22.942
KCRA: start recovery claims for 0 data blocks
*** 2016-10-13 20:02:22.942
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2016-10-13 20:02:22.943
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/oradata/data/oradata/DBARAB/undotbs01.dbf'
Re: How i can startup database without undo tablespace, without backup and noarchivlog [message #656669 is a reply to message #656665] Fri, 14 October 2016 00:42 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It is not possible to open the database in this circumstance.

The last time I had a client in a similar situation, I tried all sorts of hacks involving opening the database without recovery, they all failed. I could actually get the thing open and run a query or two, but it would fail with ORA-600s befoe I could get any data out.

Your only option may be to contact ORacle Support and pay them (pay them a lot) to use their Data Unloader to attempt to extract the tables. That is what we ended up doing for our client. There is quite a lot of work needed after wards, to. And it may not work.
Previous Topic: Archive log Sequence number not in order
Next Topic: Drop table
Goto Forum:
  


Current Time: Thu Mar 28 15:21:02 CDT 2024