Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Startup instance without transacton recovery
- Thread starter haste
- Start date
SantaMufasa
Technical User
Haste,
Just curious...why would you not want transaction recovery?
I am not aware of a way to turn off transaction recovery since it is Oracle's architectural center-piece.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
Just curious...why would you not want transaction recovery?
I am not aware of a way to turn off transaction recovery since it is Oracle's architectural center-piece.
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Thread starter
- #3
SantaMufasa
Technical User
Haste,
I believe we can help you, but we need a full disclosure of what your situation is and what you are trying to accomplish.
First, can you please confirm the status of your database? Is it up and running? If not, what are the diagnostics that Oracle gives you when you attempt to startup?
Mufasa
(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
I believe we can help you, but we need a full disclosure of what your situation is and what you are trying to accomplish.
First, can you please confirm the status of your database? Is it up and running? If not, what are the diagnostics that Oracle gives you when you attempt to startup?
Mufasa(aka Dave of Sandy, Utah, USA)
Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.
- Thread starter
- #5
The issue at the site has been closed - we reinstalled from a dump.
However for learning ends,there was an error in the SMON alert log. It kills the instance after attempin transaction recovery. The system runs on oracle 8i.
It started when the IT admin noticed that transaction weren't completing for lack of space. He thought that the Temp01.dbf which was 15GB in size was the cause so he tried dropping. So he dropped the file before dropping the tablespace. A file that size obviously didn't contain anything temporary.
However for learning ends,there was an error in the SMON alert log. It kills the instance after attempin transaction recovery. The system runs on oracle 8i.
It started when the IT admin noticed that transaction weren't completing for lack of space. He thought that the Temp01.dbf which was 15GB in size was the cause so he tried dropping. So he dropped the file before dropping the tablespace. A file that size obviously didn't contain anything temporary.
- Status
Similar threads
- Locked
- Question